Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem adding information.sql - error


Recommended Posts

Hi,

when installing this contribution I try to 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

Link to comment
Share on other sites

Oh FFS, I meant this to be in this thread:

http://www.oscommerce.com/forums/index.php?showtopic=179289

 

 

Hi,

when installing this contribution I try to 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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...