Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: HELP: moving DB to another server probs :(  (Read 4115 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.021 seconds with 18 queries.