Show Posts

1

Support / Database error for help

« on: December 19, 2021, 09:30:42 PM »

The error content displayed on the page is as follows:
There has been a critical error processing your request
Error: Table'./H100 /abc_online_customers' is marked as crashed and should be repaired
Error No: 145
DELETE FROM `abc_online_customers` WHERE `date_added`< (NOW()-INTERVAL 1 HOUR) in

In the same problem last week, I found the abc_online_customers form in Navicat and repaired it. At that time, the website was back to normal.

But the same error was reported today. What's more troublesome is that abc_online_customers is no longer found in Navicat. Where did it go? How to deal with it? Please help me, thanks!

2

Support / There has been a critical error processing your request

« on: September 17, 2020, 10:00:46 PM »

Hello
My website was unable to log in to FTP this morning. After contacting the service provider to recover, the following error appeared on the website page.
Error: Table'./H1×0××7_×B/abc_online_customers' is marked as crashed and should be repaired
Error No: 145
DELETE FROM `abc_online_customers` WHERE `date_added`< (NOW()-INTERVAL 1 HOUR)

This seems to be a problem with the database? Please help me, thanks!

3

Support / help. Coupon is either invalid, expired or reached it's usage limit!

« on: August 24, 2020, 10:12:29 PM »

The system version is 1.2.12. Coupon has been set before and it can work normally.
Yesterday, a new coupon was set up, and customers reported that the discount code was invalid. After self-testing, this is indeed the case.
I tried to modify the Per Coupon, Total Amount, and login status, etc., and every test showed the same error.
I can't check the source of the problem now, help me! Thank you!

4

Support / Error: Unknown column 'sku' in 'field list'

« on: November 20, 2019, 08:31:35 PM »

The version is upgraded from 1.2.6 to 1.2.12, jumping.
Everything else is debugged. However, the following error occurred when the test order was checked out. I tried a lot of ways. But it has not been resolved. can you help me?

2019-11-20 18:16:33 - database error: AbanteCart core v.1.2.12 Error: Unknown column 'sku' in 'field list'
Error No: 1054
INSERT INTO abc_order_products
SET order_id = '1663',
product_id = '272',
name = 'Dragon HDD Bay Hard Drive Cover Shell Replacement Faceplate for PS4 Console',
model = '',
sku = '',
price = '8.9',
total = '17.8',
tax = '0',
quantity = '2',
subtract = '1' in <b>/www/users/H10046687/core/database/mysql.php</b> on line <b>118</b>

5

Support / The “options” function in creating a new product section is completely invalid?

« on: November 27, 2018, 12:09:28 AM »

For the site itself, I don't have any action, just create a new product, but I can't save it when I add a product category to “options”.

I tried to modify the“ options” section of the previous successful product, but I still can't save it.

Has anyone encountered this situation? How to solve it?

6

Support / The database received the attack twice and the room was filled.

« on: May 14, 2017, 11:57:31 PM »

DOes the site iself have a database backup? What is the path?

How to avoid this happening again?