Re: [PHP] mysql_errno codes

[Don Read]

On 16-Jun-2003 Thomas Hochstetter wrote:
> Hi.
> 
> [3rd try] ... where can i get mysql_error codes from? The ones that
> mysql_errno returns.
> 

You can get all the OS and MySQL  error codes with:
$ perror `jot 1500` | grep -v 'Unknown error'

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] mysql_errno codes

[Thomas Hochstetter]

Thanks guys ... always a pleasure.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql_errno codes

[David Nicholson]

Hello,


This is a reply to an e-mail that you wrote on Mon, 16 Jun 2003 at 17:53,
lines prefixed by '>' were originally written by you.
> Hi.
> [3rd try] ... where can i get mysql_error codes from? The ones that
> mysql_errno returns.

In the comments section of http://uk2.php.net/mysql_errno it says:
"All mysqld error messages are located into the file
/usr/local/share/mysql/english/errmsg.txt and listed in numerical order
from 999 to 1175. You can change the output language as well, issuing the
'-L spanish' option for example. See the manual for more details."

All the best,

David

--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/

  Professional Web Development by David Nicholson
http://www.djnicholson.com/

QuizSender.com - How well do your friends actually know you?
 http://www.quizsender.com/
(developed entirley in PHP)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql_errno codes

[Jeff Harris]

On Jun 16, 2003, "Thomas Hochstetter" claimed that:

|Hi.
|
|[3rd try] ... where can i get mysql_error codes from? The ones that
|mysql_errno returns.
|
|Thanks
|Thomas
|

All mysqld error messages are located into the file
$MYSQL_ROOT_DIR/$LANGUAGE/errmsg.txt (or thereabouts) and listed in
numerical order from 999 to 1175. You can change the output language as
well, issuing the '-L spanish' option for example. See the manual for more
details.

try a "$ locate errmsg.txt"

Or, if you need them at runtime, try
http://www.php.net/manual/en/function.mysql-error.php

-- 
Registered Linux user #304026.
"lynx -source http://jharris.rallycentral.us/jharris.asc | gpg --import"
Key fingerprint = 52FC 20BD 025A 8C13 5FC6  68C6 9CF9 46C2 B089 0FED
Responses to this message should conform to RFC 1855.





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] mysql_errno codes

[Jay Blanchard]

[snip]
[3rd try] ... where can i get mysql_error codes from? The ones that
mysql_errno returns.
[/snip]

If MySQL returns an error code (let's use 80 as an example) go to your
shell and type;

perror 80

You will get back a response...

Error code  80:  Accessing a corrupted shared library

If you want to do this via PHP there is a fine example at

http://us3.php.net/manual/en/function.mysql-errno.php


HTH!

Jay

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mysql_errno codes

[Thomas Hochstetter]

Hi.

[3rd try] ... where can i get mysql_error codes from? The ones that
mysql_errno returns.

Thanks
Thomas

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php