Print

[Αndré]

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'.

[profili]

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.

[Αndré]

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

[profili]

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?

[Αndré]

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

[profili]

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'


[Αndré]

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).

[profili]

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

[freako]

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

best regards

[phill104]

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