luchino Posted July 7, 2007 Share Posted July 7, 2007 when I add the sql in information.sql using phpmyadmin I get: Error SQL query: CREATE TABLE `information` ( `information_id` tinyint( 3 ) unsigned NOT NULL AUTO_INCREMENT , `information_group_id` int( 11 ) unsigned NOT NULL default '0', `information_title` varchar( 255 ) NOT NULL default '', `information_description` text NOT NULL , `parent_id` int( 11 ) default NULL , `sort_order` tinyint( 3 ) unsigned NOT NULL default '0', `visible` enum( '1', '0' ) NOT NULL default '1', `language_id` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `information_id` , `language_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: #1064 - 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 'DEFAULT CHARSET=latin1' at line 11 Line 11 is: `sort_order` tinyint( 3 ) unsigned NOT NULL default '0', I have MySQL 4.0.27-standard. Trying to instal version 2.03 (IPU) but have tried the sql from some earlier versions (down to v2) but no luck there either. latest osc - as of a few weeks ago. I know not much about mysql, but have run sql from other mods & other stores no probs. Can anyone shed some light on what the problem might be? My guess is it needs a different version of mysql perhaps - cant find anyone else with this problem. Ive not installed this contribution before - had used Information Pages Enhanced v1.3 in previous stores. I downloaded this one by mistake ... but thought I'd give it a try. Thanks ant I got the same error... anyone has ideas? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.