Support

Site Restoration

#29974 Database error processing line 5

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 Friday, 17 August 2018 17:17 CDT

Wednesday, 18 July 2018 01:43 CDT

anderslolk
Hi.

I'm move my site from one server to another. I've created a backup and try to restore it on the other server but I get the fail: "Database error processing line 5". Se attachment.

Can you help?

Wednesday, 18 July 2018 04:20 CDT

nicholas
Run the restoration.

When you reach the Database Restoration page look on the right hand side and do the following:
  • Force UTF-8 collation on database: unchecked
  • Force UTF-8 collation on tables: unchecked
  • Allow UTF8MB4 auto-detection: unchecked


If it still fails, change it to:
  • Force UTF-8 collation on database: CHECKED
  • Force UTF-8 collation on tables: CHECKED
  • Allow UTF8MB4 auto-detection: unchecked

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 17 August 2018 17:17 CDT

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 2018-08-17 17:17 CDT

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!