I am having the same problem.

When attempting to install the Quickstart package the first step in the installation is to set up the Akeeba Backup Installer 3.6.12 and this is where it fails in the same way as described above with the following error message :

Error at the line 0: DB 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 'DB DEFAULT CHARSET=utf8' at line 1). The query was:DB DEFAULT CHARSET=utf8

I have tried all the alternative settings from within the Akeeba dialogs, changed and checked permissions, edited the joomla.sql script under /installation/sql but all without any success. This is on a Win7-64bit OS running Apache/2.2.22 (Win64) , PHP/5.4.3 , MySQL 5.5.24 and phpMyAdmin 3.5.1. I'm trying to set up the Joomla3 version but have failed exactly in the same step with the previous 2.5 version so this is not a Joomla issue.

It is quite likely that the WAMPserver installation used (with versions above) is not compatible with Akeeba Backup but I have not found any information about that. If anyone has managed to install the QuickStart on a Win7-64bit machine please let me know which versions of MySQL, PHP and phpMyAdmin you are using and if installed with the WAMPServer bundle which version.

Thanks for a great template that I really wish I could install.

I believe that your mysql server does not support InnoDB type.
solution is:
replace/delete ALL "ENGINE=InnoDB" with empty string "" in installation\sql\joomla.sql

Hi and thanks for the reply.

I am using XAMPP v1.81, and checked my mysql/bin/my.ini file for InnoDB support. It looks like it can, by default, use the InnoDB table type:



I was able to set up a new database in phpmyadmin, and import the necessary data from the installation/sql/joomla.sql file inside the Quickstart package. In the end it worked quite easy and I learned something more about databases.

Cheers,

Kiwi

Thank you kurtcobain and elkiwigrande,

I realize now that the problem is indeed with the lack of Innodb support or correct setup. Attempting to correct the settings for innodb in the my.ini as elkiwigrande showed, I created further problems and think it's to do with the wamp package not having the correct MySql packages in the default bundle as pointed out by kurtcobain. Easiest is to instead use the XAMPP bundle and check the settings for innodb instead. This might be worth mentioning to other newbies so they dont get stuck at the same step. I had no idea about this limitation in wamp before, great learning experience. Many Thanks!

Yeah, i can't fix the problem to.
The message is "NOT XML FILE for Instalation"

I hope this is the correct topic, if not I apologize in advance.

I found your great Joomla 3 template JF Vihrea, and the install went perfect. I have the template setup as the default, but I am trying to figure out how to get images setup just like the demo. For example your demo www.joomfreak.com/demo/jf_vihrea/ has various images and if you click on one you can get a description. I love this, but I am guessing this is some extension to do this. Could you please give me a few details on how this was done, if there there was a third party extension, and any special tips?

Thanks!

Tim