MySQL Error - lasthit_ip issues MySQL Error - lasthit_ip issues
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

MySQL Error - lasthit_ip issues

Started by SaigonK, June 17, 2004, 12:32:01 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

SaigonK

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

SaigonK

damn..sorry about this one...I fixed it by adding the correct table to my cpg_pictures table.

Tarique Sani

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
SANIsoft PHP applications for E Biz