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.
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
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
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
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
Has there been a fix released? I have this problem as well.
Offline
The forthcoming update will address this.
Offline
When is an update coming?
Offline
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.
Offline
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.
Offline
Steve, it doesn't get 'rolled out' to all users. You have to install it yourself.
James...
Offline
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
Offline
Well, I was expecting you to say that, so I had an answer prepared 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 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
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
Offline
Aha! (Or should that be 'Doh!')
I discovered the 'WHERE'... right at the top of the CCP6 Support forum!
Am I embarrassed? Yes!
Cheers,
Steve
Offline
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
Offline
Yes it does. The GBU Version usually follows about 2-4 weeks after the US Version.
Offline
Steve, the GBU updates come out later but you guys got a sales and marketing MOD already...so it's a wash
James, when are you releasing the XMODs???
Offline
Many thanks for the prompt response James.
I look forward to the release.
Cheers,
Steve
Offline