Support

Site Restoration

#24965 Database error processing line 248 - Error #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 Friday, 20 May 2016 17:20 CDT

moxley
 Hello,
I have a site backup that I took from a VPS server with Godaddy and launched it locally on my Mac using MAMP. I'm now trying to upload a backup from the mamp site back to the same server in a test folder before pointing the live site to this new folder with the new site.

Each time the database restoration starts and towards the end I get the same Error #0 as some other users here have reported. Nothing in their threads has helped me to solve this yet though.

I attached a sample of the error message. I should point out, that I've tried this multiple times and I get different line number errors each time, so it's not like it always stalls at the same point.

Any ideas?

moxley
I ran the Alice Troubleshooter and kept getting this error when scanning the log files:

------ BEGIN OF ALICE RAW OUTPUT -----
Large files issues
The following files are too big and can cause backup issues:
File: <root>/4-18-16archive.zip 394.79 Mb
File: <root>/media/com_cjlib/geoip/GeoLiteCity.dat 16.83 Mb
File: <root>/media/com_cjlib/geoip/GeoLiteCity.dat.gz 10.79 Mb

------ END OF ALICE RAW OUTPUT -----

tampe125
Akeeba Staff
Hello Joseph,

in the Database page, please click on the Show advanced options button.
Then flag the option Force UTF-8 collation on database and try again. If still get the same error, please uncheck that option and try with Force UTF-8 collation on tables .
That should do the trick.

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!

moxley
Thanks Davide, I had to force UTF-8 collation on tables to make it work. Thank you!

tampe125
Akeeba Staff
You're welcome!

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!

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.

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!