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. Can't login.  (Read 8533 times)

0 Members and 1 Guest are viewing this topic.

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Fatal error after Upgrade. Can't login.
« on: January 07, 2011, 03:43:23 pm »

Hi,
I followed the steps on the documentation. I upgraded from 1.4.27 to 1.5.12
I run the update php but it won't let me login.
Fatal error on the main page http://www.jennifer-beals.com/gallery/index.php

i don't know what to do :-[
Logged

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #1 on: January 07, 2011, 04:19:02 pm »

sorry this is the message on debug mode

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

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

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #3 on: January 08, 2011, 12:03:20 am »

Read this thread.
http://forum.coppermine-gallery.net/index.php/topic,66743.0.html



I read that thread and a few similar ones and still no solution.

I have all the new files on the server... I have a few old ones that dont come on the new version remaining from previous install but I don't think it would cause this problem ,would it?

I disabled plugins and deleted the plugins folder  before I started the upgrade. I dont use bridge.
I deleted the lang folder before upgraded...
I left the anycontent.php and /config.inc.php

I can only see http://www.jennifer-beals.com/gallery/update.php otherwise is just the error page
 :-\
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Fatal error after Upgrade. Can't login.
« Reply #4 on: January 08, 2011, 12:14:38 am »

Old files should be removed, back them up if you want to keep them.

Try this: http://forum.coppermine-gallery.net/index.php/topic,65521.msg325610.html#msg325610

I do not strongly recommend downgrading to start over, but it is an option if you made a backup:
http://documentation.coppermine-gallery.net/en/upgrading.htm#downgrading

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #5 on: January 08, 2011, 12:32:23 am »

Old files should be removed, back them up if you want to keep them.

Try this: http://forum.coppermine-gallery.net/index.php/topic,65521.msg325610.html#msg325610



I had to create the access level table because it wasn't there.
Now I get this error
Code: [Select]
While executing query 'SELECT COUNT(*) FROM cpg_categorymap WHERE group_id in (3)' in bridge/udb_base.inc.php on line 340

mySQL error: Table 'tibettec_copp1.cpg_categorymap' doesn't exist
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Fatal error after Upgrade. Can't login.
« Reply #6 on: January 08, 2011, 12:37:10 am »

There is more than just one suggested fix in that thread.

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #7 on: January 08, 2011, 12:53:20 am »

I can see that I have some missing tables like languages and categorymap. See attachment.
Should I just downgrade and start again. I do have a backup , I hope it works.
Logged

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #8 on: January 08, 2011, 02:01:01 pm »

Before attempting any downgrade ( i don't feel confident) is there anything I can do to fix my problem?
are the missing tables causing the problem? what do I do?
sorry my knowladge on this matter is limited :-\
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Fatal error after Upgrade. Can't login.
« Reply #9 on: January 08, 2011, 02:30:55 pm »

I disabled plugins and deleted the plugins folder  before I started the upgrade.
The plugins should have been uninstalled and deleted.
Keep this in mind as you make your repairs. The entries can be deleted from the db or if you completely downgrade, then uninstall, etc.

Your choices, in my opinion are to recreate the db as that thread directs you to.
Manually editing the database will be a time-consuming task. In fact you need to run the queries in sql/update.sql - just make sure to replace the prefix CPG_ with your custom table prefix cpg148_. Subsequently, the database query you need to run would be as in the attached file. You can do a copy-paste job from the file right into the query field of phpMyAdmin.
http://forum.coppermine-gallery.net/index.php/topic,65521.msg325640.html#msg325640

Or to do it manually fix each entry until you have no errors.

Or use your backup db.
    - remove the plugin entries after you restore it
    - check it for errors
    - make sure that you have a clean, complete upload of cpg 1.5.12 on your server
    - if your anycontent.php file has code, links, etc in it, use the cpg anycontent.php file or edit
    the db entry in Config to temporarily remove any influence
    - run update.php, look for errors

If you have your albums folder, config.inc.php, and anycontent.php backed up, then you should also be able to ask your host for some assistance too

I am not very experienced with your problem, so that is the best that I can offer. With backups intact you should be fine, no matter what you try.


skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #10 on: January 08, 2011, 03:31:01 pm »

The plugins should have been uninstalled and deleted.
Keep this in mind as you make your repairs. The entries can be deleted from the db or if you completely downgrade, then uninstall, etc.

 I did that, I uninstalled the two plugins I had plus th sample one and I deleted the plugins folder before upgrading.

Quote
Your choices, in my opinion are to recreate the db as that thread directs you to.http://forum.coppermine-gallery.net/index.php/topic,65521.msg325640.html#msg325640

Or to do it manually fix each entry until you have no errors.

I got lost on that thread. I don't know how and where to run sql queries



Logged

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #11 on: January 08, 2011, 08:11:47 pm »

I've gone back to 1.4.27 and it's working fine.
But I've noticed that I still have the same tables missing that I attached on my earlier post (I'm attaching it again) would this be the cause why I can't upgrade to the new version? I never had any problem upgrading from earlier versions. ???


Logged

skyone

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 75
Re: Fatal error after Upgrade. Can't login.
« Reply #12 on: January 09, 2011, 11:42:18 pm »

I got confused on another thread with the tables regarding the above post.
After going back to 1.4.27 I gave it another try to 1.5.12, I upgraded and this time it worked.
I'm marking as solved  :)
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Fatal error after Upgrade. Can't login.
« Reply #13 on: January 10, 2011, 01:09:11 am »

Great! Thanks for returning and marking your post as solved.
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 20 queries.