Page 1 of 1
Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 4:49 am
by wackychick
It just says internal server error with no number or anything... How do I begin determining what the problem is? Fresh install of OC 3.0.2.0, linux server, php 7.1, no other extensions installed... thanking everyone in advance.
Re: Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 5:58 am
by straightlight
Check the most recent web server access logs from your host console or from your root FTP folder - > access_logs or logs folder. More information is needed.
Re: Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 7:22 am
by wackychick
xx.xxx.xx.xxx - - [15/Feb/2018:16:03:59 -0700] "GET /shop/admin/index.php?route=tool/backup&user_token=rtdLdaJMZxYcu3z31E0slAIlMOieqIsz HTTP/1.1" 200 5536 "
http://www.blahblahblah.com/shop/admin/ ... IlMOieqIsz" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36"
xx.xxx.xx.xxx - - [15/Feb/2018:16:04:17 -0700] "POST /shop/admin/index.php?route=tool/backup/import&user_token=rtdLdaJMZxYcu3z31E0slAIlMOieqIsz HTTP/1.1" 500 - "
http://www.blahblahblah.com/shop/admin/ ... IlMOieqIsz" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36"
These are the two lines that corespond with what I was doing at that timestamp... substituted IP address with xxx and domain with blahblahblah. thanks again for looking.
Re: Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 8:10 am
by straightlight
At this point, due to a failed import, I would suggest to restore backups.
Re: Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 9:04 am
by wackychick
That's exactly what I tried to do. I attempted to Restore an sql file that was generated with the backup feature that comes with OC and I got the internal server error. thanks anyway.
Re: Restore sql file generates internal server error
Posted: Fri Feb 16, 2018 9:07 am
by straightlight
What I meant is a restoration from a backup done in your host console to recover your database. A real restoration point.