Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

superdave421

Pioneers
  • Posts

    1
  • Joined

  • Last visited

Profile Information

  • Real Name
    David

superdave421's Achievements

  1. Hello, Not sure if anyone has posted this issue yet, or if it has event been addressed. I am not sure what release of SPPC I am on becuase I got SPPC integrated with CreLoaded. This is the issue, when you have more than 10 groups, the SQL logic breaks down. The customer groups, say for products are stored in this format x,x,x where x is the customer group number. The logic breaks when you have the sql statement LIKE x% The issue happens when you hit the 10th group. With the SQL statement LIKE 1%, the customer group 1 and 10 are returned. For example, ... and p.products_group_access LIKE '1%' will return all products for groups 1 and 10. It will also occur for any 1x group number, The simply fix for this is to start the groups id with 10, this should resolve it. If there is a fix, can you please tell me which revision it is in. If not, I am looking for a solution, but there may not be one unless the DB structure is modified. Thanks -David
×
×
  • Create New...