coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: SaigonK on June 17, 2004, 12:32:01 PM

Title: MySQL Error - lasthit_ip issues
Post by: SaigonK on June 17, 2004, 12:32:01 PM
So after updating my schema.sql file from the CVS, it appears there is a missing table or something in my database. Here is the error i get in debug mode:
Any thoughts?


There was an error while processing a database query.
While executing query "UPDATE cpg11d_pictures SET hits=hits+1, lasthit_ip='216.227.168.186' WHERE pid='5385'" on 0
mySQL error: Unknown column 'lasthit_ip' in 'field list'
File: /home/is12net/public_html/gallery/include/functions.inc.php - Line: 110
Title: Re: MySQL Error - lasthit_ip issues
Post by: SaigonK on June 17, 2004, 12:34:45 PM
damn..sorry about this one...I fixed it by adding the correct table to my cpg_pictures table.
Title: Re: MySQL Error - lasthit_ip issues
Post by: Tarique Sani on June 17, 2004, 01:03:38 PM
You are using the devel checkout - There is absolutely no support OR guarantee that this will not break your set up OR wipe out your entire database - use at your own risk.

Hint: run update.php if you install a devel check out - while the above statement still holds true, this most of the times will help