Problem in Migration again

--===============1955092300486833717==
Content-Type: multipart/alternative; 
	boundary="----=_Part_47828_364560.1228726440453"

------=_Part_47828_364560.1228726440453
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,

I've build the actual version from SVN, but on startup I've get the error:

Caused by: com.tacitknowledge.util.migration.MigrationException:
patch0001_0-6-0.sql: Error running SQL at statement number 0 "create table
datasample (
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'create table
person_role (
...

I executed the sql from the patch file manually in mysql with no problem. I
started with a fresh database.

Environment is
mysql 5.0.67-community-nt
tomcat 6.0
Java 1.6

Any help is appreciated.

Best regards,
Andreas



Hi All,

I have finally got the xplanner.war built and am running it under
tomcat5. First I had a password problem but I edited
xplanner.properties and now the error I get is "migration exception
caught during migration."

I am not sure what it is migrating because this is a fresh install, but
I am still confused. It is able to connect to the DB because it passed
the login step with no error.



Thanks in Advance,



Barry

------=_Part_47828_364560.1228726440453
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,<br><br>I&#39;ve build the actual version from SVN, but on startup I&#39;ve get the error:<br><br>Caused by: com.tacitknowledge.util.migration.MigrationException: patch0001_0-6-0.sql: Error running SQL at statement number 0 &quot;create table datasample (<br>
...<br>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;create table person_role (<br>
...<br><br>I executed the sql from the patch file manually in mysql with no problem. I started with a fresh database.<br><br>Environment is <br>mysql 5.0.67-community-nt<br>tomcat 6.0<br>Java 1.6<br><br>Any help is appreciated.<br>
<br>Best regards,<br>Andreas<br><br><br><br>Hi All,<br>
 <br>
 I have finally got the xplanner.war built and am running it under<br>
 tomcat5. First I had a password  problem but I edited<br>
 xplanner.properties and now the error I get is &quot;migration exception<br>
 caught during migration.&quot;<br>
 <br>
 I am not sure what it is migrating because this is a fresh install, but<br>
 I am still confused. It is able to connect to the DB because it passed<br>
 the login step with no error.<br>
 <br>
  <br>
 <br>
 Thanks in Advance,<br>
 <br>
  <br>
 <br>
 Barry

------=_Part_47828_364560.1228726440453--


--===============1955092300486833717==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
--===============1955092300486833717==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel

--===============1955092300486833717==--