weird error after I imported database backup into phpmyadmin

Regular Joined: Jan 16, 2009 Posts: 91

I was trying to fix this error. It should be correct. It still appears as the error. Did I miss anything else?

Error

SQL query:

CREATE TABLE nuke_seo_dh_master(
'mid' int( 11 ) NOT NULL AUTO_INCREMENT ,
'order' int( 5 ) NOT NULL ,
'type' varchar( 50 ) NOT NULL ,
'name' varchar( 50 ) NOT NULL ,
'default' varchar( 255 ) NOT NULL ,
'active' int( 1 ) NOT NULL ,
PRIMARY KEY ( 'mid' ) ,
KEY 'order'('order') )
TYPE = MYISAM ;

MySQL said: Documentation
#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 ''mid' int(11) NOT NULL auto_increment,
'order' int(5) NOT NULL,
'type' varchar(5' at line 2

Posted: Mon Sep 06, 2010 3:12 pm

Odd. Are the rest of your tables importing okay? One thing I am seeing is that your software is using single quotes (') instead of the backticks (`) that we normally see in SQL load statements. Trying your query (copied from your post) on my local phpmyadmin screen (but changing the table name so I don't overwrite my own) I get the same error message you did. Changing ' to ` throughout the query executes and creates the table. Conclusion: your backup is not compatible with PHPmyadmin.

Posted: Mon Sep 06, 2010 3:26 pm

I am going to try backticks now. What hotkey did you add for backticks? I am using notepadd++.

Posted: Mon Sep 06, 2010 3:31 pm

No hotkey. Upper left corner of my keyboard ... upper case character on that key is a tilde (~).

Posted: Mon Sep 06, 2010 5:31 pm

Ah ok thanks. It's solved now. Very Happy

I almost solve it myself. I have missed backticks. lol