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: update.php not updating database  (Read 5559 times)

0 Members and 1 Guest are viewing this topic.

aps

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Female
  • Posts: 24
update.php not updating database
« on: August 08, 2013, 04:46:12 am »

hello,

i performed an upgrade from 1.4.27 and followed the instructions. amended my template uploaded all the new files and cannot get the updater to update the database. fatal error for every page on my menu. cannot login cannot do anything, gallery not there. i tried changing template to curve but same results.
this is my site. http://www.a-p-s.org.au/webfolios/index.php
this page now is empty with just fatal error
http://www.a-p-s.org.au/webfolios/update.php
is showing a menu but all links refer to a blank page with fatal error.

i don't know what to do. can anyone assist me ?

regards
stella.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: update.php not updating database
« Reply #1 on: August 08, 2013, 10:40:16 am »

Try re-uploading the files, some may not have uploaded correctly. Try emptying the plugins folder of old plugins. Check your database to see if any are stuck as "in use" or busy and if so run the repair tool from phpmyadmin.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

aps

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Female
  • Posts: 24
Re: update.php not updating database
« Reply #2 on: August 10, 2013, 01:29:24 am »

hi there,

tried re-uploading all the files, repairing my database through myphpadmin, deleted all my plugins... still same result.
i had no problem updating from 1.4.24 to 1.4.27. i've tried to upgrade to 1.5 now 5 times without success. any other ideas i could explore to solve this issue?

desperate
stella
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: update.php not updating database
« Reply #3 on: August 10, 2013, 10:27:06 pm »

Contact your host giving them the exact time of the error and ask for the server logs relating to the error. That will give you more information to go on.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

aps

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Female
  • Posts: 24
Re: update.php not updating database
« Reply #4 on: August 13, 2013, 04:50:31 am »

hiya,

this is the error i retrieved from my servers error log.

013-08-10 00:09:36 - 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 cpg143_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323 the following error was encountered:
Unknown column 'access_level' in 'field list'

does this shed any light onto my problem? any new ideas on how i can upgrade.

thanx, and still desperate
stella.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: update.php not updating database
« Reply #5 on: August 21, 2013, 11:41:05 am »

Unknown column 'access_level' in 'field list'
Check if your MySQL user has permission to ALTER tables. If you don't know how, please read this post and that corresponding post.
Logged
Pages: [1]   Go Up
 

Page created in 0.033 seconds with 20 queries.