MySQL Error Occured

[Guest ardand]

Error when i install a cubecart (last version) with the automatic install.

I have MySQL 3.23.58...

Please help me!

---------------------------------

MySQL Error Occured

1064: You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=1 ' at line 7

QUERY = CREATE TABLE `store3_CubeCart_cats_lang` ( `id` int(11) NOT NULL auto_increment, `cat_master_id` int(11) NOT NULL default '0', `cat_lang` varchar(20) NOT NULL default '', `cat_name` varchar(255) NOT NULL default '', KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 ;

-----------------------------

[roban]

Did you upload the new global.inc? If so you should not have. You have to keep your old one or transfer the data from the old one into the new.

[Guest]

I had to run mine as a sql query from PhpmyAdmin:

CREATE TABLE `store3_CubeCart_cats_lang` (

`id` int(11) NOT NULL auto_increment,

`cat_master_id` int(11) NOT NULL default '0',

`cat_lang` varchar(20) NOT NULL default '',

`cat_name` varchar(255) NOT NULL default '',

KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

[Guest ardand]

GOOD!!! TNX!

ENGINE= NOT GOOD

TYPE= GOOD!

Grazieeeeeeeeeeeee

Ciaoooo

Andrea

[Guest webgaffer]

Yeh... From the 3.0.3 package open-up schema.inc.php

Do a search for ENGINE

You will find one occurance

Change it to TYPE

Your automatic installation will then work

Oh Boy !!