WHMCS installation error

WHMCS installation error

WHMCS is a popular web hosting billing automation and support system. It is widely used by many web hosts.

WHMCS Complete Billing and Support

You may receive the following 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.

Posted in WHMCS.

Leave a Reply

Your email address will not be published. Required fields are marked *