Hi guys,
Im currently trying to backup my gallery from my current domain name which is a .co.uk domain, as Im trying to transfer it to my new .net domain which has ImageMagick. All this time my users have been uploading images and they have never been resized so you can imagine it is killing my bandwidth. I exported the SQL and uploaded it to my new domain but in phpMyAdmin it gave me this error:
QuoteError
SQL-query :
CREATE TABLE gallerypictures(
pid int( 11 ) NOT NULL AUTO_INCREMENT ,
aid int( 11 ) DEFAULT '0' NOT NULL ,
filepath varchar( 255 ) NOT NULL ,
filename varchar( 255 ) NOT NULL ,
filesize int( 11 ) DEFAULT '0' NOT NULL ,
total_filesize int( 11 ) DEFAULT '0' NOT NULL ,
pwidth smallint( 6 ) DEFAULT '0' NOT NULL ,
pheight smallint( 6 ) DEFAULT '0' NOT NULL ,
hits int( 10 ) DEFAULT '0' NOT NULL ,
mtime timestamp( 14 ) ,
ctime int( 11 ) DEFAULT '0' NOT NULL ,
owner_id int( 11 ) DEFAULT '0' NOT NULL ,
owner_name varchar( 40 ) NOT NULL ,
pic_rating int( 11 ) DEFAULT '0' NOT NULL ,
votes int( 11 ) DEFAULT '0' NOT NULL ,
title varchar( 255 ) NOT NULL ,
caption text NOT NULL ,
keywords varchar( 255 ) NOT NULL ,
approved enum( 'YES', 'NO' ) DEFAULT 'NO' NOT NULL ,
user1 varchar( 255 ) NOT NULL ,
user2 varchar( 255 ) NOT NULL ,
user3 varchar( 255 ) NOT NULL ,
user4 varchar( 255 ) NOT NULL ,
url_prefix tinyint( 4 ) DEFAULT '0' NOT NULL ,
randpos int( 11 ) DEFAULT '0' NOT NULL ,
pic_raw_ip tinytext,
pic_hdr_ip tinytext,
PRIMARY KEY ( pid ) ,
KEY pic_hits( hits ) ,
KEY pic_rate( pic_rating ) ,
KEY aid_approved( aid, approved ) ,
KEY randpos( randpos ) ,
KEY pic_aid( aid ) ,
KEY search( title, caption, keywords, filename ) ,
KEY owner_id( owner_id )
)
MySQL said:
BLOB column 'caption' used in key specification without a key length
Anyone know what this means? Any help is glady appreciated :-\\
Anybody? :-\\
Should be
FULLTEXT KEY search (title,caption,keywords,filename)