extreme order numbers

nicarcola

Avatar: nicarcola

2007-12-03 20:17

This is my order file. As you can see, I get all of a sudden, extreme orer numbers. What is the reason for this? I work with V1.4 loaded.

1$1196184315371$0$
5813208210$1196670511429$0$
5813208209$1196668557398$0$
5813208208$1196666493193$0$
5813208207$1196666329770$0$
5813208206$1196662360484$0$
5813208205$1196660319961$0$
5813208204$1196650813859$0$
5813208203$1196649368969$0$
5813208202$1196646316602$0$
5813208201$1196645140183$0$
5813208200$1196643460995$0$
5813208199$1196642385726$0$
5813208198$1196641960707$0$
5813208197$1196640383502$0$
5813208196$1196638912155$0$
5813208195$1196637853130$0$
5813208194$1196637214195$0$
5813208193$1196637203186$0$
5813208192$1196636885438$0$
5813208191$1196636181450$0$
5813208190$1196633916281$0$
5813208189$1196633641264$0$
5813208188$1196633509296$0$
5813208187$1196633474854$0$
5813208186$1196633444287$0$
5813208185$1196632670889$0$
5813208184$1196632214826$0$
5813208183$1196631447764$0$
5813208182$1196631159621$0$
5813208181$1196630563901$0$
5813208180$1196627793941$0$
5813208179$1196627641251$0$
5813208178$1196627547883$0$
5813208177$1196625987470$0$
5813208176$1196624477879$0$
5813208175$1196624202909$0$
5813208174$1196623694539$0$
5813208173$1196621954604$0$
5813208172$1196620967771$0$
5813208171$1196620730307$0$
5813208170$1196620145313$0$
5813208169$1196620423751$0$
5813208168$1196619942402$0$
5813208167$1196619870854$0$
5813208166$1196617598788$0$
5813208165$1196617969130$0$
5813208164$1196616840266$0$
5813208163$1196615308230$0$
5813208162$1196614946329$0$
5813208161$1196614898565$0$
5813208160$1196614889763$0$
5813208159$1196614864674$0$
5813208158$1196614776136$0$
5813208157$1196614748782$0$
5813208156$1196614738252$0$
5813208155$1196614720272$0$
5813208154$1196614707932$0$
5813208153$1196614688497$0$
5813208152$1196614663682$0$
5813208151$1196614647692$0$
5813208150$1196614619172$0$
5813208149$1196614602546$0$
5813208148$1196614588935$0$
5813208147$1196614575386$0$
5813208146$1196614556288$0$
5813208145$1196614551170$0$
5813208144$1196614545259$0$
5813208143$1196614539269$0$
5813208142$1196614513333$0$
5813208141$1196614502791$0$
5813208140$1196614465822$0$
5813208139$1196614460457$0$
5813208138$1196614423895$0$
5813208137$1196614370349$0$
5813208136$1196614365437$0$
5813208135$1196614333318$0$
5813208134$1196614313504$0$
5813208133$1196614274789$0$
5813208132$1196614179890$0$
5813208131$1196612025113$0$
5813208130$1196611644238$0$
5813208129$1196608083834$0$
5813208128$1196605953879$0$
5813208127$1196602704656$0$
5813208126$1196602030409$0$
5813208125$1196596566378$0$
5813208124$1196584925559$0$
5813208123$1196584477469$0$
5813208122$1196584344834$0$
5813208121$1196583518150$0$
5813208120$1196583171111$0$
5813208119$1196572956926$0$
5813208118$1196562781538$0$
5813208117$1196561006984$0$
5813208116$1196558517605$0$
5813208115$1196556744735$0$
5813208114$1196556005209$0$
5813208113$1196552829236$0$
5813208112$1196551107491$0$
5813208111$1196549872573$0$
5813208110$1196549096274$0$
5813208109$1196544948300$0$
5813208108$1196541811864$0$
5813208107$1196540866568$0$
5813208106$1196538946188$1$
5813208105$1196535268233$0$
5813208104$1196533797509$0$
5813208103$1196531648283$0$
5813208102$1196530931574$0$
5813208101$1196528048852$0$
5813208100$1196524229129$0$
5813208099$1196515940784$0$
5813208098$1196515036408$0$
5813208097$1196514248675$0$
5813208096$1196513686367$0$
5813208095$1196511449508$0$
5813208094$1196507769821$0$
5813208093$1196507159119$0$
5813208090$1196500684653$1$
5813207812$1196061101317$1$
4098$1195767065307$1$
3946$1195636972108$1$
3920$1195561550340$1$
3646$1195054293422$1$
3358$1194712249717$1$
3028$1194358913868$1$
2956$1194275454281$1$
2502$1193758942878$1$
2320$1193574418520$1$
2295$1193553248356$1$
2190$1193404823989$1$
2014$1193130780729$1$
1874$1192805809267$1$
1782$1192733881330$1$
1345$1192108832795$1$

