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: Migration not possible - keeps giving back HTTP 500 error  (Read 3160 times)

0 Members and 1 Guest are viewing this topic.

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar

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!
Logged

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Logged

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Migration not possible - keeps giving back HTTP 500 error
« Reply #2 on: July 19, 2022, 07:33:07 pm »

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

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #3 on: July 20, 2022, 12:09:41 am »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #4 on: July 21, 2022, 01:32:02 am »

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

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4856
    • Windsurf.me
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #5 on: July 21, 2022, 08:53:51 pm »

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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #6 on: July 24, 2022, 04:38:41 pm »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #7 on: July 24, 2022, 04:41:25 pm »

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!
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4856
    • Windsurf.me
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #8 on: July 24, 2022, 04:49:52 pm »

Logged
It is a mistake to think you can solve any major problems just with potatoes.

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #9 on: July 24, 2022, 08:23:08 pm »

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

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #10 on: July 25, 2022, 12:49:49 am »

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.
« Last Edit: July 25, 2022, 01:08:00 am by ron4mac »
Logged

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #11 on: July 25, 2022, 02:52:07 pm »

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

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #12 on: July 25, 2022, 03:02:31 pm »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #13 on: July 25, 2022, 03:52:39 pm »

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)?
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #14 on: July 25, 2022, 04:04:51 pm »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #15 on: July 25, 2022, 04:25:44 pm »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #16 on: July 28, 2022, 02:31:07 pm »

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?
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #17 on: July 28, 2022, 03:36:15 pm »

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

Hanna.

  • Coppermine frequent poster
  • ***
  • Country: us
  • Offline Offline
  • Gender: Female
  • Posts: 206
  • webstar
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #18 on: July 31, 2022, 12:40:28 am »

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

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1905
Re: Migration not possible - keeps giving back HTTP 500 error
« Reply #19 on: July 31, 2022, 03:08:04 am »

If you'll PM me login credentials for your hosting account, I'll see what I can figure out.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.022 seconds with 21 queries.