somehow my order DBs get screwed after some time (searchbots I guess) and there starts to appear a phantom product in basket every time I add a new product to the basket in a new session. It works like this: - In a new session I go to basket, it is empty. - Then I go to some product, add it to basket and behold: there are 2 or more products, one that I added, another one that appeared there. - I erase all products from the basket, start over in the same session and it works ok. Then I may try following: - close all browser windows and reopen QC (=start a new session) - go to basket (empty) - add any product (the product appears in the basket again with some other phantom product/s) - and so on...
When I checked the DB files, the orders.php was messed up the most. there was no
<?php exit; ?>
at the beginning of the file and there was a line that appeared just as $$$ at the end of the file. The order_ext.php was ok. The orders_products was messed up in a very special way, in the middle of the huge list of product_orders there was a break in the number sequence in the second column of the db (restarted from 1). A search for the numbers in the second column showed that there are two or more instances of a number in that column, that's how the phantom products were able to appear in the basket. The 1st column was the actual product_order line number.
I have no idea how this happened, but it happens every time I clean the DBs and leave the system run for a while, several days. Help?
12345 -- that would be difficult to try, since I could never get that much traffic from people/bots there. I am posting the whole phpinfo page here: http://www.nlp.sk/test/
BTW, this thing started happening since the product/category images stopped uploading in the admin section. But that doesn't concern me as much since I generate all that shit anyway, I don't add products manually. But these two bugs may be related to some change our admin did just before these two bugs appeared.
wizzud
2006-06-02 15:42
Beholder >> You mentioned that this happens after you 'clean the DBs' - what files do you 'clean' and how?
~Beholder
2006-06-18 23:18
The problem has gone away since v. 1.3 RC1. Thank God! I cleaned the dbs by editing them with Total Commander (pressing f4) and then the TC uploaded the files back to their place. The noticeable differences inside the db files are these:
The Orders.php gets cleaned up automatically once in a while, there are never too many entries inside. I have a feeling that this didn't happen when the bug was active.
The Orders_products.php is a file that begins with entry #1 and ends with entry with a very high number. This one never gets cleaned up by itself, but it is actually good. The buggy behavior before was that there was a break in the number sequence in the second column of the db (restarted from 1) while the first column continued on to high numbers. This doesn't happen anymore.
Maybe it was a bot clicking too many links at once. Or maybe it was a bug in the QC. It might be fixed already, though.
renu
2007-12-30 20:39
Hi. I have the same problem, using QC 1.4 loaded. I´m getting crazy? Any idea on how to solve the issue? I posted the question under "sometimes"...
renu
renu
2008-01-01 13:40
First of all: Happy new year to all of you fabolus contributers!
The problem is now solved. It seems to be a corupted "orders_products.php" file. I used Total Commander to open the file, and with "F4" I deleted everything after "<?php exit; ?>" and uploaded the file again. Then the random extra "Phantom Product" stopped showing up in my cart. The sad thing is, that I had to overwrite one file at the time from a standard QC to my modified shop. I have spend the whole christmas holliday!
The thread goes on here: http://opensolution.org/Quick.Cart/forum/?p=readTopic&nr=4686&page=999