New Parser & Database Index Bug Fix
New Parser
I've released a new update to the ClickBank product feed parser. This update will not add the weird internal ClickBank categories to your database. If you have already ran the new parser and removed the categories, this parser won't add anything new.
You can download it here: http://www.cbfront.com/parser.zip
Unzip and upload to your 'includes/admin/parser/' directory.
Database Bug
There is a database index bug that prevents ClickBank products from being imported into your database if the ClickBank ID has the same first 7 characters as another product already in your database. This affects anywhere from a couple hundred products to almost 1,000 products.
To fix this bug, you'll need access to your database through PHPMyAdmin or some other database access tool. You'll need to run the following two SQL query commands:
alter table cbf2_products drop index idx_lookup;
alter table cbf2_products add index idx_lookup(source_id, source_type);
Run the product importer and you should notice a bunch of new products.
The CBFront retail installation zip has been updated with this fix, so if you're planning on installing CBFront, download the latest cbfront2.zip file from 'Your Purchases' in the members-only section.
February 25th, 2010 - 20:04
Hey there Christopher,
Just wanted to say thanks for not letting this project go. It has been a while now since I have been able to even attend my store, so I just read about Jessie moving on. I wish him the best of luck. He was a great guy to deal with, and I am sure we will receive the same from you. Thanks for the updates, and I am trying to get you some sells mate, just not a whole lot of buying going on that I am seeing, so I sure hope that everyone else is having better luck than I am. I’ve had 1 sale in the last year, and I actually got it through YouTube, and not the store. It was a Great sell. I had made over $300 just off 1 person, but the problem is I have made only 1 sell, and now I am to the point where CB is taking away all of that money, because I have not had 5 separate Credit Card sells. I am ready to say the hell with ClickBank, they steal affiliate sells, and say it is to prevent fraud. I needed that, and it is disappearing fast. Anyway boohoo for me right. Good Luck Mate, and if I don’t just give up on ClickBank then I will be in contact.