Steve Whitson wrote:
When I start the server I get the following error:
[notice] Apache/2.2.9 (Unix) DAV/2 PHP/5.2.6 SVN/1.5.1 configured --
resuming normal operations
[info] Server built: Aug 7 2008 11:06:05
[debug] prefork.c(1001): AcceptMutex: fcntl (default: fcntl)
[error] (20014)Internal error: DBD: failed to prepare SQL
statements:
Unknown command
[error] (20014)Internal error: DBD: failed to initialise
Since you get to the point of preparing your SQL statement when the error occurs, apache has already
successfully connected to your mysql database. This pretty much rules out missing libraries, etc.
The problem seems to be that mysql is returning "Unknown command" in response
to your SQL statement:
"select password from users where name = %s"
The apache part of the error message is as expected, but the mysql-supplied part of the message is
"Unknown command". FYI - this is what a log entry for an invalid SQL statement looks like:
[Fri Aug 15 07:35:09 2008] [error] (20014)Internal error: DBD: failed to prepare SQL statements: You
have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'selectXX password from users where name = ?' at line 1
[Fri Aug 15 07:35:09 2008] [error] (20014)Internal error: DBD: failed to
initialise
You are using mysql version 5.0, right?
-tom-
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]