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.26
PHP version: 5.2.5
MySQL version:5.5.25a
Host: siteground
Akeeba Backup version which took the backup: 3.2.7
Kickstart version used to extract the backup: 3.2
Description of my issue:
I backup up my site and then installed a recommended upgrade. Plugin manager then failed and siteground restored the database from softaculous. This didn't solve so i thought it best to restore from akeeba. Kickstart works fine and then I get the error:
Error at the line 0: CREATE TABLE `#__ak_profiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=My ...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=2' at line 1). The query was:CREATE TABLE `jos_ak_profiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2
Have tried deleting the database and recreating and it still fails. I'm not the most technical when in comes to web sites and would really like some help / instructions to get my site back up and running.
Thanks
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.26
PHP version: 5.2.5
MySQL version:5.5.25a
Host: siteground
Akeeba Backup version which took the backup: 3.2.7
Kickstart version used to extract the backup: 3.2
Description of my issue:
I backup up my site and then installed a recommended upgrade. Plugin manager then failed and siteground restored the database from softaculous. This didn't solve so i thought it best to restore from akeeba. Kickstart works fine and then I get the error:
Error at the line 0: CREATE TABLE `#__ak_profiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=My ...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=2' at line 1). The query was:CREATE TABLE `jos_ak_profiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2
Have tried deleting the database and recreating and it still fails. I'm not the most technical when in comes to web sites and would really like some help / instructions to get my site back up and running.
Thanks
