| View previous topic :: View next topic |
| Author |
Message |
Hubertus
Joined: 11 Feb 2006 Posts: 153 Location: Austria
|
Posted: Tue Aug 01, 2006 8:30 am Post subject: strange MySql problem |
|
|
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
| Quote: | 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 ?  |
|
| Back to top |
|
 |
aware_support
Joined: 24 Apr 2005 Posts: 3224
|
Posted: Tue Aug 01, 2006 8:42 am Post subject: |
|
|
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 _________________ Aware IM Support Team |
|
| Back to top |
|
 |
Hubertus
Joined: 11 Feb 2006 Posts: 153 Location: Austria
|
Posted: Tue Aug 01, 2006 9:42 am Post subject: |
|
|
You guys are crazy ! YESSS it works !!!!!!
Thanks a lot |
|
| Back to top |
|
 |
|