Moving from a server to another one ?

[mika2k3]

Hello,

I want to move my Cpg1.2.0 from one server to another one...

- I've put on my hard disk the structure of my first server (files & folders)
- I've backup my database (file : "backup_db.sql")
- I've change "config_inc.php" to match new parameters
- I've uploaded my files & folders on 2nd server
- I want to run the "backup_db.sql" on new database via phpmyadmin

--> it gives me an error message for the table "pictures" :

CREATE TABLE ecrantot_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(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)
)

MySQL a répondu:

BLOB column 'caption' used in key specification without a key length

I use Mysql 3.23.47
Can u help me please ?

Thanks,
Mika.

[Tarique Sani]

Open schema.sql and replace

Code Select Expand

caption text NOT NULL,
with

Code Select Expand

caption varchar(500) NOT NULL,

That will fix it for the time being[/code]

[mika2k3]

If i use :

Code Select Expand

caption varchar(500) NOT NULL

i obtain this sql error :

Too big column length for column 'caption' (max = 255). Use BLOB instead

and if i use

Code Select Expand

caption varchar(255) NOT NULL

i obtain :

Specified key was too long. Max key length is 500

Can u help me !?

[sede]

I have the same problem. Cannot restore the database.

Finally I was able to do it, when deleted the following line:
"KEY search (title, caption, keywords, filename) "
But I think it is not the best solution...

Please help!

[nozzz]

Hi all - maybe a bit late, but for anyone searching in the future here is the fix:

The last line of the create table SQL looks like this
KEY search (title,caption,keywords,filename)

sede mentiond it worked when he removed it, but the better option is to make the line look like this:

FULLTEXT KEY search (title,caption,keywords,filename)

I found the solution by looking in the install.php for coppermine.  The original install creates the table this way.

regards,
john
nozzz

[mohamedimran]

thx frnd...

http://funnyimgs.co.cc - My site

me too got this prob... but now it solved....

thx again...

[Fabricio Ferrero]

Locking.

Edit: I tried to locking the thread....  :-\  I can't lock this thread (as I thought), neither delete my post to let someone else see this and take action. Please some with the right permissions do what is needed.

[Joachim Müller]

@Fabricio: did as suggested. Thanks.

@all: locking.

@mohamedimran: in the future, don't post on boards that exist for reference only.