Troubleshooting an Order Not Found...Exiting... Error
Order not found.. Exiting... may be encountered when placing a new order. This is likely to be experienced in conjunction with a number of other errors.
Symptoms
When placing an order, you encounter an Order not found... Exiting... error message on a blank page.
Cause
This error is caused by an inability for the WHMCS software to write to the MySQL database. This is typically due to the MySQL server being in strict mode. To confirm whether this is the case, use a tool like phpMyAdmin.
From the phpMyAdmin homepage, click Variables:
Scroll down to find the sql mode variable:
Make a note of the sql mode value.
If the value contains both or either of the following settings, then MySQL strict mode is enabled:
STRICT_TRANS_TABLES,STRICT_ALL_TABLESSolution
To resolve this problem, please adjust your MySQL server configuration so as to disable Strict Mode.
This can usually be done by configuring the mysqld service, or editing the /usr/my.cnf file (depending upon your server configuration).
We recommend the following value:
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONIt may be necessary to contact your server admin/hosting provider to make this server configuration change.
Please also take this opportunity to ensure your server meets all the System Requirements and resolve any errors in the Admin Area at Configuration > System Health (Help > System Health Status prior to WHMCS 8.0).