Migration not possible - keeps giving back HTTP 500 error

[Hanna.]

I spent all morning trying to migrate the coppermine with database. All other sites worked fine. I imported the whole database, it gives HTTP 500. When I import each cell in the database table, I see changes. The HTTP 500 prevents me from accessing anything. It simply doesn't load.

Please help!

[Hanna.]

The URL is: https://kaley-cuoco.net/gallery/

[Hanna.]

I spent all morning trying to migrate the coppermine with database. All other sites worked fine. I imported the whole database, it gives HTTP 500. When I import each cell in the database table, I see changes. The HTTP 500 prevents me from accessing anything. It simply doesn't load.

Please help!

I know 500 are typical server errors. But I have gone to my server/host and the entire thing is errorless. Nothing shows up in error log or elsewhere.

[ron4mac]

I see you got it running. Can you share what resolved the issue?

[Hanna.]

I see you got it running. Can you share what resolved the issue?

Not quite sure yet. What I did was, I created new databases and installed the Coppermine software from scratch. I reset database properties to default first. I noticed that the ' localhost ' was removed and an IP replaced in the config (when running the install from beginning). After that I think what I did was clear out the database (cpg) and import my sql file from old server to new.

So I believe that a combination of database properties and perhaps the localhost setting in the config file disturbed my site completely. I mean I was able to run update.php but nothing else as it was all giving me blank pages or 500 internal server errors.

Now my plan is to export the tables all and all from phpMyAdmin, create a new database (with chosen db name as I didn't choose the name when I created above^) then import the files again. Hopefully no issues.

[phill104]

Thanks for the resolution. Given all you have said I would not trust that host too much, or at least the support you got. All 500 errors will generate a message in the servers logs if it is correctly configured and support know where to look. That should be their job. Devils advocate says you may have not given them a time for the error, but that should be one of the first questions they ask.

In addition, I would be a little concerned that localhost is not resolving correctly. That may be something that needs testing (google how to for your particular hosting operating system) as if it is wrongly configured you may get bitten in the future. Hosting is out of our remit though so only general advice.

Well done on getting your gallery up and running.

[Hanna.]

Right.

I had to reinstall Wordpress the other day - and I created a whole new database, used their export/import function and it works really great. I am still seeing some weird issues with Coppermine - such as the update.php isn't able to run because it's conflicting somewhere with another file (same filename).

Is there any way to export the categories,albums,images/files and reinstall Coppermine from scratch, then import all that content on top of a new installation? This particular set up has been up since 2017 and moved around quite a lot so it could have gotten corrupted.

[Hanna.]

Something fishy is definity going on - ever since having to put an IP address instead of localhost in db config, and now it's not picking up my plugins... Yeah, weird. I'd love to clear it out with a new foundation!

[phill104]

Have you checked the gallery url correctly in your config

https://coppermine-gallery.net/docs/curr/en/configuration.htm#admin_general_coppermine-url

[Hanna.]

Have you checked the gallery url correctly in your config

https://coppermine-gallery.net/docs/curr/en/configuration.htm#admin_general_coppermine-url

Correct. I've looked through the configs. Nothing seems to put it back. Attaching screenshots for further.

[ron4mac]

It looks like you are using Cloudflare for that site. It is also returning 2 different Cloudflare IP addresses for kaley-cuoco.net (104.21.10.205 and 172.67.131.186). Did you purchase Cloudflare load balancing? I would think it is quite possible that your Cloudflare setup is causing issues.

[Hanna.]

It looks like you are using Cloudflare for that site. It is also returning 2 different Cloudflare IP addresses for kaley-cuoco.net (104.21.10.205 and 172.67.131.186). Did you purchase Cloudflare load balancing? I would think it is quite possible that your Cloudflare setup is causing issues.

That's very interesting. One of those IP's should be deactivated now.

[ron4mac]

That may help. You should probably re-install (disable cloudflare when doing so).
Not sure why your db server should have been anything other than 'localhost'.
If you want to avoid using cloudflare, you may be able to effectively use the Theme Caching plugin, instead.

[Hanna.]

That may help. You should probably re-install (disable cloudflare when doing so).
Not sure why your db server should have been anything other than 'localhost'.
If you want to avoid using cloudflare, you may be able to effectively use the Theme Caching plugin, instead.

What do you recommend me to with reinstalling? Should I reinstall coppermine with a new database and then import the old? Is there any way to move over the content alone (database wise)?

[ron4mac]

It seems to be functioning better now without cloudflare. The update.php file seems to have magically reappeared. Are your plugins working okay? If all seems okay, there may be no need to reinstall. You should run a version check to make sure all files are there and valid.

[Hanna.]

The update.php seems back now. The plugins are not syncing though.

[Hanna.]

Is there any way to clear out the plugins and re-load? They are still not showing up... Or any other way to check any errors?

[ron4mac]

Please disable the use of cloudflare on the site to see whether it then functions as you expect.

[Hanna.]

Please disable the use of cloudflare on the site to see whether it then functions as you expect.

It's been disabled. The software is not recognizing the plugins folder still...

[ron4mac]

If you'll PM me login credentials for your hosting account, I'll see what I can figure out.