[RESOLVED] Very odd problem

[minifairy]

I have just experienced a very odd problem and although I have it more or less resolved I am curious if any of you might have any clue what would cause such a thing because I certainly don't have any idea. Here is what happened.

Background.
I have a MySql database with quite a few tables in it. One of the tables is used to add things to inventory. It is called purchases. Basically it adds a line to the table for each item that you are replenishing in inventory. It stores the item number and the quantity, the date and a field for it if has been added to inventory. This has been working fine for a couple of years. It allows you to print price labels for the items that you are adding to inventory.

Today
it all of a sudden started giving an internal server error when you selected more than 10 lines from the database to print labels. 9 lines it would print fine. Day before yesterday it was working fine did well over 50 lines no problem. So I started trying to figure out what is going on. Finally narrowed it down to something to do with the table although I can see nothing wrong with the table. I have this whole system running in a mirror on my local system and online. When I exported the table and put it on my system I started getting the error. Working on the local system, I deleted all the items that were added today and the error goes away. Then I tried adding back a few at a time to try and find the line that apparently was the issue. Somehow I ended up adding back everything and it was still working fine. Tried to export from my local system to the online system and I stll get the error. Delete today's stuff error goes away. So I though hmm. Tried deleting stuff before the beginning of May instead of todays stuff. And it still works. So apparently the problem is not in one of the lines added today. Since the id numbers of the items added today did not change it has nothing to do with the program blowing up at some id number or something weird like that.

Does anyone have any clue what could cause something like this?

[traq]

minifairy;11004683 wrote:

... Does anyone have any clue what could cause something like this?

not without some hint of what your code actually does, and how.

[dalecosp]

"Internal Server Error" sounds a tad like Apache. You'd think there'd be a clue in a logfile someplace?

How about memory allocation limits?

[minifairy]

There were no errors reported in the log files.. NONE. Memory should be ok. It works fine on my home system and I'm pretty sure the online server would have more memory than my laptop. At the point that it dies it really hasn't done anything other than submit the form with the checked boxes and run a simple loop to put the posted bits into hidden inputs and set up questions for what sort of labels you want to print. The real work is done in after the second form is submitted.

The weird part is that it works fine if I delete either the beginning or the end of the table and that it works fine on my local system with the whole table intact.

[dagon]

minifairy;11004692 wrote:

There were no errors reported in the log files.. NONE. Memory should be ok. It works fine on my home system and I'm pretty sure the online server would have more memory than my laptop.

probably not, especially on any kind of shared host.

but as every one says with out seeing actual code your question is unanswerable, doctor's don't diagnose patients with out bodies.