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]
