forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 permissions => Topic started by: decoy4000 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.
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fwww.blueteq.net%2Fskitch%2FManage_user_groups_--20100821-232720.jpg&hash=62ecf5841bbd3da8dbf388a384eb1cbdf60aad19)
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.
-
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 (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.
-
Apologies for messing around with the post. I just wanted to make update the post with a link.
-
Did you run update.php?
-
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,
-
Please check if the field lasthit_ip exists in your pictures table.
-
Updating from 1.3 to 1.5 is not supported. You should go via 1.4.
-
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
-
lasthit_ip does not exist in the pictures table?
Add it manually.
-
First thing I tried. Every time I try to access the pages again it reverts the setting?