>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)
[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 :
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 and
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?
[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 Cri
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 vi
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 d
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
PLACE
would delete that data.
http://daevid.com
> -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_a
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 DUPLICATE
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 |INSE
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 "che
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 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 by
available , table does not exits, duplicate 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 kno
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
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 c
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 th
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 th
I'm getting an error trying to create a table but can't find any error codes
listed in the online mysql documentation.
Does anyone know a good source for this?
Also is the cause of my error recognisable to anyone? I just successfully
created the tables listed but this one bounced.
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
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'
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,
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 ta
e-
> From: Javier Armendáriz [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 h
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
to
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
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
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
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.
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
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 se
> 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
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
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 ? Wher
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 databas
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))
M
On 7/3/01 at 12:48 PM, Gerald Clark wrote:
> Check the source for mysqld_error.h
Thanks. I have seen these, but I was hoping for a list with more explicit
descriptions. My current plan is to go through this list and take descriptions
from the manual/books for each error that I can locate, but
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 co
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]
--
Fletche
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
> /usr/local/games/hlds_l/hlstats-1.01
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 somethin
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 an
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
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:
"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
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
48 matches
Mail list logo