Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 06-13-2008 14:42:45

solaris
Member
Registered: 08-07-2007
Posts: 105

*** BUG FIX AVAILABLE *** Products in wrong categories README

There is a bug in the kryptronic software which many have seen; however, no one
has identified the issue or fixed it. The bug exists when two or more categories have a similar
category id.

e.g a category listing for the "products" category will show results for all products belonging to
the "products" category as well as all products belonging to the "productstest" category.

I'm hoping this posting will get an emergency patch put in place to fix
the issue. I think this bug would allow you to see products from restricted view categories as well.

This following is a temporary fix which can be used by anyone with a mysql database. Please note
I will offer no support and this is to be used at your own risk.

First make a backup copy of CCP_Prod.php
Near line 266 in CCP_Prod.php add the following lines of code after the line reading:
"if (!(empty($where))) {$where .= 'AND ';}"

//Custom Bug Fix - by solaris 2008-06-13
//Products were showing up in the wrong category based on the like search
//e.g. a product listing for a product with the category 'prod'
//would show up in both the 'prod' and 'prodtest' category
$mycat = "%,".mysql_escape_string($ref).",%";
$where .= "xcat LIKE '{$mycat}' ";


Now put a // in front of the following lines to comment them out.

$where .= '(xcat LIKE ' . $this->KHXC_DB->quote_like($ref . ',') . ' OR ';
$where .= 'xcat LIKE '  . $this->KHXC_DB->quote_like(','  . $ref) . ' OR ';
$where .= 'xcat LIKE '  . $this->KHXC_DB->quote_like(', ' . $ref) . ' OR ';
$where .= 'xcat='       . $this->KHXC_DB->quote($ref) . ') ';

This fix will require your products to list the categories with a comma directly infront
and directly behind the category title (Even the first category will need a comma infront of it).

Possibly examples would be:
",cat1,cat2,prod,prodtest,"
",cat1, ,cat2, ,prod, ,prodtest,"

NOTE: 255 characters is your limit

Offline

 

#2 06-13-2008 14:50:15

solaris
Member
Registered: 08-07-2007
Posts: 105

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Oh, I should not I did not use the $this->KHXC_DB->quote_like() because I have categories with underscores in them and It didn't seem to work properly with these.

Offline

 

#3 06-17-2008 05:50:17

Kylos
Member
Registered: 01-03-2008
Posts: 15

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

I have had a very similar problem to this, where products have been showing up in categories where i have not related them to, and funily enough the Product Identifiers / category Identifiers are very similar.....

I think i will wait for a patch or somethign tho, as im not confident in messing around with the stuff i dont yet quite understand.

Offline

 

#4 06-18-2008 06:19:06

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

The solution solaris posted may work for you but I wouldn't recommend it as a long term solution.  This "problem" is a bit more insidious that it appears and it isn't a simple matter of changing the application (CCP) layer.  I'm looking at a core file change to address this though there are still going to be some situations where an identifier "collision" is going to cause confusion.

If/when I figure out the best solution it will still be up to Nick to decide whether or not to incorporate my suggested change(s) and when and how he releases them (if he does).

Offline

 

#5 08-09-2008 17:16:07

m0rningstarr
Member
From: Exton Pa
Registered: 11-18-2007
Posts: 40
Website

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Has there been a fix released?  I have this problem as well.

Offline

 

#6 08-09-2008 17:35:27

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

The forthcoming update will address this.

Offline

 

#7 08-14-2008 17:01:58

theblade24
Member
From: Tampa, Florida
Registered: 11-19-2003
Posts: 384
Website

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

When is an update coming?


CCP 5.1
CCP 5.1
CCP 5.1

Offline

 

#8 08-14-2008 21:07:47

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

This item was corrected in the software update released on 08/13/2008 (Update: KRYPT08132008A Build: ClickCartPro 6.0.0).  In addition many other enhancements were made and support for Extension Modules (XMODs) was added.  To be released next week are five new XMODs for ClickCartPro:  QuickBuy, ShipEstimator, SiteMap, THUB and AutoGC.  Stay tuned to kryptronic.com for more info.


Nick Hendler

Offline

 

#9 08-19-2008 18:04:01

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Hi Dave,

Has this update been rolled out to all users? If so, it hasn't fixed the issue of products being displayed in the wrong categories. I am still getting exactly the same problem with exactly the same products as before (when I forwarded the .csv's).

Here are a couple of links showing 'stray' products ...

http://www.sbtooling.co.uk/khxc/index.p … mp;ref=scH (nailers do not belong in the battery chargers category)

http://www.sbtooling.co.uk/khxc/index.p … mp;ref=scE (power tool kits do not belong in the batteries category)

Unfortunately I have been unable to any work on the site for a while due to breaking a few bones in my hands (mice are not designed to be used whilst wearing plaster casts!), but I was hoping to get stuck in within the next few weeks.


Cheers,

Steve

Offline

 

#10 08-19-2008 18:16:43

wyattea
Member
Registered: 01-07-2006
Posts: 1650

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Steve, it doesn't get 'rolled out' to all users. You have to install it yourself.

James...

Offline

 

#11 08-19-2008 18:22:50

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Hmmm, thanks for letting me know James. I presumed it was done automatically.

Live and learn, I guess ... but the 'learn' bit is an extremely long curve where CCP is concerned!

Cheers,

Steve


Cheers,

Steve

Offline

 

#12 08-19-2008 18:25:02

wyattea
Member
Registered: 01-07-2006
Posts: 1650

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Well, I was expecting you to say that, so I had an answer prepared smile If it automatically updated files, and you had mod's installed or had modified things yourself that they don't know about, you'd be pretty darn mad smile  I had 5 or 6 files I had to back up and save to make sure I 're-implemented' the custom work I had done. They weren't files from the admin section like xhtml includes but private-khxc files that most people don't usually touch.

James...

Offline

 

#13 08-19-2008 18:30:06

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

There is that I guess!

Next question ... WHERE are the updates located? I expected to see some sort of mention in 'Announcements', but there's nothing??

Cheers,

Steve


Cheers,

Steve

Offline

 

#14 08-19-2008 18:40:21

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Aha! (Or should that be 'Doh!')

I discovered the 'WHERE'... right at the top of the CCP6 Support forum! roll

Am I embarrassed? Yes!

Cheers,

Steve


Cheers,

Steve

Offline

 

#15 08-19-2008 18:47:35

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

I'm no longer embarrassed, just slightly confused.

From the announcement ...

Does my version of ClickCartPro (GBU), purchased via wwwclickcartpro.co.uk, fall into the category of a 'third-party distribution'?

Dave? Anyone?

Cheers,

Steve


Cheers,

Steve

Offline

 

#16 08-19-2008 18:54:44

redmanstudios
Member
Registered: 11-10-2003
Posts: 387

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Yes it does. The GBU Version usually follows about 2-4 weeks after the US Version.

Offline

 

#17 08-19-2008 18:56:22

wyattea
Member
Registered: 01-07-2006
Posts: 1650

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Steve, the GBU updates come out later but you guys got a sales and marketing MOD already...so it's a wash smile

James, when are you releasing the XMODs???

Offline

 

#18 08-19-2008 18:58:40

Steveb9990
Member
From: UK
Registered: 03-21-2008
Posts: 121

Re: *** BUG FIX AVAILABLE *** Products in wrong categories README

Many thanks for the prompt response James.

I look forward to the release.

Cheers,

Steve


Cheers,

Steve

Offline

 

Board footer