• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

WHMCS installation error

Started by Rick, April 04, 2014, 12:26:15 PM

Rick

Hi,

I am helping one of my friends to install WHMCS on his website but I am receiving the following error during 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
-------------------------------------------------

This is a fresh installation. Initial check was passed and server meets  WHMCS requirements but I am not sure how to resolve above error.

Please help!

Thanks,
Rick

Kailash

#1
Hi,

This is very common WHMCS installation error. You are receiving this error due to MySQL strict mode. To resolve this WHMCS installation error, please refer our knowledegbase article on WHMCS installation error.

- Kailash