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.
Kathleen
::-----Original Message-----
::From: [EMAIL PROTECTED]
::[mailto:[EMAIL PROTECTED]]On Behalf Of Bob Hutchinson
::Sent: Monday, August 14, 2000 1:24 PM
::To: FreeTrade
::Subject: RE: [FreeTrade] admin department items screen choking
::
::
::I also have a client with a pretty complex categorisation, and
::the thought
::of entering thousands of item using the admin, well not on, so I
::had to get
::a grip on the relationship between the tables department,
::department-item,
::and item (and sku).
::I initially built up the departments but did not insert any items (well
::just a few to see how it worked) then exported it all and shovelled the
::tables into Excel where the relationships became more apparent. Then I
::built the item table in Excel, linked deptartments to items in the table
::department-item and imported it all back in. Works fine
::
::At 12:37 14/08/00 -0400, you wrote:
::>Leon,
::>The client has decide on a fairly complex department structure.
::There are
::>about 100 departments and they are structured something like:
::>
::>Department1
::> SubDepartment1
::> SubSubDepartment1
::> Items
::> SubSubDepartment2
::> Items
::> SubDepartment1
::> SubSubDepartment1
::> Items
::> SubSubDepartment2
::> Items
::>Department2
::> SubDepartment1
::> SubSubDepartment1
::> Items
::> SubSubDepartment2
::> Items
::> SubDepartment1
::> SubSubDepartment1
::> Items
::> SubSubDepartment2
::> Items
::>
::>I am wondering if this is too many department levels for the admin gui
::>screen.
::>
::>Kathleen
::>
::>
::>::-----Original Message-----
::>::From: [EMAIL PROTECTED]
::>::[mailto:[EMAIL PROTECTED]]On Behalf Of Leon Atkinson
::>::Sent: Monday, August 14, 2000 12:04 PM
::>::To: FreeTrade
::>::Subject: RE: [FreeTrade] admin department items screen choking
::>::
::>::
::>::I did a test once where I inserted many, many items. I can't
::find where
::>::I talked about it on the list, though. Anyway, I think I had 10,000
::>::items divided into 10 departments, and there were no problems with the
::>::admin or the department/item screens. The quickorder screen choked, of
::>::course because an HTML table with 10,000 rows is a bit over the limit.
::>::
::>::It's possible the code for the admin screen has changed in some way.
::>::I'll try to get to testing it today.
::>::
::>::Leon
::>::
::>::> -----Original Message-----
::>::> From: [EMAIL PROTECTED]
::>::> [mailto:[EMAIL PROTECTED]]On Behalf Of Kathleen Ballard
::>::> Sent: Monday, August 14, 2000 4:50 AM
::>::> To: FreeTrade
::>::> Subject: [FreeTrade] admin department items screen choking
::>::>
::>::>
::>::> Dear List,
::>::> I am in the process of importing data from existing .txt
::files to the ft
::>::> tables.
::>::>
::>::> I have approx. 2100 items and 100 departments. After inserting
::>::about 2500
::>::> records into the department_item table, the departments and
::items admin
::>::> screen stopped displaying. Testing showed that I can have about
::>::> 500 of any
::>::> of those records. More than 500 will cause a 2013 mysql error
::>::> with the page
::>::> displaying incompletely and all 2500 causes the page to not
::>::> display at all.
::>::>
::>::> Has anyone else experienced this?
::>::>
::>::> I did check the list archives and found a reference to problems
::>::> with the gui
::>::> display and corrupted image files. I have reuploaded all
::the ft images.
::>::>
::>::> Kathleen
::>
::>
::>
::>------------------------------------------------------------
::>To subscribe: [EMAIL PROTECTED]
::>To unsubscribe: [EMAIL PROTECTED]
::>Site: http://www.working-dogs.com/freetrade/
::>Problems?: [EMAIL PROTECTED]
::
::
::
::------------------------------------------------------------
::To subscribe: [EMAIL PROTECTED]
::To unsubscribe: [EMAIL PROTECTED]
::Site: http://www.working-dogs.com/freetrade/
::Problems?: [EMAIL PROTECTED]
::
::
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
