Installation error - Database error

[snecklifter]

Hi,

I'm getting a "Database error" when trying to run the vbacmps_install.php, i
get to the first menu and when i select install and hit continue i get the following error..

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_modules
(`title`, `identifier`, `filename`, `inctype`, `templatelist`, `active`, `useshell`, `link`, `modid`, `userperms`)
VALUES
('Online Users', 'onlineusers', 'onlineusers.php', 'php_file', 'adv_portal_onlineusers\r\nforumhome_loggedinuser', '1', '1', '{$vbulletin->options[bburl]}/online.php{$vbulletin->session->vars[sessionurl_q]}', '1', '4,6,8,7,2,5,1,3');

MySQL Error : Field 'formcode' doesn't have a default value
Error Number : 1364
Request Date : Friday, October 17th 2008 @ 11:22:58 PM
Error Date : Friday, October 17th 2008 @ 11:22:58 PM
Script : http://www.keep-refurbishment.eu/admincp/vbacmps_install.php
Referrer : http://www.keep-refurbishment.eu/admincp/vbacmps_install.php
IP Address : **.*.**.**
Username : snecklifter
Classname : vB_Database
MySQL Version : 5.0.67-community-nt</textarea></form>

I have gone through the installation manual 3 time's and as far as i'm aware i hav'nt made a mistake

Please help me out, this is driving me nuts :mad:

Cheers

Sneck

[Brian]

Seems to be a bug in the MySQL version you are running.
http://bugs.mysql.com/bug.php?id=14306

Looks like you could get around it by changing your my.ini file as stated at the end (or contact your host if you do not have access to your my.ini file).