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: Weird user groups problem: Anonymous reverts back to Guest  (Read 8056 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: 15764
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: 15764
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: 15764
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.023 seconds with 20 queries.