View Single Post
Old November 3rd, 2007, 01:35 PM   #4 (permalink)
oldengine
Member
Verified Customer
 
Join Date: Oct 2004
Location: Florida
Posts: 318
How do I get update to run after it has already run once?

(I'm working with 1 gig of database)

Invalid SQL:
ALTER TABLE ppgal_images DROP INDEX dateline;
MySQL Error : Can't DROP 'dateline'; check that column/key exists
Error Number : 1091

Invalid SQL:
CREATE TABLE ppgal_stats (
dateline int(10) unsigned NOT NULL default '0',
necard mediumint(8) unsigned NOT NULL default '0',
nimage mediumint(8) unsigned NOT NULL default '0',
npost mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (dateline)
) TYPE=MyISAM;

MySQL Error : Table 'ppgal_stats' already exists
Error Number : 1050

You are already running the current version of PhotoPost vBGallery Photopost vBGallery.
oldengine is offline   Reply With Quote