During Installation SQl error : " * user warning: You have an error in your SQL syntax; check the manual that corresponds t

I have the same error, how odd, that 2 people have the same error. Any ideas on how to move on?

I had the same error... it seems like a cache issues so I messed around w/ the cache tables and got it to work (not fully tested yet though so take this w/ a grain of salt).

I cleared my cache, and deselected the tables:
-cache
-cache_menu
-cache_update EDIT: - this one causes problems... need to look at it some more.

Seems to work fine for me... and even works in aegir.

Ok, soooo I gave up on this .... kinda.

I mixed it with the db dump profile found here: http://www.lullabot.com/articles/5-step-drupal-distributions

The lullabot profile doesn't work with aegir... or at least I had troubles with it... because is imports that db dump after submitting the form rather than at the end of the install.

So attached is my working install profile...

Here is how you use it:

Site structure
--folders--
-modules
-themes
-sites
-includes
-scripts
-etc.....

-profiles
--yoursite_profile // Rename the words 'yoursite' with your own name. Ex: basic_profile
----yoursite_profile.profile //this is the profile file, remain this the same way you did the folder. Ex: basic_profile.profile
----db.sql // this is the db dump --read below for how to dump from phpmyadmin--

Extra instructions
Inside the yoursite_profile.profile file (attached) do a find and replace for yoursite_profile and replace that with what you want. this can be done with a simple notepad program (google notepad++) Ex: find all yoursite_profile.... replace with basic_profile .

You can also modify the name and description at lines 23 and 29 of the .profile file.

DB dump instructions
- Dump: I just did a db dump like I would normally by following these guidelines: http://drupal.org/node/81993
- Rename the sql file to: db.sql
- stick the db.sql file in with your .profile file

Example:
So in the end your files should look like this... if your naming it basicsite
-profiles
--basicsite_profile
----basicsite_profile.profile
----db.sql

ps. I made a few modifications to the .profile file without testing it so let me know if I made any typo's and it doesn't work.