Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Database error on selecting category within Live Site Rate Topic   - - - - -

 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 09 April 2013 - 06:24 PM #1

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

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4671 posts

Posted 09 April 2013 - 07:34 PM #2

no image

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 09 April 2013 - 08:04 PM #3

There's the image, sorry!

Attached Thumbnails

  • Screen shot 2013-04-09 at 19.22.47.png


 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3809 posts

Posted 10 April 2013 - 11:19 AM #4

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

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 11 April 2013 - 10:10 AM #5

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

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3809 posts

Posted 11 April 2013 - 10:23 AM #6

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

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • DIZZYMOTHER
  • Senior Member
  • Members
  • Join Date: 13-Jun 07
  • 299 posts

Posted 11 April 2013 - 10:29 AM #7

Pure genius! ^______^


Superb, thankyou!

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3809 posts

Posted 11 April 2013 - 10:32 AM #8

You are welcome.

---
Pavel Zyukin
CS-Cart Support team

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation