Advanced search  


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: Unknown column 'access_level' in 'field list'  (Read 6837 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 6
mySQL error: Unknown column 'access_level' in 'field list'
« on: December 09, 2012, 01:44:53 am »

Unfortunately it is not working for me.  I was on 1.4.19, successfully upgraded to 1.4.29.  I tried to upgrade to 1.5.20 and am getting fatal errors.  I've backed, restored the database,
and tried again half a dozen times.  Each time, after I run update.php, when I go the gallery I get a fatal error.  I set debug_mode to 1 in cpg_config using mysql and now I get the following error:

While executing query 'SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (3)' in bridge/ on line 323

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


  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: mySQL error: Unknown column 'access_level' in 'field list'
« Reply #1 on: December 10, 2012, 11:07:00 am »

Check if your MySQL user has permission to ALTER tables. If you don't know how, please read this post and that corresponding post.

Next time, please don't hijack threads and search the boards before you post, as there are already some threads that dealing with that issue.
Pages: [1]   Go Up

Page created in 0.033 seconds with 20 queries.