strange MySql problem

Hubertus

I've just tried installing AwareIM on a headless Linux server.
Starting AwareIM creates the databases BASDB and BASDBTEST correctly, but trying to create the default tables results in

Creating database tables...
Database tables have been created
Installing predefined objects...
2006-08-01 09:09:05,298 ERROR -Error adding new record into the history
of business space version Error inserting history record into
persistence Incorrect arguments to mysql_stmt_execute
Dropping database tables...
Database tables have been dropped
Cleaning up...
Could not initialise database tables
Aware IM Server startup error Unable to initialise the database tables
due to the following exception
com.bas.basserver.persistence.PersistenceException Internal error. Error
persisting business object RegularUser Incorrect arguments to
mysql_stmt_execute exiting...

This happens using MySQL 4.1.12-Debian_1ubuntu3-log whereas 4.0.24_Debian-10ubuntu2.1-log works perfectly.

Any ideas ? :?

aware_support

It looks like a MySQL bug specific for this operating system (actually somewhere between MySQL and MySQL driver). Please try this workaround:

Add "&useServerPrepStmts=false" to 3 MySQL entries in the BASServer.props file, for example:

DriverURL=jdbc:mysql://localhost/BASDB?user=root&useServerPrepStmts=false
DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root&useServerPrepStmts=false
BootstrapURL=jdbc:mysql://localhost/?user=root&useServerPrepStmts=false

Hubertus

You guys are crazy ! YESSS it works !!!!!!
Thanks a lot