Home > Archive > PHP SQL > November 2006 > Error restoring SQL database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error restoring SQL database
|
|
| DonRon 2006-11-09, 6:57 pm |
| 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
| |
| Andy Hassall 2006-11-10, 6:57 pm |
| On 9 Nov 2006 13:20:22 -0800, "DonRon" <rpp.linders@gmail.com> wrote:
>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
There should be a space between 'default' and 'CURRENT_TIMESTAMP'.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
|
|
|
|
|