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: Weird user groups problem: Anonymous reverts back to Guest  (Read 7071 times)

0 Members and 1 Guest are viewing this topic.

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Weird user groups problem: Anonymous reverts back to Guest
« on: August 21, 2010, 03:36:45 pm »

Hi, Thanks for the support on this great product. My Dad's been using it on V1.3 for over 5 years now.
I am in the process of setting up a new instance on another server.

After some long reading and many retry's I managed to get 1.5 up and running with original data.

However I have this funny error,  I can only view thumbnail, intermediate, and full-size images when logged in as a registered user.
As Anonymous I get this error when trying to access a full-size image:
While executing query 'UPDATE cpg131_pictures SET hits = hits + 1, lasthit_ip = '58.175.25.140', mtime = CURRENT_TIMESTAMP WHERE pid = 413' in include/functions.inc.php on line 2719

mySQL error: Unknown column 'lasthit_ip' in 'field list' 


Under the Group settings I have the three standard groups. Administrator, Registered and "Guest". "Guest" has a red X next to it recommending I change the group name to Anonymous.
(http://www.blueteq.net/skitch/Manage_user_groups_--20100821-232720.jpg)

When I click the X the name changes, I then click Apply Changes. When I navigate anywhere and then come back it will be reverted back to "Guest"

I Imported the original group table from the previous db and after running update it just went back to Guest.

Please let me know what other information I can share to help resolve this problem.

 
Logged

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #1 on: August 21, 2010, 03:37:47 pm »

Hi, Thanks for the support on this great product. My Dad's been using it on V1.3 for over 5 years now.
I am in the process of setting up a new instance on another server.

After some long reading and many retry's I managed to get 1.5 up and running with original data.

However I have this funny error,  I can only view thumbnail, intermediate, and full-size images when logged in as a registered user.
As Anonymous I get this error when trying to access a full-size image:
While executing query 'UPDATE cpg131_pictures SET hits = hits + 1, lasthit_ip = '58.175.25.140', mtime = CURRENT_TIMESTAMP WHERE pid = 413' in include/functions.inc.php on line 2719

mySQL error: Unknown column 'lasthit_ip' in 'field list' 


Under the Group settings I have the three standard groups. Administrator, Registered and "Guest". "Guest" has a red X next to it recommending I change the group name to Anonymous.
http://www.blueteq.net/skitch/Manage_user_groups_--20100821-232720.jpg

When I click the X the name changes, I then click Apply Changes. When I navigate anywhere and then come back it will be reverted back to "Guest"

I Imported the original group table from the previous db and after running update it just went back to Guest.

Please let me know what other information I can share to help resolve this problem.

 

Logged

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #2 on: August 21, 2010, 03:39:28 pm »

Apologies for messing around with the post. I just wanted to make update the post with a link.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #3 on: August 22, 2010, 12:14:12 pm »

Did you run update.php?
Logged

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #4 on: August 22, 2010, 02:43:04 pm »

Hi,

Yes Ran /update.php every-time I made a change to the db, and after every upgrade.
/versioncheck.php had a few issues which I promptly fixed, it now reports no errors.



Thanks for the reply,
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #5 on: August 22, 2010, 03:17:19 pm »

Please check if the field lasthit_ip exists in your pictures table.
Logged

Nibbler

  • Guest
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #6 on: August 22, 2010, 03:26:09 pm »

Updating from 1.3 to 1.5 is not supported. You should go via 1.4.
Logged

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #7 on: August 23, 2010, 03:16:04 am »

I did upgrade as recommended 1.3 to 1.4 then 1.5

lasthit_ip does not exist in the pictures table?
Ip related columns are: plc_raw_ip and plc_hdr_ip and following that the last column guest_token



 
   
   
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #8 on: August 30, 2010, 12:24:29 pm »

lasthit_ip does not exist in the pictures table?
Add it manually.
Logged

decoy4000

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Weird user groups problem: Anonymous reverts back to Guest
« Reply #9 on: August 31, 2010, 11:27:01 am »

First thing I tried. Every time I try to access the pages again it reverts the setting?
Logged
Pages: [1]   Go Up
 

Page created in 0.028 seconds with 19 queries.