» Quick.Cart v1.x

noudshoorn@scarlet.nl

merci

No avatar

2007-12-04 08:36

nicarcola - the new order is added while adding product to basket, so the reason can be that some robots were clicking "add to basket" button, and make so many inserts to the file. There were in the paste few topic similar to your, so you can search for them.

nicarcola

Avatar: nicarcola

2007-12-04 17:50

Is it possible to be more specific. I mean where have all the other order numbers of those robots(?) gone to.

I can't find the similar topics and the topics I can find don't answer this problem.

noudshoorn@scarlet.nl

merci

No avatar

2007-12-05 09:08

nicarcola - what you can do is to remember (save) this orders with big id numbers which have 1 in last column (only this are real orders) and then delete all lines with big id. The next time when the order will be save it will take the last id to ganerate id for new order.

nicarcola

Avatar: nicarcola

2007-12-06 18:59

OK I understand what I can do. But I hope you agree with me that this is not the solution of this problem. I want to know what causes this problem!

noudshoorn@scarlet.nl

merci

No avatar

2007-12-07 08:19

nicarcola - I don't know what caused this, but it is rather not dangerous. You are first person who has this problem, so it is rare situation and as I said not dangerous.

renu

No avatar

2007-12-16 15:55

Hi.
I recently implemented Quic.Cart and have a problem similar to the one above.

Merci. How would you prefer all of deleting the $0 at the end of all lines (code and file)?
If someone is online an you delete the "$0" orders they will loose the order they (perhaps) generate.

It´a a quite tricky issue, as one has to refer the order ID´s to the local authorities (TAX).
They simply won´t believe, when jumping up and down in order ID´s .

