Need PHP Help ! ( Mysql - Reward $ )

hi allz..
i do have a problem when i want to move my website to an new webhost
i am using php nuke and i get an error when i try to put the backup from the curently php nuke database.


# Table structure for table 'nuke_cpg_pictures'
#

CREATE TABLE nuke_cpg_pictures (
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 DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
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, user1, user2, user3, user4)
);



ERROR: #1170 - BLOB/TEXT column 'caption' used in key specification without a key length


and if i try to delete from table "caption" it gives me another error :
key max lenght 1000 char


if think you can help me i will give you the infos of the host..so you maby can setup it for me..
i will reward you with 5 $

thanks and waiting your posts

 

for error #1170:
you need to set a length on caption in order to have it searched by key. such as text(1000) or something.

as for deleting, i think this may resolve itself if a max langth is set on caption.

 

Try replacing:

caption text NOT NULL,

Code (markup):

With

caption varchar(255) NOT NULL,

Code (markup):

For a max length of 255 characters.

Jay

 

thats what i was saying up there. i just forgot to change text to varchar when i copied it. Im pretty sure if he was using text as the type he would want it a little more than 225 no? i dont know what he wants though.

 

i`m just trying to move the current mysql database from an webhost to antother webhost via import
this i want to do.. and not working.. i get a couple of another errors..

 

Can you post them here?

Thanks,

 

A quick solution for now is to change this:

KEY search (title, caption, keywords, filename, user1, user2, user3, user4)

Code (markup):

To this:

KEY search (title, keywords, filename, user1, user2, user3, user4)

Code (markup):

 

I think your issue has been resolved. Do you still have any issue?