[ic] Problem with "Others who........"

Mark Bryant mark at vwe.net
Thu Mar 11 10:42:01 EST 2004


>>Hi Everyone,
>>
>>I seem to be having a strange problem with the "Generate Others Who...." 
>>link on the merchandising page in the UI for 4.8.7 in that it seems to 
>>stop after processing 50 orders/orderlines :(
>>
>>The error log is less than helpful:
>>
>>supercow.vwe.net SpIKgoQC:vwe.net - [11/March/2004:12:20:28 +0000] eros 
>>/cgi-bin/eros/admin/build_related.html Error saving matches:
>>
>>Yup that's it, doesn't say what the error is :(
>>
>>I've fiddled with the build_related.html to print out what's going on 
>>whilst it's working
>>
>>The page claims to be using this select statement:
>>
>>         select code,order_number,sku,username from orderline
>>
>>I then have it print out the order numbers it finds, which looks like this:
>>
>>EROS00000124:
>>EROS00000264:
>>EROS00000029:
>>EROS00000089:
>>EROS00000008:
>>EROS00000148:
>>EROS00000221:
>>EROS00000073:
>>EROS00000207:
>>EROS00000228:
>>EROS00000289:
>>EROS00000301:
>>EROS00000178:
>>EROS00000251:
>>EROS00000037:
>>EROS00000097:
>>EROS00000076:
>>EROS00000110:
>>EROS00000170:
>>EROS00000302:
>>EROS00000215:
>>EROS00000348:
>>EROS00000356:
>>EROS00000369:
>>EROS00000370:
>>EROS00000373:
>>EROS00000312:
>>EROS00000164:
>>EROS00000023:
>>EROS00000143:
>>EROS00000062:
>>EROS00000269:
>>EROS00000283:
>>EROS00000128:
>>EROS00000087:
>>EROS00000201:
>>EROS00000261:
>>EROS00000342:
>>EROS00000367:
>>EROS00000078:
>>EROS00000306:
>>EROS00000291:
>>EROS00000010:
>>EROS00000077:
>>EROS00000150:
>>EROS00000196:
>>EROS00000255:
>>EROS00000369:
>>EROS00000207:
>>EROS00000353:
>>
>>353 is the 50th line in the orderline DB that it encounters ( i know this 
>>to be the case as I've exported it and loaded it into excel to see which 
>>order things happen in and these two lists match up to line 50) and then 
>>for no fathomable reason the process stops and immediately goes on to 
>>show the normal results you'd expect to see if it were working properly 
>>with only 50 order lines....
>>
>>000005: times ordered=1 others_bought ==> {}
>>000007: times ordered=2 others_bought ==> {}
>>000045: times ordered=2 others_bought ==> {}
>>000047: times ordered=1 others_bought ==> {}
>>000051: times ordered=1 others_bought ==> {}
>>000065: times ordered=1 others_bought ==> {}
>>000067: times ordered=1 others_bought ==> {}
>>000073: times ordered=1 others_bought ==> {}
>>000087: times ordered=1 others_bought ==> {}
>>000101: times ordered=3 others_bought ==> {}
>>000103: times ordered=2 others_bought ==> {}
>>000107: times ordered=1 others_bought ==> {}
>>000111: times ordered=1 others_bought ==> {}
>>000117: times ordered=1 others_bought ==> {}
>>000123: times ordered=1 others_bought ==> {}
>>000129: times ordered=4 others_bought ==> {}
>>000145: times ordered=1 others_bought ==> {}
>>000165: times ordered=8 others_bought ==> {}
>>000183: times ordered=1 others_bought ==> {}
>>000185: times ordered=1 others_bought ==> {}
>>000187: times ordered=1 others_bought ==> {}
>>000189: times ordered=1 others_bought ==> {}
>>000191: times ordered=1 others_bought ==> {}
>>000199: times ordered=1 others_bought ==> {}
>>000217: times ordered=1 others_bought ==> {'000225' => "1",}
>>000225: times ordered=1 others_bought ==> {'000217' => "1",}
>>000241: times ordered=1 others_bought ==> {}
>>000271: times ordered=2 others_bought ==> {}
>>000319: times ordered=1 others_bought ==> {'000363' => "1",}
>>000321: times ordered=1 others_bought ==> {}
>>000363: times ordered=2 others_bought ==> {'000319' => "1",}
>>000379: times ordered=2 others_bought ==> {}
>>
>>The problem is that i have 630 order lines so far spread across 373 
>>orders. It doesn't take a genius to work out that there's a LOT of stuff 
>>not being processed here, but I'm stumped as to how to fix it.
>>
>>I did find a couple of lines in orderline that didn't have a username, so 
>>I fixed that up hoping it was the answer but sadly it's made no 
>>difference at all :(
>>
>>Does anyone have any ideas why this isn't working in the way it should? 
>>I'm feeling that something is wrong in the orderline DB, but I'm not able 
>>to find it :(
>>
>>In the mean time I am manually entering stuff into the merchandising 
>>table for each order we process. This is very laborious and I would like 
>>to take advantage of the supplied link so that my time can be better 
>>spent on other things.
>>
>>Many thanks
>>
>>Mark
>
>more...
>
>My ideal solution to this problem would be to use a perl script on a cron 
>job so that it can be left to get on with it, but I'm happy to click the 
>link a few times per week if needs :)
>
>Anyway, I've had a good root about in the archives on google and sadly all 
>the issues I found seemed to be related to permissions problems on the 
>files which don't apply here.
>
>Many thanks for any suggestions.
>
>Mark

even more....

OK since my last post I've resorted orderline.txt so that the orders are 
sequential (hoping that IC will encounter them in a different order) and it 
still stops after 50 items, so I'm now thinking this isn't a fault in the 
source file/DB and is probably an "IC setting/directive" somewhere?

Many thanks

Mark



Eros Shop
vwe internet ltd
PO BOX 1067
SLOUGH
SL1 7YA
UK

Shop - http://www.eros-shop.co.uk
EMail - info at eros-shop.co.uk
Tel - 0870 737 3369
Fax - 0870 737 4469




More information about the interchange-users mailing list