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
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.
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