WHMCS is a popular web hosting billing automation and support system. It is widely used by many web hosts. You may received the following WHMCS installation error on fresh WHMCS installation.
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade330.sql
Line 15 – Field ‘fromname’ doesn’t have a default value
Line 16 – Field ‘fromname’ doesn’t have a default value
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade340.sql
Line 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 Occurred
Please open a ticket with the debug information below for support
File: upgrade341.sql
Line 6 – Field ‘fromname’ doesn’t have a default value
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade380.sql
Line 24 – Incorrect integer value: ” for column ‘id’ at row 1
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade450.sql
Line 4 – Incorrect integer value: ” for column ‘id’ at row 1
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade500.sql
Line 6 – Field ‘attachments’ doesn’t have a default value
Line 12 – Field ‘attachments’ doesn’t have a default value
Errors Occurred
Please open a ticket with the debug information below for support
File: upgrade520.sql
Line 12 - Field 'attachments' doesn't have a default value
Line 20 - Field 'attachments' doesn't have a default value
The above WHMCS installation error occurs due to MySQL strict mode. If your MySQL server is configured with strict mode, you will receive the above error. If you have server’s root/administrative access, you can disable MySQL strict mode. Once you disable MySQL strict mode, you can proceed to install it again. This should resolve your above WHMCS installation error. Make sure that you remove all tables and files before proceeding again.
