Well, I kinda messed up my forum, but now when I want to restore my backup (using phpmyadmin)
i get the following error:
Well, I tried to restore a backup using phpmyadmin, but when i want to upload the .sql,
i get the following error:
SQL-query:
CREATE TABLE `smf_shop_items` (
id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
DESC text NOT NULL default '',
price decimal( 8, 2 ) unsigned NOT NULL default 0.00,
module tinytext NOT NULL default '',
stock smallint( 6 ) NOT NULL default 0,
info1 text NOT NULL default '',
info2 text NOT NULL default '',
info3 text NOT NULL default '',
info4 text NOT NULL default '',
input_needed tinyint( 3 ) unsigned NOT NULL default 1,
can_use_item tinyint( 3 ) unsigned NOT NULL default 1,
image tinytext NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM
-------------------------
MySQL retourneerde: Documentatie
#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 'desc text NOT NULL default '',
price decimal(8,2) unsigned NOT NULL default 0' at line 4
After asking on SMF support, they told me to visit the shop mod thread.
Anyone know how to solve this?
