Hi again,

Just a small update on this, I replaced the file: _banner_stat.sql because it was missing after I was moved from another hosting.

Now I am still getting:
Resource Limit Is Reached
The website is temporarily unable to service your request as it exceeded resource limit. Please try again later.

But there is now no ERROR LOG in abantecart logs

I am still getting high CPU usage on the server though:
CPU Usage
87 / 100 (87%)

Apart from upgrading to latest is there any way to find out what is causing the high CPU usage?

Thanks

Hello.
First of all looks like you enable debug in your AbanteCart settings. Please disable it.
Then make sure you have enabled cache in AbanteCart
https://abantecart.atlassian.net/wiki/spaces/AD/pages/7569496/Debug

ok, I have disabled this now.

Now I have found this in the Error Logs:

2019-09-10 16:18:16 - database error: AbanteCart core v.1.2.13 SQL Error: Table 'tvwiza_aban964.abeb_banner_stat' doesn't exist
Error No: 1146
SQL: INSERT INTO abeb_banner_stat (`banner_id`, `type`, `store_id`, `user_info`)
VALUES ('24',
'1',
'0',
'a:4:{s:7:\"user_id\";s:0:\"\";s:7:\"user_ip\";s:13:\"81.47.174.209\";s:9:\"user_host\";N;s:2:\"rt\";s:26:\"r/extension/banner_manager\";}') in <b>/home/tvwiza/public_html/shop/core/database/amysqli.php</b> on line <b>109</b>

Any ideas please?

They have increased the resources on my package but it still keeps hitting their top limits:

Entry Processes
60 / 60 (100%)
CPU Usage
99 / 100 (99%)
Number Of Processes
61 / 75 (81.33%)

I have had this package with them for almost 2 years so I don't understand what has gone wrong here. Surely the above Entry Processes are too high, any idea what the cause might be?

Thanks

hi,

Thanks for reply, they are saying it is the website script and to seek advice from the developer, see the pic I took from my hosting cpanel

Daz

Hi, can anyone help me solve this problem which started today, a client tried to purchase and it said to check error log and this si the log:

2019-04-28 14:50:29 - database error: AbanteCart core v.1.2.14 SQL Error: Unknown storage engine 'InnoDB'
Error No: 1286
SQL: SELECT *
FROM abjy_product_stock_locations psl
LEFT JOIN abjy_locations l
ON l.location_id = psl.location_id
WHERE psl.product_id=123 AND psl.product_option_value_id IS NULL ORDER BY psl.sort_order in <b>/home/xxxxxxxx/public_html/xxxx/core/database/amysqli.php</b> on line <b>114</b>

I cannot open any product in the admin products and when i try to add a new product it fails with message to email to help@abantecart.com

Regards

Libera

Hello,

I installed Abantecart for a friend a couple days ago and everything was perfect, but today he says the main page is all over the place, he says he hasn't done anything but it looks like something is missing or edited incorrectly, i'd appreciate if someone could take a look and advise what the problem could be.
In system logs this is what is shows:
parsing error: AbanteCart core v.1.2.14 syntax error, unexpected '[' in <b>/home/xxxxxxx/public_html/shop/storefront/controller/responses/product/product.php</b> on line <b>133</b>

parsing error: AbanteCart core v.1.2.14 syntax error, unexpected '&' in <b>/home/xxxxxxx/public_html/shop/admin/controller/responses/product/product.php</b> on line <b>589</b>

database error: AbanteCart core v.1.2.14 SQL Error: Table 'serenity_abant20.xxxx_settings' doesn't exist
Error No: 1146
SQL: SELECT se.*
FROM xxxx_settings se
WHERE se.store_id = '0'
AND se.`group` NOT IN (SELECT `key` FROM abay_extensions) in <b>/public_html/shop/core/database/xxxsqli.php</b> on line <b>114</b>

Any help would be appreciated, thanks in advance

And if any helpers want to look at the website feel free to ask...

Libera