Site Restoration

#36559 Databaste restoration error: "Database error processing line 0"

Posted in ‘Site restoration’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version

n/a

CMS Type

Other

CMS Version

n/a

Backup Tool Version

n/a

Kickstart version

n/a

Latest post by on Sunday, 06 March 2022 20:17 CST

Friday, 04 February 2022 04:12 CST

Please look at the bottom of this page (under Support Policy Summary) for our support policy summary, containing important information regarding our working hours and our support policy. Thank you!

Dear Support,

While trying to move our site to a new server, we sadly run into this error: "See attachment"

This error only occurs while installing the back-up on a different server. Installing the back-up on our old server works correctly. So it doesn't look like the back-up is corrupted.

Could you please take a look and see what you can find so we can resolve this issue?

Kind regards,
Raoul Alderse Baas

P.S.
Kickstarting and disabling the error messages did allow the kickstart to finish, but then a specific component didn't work as intended anymore.

Said component is ZOO version 4.1.10

Edited by on 2022-03-06 20:45 CST

Friday, 04 February 2022 08:40 CST

tampe125

Hello,

looking at the error, it seems that new data has been added while taking a backup. Usually that shouldn't be a problem, since we use the primary key to order the records and then paginate through them.
However, if the primary key is not set to be an autoincrement one, weird things could happen.
Another possibility could be the database server having a temporary issue, so the same record is reported twice.

Since you're moving to a new server, my suggestion would be to put your website in maintenance mode, so no one is going to interact with it; then perform the backup again. In this way we will be sure that the original data doesn't have any issues.

Then perform the restoration again. If you still have issues, it means that the problem is on the remote server, maybe you will have to slow down the restoration.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Sunday, 06 March 2022 20:17 CST

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2022-03-06 20:17 CST

Support