Fatal error after Upgrade. Can't login.

[skyone]

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

[skyone]

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'

[Joe Carver]

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

[skyone]

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
:-\

[Joe Carver]

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]

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 Expand

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

[Joe Carver]

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

[skyone]

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.

[skyone]

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 :-\

[Joe Carver]

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]

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.

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

[skyone]

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.

[skyone]

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 

[Joe Carver]

Great! Thanks for returning and marking your post as solved.