Discussion:
[Citrusdb-users] Install issues with mysql60-server when trying to create tables.
Clinton Strouth
2009-07-10 17:21:07 UTC
Permalink
I'm currently having problems implementing the citrusdb software for the
company I work for.
We are having the following problems when trying to create the tables

cobra# mysql -p citrus <
/usr/local/www/apache22/data/citrus-1.3.1/citrus.sql
ERROR 1064 (42000) at line 19: 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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 4

The current version for mysql server is 6.0 and we are trying to run
citrus-1.3.1
Do we need to downgrade from mysql6.0 to 5.0 or what?

Any help would be appericated

Clinton
SkyNET Communications
Network Engineer
Paul Yasi
2009-07-10 19:03:51 UTC
Permalink
There may be a compatibility mode you can try turning on that may
make it work. I think 6.0 is a preview version and not really for
production use. I would recommend sticking to the regular general
release version, which is 5.1 right now.

Paul
Post by Clinton Strouth
I'm currently having problems implementing the citrusdb software for the
company I work for.
We are having the following problems when trying to create the tables
cobra# mysql -p citrus <
/usr/local/www/apache22/data/citrus-1.3.1/citrus.sql
ERROR 1064 (42000) at line 19: 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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 4
The current version for mysql server is 6.0 and we are trying to run
citrus-1.3.1
Do we need to downgrade from mysql6.0 to 5.0 or what?
Any help would be appericated
Clinton
SkyNET Communications
Network Engineer
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Loading...