MySQL Error - lasthit_ip issues MySQL Error - lasthit_ip issues
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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