Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 1.5.22?
PHP version: (4.3.10)
MySQL version: (5.2 I think)
Host: (HostGator)
Akeeba Backup version which took the backup: Not Sure, Probably 6 months old
Kickstart version used to extract the backup: No, Zip File so simple extract
Description of my issue:
My site got hacked so when I went to a backup from about May, I go thru the normal proceedure of uploading and extracting to the same exact location as backup. Clicking next I get the following error.
Error at the line 0: CREATE TABLE `LinkBuildingURL` ( `LinkBuildingID` int(11) NOT NULL AUTO_INCREMENT, `LinkBuildingURL` varchar(100) NOT NULL, PRIMARY KEY (`LinkBuildingID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ... 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 'TYPE=MyISAM AUTO_INCREMENT=3' at line 1). The query was:CREATE TABLE `LinkBuildingURL` ( `LinkBuildingID` int(11) NOT NULL AUTO_INCREMENT, `LinkBuildingURL` varchar(100) NOT NULL, PRIMARY KEY (`LinkBuildingID`) ) TYPE=MyISAM AUTO_INCREMENT=3
I have tried the solution you recommended before about doing a manual restore and doing a find/replace in this post: https://www.akeebabackup.com/support/site-restoration/13544-mysql-query-failed-with-error-1064.html
That gave me an error about Session Variables so I found a post Here, about fixing the Session Table problem, but then I got to more errors.
There has to be an easier fix...
