Mailing List Archive


Back to the month index Back to the list index
Henry Stapp (hstapp@netlinxstudios.com)
Mon, 6 Jan 1997 03:30:32 -0800 

Message-Id: <199701060322.DAA04111@nix.netlinxstudios.com>
From: "Henry Stapp" <hstapp@netlinxstudios.com>
Subject: [mSQL] Server Errors with w3-mSQL. Please help :O
Date: Mon, 6 Jan 1997 03:30:32 -0800

Hi All,

I'm having a weird problem with w3-mSQL. Here's the specifics:

When accessing certain pages with queries embedded in them via the web I
get the reply SERVER ERROR from the server. In the httpd server error log
these errors show up as "Malformed header" errors (since I upgraded to
Apache 1.2b4 these now show up as "Premature end of script header" errors).

These queries _used_to_work_fine! For some reason all of a sudden they
stopped working without any changes in either the tables or the HTML files.
Other w3-msql queries on the same table work fine, as do similar queries to
other tables. In fact, if I merely change the table name the query works
fine, so I know it's not a typo in the HTML file.

I dumped out the table and checked it out. It looked like it might be
messed up so I reloaded the data. That seemed to help, in that fewer
queries mess up, but it didn't fix the problem entirely.

Here's the debug output from a failed query coming in off the web via
w3-msql:

[msqld] New connection received on 5
[msqld] Host = UNIX domain
[msqld] User = nobody
[msqld] Command on sock 5 = 2 (Init DB)
[msqld] DBName = steadi
[msqld] Command Processed!
[msqld] Command on sock 5 = 3 (Query)

[msqld] Query = select distinct manufacturer, description, quality, size,
unit, packaging, quantity, price, steadiID from media where category like
'FILM - MOTION' and manufacturer like '%' and quality like '%' and unit
like '%' and packaging like '%' and format like '35MM'
[msqld] Command Processed!
[msqld] Command read on sock 5 failed! <-------------- NOTE ERROR HERE
[msqld] Command on sock 5 = 1 (Quit)
[msqld] DB QUIT!
[msqld] Command Processed!

If I copy the query text from the above debug output and paste it verbatim
into the mSQL terminal monitor the query works fine, and doesn't give the
"Command read on sock 5 failed!" error seen above. This leads me to
conclude that the problem is somewhere in the communication between w3-msql
and msqld. All I can think is that w3-msql parses the query and passes it
to msqld fine, but then craps out for some unknown reason. That's as far as
I've gotten.

At present I can't upgrade this whole site to version 2 and Lite. The
software I'm currently running is

FreeBSD 2.1.0
mSQL 1.0.16
w3-mSQL 1.0.3
Apache 1.2b4

Hats off to whoever can solve this one :)

Thanks in advance,

Henry Stapp

p.s. Check www.steadi.com for a look at the site in question

 

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!