Install issues with mysql60-server when trying to create tables.

[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
Citrusdb-users@...
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Paul Yasi]

 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

On Fri, Jul 10, 2009 at 1:21 PM, Clinton Strouth<cstrouth1@...> wrote:

> 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
> Citrusdb-users@...
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>

--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System

------------------------------------------------------------------------------
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
Citrusdb-users@...
https://lists.sourceforge.net/lists/listinfo/citrusdb-users