Error - probably something with MySQL

[MaThIbUs]

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:

Code Select Expand

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:!

[Nibbler]

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.

[MaThIbUs]

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?

[Nibbler]

It should be in the comments table, it is used to hold the ip address of the comment poster.

[MaThIbUs]

Nibbler > you just repaired my site's picture section! Thanks a bunch!