Database error on selecting category within Live Site

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

There's the image, sorry!

Screen shot 2013-04-09 at 19.22.47.png

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