Web Hosting Main Forums > Script/software installation and upgrade

WHMCS installation error

(1/1)

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:
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

Navigation

[0] Message Index

Go to full version