1054 - Unknown column 'order_product_price_before_discount' in 'field list'

Hi,

This indicates a problem with the update process.
Please click on the "check database" button in the HikaShop configuration and it should fix the problem.

Hi,

This indicates that you have too many columns in the hikashop_order_product and hikashop_cart_product tables.
I suppose that you must have created and deleted a lot of custom item fields in the past.
Go in your PHPMyAdmin and open these two tables and delete the columns of previously deleted custom item fields and it will then allow you to run the "check database" and the checkout will work again.

No. Not the records. I'm talking about the columns.
You need to check the structure of the tables and you'll see all the columns.
www.hostgator.com/help/article/dropping-...-table-in-phpmyadmin

Hi,

These are the default columns of the tables. Don't you have more columns in these tables ?
If not, then it's not a deleted custom field issue but a MySQL server setup issue.
Here is a page talking about this:
stackoverflow.com/questions/15585602/cha...l-row-size-too-large
There are several solutions proposed there.
The simplest is to run a small MySQL query to change the ROW_FORMAT of the tables:
ALTER TABLE `my_table` ROW_FORMAT=DYNAMIC;
However, this might not help and you might need to add an extra option like:
innodb_strict_mode=0
in your my.cnf file (the configuration file for the MySQL server).
But there are more potential solutions provided on that link.
Basically, it will require some tests to find what is the solution that works for you as it depends on how your MySQL server is configured.

Hi,

I can work on it, yes. However, it requires backend access, PHPMyAdmin access and server access (if the mysql configuration needs to be changed. So that means SSH access, or cpanel. Basically, what your hosting provided you to manage your server).
Also, please understand that this is the realm of server setup, not HikaShop user support.
So first, it's not my expertise. I know quite a bit about server management, but my speciality is HikaShop/Joomla/PHP/JS.
I'll basically try the different solutions proposed on the link I gave you and potentially do some more research on what the solution could be.
And second, I'll have to charge you extra for the time spent looking into. I expect it will be around 100€. Less if I can find a solution quickly, more if I need to spend several hours on it.

You can use our contact form to provide the credentials if you're ok with that:
www.hikashop.com/support/contact-us.html
Make sure you provide the URL of this forum thread for reference in your message.

Hi,

You're in luck. I was able to fix the problem by just runing the MySQL query I was talking about in your PHPMyAdmin.
After that, the "check database" button worked its magic and I was able to finish an order on your checkout without problem.
I won't charge anything as it only took me 2 minutes.