On selecting the category on the live site I am getting a database error, image below.
Can anyone explain why this may be and what I need to do to correct it?
Thanks in advance
no image
Hello DIZZYMOTHER,
Thank you for your message
The problem occurs because the display_more_count field is missing for some reason in the cscart_product_filters table of your database. Please add this field manually (e.g. with using phpMyAdmin) on your server and check the result. The field should have the smallint(5) type.
—
Pavel Zyukin
CS-Cart Support team
Thanks for the reply, but I haven't a clue on how to do this?
I'm in PHP my admin, I've found the cs_cart_product_filters section… what now?
Thanks
Hello DIZZYMOTHER,
Thank you for the reply.
You should click on the name of this table in the left column and then go to the SQL tab. In this tab, clear the Run SQL query/queries in the database text input area and paste the following SQL query there:
ALTER TABLE `cscart_product_filters` ADD `display_more_count` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '20' AFTER `display_count`
After this click the Go button. Please check it.
Thank you.
—
Pavel Zyukin
CS-Cart Support team
Pure genius! ^______^
Superb, thankyou!
You are welcome.
—
Pavel Zyukin
CS-Cart Support team