Products »
osCommerce Sales Forecasting » Here
Troubleshooting Lokad osCommerce
You can get community support through the
Forecasting for Business web forums. If you need immediate assistance, the
Lokad Support Team is also available.
Your subscription plan is not sufficient to access this function.
Symptoms
- You have successfully deployed the PHP code.
- You click on Download in the admin section of osCommerce.
Root causes: Add-on integration is only available with the
Enterprise subscription plan.
Solutions: You can upgrade your subscription plan from the
billing section of your Lokad account.
There are no forecasts to display
There are no forecasts to display, because you have not uploaded your data yet.
Symptoms
- You have successfully deployed the PHP code.
- You have clicked on Upload in the admin section of osCommerce
- If you log into you Lokad account, no time-series seem to have been uploaded.
- When you click on Download, you get the message There are no forecasts to display, because you have not uploaded your data yet..
Root causes: this problem typically happens on shared hosting when there are short server timeouts for the PHP executions. Indeed,
Lokad for osCommerce needs to process your sales history, and this operation can take more than a few seconds.
Solutions: We suggest to use the
Lokad Desktop Sales Forecasting. This application provides basically identical features compared to
Lokad for osCommerce. Yet, it's a regular Windows application to be install directly on your computer, and thus it will not suffer from the shared hosting timeouts.
syntax near '(orders.date_purchased) AS OrderDate
syntax near '(orders.date_purchased) AS OrderDate, SUM(orders_products.products_quant' at line 7
Symptoms
- You have successfully deployed the PHP code.
- You have clicked on Upload in the admin section of osCommerce.
- You get an SQL syntax error message.
Root causes: this problem arises if you have an old
MySQL version (typically 4.0.x series). Those MySQL versions are not supported any more even by MySQL itself (
MySQL 4.0); thus, Lokad makes no commitment to support those deprecated products.
Solutions: We would really suggest to upgrade toward a more recent version of MySQL (because you are likely to encounter similar issues for all PHP packages). Also you can try to substitute the
DATE_FORMAT method to
DATE. This approach has been discussed in the
Forecasting for Business web forums.
Fatal error: Allowed memory size of 8388608 bytes exhausted
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 79 bytes) in /usr/home/web/web103392/admin/includes/classes/lokad/common.php on line 150Symptoms
- You have successfully deployed the PHP code.
- You have clicked on Upload in the admin section of osCommerce.
- You did get the error message similar to the one here above (numbers may vary).
Root causes: this issue is likely to happen in shared hosting environment that restricts the amount of memory available to run the Lokad PHP script.
Solutions: We suggest to use the
Lokad Desktop Sales Forecasting. This application provides basically identical features compared to
Lokad for osCommerce. Yet, it's a regular Windows application to be install directly on your computer, and thus it will not suffer from the shared hosting memory limitation.