Issue when upgrading

[Sarah1981]

I did the latest upgrade today on my website

http://sarahhardingaddicts.bravehost.com/Gallery/index.php [Edit André: NOT SAFE FOR WORK!]

I followed the guide didn't overwrite the album folder or any.content but when I run the update I get


Coppermine Photo Gallery seems not to be installed correctly, or you are running coppermine for the first time. You'll be redirected to the installer. If your browser doesn't support redirect, click here.

Has anyone any idea on what I need to do to sort this??

Thank you.

[phill104]

Please check you include/config.inc.php file as it appears you have overwritten that.

[Sarah1981]

Thank you will go and check.

[Sarah1981]

I wrote it in as I couldn't find it but its still not working.

Now it comes up with

While executing query 'SELECT name, value FROM config' in include/init.inc.php on line 179

mySQL error: Table 'sarahhardingaddictsgallery_570045.config' doesn't exist


Thanks

[phill104]

Does the table exist? Please check using phpmyadmin. I am guessing that you may have simply not put in the details correctly possibly missing or miss typing the pre-fix

[Sarah1981]

The table exists, just checked. I had to change the password as I couldn't remember it, could this be the issue??

[Sarah1981]

Also when I try running the update it comes up with this

Coppermine critical error:
The group table does not contain the Anonymous group !

[gmc]

As Phil mentioned - verify the table prefix in yourgallery/include/config.inc.php

Code Select Expand

$CONFIG['TABLE_PREFIX'] =  "cpg_";
This prefix must match the actual prefix for your tables... It is usually not null.

Both of those errors suggest the tables are not being found.
The password should be fine - of CPG wouldn't get to the point of issuing the SQL.

[Sarah1981]

My hosts sorted something and the gallery is back but things are missing like the login box, the home buttons. I have options of login into the site. Could this be down to the theme I'm using? Would deleting the theme solve the issue?

Im running Coppermine version: 1.5.38

in the include/config file is says

// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg14x'.'_'

[Αndré]

My hosts sorted something and the gallery is back but things are missing like the login box, the home buttons. I have options of login into the site. Could this be down to the theme I'm using?

Probably. Unfortunately it seems you have deleted the default themes like curve or water_drop, so I cannot check that in detail.

[Sarah1981]

Probably. Unfortunately it seems you have deleted the default themes like curve or water_drop, so I cannot check that in detail.

I've not deleted those themes, they are still showing up in the sftp section.

I changed the theme to curve and the issue is still there.

[Αndré]

There seems to be something wrong, as I get a lot of Symbols before the HTML doctype declaration (which makes me impossible to have a closer look at your gallery's HTML source, as I always get 100% CPU usage when I try to search something). I assume it's injected by your server, as Coppermine's custom header feature would add it in the <body> tag.

[Sarah1981]

There seems to be something wrong, as I get a lot of Symbols before the HTML doctype declaration (which makes me impossible to have a closer look at your gallery's HTML source, as I always get 100% CPU usage when I try to search something). I assume it's injected by your server, as Coppermine's custom header feature would add it in the <body> tag.

Sorry for all the questions. Is there anything I can do to try and sort this?

[Αndré]

I suggest to perform the upgrade again as described in the docs (this time, keep also include/config.inc.php), in case any file got corrupted during the upload last time. When done, test again if the issue is fixed.

[Sarah1981]

Got this sorted now, thank you everyone for your help its very much appreciated 

[Αndré]

Would you be so kind and tell us what exactly you did to fix the issue? Did the second update fixed the issue immediately?

[Sarah1981]

The second installed seemed to fix everything, I think the issues were from the images or js folder as the admin panel came back after overwriting one of those folders.


Thank you for your advise and help, it really is very much appreciated, you guys are amazing and so helpful.