Post by tingwing » Wed Oct 09, 2019 11:37 pm

hi
a "internal server error" window popup when restore using the sql I got at system-maintanence-backup&restore-backup.

the first step, I go to backup by :system-maintanence-backup&restore , select "backup"tab and click "export". then I got "xx.sql" file.
later,I found that I have miss-deleted some products I need,I would like to restore.

so the second step,I go to restore by : system-maintanence-backup&restore select "restore"tab and click "import" ,and select that "xx.sql" I have gotten in the first step.

but a "internal server error" window popup,when it run well until 3/4 . pleast take a look at the attached image named"internalServerError.jpg".

version:opencart3.0.3.1 +jounal3,not any other extenion.

thanks

Attachments

internalServerError.jpg

internalServerError.jpg (79.32 KiB) Viewed 2104 times

Last edited by tingwing on Sat Oct 12, 2019 6:36 pm, edited 1 time in total.

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by paulfeakins » Thu Oct 10, 2019 5:21 pm

Don't use the built-in backup and restore:
https://www.antropy.co.uk/blog/opencart-backup-restore/

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by tingwing » Thu Oct 10, 2019 9:10 pm

I have check storage/logs/error.log ,but there is not relevant information.
I guess it has something to do with permission,
any advice would be apreciate

thanks in advance

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by paulfeakins » Thu Oct 10, 2019 9:16 pm

Could be mod_security, ask your host to disable it.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by tingwing » Thu Oct 10, 2019 9:24 pm

paulfeakins wrote:
Thu Oct 10, 2019 5:21 pm
Don't use the built-in backup and restore:
https://www.antropy.co.uk/blog/opencart-backup-restore/
thanks for reply,by the way i know how to do a complete backup(by phpmyadmin to export full sql,and download full site files)

and I also know that the backup sql which I got from the backend-system-maintainence-backup&restore,only contain the data of table ,not include creating tables.

and I also know that if by phpmyadmin,I can use that backend's backup sql to successfully restore,

but I wish the restore function at the backend work,then I can restore more conveinently,when I need to restore data ,such as deleting some products by mistake.


thanks

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by paulfeakins » Thu Oct 10, 2019 9:25 pm

tingwing wrote:
Thu Oct 10, 2019 9:24 pm
but I wish the restore function at the backend work,then I can restore more conveinently,when I need to restore data ,such as deleting some products by mistake.
I see well in that case see my reply above about mod_security.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by tingwing » Thu Oct 10, 2019 9:32 pm

paulfeakins wrote:
Thu Oct 10, 2019 9:16 pm
Could be mod_security, ask your host to disable it.
thanks so much,I am using vps,could you be kind tell me which document should I follow to disable mod_security?

thanks

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by paulfeakins » Thu Oct 10, 2019 9:36 pm

It depends what software you're using, so Google it first and come back if you get stuck.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by tingwing » Thu Oct 10, 2019 9:49 pm

thanks,the follow article will help,but I would suggest not disable mod_security.
https://kb.bodhost.com/why-and-how-to-d ... _security/

my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com


Active Member

Posts

Joined
Tue Aug 02, 2016 9:01 pm

Post by paulfeakins » Thu Oct 10, 2019 9:51 pm

tingwing wrote:
Thu Oct 10, 2019 9:49 pm
thanks,the follow article will help,but I would suggest not disable mod_security.
https://kb.bodhost.com/why-and-how-to-d ... _security/
Sure but try it to see if that is the problem. It might not be.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: nonnedelectari and 405 guests