Re: XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install

A little bit more information would be critical here to diagnose the
problem.
Are you a developer yourself? Put yourself in my shoes and then ask yourself
what information would you needed in order to troubleshoot your problem?
THEN write the email to request support. That will save everybody some time!

Also a little bit of courtesy would be nice... A thank sometimes makes a
world of difference when you do not pay for support.

So now back to business:
What database are your running?
What version are you upgrading from or is it a brand new install?
What package are you trying to install?
Have you followed the steps in the README.txt in respect to setting
xplanner-customer.properties properly? Could you dump it here?

Jacques

On 8/24/06, gyanapalam-email-/[email protected] <gyanapalam-email-/[email protected]> wrote:
>
> [  16796]  ERROR - on.jdbc.SqlScriptMigrationTask -
> patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "SELECT @id:=next FROM
> identifier"                                  java.sql.SQLException:
> Unknown column 'next' in 'field list'                                 at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
> at com.mysql.jdbc.Statement.execute(Statement.java:529)
> at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(
> SqlScriptMigrationTask.java:124)
> at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(
> MigrationProcess.java:162)
> at
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> JdbcMigrationLauncher.java:288)
> at
> com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(
> JdbcMigrationLauncher.java:108)
>
>
>
> Shankar S. Pattabiraman,
> Sr.Software Engineer
> Applied Biosystems,Silicon Valley
> Address:
> 3770 Flora Vista Ave,#903
> Santa Clara, USA.
> *Res*: 408-985-7131,
> *Mobie*: 408-623-7230
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> _______________________________________________
> Xplanner-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/xplanner-devel
>
>
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

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