I get an error if I want to view any picture on my pics site now!
It says "There was an error while processing a database query."
Debug info:
While executing query "SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM pictures_comments WHERE pid='962' ORDER BY msg_id ASC" on 0
mySQL error: Unknown column 'msg_raw_ip' in 'field list'
Seems like something with the MySQL table...
Any help is appreciated, as I'm in need now :roll:!
My guess would be you are running a 1.2 version of coppermine without the db changes that should occur during the update. Check the msg_raw_ip column exists, and re-apply the update if it doesnt.
Thanks for the reply!
I ran the upgrade script when I upgraded to CPG 1.2 though, and it worked fine untill yesterday!
Where should this msg_raw_ip column located then? In the cpg_pictures table?
It should be in the comments table, it is used to hold the ip address of the comment poster.
Nibbler > you just repaired my site's picture section (http://www.mathibus.com/pictures/)! Thanks a bunch!