Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: MySQL Error - lasthit_ip issues  (Read 4551 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.019 seconds with 18 queries.