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: Fatal Error after upgrade from 1.4.19 to 1.5.28  (Read 22022 times)

0 Members and 1 Guest are viewing this topic.

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Fatal Error after upgrade from 1.4.19 to 1.5.28
« on: May 02, 2014, 11:44:35 am »

When I try to run update.php it successfully loads the initial page (which tells me 'Gallery is currently offline - check back soon'), but when I try to click login I get a white screen with 'Fatal Error'.  Is the 'offline' status somehow preventing update.php running?

My 1.4.19 install was successfully running for some years, and as far as I remember it wasn't fiddled about with, just a virgin install with no plugins.  Having read the upgrade instructions I look these steps:

Backed everything up
Set the gallery to offline
Downloaded and expanded cpg1.5.28.zip
Copied the files over the top of 1.4.19 (except the Albums directory, and anycontent.php)
Ran http://hrca.net/photogallery/update.php

I assume the following error is systematic of the fact update.php hasn't actually been run?
From ../logs/database.log.php

2014-05-02 09:08:18 - 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/udb_base.inc.php on line 323 the following error was encountered:
Unknown column 'access_level' in 'field list'

Assistance in running update.php would be much appreciated.
Thanks
Robin
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #1 on: May 02, 2014, 11:53:10 am »

Did you have bridging enabled previously? Did you have any plugins installed previously? If so please disable the bridge and all plugins. This can be done in phpmyadmin if you know what you are doing (there are plenty of threads detailing how).
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #2 on: May 02, 2014, 12:43:43 pm »

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

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #3 on: May 02, 2014, 01:07:45 pm »

My cpg_usergroups table doesn't have an 'access_level' row, should I add one (is it normal to have to dive into SQL during a routine upgrade?).

My cpg_plugin table is empty and cpg_bridge has these 27 rows:

-- Dumping data for table `cpg_bridge`
--

INSERT INTO `cpg_bridge` (`name`, `value`) VALUES
('short_name', ''),
('license_number', ''),
('db_database_name', ''),
('db_hostname', ''),
('db_username', ''),
('db_password', ''),
('full_forum_url', ''),
('relative_path_of_forum_from_webroot', ''),
('relative_path_to_config_file', ''),
('logout_flag', ''),
('use_post_based_groups', ''),
('cookie_prefix', ''),
('table_prefix', ''),
('user_table', ''),
('session_table', ''),
('group_table', ''),
('group_relation_table', ''),
('group_mapping_table', ''),
('use_standard_groups', '1'),
('validating_group', ''),
('guest_group', ''),
('member_group', ''),
('admin_group', ''),
('banned_group', ''),
('global_moderators_group', ''),
('recovery_logon_failures', '0'),
('recovery_logon_timestamp', '');
Logged

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #4 on: May 02, 2014, 01:31:43 pm »

.... further to my last post, just looked at cpg_config and it doesn't have a 'bridge_enable' row.
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #5 on: May 02, 2014, 02:55:37 pm »

My cpg_usergroups table doesn't have an 'access_level' row, should I add one (is it normal to have to dive into SQL during a routine upgrade?).
No - it's not normal...
Missing fields are signs that update.php did not run properly.

As Andre indicated below:
Quote
Check if your MySQL user has permission to ALTER tables. If you don't know how, please read this post and that corresponding post.
(links to posts are active in his entry below)
ALTER authority is only needed at upgrade time to make any table changes introduced since your last upgrade.
It is very comprehensive - as we never know what version you are coming from - as a result many statements reply 'already done'.

The script cannot currently tell the difference between truly already done - and an authorization failure...
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #6 on: May 02, 2014, 04:16:43 pm »

I've now manually added this row:
ALTER TABLE cpg_usergroups ADD access_level tinyint(4) NOT NULL default '3';
but I still get the 'Fatal error' when I try to login.

I also tried running sql/update.sql as per another forum thread, but hit errors.  Was that the correct thing to have done?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #7 on: May 02, 2014, 04:57:31 pm »

Please follow the links in my first reply to understand/find out what goes wrong and how it can be fixed. I haven't checked the database changes, but there are probably more than one table alteration. So I recommend to fix the MySQL permissions and then run the upgrade script again.
Logged

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #8 on: May 02, 2014, 05:22:17 pm »

I'm logged into phpmyadmin with the same database user as defined in coppermine, and I was able to alter the sql table with the command:
ALTER TABLE cpg_usergroups ADD access_level tinyint(4) NOT NULL default '3';
I assume this means the Update.php script would also have the 'alter' permissions?

I'm unsure what other MySQL permissions I need to fix.  Could you kindly detail exactly what I need to check or fix next, as it wasn't clear from reading the referenced other posts.

