Note that this error list is for the Linux version (parts differs for
another OS). More error descriptions can be found in the header files.
(forgot currently which ones). If you search the forum for error codes and
my name than you will find the info (roughly a year+ old)
The typical place
I looked around and didn't see documentation of MySQL
error codes. I did find a short list of INNODB codes
but nothing comprehensive. Is there such a page?
Thanks,
Tripp
__
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses
[snip]
I looked around and didn't see documentation of MySQL error codes. I did
find a short list of INNODB codes but nothing comprehensive. Is there such a
page?
[/snip]
You can use perror to find out want a mysql errno means.
http://dev.mysql.com/doc/mysql/en/perror.html
---
Tom Crimmins
http://www.be-known-online.com/mysql/
(B
(BBest regards
(B
(BNils Valentin
(B
(B
(B [snip]
(B I looked around and didn't see documentation of MySQL error codes. I did
(B find a short list of INNODB codes but nothing comprehensive. Is there such
(B a
(B page?
(B [/snip]
(B
(B You can
Hi Emmett,
(B
(BPlease try http://www.be-known-online.com/mysql/
(B
(BNote that this error list is for the Linux version (parts differs for
(Banother OS). More error descriptions can be found in the header files.
(B(forgot currently which ones). If you search the forum for error codes
[snip]
I looked around and didn't see documentation of MySQL error codes. I did
find a short list of INNODB codes but nothing comprehensive. Is there such a
page?
[/snip]
OS error codes :
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Server error messages :
http
Daevid Vincent wrote:
Well, my hack (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id' field to a combination of two
other fields (mac/scanner_id) that I know must be unique. Then I rely upon
the fact that mySQL will not allow a duplicate PK. (I
At 12:38 -0700 on 05/27/2004, Daevid Vincent wrote about Re: Feature
Request: UPDATE 'error codes' or mysql_affected:
REPLACE INTO won't work, as I need the previous record (hence the update). I
store the first and last time I saw a node, amongst other info. REPLACE
would delete that data
Does REPLACE INTO not work in your case?
|
|
|REPLACE| works exactly like |INSERT|, except that if an old record
in the table has the same value as a new record for a |PRIMARY KEY|
or a |UNIQUE| index, the old record is deleted before the new record
is inserted. See section 14.1.4
http://dev.mysql.com/doc/mysql/en/INSERT.html
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
If you specify the ON
-Original Message-
From: Steve Meyers [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 7:42 AM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject: Re: Feature Request: UPDATE 'error codes' or
mysql_affected_rows() to be more accurate
http://dev.mysql.com/doc/mysql/en
I'm developing a program where I try an UPDATE ... LIMIT 1 and if
mysql_affected_rows == 0, then I know nothing was updated and so I do an
INSERT. I find this is much cleaner and the majority of the time, I'm going
to do UPDATES, so I didn't want to waste a SELECT (even though I hear
they're
Hi folks,
A couple of my sites are intermittently getting the following error:
2014 - Commands out of sync; You can't run this
command now
select configuration_key as cfgKey,
configuration_value as cfgValue from configuration
On one site the error is being reported regularly
http://www.mysql.com/doc/en/Commands_out_of_sync.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Andrew Hazen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 03 June, 2003 09:40
Subject: Meaning of error codes
Hi folks,
A couple of my
the return error code value and which
file contains all these error codes??
I m using function SQLGetDiagRec() to see the error
messages, Can i use the same for error code?
Thx in advance,
Rgds,
Jenny
__
Do You Yahoo!?
Yahoo! Autos - Get
data
etc.
How can i see the return error code value and which
file contains all these error codes??
I m using function SQLGetDiagRec() to see the error
messages, Can i use the same for error code?
I don't know about anything included in the MyODBC driver, but included with
the server
and which
file contains all these error codes??
I m using function SQLGetDiagRec() to see the error
messages, Can i use the same for error code?
Thx in advance,
Rgds,
Jenny
__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http
On Tuesday, 12. February 2002 06:07, Chetan Lavti wrote:
Hi!
hi,
I am using C api's for accessing the MySQL server, I want to make use of
the mysql api's inside the functions I have made. I do not want to print
the description of the error, instead, I want to display out the error
code
hi,
I am using C api's for accessing the MySQL server, I want to make use of
the mysql api's inside the functions I have made. I do not want to print
the description of the error, instead, I want to display out the error
code corresponding to that message.
Is there any description about this in
hi,
I am using C api's for accessing the MySQL server, I want to make use of
the mysql api's inside the functions I have made. I do not want to print
the description of the error, instead, I want to display out the error
code corresponding to that message.
Is there any description about this in
I tried checking for error codes in the documentation, but didn't find
anything particularly useful.
I'm getting this:
mysql load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
(aid, wid, wordform, start, length);
ERROR 1030: Got error 28 from table handler
In case
Cindy wrote:
I tried checking for error codes in the documentation, but didn't find
anything particularly useful.
I'm getting this:
mysql load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
(aid, wid, wordform, start, length);
ERROR 1030: Got error 28 from table
Bill Adams writes:
Cindy wrote:
I tried checking for error codes in the documentation, but didn't find
anything particularly useful.
I'm getting this:
mysql load data infile '/export/home/Scratch/WordIndex.txt' into table wor
dindex (aid, wid, wordform, start, length);
ERROR 1030
Thanks a lot for the perror. However it doesn't seem to have descriptions
for some code (ex. 1046, 1064).
But still, it was really usefull (y MySQL book doesn't mention that, weird)
Cindy wrote:
C:
C: Bill Adams writes:
C: Cindy wrote:
C:
C: I tried checking for error codes
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts to users in php
Thanks a lot
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts to users in php
Hola Javier,
Yes it is in the manual - but try
Get the pdf version from php.net.
At 01:02 P 21/10/01, DL Neil wrote:
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts
Thanks a lot, as you know, I need to translate error codes (such as
duplicate references) to the future (i hope) program operator. The error
codes are for operators (those who write data into the catalog), not for
public, I know PHP error reporting functions with MySQL, but i would like
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 21, 2001 5:49 AM
To: DL Neil; [EMAIL PROTECTED]
Subject: Re: Error codes list
Thanks a lot, as you know, I need to translate error codes (such as
duplicate references) to the future (i hope) program operator. The error
codes
yogi writes:
Hi, is there a comprehensive list of mySQL error codes and the related
messages somewhere?
Thanx, Cheerio, yogi
- travel light!
e-mail: [EMAIL PROTECTED]
Hi,
Try perror #err_code. 'perror' (print error) comes with MySQL
distribution. perror works also for system error
I'm developing some MySQL applications using VB6 and ADO, and need to do some work on
error handling. I can get the error code easily enough from ADO's Error collection,
but is there a list of error codes and their descriptions. I've been doing this by
generating errors and seeing what codes
Check the source.
include/mysqld_error.h
A. Clausen wrote:
I'm developing some MySQL applications using VB6 and ADO, and need to do some work
on error handling. I can get the error code easily enough from ADO's Error
collection, but is there a list of error codes and their descriptions
Hi,
I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql
server as root and trying to use a sample database from Paul Dubois book MySql, I '
ve got the error 13, can't create directory/file ./samp_db/president.xxx.
The thing is I'm using an example DB, any help ?
perror will tell you
Error code 69: Srmount error
This looks pretty much like a system error to me. Ask your ISP.
[EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48:
Hello,
I seem to have corrupted mySQL deep down inside. I can not create any tables in any
new
Hi,
I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql server
as root and trying to use a sample database from Paul Dubois book MySql, I ' ve got
the error 13, can't create directory/file ./samp_db/president.xxx.
The thing is I'm using an example DB, any help ?
Looks to me like a permissions problem. If you were manipulating the
MYSQL files as root or if you copied or moved them, this could happen.
Look at the permissions on a working machine and match those on this
machine. The permissions need to allow changes, but too permissive
permissions will
Hello,
I seem to have corrupted mySQL deep down inside. I can not create any tables in any
new databases. I will get the exact same errcode each time ... that is :
SQL-query:
CREATE TABLE test (user_id INT (6) not null AUTO_INCREMENT, notes VARCHAR (100) not
null , PRIMARY KEY (user_id))
I am looking for a concise listing of all the error codes that MySQL might
return after issuing a SQL statement. The manual and other books I've checked
have descriptions of the errors, but don't seem to collect them all into one
reference.
Thanks,
[fletcher]
--
Fletcher Sandbeck
Check the source for mysqld_error.h
Fletcher Sandbeck wrote:
I am looking for a concise listing of all the error codes that MySQL might
return after issuing a SQL statement. The manual and other books I've checked
have descriptions of the errors, but don't seem to collect them all into one
I have a web page which is based on mysql databases using PHP coding, but
the web page refuses to display correctly. It always returns an error
message:
Fatal error: Call to undefined function: mysql_select_db() in
/usr/local/games/hlds_l/hlstats-1.01/hlstatsinc/db.inc on line 67
Is it
On 18-Jun-01 Sam Peascod wrote:
I have a web page which is based on mysql databases using PHP coding, but
the web page refuses to display correctly. It always returns an error
message:
Fatal error: Call to undefined function: mysql_select_db() in
Hello,
A few days ago I asked if anyone knows the numeric values of the
Mysql error codes. Nobody responded, so I looked through the source
code to find the answer. This info would be valuable if, for
example, you wanted to programmatically handle certain types of
errors.
In the source
Type perror #error_num at the prompt, you can get what the error codes
mean from there.
ryan
Hello,
A few days ago I asked if anyone knows the numeric values of the
Mysql error codes. Nobody responded, so I looked through the source
code to find the answer. This info would be valuable
Can someone point me to the documentation of the error codes returned by Mysql?
I mean the ones you get back from DBI via "err".
I couldn't find them in the online docs.
-
Before posting, please check:
http://www
Hi all.
I have a problem with one of my tables. I can get a count of records, or
simple selects, but if I go any more complex, I get an error "ERROR 1030:
Got error 127 from table handler". I can't seem to find any documentation
that further explains these types of errors. Is there anywhere I
"Bass, Benjamin" wrote:
Hi all.
I have a problem with one of my tables. I can get a count of records, or
simple selects, but if I go any more complex, I get an error "ERROR 1030:
Got error 127 from table handler". I can't seem to find any documentation
that further explains these types
46 matches
Mail list logo