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

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4726
    • 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

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4726
    • 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: 15765
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.017 seconds with 19 queries.