Print

[Shelia]

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

[Nibbler]

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.

[Shelia]

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