Advanced search  

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

Pages: [1]   Go Down

Author Topic: MySQL Error - lasthit_ip issues  (Read 4539 times)

0 Members and 1 Guest are viewing this topic.

SaigonK

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
MySQL Error - lasthit_ip issues
« 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

SaigonK

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Re: MySQL Error - lasthit_ip issues
« Reply #1 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.

Tarique Sani

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 2712
    • http://tariquesani.net
Re: MySQL Error - lasthit_ip issues
« Reply #2 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
Logged
SANIsoft PHP applications for E Biz
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.