Akeeba Backup for Joomla!

#11300 Problem with database restoration

Posted in ‘Akeeba Backup for Joomla! 4 & 5’

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

Joomla! version

n/a

PHP version

n/a

Akeeba Backup version

n/a

Latest post by nicholas on Tuesday, 28 February 2012 05:46 CST

Tuesday, 28 February 2012 05:26 CST

user568

When im trying to install the site at the server i get the following error:

Error at the line 40: ï»¿CREATE TABLE `#__community_activities_hide` ( `activity_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ... MySQL: MySQL query failed with error 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ï»¿CREATE TABLE `m3o0s_community_activities_hide` ( `activity_id` int(11) NOT ' at line 1). The query was:ï»¿CREATE TABLE `m3o0s_community_activities_hide` ( `activity_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

Tuesday, 28 February 2012 05:46 CST

nicholas

I tried guessing your exact Joomla! version, exact PHP version, exact Akeeba Backup version used to take the backup, if you used JPA, JPS or ZIP format, how you transferred your backup archive, whether you've read the documentation and the troubleshooter (let alone which pages you read), which version of Kickstart or Akeeba eXtract Wizard (or none of the above) you used to extract the archive, which browser (make and version) you are using and the contents of your backup log file. Unfortunately, I am a lousy guesser.

So, in the absence of all of the mandatory information which you skipped mentioning despite being asked to when submitting this ticket, all I can tell you is that you have some junk characters in one of your SQL files. Most likely you are trying to restore the backup archive taken with a very old release or you are restoring it with an unsupported way.

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!

Support