Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Lita
New Member
New Member


Joined: Sep 29, 2004
Posts: 11

PostPosted: Sun Oct 03, 2004 6:39 pm Reply with quote

I dropped all the tables in my database, then i click sql tab in phpmyadmin then i click browse and find the saved sql file i made for backup that i did in the phpmyadmin. after i click go i recieve the following error:

Code:
Error

SQL-query :

CREATE TABLE nuke_config(

sitename varchar( 255 ) NOT NULL ,
nukeurl varchar( 255 ) NOT NULL ,
site_logo varchar( 255 ) NOT NULL ,
slogan varchar( 255 ) NOT NULL ,
startdate varchar( 50 ) NOT NULL ,
adminmail varchar( 255 ) NOT NULL ,
anonpost tinyint( 1 ) DEFAULT '0' NOT NULL ,
Default_Theme varchar( 255 ) NOT NULL ,
foot1 text NOT NULL ,
foot2 text NOT NULL ,
foot3 text NOT NULL ,
commentlimit int( 9 ) DEFAULT '4096' NOT NULL ,
anonymous varchar( 255 ) NOT NULL ,
minpass tinyint( 1 ) DEFAULT '5' NOT NULL ,
pollcomm tinyint( 1 ) DEFAULT '1' NOT NULL ,
articlecomm tinyint( 1 ) DEFAULT '1' NOT NULL ,
broadcast_msg tinyint( 1 ) DEFAULT '1' NOT NULL ,
my_headlines tinyint( 1 ) DEFAULT '1' NOT NULL ,
top int( 3 ) DEFAULT '10' NOT NULL ,
storyhome int( 2 ) DEFAULT '10' NOT NULL ,
user_news tinyint( 1 ) DEFAULT '1' NOT NULL ,
oldnum int( 2 ) DEFAULT '30' NOT NULL ,
ultramode tinyint( 1 ) DEFAULT '0' NOT NULL ,
banners tinyint( 1 ) DEFAULT '1' NOT NULL ,
backend_title varchar( 255 ) NOT NULL ,
backend_language varchar( 10 ) NOT NULL ,
language varchar( 100 ) NOT NULL ,
locale varchar( 10 ) NOT NULL ,
multilingual tinyint( 1 ) DEFAULT '0' NOT NULL ,
useflags tinyint( 1 ) DEFAULT '0' NOT NULL ,
notify tinyint( 1 ) DEFAULT '0' NOT NULL ,
notify_email varchar( 255 ) NOT NULL ,
notify_subject varchar( 255 ) NOT NULL ,
notify_message varchar( 255 ) NOT NULL ,
notify_from varchar( 255 ) NOT NULL ,
moderate tinyint( 1 ) DEFAULT '0' NOT NULL ,
admingraphic tinyint( 1 ) DEFAULT '1' NOT NULL ,
httpref tinyint( 1 ) DEFAULT '1' NOT NULL ,
httprefmax int( 5 ) DEFAULT '1000' NOT NULL ,
CensorMode tinyint( 1 ) DEFAULT '3' NOT NULL ,
CensorReplace varchar( 10 ) NOT NULL ,
copyright text NOT NULL ,
Version_Num varchar( 10 ) NOT NULL ,
PRIMARY KEY ( sitename ) ,
KEY foot1( foot1 ) ,
KEY nukeurl( nukeurl ) ,
KEY sitename( sitename ) ,
KEY nukeurl_2( nukeurl ) ,
KEY nukeurl_3( nukeurl )
)

MySQL said:


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


Is this problem unfixable?! Thanks!
 
View user's profile Send private message
chatserv
Member Emeritus


Joined: May 02, 2003
Posts: 1389
Location: Puerto Rico

PostPosted: Sun Oct 03, 2004 6:59 pm Reply with quote

Change in that file:
Code:
Version_Num varchar( 10 ) NOT NULL , 

PRIMARY KEY ( sitename ) ,
KEY foot1( foot1 ) ,
KEY nukeurl( nukeurl ) ,
KEY sitename( sitename ) ,
KEY nukeurl_2( nukeurl ) ,
KEY nukeurl_3( nukeurl )
)

to:
Code:
  Version_Num varchar(10) NOT NULL default '',

  PRIMARY KEY  (sitename)
) TYPE=MyISAM;
 
View user's profile Send private message Visit poster's website
Lita
PostPosted: Sun Oct 03, 2004 7:24 pm Reply with quote

Doing as you said I recieved the following error. It appears to be an error from the Coppermine Gallery module? I dunno anything about this stuff...but the initials CPG and pictures after it makes me think this way, if it is and if I need to somehow take out this table and lose the information within then that's fine as long as you tell me how to do it. I can always re upload the pictures. Thanks for the quick response!

Code:
Error


SQL-query : 

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( 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, user1, user2, user3, user4 )
)

MySQL said:


BLOB column 'caption' used in key specification without a key length
 
chatserv
PostPosted: Sun Oct 03, 2004 8:30 pm Reply with quote

I suggest removing that table's code along with its insert lines (save these insert lines to another file) from the backup file, once your backup has loaded create that table using coppermine's sql file and then use the insert lines you saved earlier.
 
Lita
PostPosted: Mon Oct 04, 2004 8:29 am Reply with quote

Hey Chatserv, thanks so much for the reply. I really thought I was hopeless and had lost all the files I've been working on the past year. Though, I have one more question if you don't mind. What exactly do the insert lines look like? Is it this "CREATE TABLE nuke_cpg_pictures". Thanks again, and I'll be sure to try the solution as soon as I get home from work!
 
chatserv
PostPosted: Mon Oct 04, 2004 8:35 am Reply with quote

They will look something like:
Code:
INSERT INTO nuke_cpg_pictures VALUES ('etc

INSERT INTO nuke_cpg_pictures VALUES ('etc
 
Lita
PostPosted: Mon Oct 04, 2004 12:30 pm Reply with quote

Thanks so much, it worked!!! Very Happy
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©