Posted by Andy Hassall on 11/10/06 16:45

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

[Back to original message]