Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: HELP: moving DB to another server probs :(  (Read 3780 times)

0 Members and 1 Guest are viewing this topic.

kevingpo

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
HELP: moving DB to another server probs :(
« on: December 19, 2004, 05:59:00 pm »

I exported my database so that I can move my website to another server PC. Upon importing into the new MySQL server I get this error messsage. I had a look at MySQL website but to no avail I still did not know what it means or how to solve it. Please can someone help me solve this bug.


MySQL said: 

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

#
# Dumping data for table 'nuke_cpg_exif'
#
# --------------------------------------------------------
#
# 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',
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 )
)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HELP: moving DB to another server probs :(
« Reply #1 on: December 19, 2004, 06:12:06 pm »

no nuke support on this forum, because we don't know the nuke port. Read the sticky thread on the sub-board I'm moving your posting to.

Joachim
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 18 queries.