News:

Wondering if this will always be free?  See why free is better.

Main Menu

SQL Import Error on phpMyAdmin

Started by kevin5fan, May 21, 2010, 06:09:24 PM

Previous topic - Next topic

kevin5fan

OK Imported my SQL Backup that I backed up
It gave me this error
SQL query:

CREATE TABLE `smf_shop_items` (
id int( 10 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL ,
DESC text NOT NULL ,
price decimal( 10, 0 ) NOT NULL default 0,
module tinytext NOT NULL ,
stock smallint( 6 ) NOT NULL ,
info1 text,
info2 text,
info3 text,
info4 text,
input_needed tinyint( 1 ) NOT NULL default 0,
can_use_item tinyint( 1 ) NOT NULL default 0,
delete_after_use tinyint( 1 ) NOT NULL default 0,
image tinytext,
category smallint( 6 ) NOT NULL default 0,
PRIMARY KEY ( id )
) TYPE = MYISAM ;

IDK What this is, but can you tell me how to fix this, I was moving to a new host

Allusion

Save a backup copy of the SQL file(just in case you make mistakes), open it in a text editor and replace:

DESC text NOT NULL ,


with:

`DESC` text NOT NULL ,


Save the file and try the import again.

Advertisement: