Bob,
Thank you for mentioning the quick order screen. That was one I had not
tried yet.
When I tried to run the quick order screen, I received a 0 is not a mysql
result error. So I printed out the query and ran it through phpmyadmin and
this is the error message I got:
MySQL said: The table 'SQLea60_0' is full
I assume that this points more strongly to mysql.
Also, I have experienced timeouts in phpmyadmin for simple select queries
like "Select ID from department where Parent = [number]".
Thank you all for your help. I guess it is time to contact the ISP.
Kathleen
::-----Original Message-----
::From: [EMAIL PROTECTED]
::[mailto:[EMAIL PROTECTED]]On Behalf Of Bob Hutchinson
::Sent: Tuesday, August 15, 2000 5:52 AM
::To: FreeTrade
::Subject: RE: [FreeTrade] admin department items screen choking
::
::
::At 18:59 14/08/00 -0400, you wrote:
::>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
::
::I'm guessing here, but it sounds like a mysql prob. In compiling mysql
::recently for a client, I noticed that there are settings for
::default table
::size.
::If you search for 'SQL_BIG_TABLES' in the mysql docs, you might
::be able to
::over-ride the defaults. I have had this problem with
::screens/report_inventory which like screens/quick_order scoffs the lot.
::Using LIMIT in your query string also might solve the problem.
::Getting your isp to recompile with larger settings is possible (but not
::likely, in my experience)
::If you have a linux dev box you could try recompiling yourself with a
::variety of settings, that way at least you will know what the problem is.
::
::
::>::-----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]
::
::
::
::
::------------------------------------------------------------
::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]
