Install fails: Field 'afterforumids' doesn't have a default value

[Cars2007]

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO pt_project
(title, summary, description, displayorder, title_clean, summary_clean)
VALUES
('Default Project', 'This is a short summary of the project.', 'This is a description of the project. You may wish to discuss things like goals, timelines, and responsibilities here.', 1, 'Default Project', 'This is a short summary of the project.');

MySQL Error : Field 'afterforumids' doesn't have a default valueMySQL 5.1

[Steve Machol]

It's not supposed to have a default value. What are you doing when you get this error? Have you installed any modifications other than the PT and Blog?

[Cars2007]

The error happens when the installer is running. I tried dropping every table starting with pt_ and reinstalling, but that didn't fix it.

I also tried disabling all of my other products (confirmed all plugins show as "crossed out"). Same error.

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[Mike Sullivan]

You're using MySQL's strict mode. You need to disable that using the option in config.php (you should get a warning about it when you login to your control panel).

[Cars2007]

That resolved the error.