Thanks
Robin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #9 on: May 02, 2014, 05:40:45 pm »

From the first link:
Please run update.php with the parameter debug:
Quote
update.php?debug

This will show you additional information below each command. What exactly is printed below
Quote
ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';
?

As you already executed that query via phpMyAdmin successfully, either undo that change (i.e. delete the access_level column) or search for the next ALTER query.
Logged

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #10 on: May 02, 2014, 06:09:21 pm »

I've dropped the access_level row, and run with ?debug and I see this in the logs/basebase.log.php

2014-05-02 16:00:07 - While executing query 'SELECT MAX(group_quota) AS disk_max, MIN(group_quota).....
in bridge/udb_base.inc.php on line 323 the following error was encountered:
Unknown column 'access_level' in 'field list'

Should I be looking elsewhere for other more detailed 'debug' output?

Thanks for helping me here, as you can imagine I have little experience with Coppermine and other such software!
Robin
Logged

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #11 on: May 02, 2014, 06:17:18 pm »

...I should have added, I still got the fatal error message, but nothing after it:
Fatal error :

If you try running my update.php then hopefully you'll see nothing much happens, it loads the initial screen (doesn't appear to have done any updates), then when I click any of the menu items (e.g. Login) I get the fatal error:

http://hrca.net/photogallery/update.php?debug

Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #12 on: May 02, 2014, 08:18:37 pm »

For a Fatal Error, the debug for Coppermine is set in the config (or database) - not in the URL...
http://documentation.coppermine-gallery.net/en/errors.htm#errors_fatal

Debug in the url gives more info during update.PHP for specific commands.... But not for a Fatal Error.

Since you are upgrading across several years of releases - I'm sure there are multiple missing fields that have been added...
All will be handled by update.php if it is run with the proper permissions.

Have you validated the permissions as André requested??
He provided links with info related to that...

(edited to clarify the different 'debug's)
« Last Edit: May 02, 2014, 11:05:36 pm by gmc »
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #13 on: May 04, 2014, 03:58:03 pm »

OK... there is a disconnect here... and I think I found it.

From original post:
When I try to run update.php it successfully loads the initial page (which tells me 'Gallery is currently offline - check back soon'), but when I try to click login I get a white screen with 'Fatal Error'.  Is the 'offline' status somehow preventing update.php running?

Yes... the gallery being offline is preventing update.php from running (oops!).... and the missing field is preventing you from logging in... SO you have never gotten to the point of actually having update/php execute the required SQL to update your tables...

Since update.php is clearly maintenance - it should be allowed when the gallery is offline.

A few options:
Update includes/init.inc.php. 
Find: (at the bottom)
Code: [Select]
if (!USER_IS_ADMIN && $CONFIG['offline'] && !strstr($CPG_PHP_SELF, 'login')) {
and replace with:
Code: [Select]
if (!USER_IS_ADMIN && $CONFIG['offline'] && !strstr($CPG_PHP_SELF, 'login') && !defined('UPDATE_PHP')) {
This will allow execution of update.php (it defines constant 'UPDATE_PHP') even if the gallery is offline.
(This should be included as a 'bug fix' in my opinion...)

Other workarounds:
Set gallery online - will need to be done with a tool like phpMyAdmin as you can't current;y login...
The record to update is in cpg_config with a name of 'offline' - set value to '0'.
Code: [Select]
UPDATE `cpg_config` SET `value` = '0' WHERE `name` = 'offline';

Use the SKIP_AUTHENTICATION flag in update.php...
Uncomment the first of two lines below: (near the top)
Code: [Select]
// define('SKIP_AUTHENTICATION', true);
// If you don't remember the admin account data you're prompted for when running this file in your browser, umcomment the line above by removing the two slashes in front of it, upload that file to your webserver, run it in your browser. After successfully having run it, remember to restore the two slashes you removed and replace the "unsecure" version on your webserver with the "secure" version (the one that contains the double slashes).
which will bypass checks for authentication (and offline status).  Be sure to undo this once complete.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

robin.hair

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #14 on: May 06, 2014, 11:34:39 pm »

Many thanks Greg for rereading my earlier posts.  I used your third option of bypassing the authentication and offline status checks and the installation is now updated successfully :).  It seemed like a natural thing to set the Gallery Off-line, so as users wouldn't receive errors, but that was clearly my downfall!

Thanks
again
Robin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error after upgrade from 1.4.19 to 1.5.28
« Reply #15 on: May 07, 2014, 10:09:41 am »

Fixed in SVN revision 8692.
Logged
Pages: [1]   Go Up
 

Page created in 0.036 seconds with 19 queries.