1
Hi, Backup&restore 3.0 not run nice with module wordbook. When i create a backup of wbentries i can´t restore it, the error:
Quote:
Processing file: bkp0507200335_xoops_wbentries.sql
Starting at the line: 1
Error at the line 33: );
Query: CREATE TABLE xoops_wbentries ( entryID int(8) NOT NULL auto_increment, categoryID tinyint(4) DEFAULT '0' NOT NULL, term varchar(255) DEFAULT '0' NOT NULL, init char(1) DEFAULT '0' NOT NULL, definition text NOT NULL, ref varchar(255) DEFAULT '0' NOT NULL, url varchar(255) DEFAULT '0' NOT NULL, uid int(6) DEFAULT '1', submit int(1) DEFAULT '0' NOT NULL, datesub int(11) DEFAULT '1033141070' NOT NULL, counter int(8) unsigned DEFAULT '0' NOT NULL, html int(11) DEFAULT '0' NOT NULL, smiley int(11) DEFAULT '0' NOT NULL, xcodes int(11) DEFAULT '0' NOT NULL, breaks int(11) DEFAULT '1' NOT NULL, block int(11) DEFAULT '0' NOT NULL, offline int(11) DEFAULT '0' NOT NULL, notifypub int(11) DEFAULT '0' NOT NULL, request int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (entryID), UNIQUE entryID (entryID), KEY definition (definition) );
MySQL: BLOB column 'definition' used in key specification without a key length
Stopped on error
Start from the beginning (DROP the old tables before restarting)
If i use phpmyadmin for restore it, the error is:
Quote:
Error
consulta SQL :
CREATE TABLE xoops_wbentries(
entryID int( 8 ) NOT NULL AUTO_INCREMENT ,
categoryID tinyint( 4 ) DEFAULT '0' NOT NULL ,
term varchar( 255 ) DEFAULT '0' NOT NULL ,
init char( 1 ) DEFAULT '0' NOT NULL ,
definition text NOT NULL ,
ref varchar( 255 ) DEFAULT '0' NOT NULL ,
url varchar( 255 ) DEFAULT '0' NOT NULL ,
uid int( 6 ) DEFAULT '1',
submit int( 1 ) DEFAULT '0' NOT NULL ,
datesub int( 11 ) DEFAULT '1033141070' NOT NULL ,
counter int( 8 ) unsigned DEFAULT '0' NOT NULL ,
html int( 11 ) DEFAULT '0' NOT NULL ,
smiley int( 11 ) DEFAULT '0' NOT NULL ,
xcodes int( 11 ) DEFAULT '0' NOT NULL ,
breaks int( 11 ) DEFAULT '1' NOT NULL ,
block int( 11 ) DEFAULT '0' NOT NULL ,
offline int( 11 ) DEFAULT '0' NOT NULL ,
notifypub int( 11 ) DEFAULT '0' NOT NULL ,
request int( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( entryID ) ,
UNIQUE entryID( entryID ) ,
KEY definition( definition )
)
MySQL ha dicho:
#1170 - BLOB column 'definition' used in key specification without a key length
[Documentación] · [Volver]
When i create a backup with phpmyadmin of wbentries i can restore it.
