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 14730 times)

0 Members and 1 Guest are viewing this topic.

Α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 #20 on: January 03, 2011, 10:59:37 pm »

Just ignore error message like 'already exists' and execute the next line(s). That's exactly the same what update.php does, too. Execute every line one by one and it should be fine. Have a look at error messages that don't tell you something like 'already exists'.
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 #21 on: January 03, 2011, 11:06:29 pm »

Just ignore error message like 'already exists' and execute the next line(s). That's exactly the same what update.php does, too. Execute every line one by one and it should be fine. Have a look at error messages that don't tell you something like 'already exists'.

André, thank you for your help and your time. But I don't understand you man! You said that I have to add the whole update.sql to that SQL thing in the phpMyAdmin, and that is what i did. Now, what do you mean with "and execute the next line(s)"? Sorry if I'm wasting your time.
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 #22 on: January 03, 2011, 11:07:56 pm »

Execute every command one by one. A comment usually starts with CREATE, UPDATE, DROP or INSERT.
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 #23 on: January 03, 2011, 11:16:48 pm »

Execute every command one by one. A comment usually starts with CREATE, UPDATE, DROP or INSERT.

All these above are Klingon language for me :)
Is it too much if I give you give me your contact address (I can't send PMs here) where I can send you all the credentials to enter my host space and take a look?
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 #24 on: January 04, 2011, 09:02:55 am »

Sorry, but I don't know what's the problem of copying each SQL command (google for it if you don't know where an SQL statement starts and ends) and paste it to the 'SQL' tab of phpMyAdmin. Please re-read the thread you referred to in your initial post. There are a lot of hints how you deal with your issue. Joachim even posted a customized sql file.

You can also try if this works: http://www.galsh.com/update.php?theme=curve
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 #25 on: January 04, 2011, 10:17:01 am »

Ok, I tried with that file from Joachim posted here.

Now the phpmyadmin gives this error:

Code: [Select]
Error

SQL query:

# --------------------------------------------------------
ALTER TABLE cpg148_filetypes DROP INDEX `EXTENSION` ,
ADD PRIMARY KEY ( `extension` ) ;

MySQL said: Documentation
#1091 - Can't DROP 'EXTENSION'; check that column/key exists

And from the gallery is this message to see:

Code: [Select]
While executing query 'SELECT aid FROM cpg148_albums WHERE moderator_group IN (3)' in include/init.inc.php on line 271

mySQL error: Unknown column 'moderator_group' in 'where clause'
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 #26 on: January 04, 2011, 10:38:36 am »

And from the gallery is this message to see:

Code: [Select]
While executing query 'SELECT aid FROM cpg148_albums WHERE moderator_group IN (3)' in include/init.inc.php on line 271

mySQL error: Unknown column 'moderator_group' in 'where clause'
Well, you get an error, that the column 'moderator_group' doesn't exist. So you'll search for that word in the sql file and execute that commands. Do that as long as you get error messages (not just this error message, but all other following error messages, too).
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 #27 on: January 04, 2011, 10:43:48 pm »

Thank you André. My gallery is now updated and is working quite ok. Thank you again.
Logged

freako

  • Coppermine newbie
  • Country: 00
  • Offline Offline
  • Posts: 1
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #28 on: January 06, 2011, 12:07:31 pm »

Ive the same Problem now at my Site Auto mieten.
Can someone give a fix, at google i nothing found

best regards
Logged
Traubenkernextrakt OPC – Das Fundament menschlicher Gesundheit http://opctraubenkernextrakt.blogspot.de/ Es muss die innige Verbundenheit mit der wilden Natur Rumäniens gewesen sein, die Robert Franz in seiner Kindheit...

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« Reply #29 on: January 06, 2011, 05:45:14 pm »

That is not a coppermine driven page nor should you hijack someone elses thread. If you have a CPG driven page then we can help, if not I will delete your post.

Locking
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.021 seconds with 20 queries.