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] 2   Go Down

Author Topic: "Fatal Error" after upgrade from 1.4.24 to 1.5.10  (Read 11799 times)

0 Members and 1 Guest are viewing this topic.

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
"Fatal Error" after upgrade from 1.4.24 to 1.5.10
« on: January 01, 2011, 11:30:52 pm »

Hello,
I have followed the instuctions of the upgrade process in one of my galleries, but it seems that something is going wrong and this gallery wont upgrade. Instead i got a simple error message and a blank page. Have searched around and I think I have the same problem as this here http://forum.coppermine-gallery.net/index.php/topic,65521.0.html
I have turned the debug mode on following this guide here http://documentation.coppermine-gallery.net/en/errors.htm#errors_fatal

And here we are:

Code: [Select]
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 cpg148_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323

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

But I don't know what to do with these codes, I don't understand anything there.

Please someone help me how to fix these problems.
The site http://www.galsh.com/

Thank you...
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #1 on: January 02, 2011, 12:45:03 pm »

Please some help here!  :-[
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #2 on: January 03, 2011, 11:26:17 am »

Run update.php.
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #3 on: January 03, 2011, 01:02:44 pm »

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #4 on: January 03, 2011, 01:44:37 pm »

Make sure you have completely replaced the update.php file and all files in the sql directory. If it still doesn't work, perform the commands of sql/update.sql manually, especially that line:
Code: [Select]
ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #5 on: January 03, 2011, 02:59:13 pm »

Make sure you have completely replaced the update.php file and all files in the sql directory.

Did those since the first time but still nothing.

Quote
If it still doesn't work, perform the commands of sql/update.sql manually, especially that line:
Code: [Select]
ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';

How do i do this?

Your help is very appreciated. Thank you.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #6 on: January 03, 2011, 03:23:21 pm »

Use a tool like phpMyAdmin.
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #7 on: January 03, 2011, 03:52:19 pm »

Use a tool like phpMyAdmin.

Ok, but how do I perform the commands of sql/update.sql manually?

Thank you.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #8 on: January 03, 2011, 04:11:34 pm »

Replace the table prefix CPG_ with your actual table prefix and copy it to the execution box (I don't know how it's called or where it is in phpMyAdmin, as I personally don't use it).
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #9 on: January 03, 2011, 04:45:56 pm »

Replace the table prefix CPG_ with your actual table prefix and copy it to the execution box (I don't know how it's called or where it is in phpMyAdmin, as I personally don't use it).

Maybe SQL query on database? Like this in the screenshot?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #10 on: January 03, 2011, 04:46:58 pm »

Try the 'SQL' tab.
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #11 on: January 03, 2011, 04:52:58 pm »

Did it.

Code: [Select]
While executing query 'SELECT COUNT(*) FROM cpg148_categorymap WHERE group_id in (3)' in bridge/udb_base.inc.php on line 340

mySQL error: Table 'gsh_galeria.cpg148_categorymap' doesn't exist

This is now the new message from the debug mode.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #12 on: January 03, 2011, 05:01:43 pm »

You have to run all commands that are in sql/update.sql (= the whole file).
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #13 on: January 03, 2011, 05:21:59 pm »

Everything in sql/update.sql or just one part of it?
Yes you said (= the whole file), but I need to be sure and not ruin the database.
Logged

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 931
  • +Tinyportal Support team.
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #14 on: January 03, 2011, 06:05:34 pm »


but I need to be sure and not ruin the database.


As always,  Please do yourself a favour and back up your database first.  Then if it goes wrong you can restore it. ;)
Logged
Running SMF 2.0.15  / Tinyportal 1.6.4, bridged with Coppermine 1.6.06, plus cpmfetch 2.0.0

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #15 on: January 03, 2011, 06:38:31 pm »

Yes everything.
Logged

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #16 on: January 03, 2011, 08:44:03 pm »

It wont work!

Code: [Select]
Error

SQL query:

# Create temporary table to store messages carried over from one page to the other
CREATE TABLE CPG_temp_messages(
message_id varchar( 80 ) NOT NULL default '',
user_id int( 11 ) default '0',
time int( 11 ) default NULL ,
message text NOT NULL ,
PRIMARY KEY ( message_id )
) COMMENT = 'Used to store messages from one page to the other';

MySQL said: Documentation
#1050 - Table 'CPG_temp_messages' already exists
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4815
    • Windsurf.me
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #17 on: January 03, 2011, 08:44:38 pm »

At this point I think you should restore to 1.4.x from your backup then begin again. Did you disable your bridge and all plugins before you started?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

profili

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 113
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #18 on: January 03, 2011, 09:07:13 pm »

I had no bridge installed and yes I have disabled the plugins before the begin of the upgrade. To restore a copy of the 1.4 version should be impossible, because I don't have it. Yes is stupid, but I haven't downloaded a copy of the DB before the update.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4815
    • Windsurf.me
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #19 on: January 03, 2011, 10:19:32 pm »

I cannot promise I can hel here but please could you email me a copy of your database if it is not too large and I will try and do something. Again, I cannot promise anything.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1] 2   Go Up
 

Page created in 0.024 seconds with 19 queries.