Posted by DonRon on 11/09/06 21:20

Hi,

Restoring my (Wordpress) SQL database gives me the following error:

Fout

SQL-query :

CREATE TABLE wp_alinks_keyphrases (
id int( 11 ) NOT NULL AUTO_INCREMENT ,
keyphrase varchar( 250 ) NOT NULL default '',
description varchar( 250 ) NOT NULL default '',
defines text NOT NULL ,
module varchar( 60 ) NOT NULL default '',
created timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
hash varchar( 32 ) NOT NULL default '',
PRIMARY KEY ( id ) ,
KEY keyword_keyword ( keyphrase )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL retourneerde:
#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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
hash varchar

Any suggestions how I can get my backup restored??

thx

Ron

[Back to original message]