Thanks for the thoughts;
I only have about 20 items in the database at this point. There is no
additional info in the HTML source when viewed. I'll try cutting the page
back to the bare essentials and see what happens.
Shawn
----- Original Message -----
From: "Kathleen Ballard" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 9:46 AM
Subject: RE: [FreeTrade] Inconsistant Database Access -- PLEASE HELP
> Shawn,
> You need to remember that any time a query fails to return a result and
you
> try to use that result, you will get the warning 0 is not.... message.
You
> need to try to figure out what the error is of the query that was run just
> before this error.
>
> How many items in your catalog. I have been having trouble with my system
> running out of memory before the quick order page is complete. Check the
> html source for comments that have the mysql err no and message. (many of
> the debugging messages in freetrade are printed into html comments.)
>
> My solution will to ultimately use limit in the query and have the users
> page through the quick order pages.
>
> Kathleen
>
> ::-----Original Message-----
> ::From: [EMAIL PROTECTED]
> ::[mailto:[EMAIL PROTECTED]]On Behalf Of Shawn
> ::Sent: Tuesday, August 29, 2000 10:55 AM
> ::To: FreeTrade
> ::Subject: [FreeTrade] Inconsistant Database Access -- PLEASE HELP
> ::
> ::
> ::Hi All;
> ::
> ::I am getting close to launching my store using Freetrade. But I
> ::have a very
> ::strange problem happening now. I have modified the "quick_order"
> ::screen to
> ::display all the "Item" info for verifying data entry. It works
> ::great on my
> ::local system, with no problems (Win NT4, PHP3, MySQL). But when
> ::I upload to
> ::my web server (Solaris, PHP3, MySQL) it fails with the following error.
> ::
> ::"Warning: 0 is not a MySQL result index in
> ::/home/secrets/public_html/store/front_to_back_entry//modules/scree
> ::ns/quick_v
> ::iew on line 31"
> ::
> ::I have even gone so far as to switch back to an unmodified version of
> ::"quick_order" and I still get the error, but only on the remote system
not
> ::on my local machine. Does anyone have any thoughts on this?
> ::
> ::Shawn
> ::
> ::
> ::
> ::------------------------------------------------------------
> ::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]
