I've tested the MySQL db initialization, and it seems to work, but I only have MySQL 4.x and later to test on. The CHARSET definition is not supported in MySQL before 4.1. I will include a MySQL 3.23 compatible version on the SQL file with the next release. If you would like it sooner, email me and I can create one that will work with Limph 1.5 and I'll attach it to my reply. Thank you for pointing this out!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hmm. I think your MySQL version might be the issue, as I've only really tested Limph in MySQL 4.x and PostgreSQL 8.x. I'll do a few tests later this week and post my results here, once I'm back from holiday. :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I get the following error when attempting to creat database tables:
ERROR 1064 at line 21: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
I am using limph-1.5 with mysql-server-3.23.58-16 on Fedora 3.
Regards
JK
I've tested the MySQL db initialization, and it seems to work, but I only have MySQL 4.x and later to test on. The CHARSET definition is not supported in MySQL before 4.1. I will include a MySQL 3.23 compatible version on the SQL file with the next release. If you would like it sooner, email me and I can create one that will work with Limph 1.5 and I'll attach it to my reply. Thank you for pointing this out!
Hmm. I think your MySQL version might be the issue, as I've only really tested Limph in MySQL 4.x and PostgreSQL 8.x. I'll do a few tests later this week and post my results here, once I'm back from holiday. :)
The 1.5.1 release has been posted, and includes a MySQL 3.23-compatible db schema file. Enjoy!