Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

DB Backup not loading completely
 View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.3
Author Message
djw2
Regular
Regular



Joined: Sep 19, 2003
Posts: 95
Location: St. Louis, MO
PostPosted: Thu Jul 08, 2004 7:39 pm Reply with quote
Hey,

I was installing a questionable modules tonight so I backed up the database before I did so. After the install the module didn't work, so, I dumped my database and reinstalled from the back up.

It only loads 43 tables and then errors.

Shocked

Code:
MySQL said: 





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


It loads everything through nuke_cpg_installs and that's where it quits.

Here is nuke_cpg_installs and the following table, nuke_cpg_pictures.
Code:
# --------------------------------------------------------


#


# Table structure for table 'nuke_cpg_installs'


#





CREATE TABLE nuke_cpg_installs (


   cpg_id tinyint(3) NOT NULL auto_increment,


   dirname varchar(20) NOT NULL,


   prefix varchar(20) NOT NULL,


   version varchar(10),


   PRIMARY KEY (cpg_id)


);





#


# Dumping data for table 'nuke_cpg_installs'


#





INSERT INTO nuke_cpg_installs VALUES ( '1', 'coppermine', 'nuke_cpg_', '1.3.0');





# --------------------------------------------------------


#


# 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(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)


);





#


# Dumping data for table 'nuke_cpg_pictures'


#





INSERT INTO nuke_cpg_pictures VALUES ( '1', '15', 'modules/coppermine/albums/userpics/10002/', 





'screenshot1.jpg', '66322', '125379', '600', '450', '2', '20040707001851', '1089173257', '2', '', '0', 





'0', 'Screenshot1', 'It\'s a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '2', '12', 'modules/coppermine/albums/userpics/10002/', 





'screenshot2.jpg', '39094', '74821', '600', '450', '2', '20040707001737', '1089173325', '2', '', '0', 





'0', 'Screenshot2', 'It\'s a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '3', '13', 'modules/coppermine/albums/userpics/10002/', 





'screenshot3.jpg', '44900', '83942', '600', '450', '3', '20040707201713', '1089173369', '2', '', '0', 





'0', 'Screenshot3', 'It\'s a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '4', '14', 'modules/coppermine/albums/userpics/10002/', 





'screenshot5.jpg', '42478', '79638', '600', '450', '1', '20040707001015', '1089173413', '2', '', '0', 





'0', 'Screenshot5', 'It\'s a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '5', '3', 'modules/coppermine/albums/userpics/10002/', 





'screenshot6.jpg', '39992', '76959', '600', '450', '1', '20040707001113', '1089173472', '2', '', '0', 





'0', 'Another screenshot', 'This is a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '6', '15', 'modules/coppermine/albums/userpics/10002/', 





'screenshot6~0.jpg', '39992', '76959', '600', '450', '1', '20040707001238', '1089173558', '2', '', 





'0', '0', 'Screenshot', 'Here is a screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '7', '15', 'modules/coppermine/albums/userpics/10002/', 





'screenshot7.jpg', '60253', '113763', '600', '450', '2', '20040707010935', '1089173604', '2', '', '0', 





'0', 'Screenshot7', 'A screenshot.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '8', '4', 'modules/coppermine/albums/userpics/10002/', 





'screenshot8.jpg', '57022', '110248', '600', '450', '1', '20040707001428', '1089173667', '2', '', '0', 





'0', 'Screenshot8', 'Sometimes, there just called \"screens\".', '', 'YES', '', '', '', '', '0', '0', 





'', '');


INSERT INTO nuke_cpg_pictures VALUES ( '9', '1', 'modules/coppermine/albums/userpics/10002/', 





'screenshot9.jpg', '45041', '84655', '600', '450', '1', '20040707001458', '1089173698', '2', '', '0', 





'0', 'Screenshot9', 'Another.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '10', '2', 'modules/coppermine/albums/userpics/10002/', 





'screenshot10.jpg', '53636', '104074', '600', '450', '1', '20040707001554', '1089173753', '2', '', 





'0', '0', '10', 'Last one.', '', 'YES', '', '', '', '', '0', '0', '', '');


INSERT INTO nuke_cpg_pictures VALUES ( '11', '18', 'modules/coppermine/albums/userpics/10003/', 





'sotw-081703.jpg', '62517', '108508', '800', '600', '2', '20040707165827', '1089179395', '3', '', '0', 





'0', 'Zdeno', 'Ah, the good ole\' days.', '', 'YES', '', '', '', '', '0', '0', '', '');


Any ideas what could be causing that to happen?

BTW, I using a PHP-Nuke 7.3 Patched 2.5.


Thanks.

Dan

_________________
It has become appallingly obvious that our technology has exceeded our humanity.

--Albert Einstein 
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088
PostPosted: Thu Jul 08, 2004 9:32 pm Reply with quote
Try changing this in your backup file
Code:
KEY search (title, caption, keywords, filename, user1, user2, user3, user4)
to
Code:
FULLTEXT KEY search (title, caption, keywords, filename, user1, user2, user3, user4)
 
View user's profile Send private message
djw2
PostPosted: Thu Jul 08, 2004 10:15 pm Reply with quote
Hey Raven,

Thanks for responding, but I went ahead a scrapped the idea of getting that back up to work.

I just reloaded to sql files and install scripts and re-did the database.

The reason I did this is because even if my database hadn't stopped loading where it did, it still wasn't complete. The last table listed in the database back up file was nuke_msanalysis_iplookup so even if the back up loaded perfectly I would have still been short 52 tables. Just looking at my database it'd be missing things like Sentinel, Sommaire, Topics, Users... who am I telling, Rolling Eyes you know what's in the bottom half of the database. I was able to manually dump and restore "most" of the tables from the database file, but I've lost a lot of work. I'm just thankful this site hasn't launched yet, if I'd had 5,000 users like you do… I'd probably freakin' flip, but as it stands it’s just some work.

Now then, why did it happen? That's what I need to figure out in order to prevent it from happening again. I ran the Nuke's back up script and downloaded the database to my PC. The script stopped at nuke_msanalysis_iplookup, which is pretty much in the middle of the MSA table structure. Could it be an error in MSA that caused it to stop backing up there?

I'm lost on this one. Confused


Peace
 
Raven
PostPosted: Thu Jul 08, 2004 10:36 pm Reply with quote
I never, ever, depend on nuke's backup script. I only use that for the quickie backups. Always depend on phpMyAdmin for full backups and restores. Or your Hist's backups.
 
djw2
PostPosted: Thu Jul 08, 2004 10:39 pm Reply with quote
Quote:
Always depend on phpMyAdmin for full backups and restores.


I shall not forget this experience, thanks for the tip.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.3


 Jump to:   




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 ©