Iny good idea`?

Jens Henrik

renu

No avatar

2007-12-16 15:56

Forgot to mention version: Running 1.4 loaded.

Jens Henrik

renu

No avatar

2007-12-16 20:53

Why generate an empty order at the beginning?
Why not storing the data in a session variable?
THEN generate the order number IF the order has to be generated?
I don´ t how to do it but after concidering it for some hours it could maybe solve the issue?

Any good ideas?

Jens Henrik

merci

No avatar

2007-12-17 11:29

renu - we know about this, we want to improve it in new version - 3.x but in older version we are not able to change it.

nicarcola

Avatar: nicarcola

2007-12-17 19:23

here I send you a new order file with the same problem. Maybe it can help you to see what caused this. Look at tn emoment where the numbering goes worng.

1$1197614353784$0$
614353522$1197913983990$0$
614353521$1197908099304$0$
614353520$1197906526614$0$
614353519$1197905140986$0$
614353518$1197902869489$0$
614353517$1197902697971$0$
614353516$1197902642693$0$
614353515$1197901301755$0$
614353514$1197900974164$0$
614353513$1197899392246$0$
614353512$1197895771413$0$
614353511$1197895731456$0$
614353510$1197893326287$0$
614353509$1197888676391$0$
614353508$1197887404161$0$
614353507$1197886519293$0$
614353506$1197881175143$0$
614353505$1197881319675$0$
614353504$1197878292833$0$
614353503$1197876435959$1$
614353502$1197876266455$0$
614353501$1197872690751$0$
614353500$1197871812293$0$
614353499$1197870302512$0$
614353498$1197868888351$0$
614353497$1197868022159$0$
614353496$1197867696839$0$
614353495$1197866896523$0$
614353494$1197865966556$0$
614353493$1197865944420$0$
614353492$1197865050103$0$
614353491$1197865048965$0$
614353490$1197865037831$0$
614353489$1197865036976$0$
614353488$1197865035535$0$
614353487$1197865034689$0$
614353486$1197865033155$0$
614353485$1197865019581$0$
614353484$1197865012857$0$
614353483$1197864993891$0$
614353482$1197864979759$0$
614353481$1197864976143$0$
614353480$1197864952316$0$
614353479$1197864951610$0$
614353478$1197864941482$0$
614353477$1197864924240$0$
614353476$1197864916683$0$
614353475$1197864909111$0$
614353474$1197864908567$0$
614353473$1197864895481$0$
614353472$1197864875827$0$
614353471$1197864859152$0$
614353470$1197864855753$0$
614353469$1197864852927$0$
614353468$1197864816351$0$
614353467$1197864814775$0$
614353466$1197864793229$0$
614353465$1197864788853$0$
614353464$1197864699475$0$
614353463$1197864680462$0$
614353462$1197864679737$0$
614353461$1197864678373$0$
614353460$1197864677785$0$
614353459$1197864672892$0$
614353458$1197864671118$0$
614353457$1197864669625$0$
614353456$1197864667361$0$
614353455$1197862274369$0$
614353454$1197862208357$0$
614353453$1197853004583$0$
614353452$1197852865664$0$
614353451$1197850433462$0$
614353450$1197850209505$0$
614353449$1197849850233$0$
614353448$1197849684891$0$
614353447$1197849536132$0$
614353446$1197848840584$0$
614353445$1197846796553$0$
614353444$1197843145219$0$
614353443$1197841591398$0$
614353442$1197841392388$0$
614353441$1197837467766$0$
614353440$1197836755990$0$
614353439$1197835662180$0$
614353438$1197835145642$0$
614353437$1197834944562$0$
614353436$1197833967219$0$
614353435$1197833384902$0$
614353434$1197832412165$0$
614353433$1197830154488$0$
614353432$1197828424831$1$
614353431$1197827912453$0$
614353430$1197827168929$0$
614353429$1197825030711$0$
614353428$1197824220971$0$
614353427$1197822392592$0$
614353426$1197822911892$0$
614353425$1197821299833$0$
614353424$1197815441118$0$
614353423$1197815419382$0$
614353422$1197810831823$0$
614353421$1197808251920$0$
614353420$1197805406928$0$
614353419$1197803635130$0$
614353418$1197800504870$0$
614353417$1197800364680$0$
614353416$1197797550165$0$
614353415$1197796445363$0$
614353414$1197796139212$0$
614353413$1197794463782$0$
614353412$1197793111760$0$
614353411$1197793032758$0$
614353410$1197780316487$0$
614353409$1197780130719$0$
614353408$1197780114520$0$
614353407$1197780075360$0$
614353406$1197779779778$0$
614353405$1197779223316$0$
614353404$1197778705933$0$
614353403$1197778428840$0$
614353402$1197772070796$0$
614353401$1197777650491$0$
614353400$1197775078791$0$
614353399$1197774580605$0$
614353398$1197773778286$0$
614353397$1197772174444$0$
614353396$1197772074216$0$
614353395$1197770864443$0$
614353394$1197769744617$0$
614353393$1197768943206$0$
614353392$1197765098790$0$
614353391$1197763660620$0$
614353390$1197761684710$0$
614353389$1197759830596$0$
614353388$1197757794513$0$
614353387$1197756213831$0$
614353386$1197756099167$0$
614353385$1197756072225$0$
614353384$1197755510261$0$
614353383$1197755470161$0$
614353382$1197755044186$0$
614353381$1197754747308$0$
614353380$1197754728871$0$
614353379$1197751862132$0$
614353378$1197751800176$0$
614353377$1197751749223$0$
614353376$1197751785446$0$
614353375$1197751114267$0$
614353374$1197750223391$0$
614353373$1197749884921$0$
614353372$1197747962845$0$
614353371$1197746828682$0$
614353370$1197746747398$0$
614353369$1197745238173$0$
614353368$1197744761385$0$
614353367$1197744453920$0$
614353366$1197738886435$0$
614353365$1197738435118$0$
614353364$1197737290640$0$
614353363$1197737144187$0$
614353362$1197736857507$0$
614353361$1197736631646$0$
614353360$1197736488363$0$
614353359$1197736376408$0$
614353358$1197735996225$0$
614353357$1197735052723$0$
614353356$1197734273317$0$
614353355$1197732542441$0$
614353354$1197732078619$0$
614353353$1197731924329$0$
614353352$1197731464797$0$
614353351$1197731217903$0$
614353350$1197730206371$0$
614353349$1197729441939$0$
614353348$1197729084351$0$
614353347$1197729385447$0$
614353346$1197729196308$0$
614353345$1197729198633$0$
614353344$1197729096540$0$
614353343$1197728747494$0$
614353342$1197728169706$0$
614353341$1197727760498$0$
614353340$1197727531489$0$
614353339$1197727490182$0$
614353338$1197727305313$0$
614353337$1197727120568$0$
614353336$1197726955744$0$
614353335$1197726667368$0$
614353334$1197726528501$0$
614353333$1197726173140$0$
614353332$1197725781909$0$
614353331$1197724071422$0$
614353330$1197723556852$0$
614353329$1197722526451$0$
614353328$1197720525187$0$
614353327$1197719007336$0$
614353326$1197718336505$0$
614353325$1197718126668$0$
614353324$1197718066646$0$
614353323$1197717553935$0$
614353322$1197716100331$0$
614353321$1197712694257$0$
614353320$1197712497110$0$
614353319$1197709781234$0$
614353318$1197700513103$0$
614353317$1197699431675$0$
614353316$1197674264717$0$
614353315$1197661688609$0$
614353314$1197661062189$0$
614353313$1197657611197$0$
614353312$1197657552329$0$
614353311$1197653504155$0$
614353310$1197653190522$0$
614353309$1197652855928$0$
614353308$1197652419180$0$
614353307$1197647231625$0$
614353306$1197647218229$0$
614353305$1197645719328$0$
614353304$1197627288283$0$
614353303$1197618840311$0$
614353302$0$$
721$1197610339522$0$
720$1197602647444$0$
719$1197600464689$0$
718$1197594639736$0$
717$1197594496715$0$
716$1197592535894$0$
715$1197589845942$0$
714$1197592055877$0$
713$1197591195179$0$
712$1197589278402$0$
711$1197587860777$0$
710$1197587410801$0$
709$1197586365568$0$
708$1197586281673$0$
707$1197586031442$0$
706$1197585425527$0$
705$1197585399311$0$
704$1197581199361$0$
703$1197581540915$0$
702$1197580941815$0$
701$1197577523232$0$
700$1197576008242$0$
699$1197575991758$0$
698$1197575837444$0$
697$1197574990273$0$
696$1197570505475$0$
695$1197568907603$0$
694$1197566820252$0$
693$1197566304532$0$
692$1197565744162$0$
691$1197558686790$0$
690$1197556333433$0$
689$1197555347626$0$
688$1197554746862$0$
687$1197554332610$0$
686$1197554072665$0$
685$1197553646760$0$
684$1197553536298$0$
683$1197553097212$0$
682$1197550126283$0$
681$1197548496412$0$
680$1197545780820$0$
679$1197545774468$0$
678$1197544779934$0$
677$1197541057998$0$
676$1197540411276$0$
675$1197539276300$0$
674$1197535627535$0$
673$1197534819708$0$
672$1197534484635$0$
671$1197534078700$0$
670$1197534036587$0$
669$1197532950537$0$
668$1197532717301$0$
667$1197532588525$0$
666$1197531806420$0$
665$1197531166577$0$
664$1197529044512$0$
663$1197526688516$0$
662$1197525192638$0$
661$1197524301817$0$
660$1197521716864$0$
659$1197521472207$0$
658$1197520043107$0$
657$1197521298403$0$
656$1197521260118$0$
655$1197521190633$0$
654$1197520932811$0$
653$1197519817278$0$
652$1197520805864$0$
651$1197519601509$0$
650$1197520109217$0$
649$1197520005241$0$
648$1197518204916$0$
647$1197507271716$0$
646$1197507196103$0$
645$1197507174430$0$
644$1197506840991$0$
643$1197502895881$0$
642$1197500476949$0$
641$1197499508902$0$
640$1197499483849$0$
639$1197499455447$0$
638$1197499358184$0$
637$1197499186322$0$
636$1197498992448$0$
635$1197497859719$0$
634$1197497815193$0$
633$1197497728120$0$
632$1197497619217$0$
631$1197497008493$0$
630$1197496854541$0$
629$1197496679229$0$
628$1197495910954$0$
627$1197495841672$0$
626$1197495518536$0$
625$1197495395177$0$
624$1197494389944$0$
623$1197494015826$0$
622$1197492552725$0$
621$1197492047852$0$
620$1197491950762$0$
619$1197490392238$0$
618$1197490015721$0$
617$1197489388546$0$
616$1197486816475$0$
615$1197486072367$0$
614$1197485808751$0$
613$1197485786594$0$
612$1197484285197$0$
611$1197483768921$0$
610$1197483521472$0$
609$1197483585259$0$
608$1197483120236$0$
607$1197482915946$0$
606$1197481250380$0$
605$1197481025673$0$
604$1197480442744$0$
603$1197477302354$0$
602$1197474576265$0$
601$1197474518801$0$
600$1197474164693$0$
599$1197474142347$0$
598$1197474118249$0$
597$1197472918533$0$
596$1197472314882$0$
595$1197471791873$0$
594$1197470322246$0$
593$1197469998425$0$
592$1197468148978$0$
591$1197467526977$0$
590$1197467135163$0$
589$1197466682859$0$
588$1197465917318$0$
587$1197465067517$0$
586$1197465056904$0$
585$1197464907663$0$
584$1197464770884$0$
583$1197464401232$0$
582$1197464103466$0$
581$1197462226339$0$
580$1197460718742$0$
579$1197460663947$0$
578$1197460154820$0$
577$1197460119456$0$
576$1197458392625$0$
575$1197457032174$0$
574$1197451055574$0$
573$1197450136269$0$
572$1197449896177$0$
571$1197449432638$0$
570$1197447911907$0$
569$1197446710160$0$
568$1197446374346$0$
567$1197444775342$0$
566$1197442154273$0$
565$1197439827207$0$
564$1197434020126$0$
563$1197426566289$0$
562$1197425516753$0$
561$1197425068465$0$
560$1197417676232$0$
559$1197409983303$0$
558$1197408771510$0$
557$1197404864651$0$
556$1197404171875$0$
555$1197401845745$0$
554$1197400312614$0$
553$1197399762259$0$
552$1197400094471$0$
551$1197399898975$0$
550$1197399282542$0$
549$1197398677965$0$
548$1197398076879$0$
547$1197394447919$0$
546$1197391001166$0$
545$1197390885202$0$
544$1197390443831$0$
543$1197389824637$0$
542$1197389862777$0$
541$1197389832966$0$
540$1197389817841$0$
539$1197389682663$0$
538$1197389227676$0$
537$1197388250181$0$
536$1197387619199$0$
535$1197386788176$0$
534$1197386025103$0$
533$1197385226203$0$
532$1197382930505$0$
531$1197382127473$0$
530$1197380633748$0$
529$1197380364836$0$
528$1197379236703$0$
527$1197379329346$0$
526$1197378167224$0$
525$1197377039210$0$
524$1197375199481$0$
523$1197373068857$0$
522$1197373109638$0$
521$1197372509244$0$
520$1197371717355$0$
519$1197365503896$0$
518$1197362312385$0$
517$1197353756830$0$
516$1197354045940$0$
515$1197352623974$0$
514$1197342666646$0$
513$1197328493390$0$
512$1197324549787$0$
511$1197321683765$0$
510$1197317786158$0$
509$1197316216417$0$
508$1197316198949$0$
507$1197316180510$0$
506$1197316088140$0$
505$1197316052320$0$
504$1197316033713$0$
503$1197316017994$0$
502$1197315978868$0$
501$1197314042965$0$
500$1197314785765$0$
499$1197314592714$0$
498$1197312720523$0$
497$1197312700972$0$
496$1197312325521$0$
495$1197312043232$0$
494$1197311686110$0$
493$1197311462296$0$
492$1197310281930$0$
491$1197310159443$0$
490$1197308975130$0$
489$1197307112737$0$
488$1197306766250$0$
487$1197306617833$0$
486$1197306280310$0$
485$1197304883264$0$
484$1197305285567$0$
483$1197305180775$0$
482$1197304334596$0$
481$1197302576663$0$
480$1197302493316$0$
479$1197302327762$0$
478$1197301768148$0$
477$1197301726804$0$
476$1197301540342$0$
475$1197301397585$0$
474$1197300576107$0$
473$1197300477718$0$
472$1197299591507$0$
471$1197298064858$0$
470$1197297918537$0$
469$1197297257700$0$
468$1197296302763$0$
467$1197296174931$0$
466$1197296153814$0$
465$1197295216385$0$
464$1197293828686$0$
463$1197293788650$0$
462$1197293547984$0$
461$1197293493720$0$
460$1197292489104$0$
459$1197291436981$0$
458$1197290904341$0$
457$1197290817406$0$
456$1197290688588$0$
455$1197290411481$0$
454$1197289489609$0$
453$1197289017803$0$
452$1197287601302$0$
451$1197286140984$0$
450$1197285259859$0$
449$1197281245252$0$
448$1197278274295$0$
447$1197279854185$0$
446$1197279686490$0$
445$1197278835358$0$
444$1197278705387$0$
443$1197278684885$0$
442$1197277497179$0$
441$1197276715214$0$
440$1197276519906$0$
439$1197276106583$0$
438$1197275500812$0$
437$1197275369879$0$
436$1197275113210$0$
435$1197274350439$0$
434$1197274177738$0$
433$1197272505872$0$
432$1197271787221$0$
431$1197271613886$0$
430$1197270764999$0$
429$1197270591449$0$
428$1197269959219$0$
427$1197269696616$0$
426$1197268001749$0$
425$1197267376654$0$
424$1197266264364$0$
423$1197264208950$0$
422$1197256493217$0$
421$1197253599999$0$
420$1197252526893$0$
419$1197251716190$0$
418$1197248473608$0$
417$1197248151878$0$
416$1197246129225$0$
415$1197239039521$0$
414$1197237325564$0$
413$1197234398497$0$
412$1197234215181$0$
411$1197228778185$0$
410$1197226051839$0$
409$1197222580915$0$
408$1197222149415$0$
407$1197218734738$0$
406$1197217655191$0$
405$1197217398287$0$
404$1197217106385$0$
403$1197217097721$0$
402$1197214415292$0$
401$1197212138320$0$
400$1197211006720$0$
399$1197206731953$0$
398$1197206369794$0$
397$1197204796313$0$
396$1197202081467$0$
395$1197200497115$0$
394$1197198707200$0$
393$1197196568682$0$
392$1197193938431$0$
391$1197190758555$0$
390$1197191639798$0$
389$1197190307930$0$
388$1197189074980$0$
387$1197188874701$0$
386$1197187429710$0$
385$1197183513366$0$
384$1197181683147$0$
383$1197181541314$0$
382$1197180998227$0$
381$1197179627671$0$
380$1197179324784$0$
379$1197175180570$0$
378$1197173476276$0$
377$1197172685436$0$
376$1197171468903$0$
375$1197169900502$0$
374$1197160495502$0$
373$1197160107735$0$
372$1197154911272$0$
371$1197147416258$0$
370$1197145359398$0$
369$1197139667902$0$
368$1197139485593$0$
367$1197139068557$0$
366$1197135951917$0$
365$1197135307858$0$
364$1197134504492$0$
363$1197131487228$0$
362$1197128203553$0$
361$1197127668986$0$
360$1197125333616$0$
359$1197123535956$0$
358$1197122960673$0$
357$1197122188736$0$
356$1197121789546$0$
355$1197120321130$0$
354$1197120950475$0$
353$1197111028985$0$
352$1197110478520$0$
351$1197110197824$0$
350$1197109800686$0$
349$1197108454231$0$
348$1197107921695$0$
347$1197107142230$0$
346$1197106969580$0$
345$1197106378357$0$
344$1197104891489$0$
343$1197104165217$0$
342$1197104050850$0$
341$1197100959782$0$
340$1197100225976$0$
339$1197100129726$0$
338$1197098710379$0$
337$1197098656166$0$
336$1197098621787$0$
335$1197097069545$0$
334$1197097413519$0$
333$1197093145544$0$
332$1197096361618$0$
331$1197092598936$0$
330$1197089361557$0$
329$1197089785860$0$
328$1197088713417$0$
327$1197088553165$0$
326$1197088239210$0$
325$1197088161766$0$
324$1197085362459$0$
323$1197081431865$0$
322$1197080772771$0$
321$1197080532996$0$
320$1197078200338$0$
319$1197077764271$0$
318$1197075114435$0$
317$1197073152101$0$
316$1197074044876$0$
315$1197070695580$0$
314$1197072260494$0$
313$1197071547724$0$
312$1197070853593$0$
311$1197070739232$0$
310$1197069842728$0$
309$1197068977719$0$
308$1197067211933$0$
307$1197057929538$0$
306$1197058251120$0$
305$1197056010547$0$
304$1197055721765$0$
303$1197055023485$0$
302$1197054568860$0$
301$1197054356276$0$
300$1197054137490$0$
299$1197050736676$0$
298$1197050446562$0$
297$1197046460529$0$
296$1197045583653$0$
295$1197044384611$0$
294$1197044297992$0$
293$1197041182115$0$
292$1197041073397$0$
291$1197039198376$0$
290$1197035014555$0$
289$1197032893531$0$
288$1197029197927$0$
287$1197028072760$0$
286$1197025603761$0$
285$1197025143539$0$
284$1197024699142$0$
283$1197024011100$0$
282$1197023119259$0$
281$1197022472396$0$
280$1197022227701$0$
279$1197021869578$0$
278$1197021657823$0$
277$1197021438366$0$
276$1197020506303$0$
275$1197016061241$0$
274$1197019977993$0$
273$1197019713491$0$
272$1197019322857$0$
271$1197018244360$0$
270$1197015734542$0$
269$1197017222306$0$
268$1197016664862$0$
267$1197015750216$0$
266$1197015648926$0$
265$1197015136199$0$
264$1197013640846$0$
263$1197013374521$0$
262$1197012797224$0$
261$1197010944190$0$
260$1197000023201$0$
259$1197006570156$0$
258$1197005117186$0$
257$1197004442532$0$
256$1197004232176$0$
255$1197001464220$0$
254$1197001377351$0$
253$1197000958394$0$
252$1196998955376$0$
251$1196995998897$0$
250$1196997602326$0$
249$1196993975636$0$
248$1196993349152$0$
247$1196991800708$0$
246$1196991246973$0$
245$1196989479727$0$
244$1196989239170$0$
243$1196978818722$0$
242$1196988332796$0$
241$1196988225376$0$
240$1196988118694$0$
239$1196987317249$0$
238$1196987236264$0$
237$1196983550441$0$
236$1196984418603$0$
235$1196982851575$0$
234$1196982445174$0$
233$1196981053437$0$
232$1196980740670$0$
231$1196980361284$0$
230$1196977601737$0$
229$1196974425529$0$
228$1196972147612$0$
227$1196972145477$0$
226$1196971740655$0$
225$1196971144541$0$
224$1196970981691$0$
223$1196969270473$0$
222$1196967939132$0$
221$1196967694303$0$
220$1196967450962$0$
219$1196967069774$0$
218$1196966688658$0$
217$1196965600482$0$
216$1196964471371$0$
215$1196962558745$0$
214$1196958493721$0$
213$1196960062176$0$
209$1196948774701$1$
114$1196797784379$1$
109$1196792988687$1$
108$1196791759664$1$
46$1196712453111$1$
$$$

noudshoorn@scarlet.nl

renu

No avatar

2007-12-17 21:38

This (above) REALLY looks strange...

I think that I´ll try to implement "ignoring" the creation of order numbers until they are a reality (submittet).

Eventually an OnUnload event warning (IE) when leaving the shop (if something in the cart/basket) could help here.
Any ideas on how to implement this?

It´s Christmas an perhaps the great OpenSolution guys are giving away goodies ;=)

Jens Henrik

ahahto

Avatar: ahahto

2007-12-17 23:33

Hello

I have same problem:

97905469$fi$0$1197905477$
97905468$fi$0$1197905472$
97905467$fi$0$1197905471$
97905466$$$$
905467$fi$0$1197905468$
4795$fi$0$1197905465$
4794$fi$0$1197905463$
4793$fi$0$1197905460$

But I find answer !

The orders.php file first line should be:
<?php exit; ?>

But it is not there, the line was disappear suddenly today.

If you add this line back to orders.php and delete wrong orders from files:
-orders.php
-orders_ext.php
-orders_products.php
-orders_payment.php

Then it works again.

This should be a bug !

treewood (OpenSolution)

Avatar: treewood

2007-12-18 09:50

nicarcola, ahahto - i think that You have this problem because some robots from google or yahoo etc. come on Your server and follow links "add to cart" from products list and file colapse. Edit templates/products_list.tpl and add to "cart" link something like that rel="nofollow". Maybe some robots will not follow this link to basket and file will be not demaged.

ahahto

Avatar: ahahto

2007-12-18 16:36

I found 366 lines from this host in apache log file:

79.16.82.178 - - [17/Dec/2007:17:21:28 +0200] "GET /ostoskori.html?sOption=add&iProduct=154&iQuantity=1 HTTP/1.1" 302 - "-" "MJ12bot/v1.0.8 (http://majestic12.co.uk/bot.php?+)"

It is from italy: host178-82-dynamic.16-79-r.retail.telecomitalia.it

How I fix this ?

ahahto

Avatar: ahahto

2007-12-18 16:49

I add rel="nofollow" to the basket link.

beholder

Avatar: beholder

2007-12-25 03:42

this really is an important bug, the orders db gets corrupted here every 3 months or so. In different versions of QC with 2.0 and higher. I was trying to report it before.
The culprit is always missing <?php exit; ?> in the beginning and various irrelevant order numbers or lines like 97905466$$$$

treewood (OpenSolution)

Avatar: treewood

2007-12-25 08:09

ahahto - as You see MJ12bot add products to Your basket. If this bot dont use rel="nofollow" there is another way to solve. Edit products_list.tpl and change

<a href="?p=ordersBasket&amp;sOption=add&amp;iProduct=$aList[iProduct]&amp;iQuantity=1" class="price" title="$lang[Add_to_basket]"><em>$lang[Price]:</em><span>$aList[sPr ice]</span>$config[currency_symbol]</a>

to

<form action='' method='get' class='basket'>
  <
fieldset>
    <
input type='hidden' name='p' value='ordersBasket' />
    <
input type='hidden' name='sOption' value='add' />
    <
input type='hidden' name='iProduct' value='$aList[iProduct]' />
    <
input type='hidden' name='iQuantity' value='1'  />
    <
em><input type='submit' value='$lang[Add_to_basket]' class='submit' /></em>
  </
fieldset>
</
form>
<
div class='price'><em>$lang[Price]:</em><span>$aList[sPrice]</span$config[currency_symbol]</div>



Most bots dont use form fields

renu

No avatar

2007-12-26 10:20

>> Beholder
Did the form field solution work for you?

Jens Henrik

ahahto

Avatar: ahahto

2007-12-26 10:30

I am using QC Pro, SEO and productsinrow modules and orderbasket link is different. Currently I have "rel=nofollow" attribute in link and it was working.

Back to top
about us | contact