Please delete this thread (Off topic) -- Thanks. Yves

[StudioZ]

Edited :
Please delete this thread (Off topic) -- Thanks. Yves

Hi,

I am seting up a demo for my clients, for them to test drive PhpWCMS. I am using a script (to be called from a Cron) to restore the database every 3 hours, to it's original state.

I can backup the database without any problem but... when I try to restore the database using this script or from within PhpMyAdmin, I then get this error:
BLOB column 'article_keyword' used in key specification without a key length

Only this table seems to not being restored.

Here's the table's structure:

Code: Select all

DROP TABLE IF EXISTS phpwcms_article;
CREATE TABLE phpwcms_article (
    article_id int(11) NOT NULL auto_increment,
    article_cid int(11) DEFAULT '0' NOT NULL,
    article_tid int(11) DEFAULT '0' NOT NULL,
    article_uid int(11) DEFAULT '0' NOT NULL,
    article_tstamp timestamp(14),
    article_username varchar(125) NOT NULL,
    article_title text NOT NULL,
    article_keyword text NOT NULL,
    article_public int(1) DEFAULT '0' NOT NULL,
    article_deleted int(1) DEFAULT '0' NOT NULL,
    article_begin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    article_end datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    article_aktiv int(1) DEFAULT '0' NOT NULL,
    article_subtitle text NOT NULL,
    article_summary text NOT NULL,
    article_redirect text NOT NULL,
    article_sort int(11) DEFAULT '0' NOT NULL,
    article_notitle int(1) DEFAULT '0' NOT NULL,
    article_hidesummary int(1) DEFAULT '0' NOT NULL,
    article_image blob NOT NULL,
   PRIMARY KEY (article_id),
   KEY article_keyword (article_keyword)
);

Is there any tweak that I could myself apply to the table that seems to be causing this restore problem?

Thank you and Regards,

[StudioZ]

oups...?

I am investigating on what I beleive is more a problem with the Backup/Restore script I am using.

I just realized that when I try to restore from within CPanel all is OK and here's the table that get's send:

In bold, the diffs between the Script and Cpanel output.

DROP TABLE IF EXISTS phpwcms_article
--------------

--------------
CREATE TABLE phpwcms_article (
article_id int(11) NOT NULL auto_increment,
article_cid int(11) NOT NULL default '0',
article_tid int(11) NOT NULL default '0',
article_uid int(11) NOT NULL default '0',
article_tstamp timestamp(14) NOT NULL,
article_username varchar(125) NOT NULL default '',
article_title text NOT NULL,
article_keyword text NOT NULL,
article_public int(1) NOT NULL default '0',
article_deleted int(1) NOT NULL default '0',
article_begin datetime NOT NULL default '0000-00-00 00:00:00',
article_end datetime NOT NULL default '0000-00-00 00:00:00',
article_aktiv int(1) NOT NULL default '0',
article_subtitle text NOT NULL,
article_summary text NOT NULL,
article_redirect text NOT NULL,
article_sort int(11) NOT NULL default '0',
article_notitle int(1) NOT NULL default '0',
article_hidesummary int(1) NOT NULL default '0',
article_image blob NOT NULL,
PRIMARY KEY (article_id),
FULLTEXT KEY article_keyword (article_keyword)
) TYPE=MyISAM

[StudioZ]

Please forget about this issue
Just realized the backup/restore script I am using is not handling this type of Key (FULLTEXT). I'll have to find a way to modify it.