Bob and Shannon,
> This is basically what I have done. The client currently has a perl based
> catalog that uses 1 main .txt file and (literally) 2.8 thousand individual
> files. I imported all the data into an ft table structure in access and
> then created all the various tables and the department_item relationships.
> Then, I exported the data to delimited .txt files and used php to insert the
> records into the mysql tables.
>
> Everything works, except the departments and items admin screens when the
> department_item table gets more than 500 records. With between 500 - 1500 I
> get erratic page displays. The html will just stop, in view source the code
> will come to an abrupt end, no error messages, sometimes in the middle of an
> href tag. Sometimes a refresh will reprint the complete page except that
> the parent's dropdown list at the bottom will display the error 0 is not a
> mysql result---connection to mysql lost (2013) in the very bottom rows of
> the select list after department names.
>
> I am wondering if it could be a problem with the set up of mysql or php on
> the server. Any ideas what I might look for? Or questions/requests to make
> of the ISP? I can print out the mysql variables, but I am not sure what to
> look for.
I wonder if the request is simply timing out (either on the server, or
in the browser--this is almost common in IE)? There's code inside
index.php3 to turn off timeouts for the server. Also, can you add a new
screen so that you can do some debugging? In your new screen, try
outputing tables that list all of the departments, and all of the
items. Also, try putting in flush() statements in the original screen
that keeps messing up.
I hope my wild babbling helps,
-jj
--
if (shannon - jj) * behrens == webEngineer["CLEAR INK�"]:
print "<i>imagination is the only real medium(sm)</i><br>"
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
