forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: aps on August 08, 2013, 04:46:12 am

Title: update.php not updating database
Post by: aps 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.
Title: Re: update.php not updating database
Post by: phill104 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.
Title: Re: update.php not updating database
Post by: aps 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
Title: Re: update.php not updating database
Post by: phill104 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.
Title: Re: update.php not updating database
Post by: aps 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.
Title: Re: update.php not updating database
Post by: Αndré 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 (http://forum.coppermine-gallery.net/index.php/topic,74537.msg358841.html#msg358841) and that corresponding post (http://forum.coppermine-gallery.net/index.php/topic,74537.msg358844.html#msg358844).