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.
We are getting more orders now than ever before (a good thing :-), but now when we open the Batch Process Orders window, there is no Submit etc. button at the bottom. It ends with the last order, but there's no way to Submit changes.
Same in both MSIE and Firefox.
Any ideas for a fix?
Nathan Kahn
Offline
Try a 'View Source' on the page and look to see if there are any errors there. Or at least see what is the last thing put out so we can try to infer what happened.
Offline
I did it 3 times and it simply stopped at 3 different places. No error message.
I'm wondering if my host has a timeout set, so I'm going to ask them next.
Here is an example of the last few lines from 1 of the above:
<tr bgcolor='#FFFFFF'><td valign='top'><input type='hidden' name='tracking_id95' value='ORD2008100218'>
<input type='hidden' name='tracking_oldstatus95' value='NS'>
<input type='radio' value='P' name='tracking_sta
Thanks,
Nathan
Offline
That definitely sounds like a timeout problem... talk to the host. Fwiw, I routinely run my ATS batch with 25-30 orders on it without a problem now; although on one host, I did have problems with the updates timing out when the list got longer than 10 orders or so.
Offline
My host says:
We monitored the script during its execution. The script was not using a MySQL database for this data.
It was reading its data from the following file:
/www/www/data/tables/trackitem.csv
For some reason, after reaching the end of the file, the scripts starts reading it all over again. You should contact the developers of this application, or consult its documentation to see what may cause this problem.
I checked and the trackitem table is indeed set to CSV. (Must be the default install from ATS? I know I haven't changed it.)
Anyway, I clicked on Change but after a few seconds it says:
500 Server Error
The web server encountered an error or misconfiguration and was unable to complete your request.
I'm guessing that there are now so many orders that I need to be in SQL mode? But how do I change to it?
P.S. There are 100 or so unshipped orders at the moment.
Thanks,
Nathan
Offline
Following on your other post, it seems you've tracked the problem back to a defective trackitem.csv. The way the ATS script is written, trackitem.csv will be read more than once, so that in and of itself does not necessarily represent a problem. Let's get your table working right and then see where we need to go from there.
Offline
This is the error message my host provided to me, as a result of trying to change trackitem.csv to database mode.
[Fri Oct 10 13:06:56 2008] cp-admin.cgi: DBD::mysql::db do failed: Duplicate entry '1' for key 1 at /home/stage/www/www/cgi-bin/ccp5/library/common/database.pl line 646.
DBD::mysql::db do failed: Duplicate entry '1' for key 1 at /home/stage/www/www/cgi-bin/ccp5/library/common/database.pl line 646.
INSERT INTO trackitem VALUES ('1','ORD200803251','W1132','John Beatles Wig','2','','39.9','0','0','0.92','0','S','UPS Ground','Lauren','Rose','','135 W. Lorain St.','OCMR 2729','Oberlin','Ohio','United States','44074','R','','UPSWEBAPI','1Z3922860347907754','4/1/2008','W1132','','Y','C','','14043772210@myfax.com','1')
The first column of the CSV file, trackitem_id, is the line number of the order. It certainly is not unique. Is it supposed to be? There is a numeral 1 in this field for every single order number - order number being in column 2 trackitem_tracknum.
How do I fix this please?
Thanks,
Nathan
P.S. I put up the first 5 lines of my trackitem.csv at:
http://www.stagesupply.com/trackitem-a.csv
Offline
For whatever reason, the trackitem_id began incrementing properly this morning. (I think it was after I deleted the corrupt entry.) Prior to that, it restarted at 1 for every new order.
So how do I fix this? What number does this trackitem_id correlate to? Can I simply overwrite that column with the numbers 1-whatever?
Offline
The trackitem_id is supposed to be unique. I suspect you are correct that the bad line was messing it up. The trackitem_id doesn't atually correlate to anything - it's just a unique number that should be assigned sequentially. Afaik, you can just overwrite them with sequential numbers and it should be fine.
Offline
I did that and switched to db mode and everything is cool groovy. The Batch Process Orders completes now. I'm sure it was timing out, I just don't know whether it was the script or my host that was responsible. My host got thrown off track by the multiple reads of the csv file and thought it was a loop. I didn't ask for a followup because I suspected the problem would go away when I switched to db.
Thanks for your help.
Nathan
Offline
You're quite welcome. I'm glad you got it sorted.
Offline