WHMCS Install Error

Some special errors show up when we try to install WHMCS today.

Errors Occured

Please open a ticket with the debug information below for support

File: upgrade330.sql

0Line 15 – Field ‘fromname’ doesn’t have a default value

Line 16 – Field ‘fromname’ doesn’t have a default value

Errors Occured

Please open a ticket with the debug information below for support

File: upgrade340.sql

0Line 16 – Field ‘fromname’ doesn’t have a default value

Line 17 – Field ‘fromname’ doesn’t have a default value

Line 18 – Field ‘fromname’ doesn’t have a default value

Line 30 – Field ‘value’ doesn’t have a default value

Errors Occured

Please open a ticket with the debug information below for support

File: upgrade341.sql

0Line 6 – Field ‘fromname’ doesn’t have a default value

Errors Occured

Please open a ticket with the debug information below for support

File: upgrade380.sql

0Line 24 – Incorrect integer value: ” for column ‘id’ at row 1

Installation Complete

The server is installed with MySQL the latest 5.1.x. While we try to troubleshoot if it is coming from the MySQL server or the WHMCS installation itself, it came up that is due to the MySQL strict mode has been enabled. Disabling the strict mode and restart your MySQL server will get your installation goes through successfully.