forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: Shelia on September 14, 2005, 05:44:21 am

Title: Critical Error
Post by: Shelia on September 14, 2005, 05:44:21 am

I am a new user and my Gallery has worked just fine for about a week. Tonight the following error appeared

While executing query "SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8" on 0

mySQL error: Unknown column 'owner_id' in 'field list'


I checked my database and in cpg133_pictures owner_id seems to be missing. Can someone post the mysql information for me to add to my database assuming that is the problem referred to in the error?

Thanks,
Shelia

Title: Re: Critical Error
Post by: Nibbler on September 14, 2005, 08:41:38 am

Code: [Select]

ALTER TABLE cpg133_pictures ADD owner_id int(11) NOT NULL default '0';
ALTER TABLE cpg133_pictures ADD INDEX owner_id( `owner_id` );
You'll have lot picture ownership information, so you may prefer to go back to your latest backup instead.

Title: Re: Critical Error
Post by: Shelia on September 14, 2005, 05:00:43 pm

I don't have a backup as my Gallary is so new. I do have a ton of photos that I uploaded. I don't have any User Gallaries. Is there any way to do a mass uploading of user info as at this point its all the same? Do I really need to include the user info?

Shelia