the end user has no
knowledge of, it is very common for the standard mysql error messages to
be cryptic at best. I always intercept duplicate key errors and display
an error that is much more meaningful to the end users.
For errors that I am not expecting, I never display them to the end
users
..@oracle.com]
Gesendet: Montag, 6. September 2010 20:03
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
Hi Thorsten, all!
Thorsten Heymann wrote:
> Hi,
>
> First, I'm new to this mailing list, hopefully I'll do my post the *right*
> way
On 9/6/2010 9:10 AM, Thorsten Heymann wrote:
No, I think you misunderstood me. I have these keys (in this example)
- PRIMARY (id)
- UNIQUE (ip_addr)
- UNIQUE (print_name)
And when of of the UNIQUEs is duplicated, I'll wshow user a message WHAT key is
a doublette.
Hi Thorsten, all!
Thorsten Heymann wrote:
> Hi,
>
> First, I'm new to this mailing list, hopefully I'll do my post the *right*
> way.
>
> I've a problem with duplicate key error messages. In my application I use a
> table with multiple unique keys (ip
tompk...@googlemail.com]
Gesendet: Montag, 6. September 2010 15:06
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
Hi
You have a PRIMARY KEY of just the id field like PRIMARY KEY ( `id` ). You
need both ip and type to be the primary key
Cheers
Neil
On Mon, Sep 6, 2010
Not the answer I hoped to get but, thanks Carsten!
-Ursprüngliche Nachricht-
Von: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Gesendet: Montag, 6. September 2010 15:17
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
On Mon, 6 Sep 2010 15:02:24 +0200
On Mon, 6 Sep 2010 15:02:24 +0200, Thorsten Heymann
wrote:
> Digging through mysqld source, I found this behaviour handled in
> sql/handler.cc and changed from printing key_nr to key.name between this
> versions. :(
>
> Is there a possible better, reliable way to detect what key is
duplictated
>
*
> way.
>
> I've a problem with duplicate key error messages. In my application I use a
> table with multiple unique keys (ip_addr and print_name). Lets use this
> example:
> Table `device` :
>
> CREATE TABLE `device` (
> `id` INT NOT NULL AUTO_INCREMENT ,
> `
Hi,
First, I'm new to this mailing list, hopefully I'll do my post the *right* way.
I've a problem with duplicate key error messages. In my application I use a
table with multiple unique keys (ip_addr and print_name). Lets use this example:
Table `device` :
CREATE TABLE `device`
I am unable to connect to mysql 5.1 with phpmyadmin 2.10.2 on win2k running
php 5.2.3.
I get the following errors:-
Event viewer:-
Event Type: Information
Event Source: Application Popup
Event Category: None
Application popup: httpd.exe - Entry Point Not Found : The procedure entry
point mysql_
rb wrote:
Hi!
Does anyone know the cause of the following error message
Ignoring query to other database
When I log onto the mysql monitor and use any command I get this message.
This is strange because last time I used my copy of mysql it worked just
fine.
I am using MAC OSX and I was wonder
Does anyone know the cause of the following error message
Ignoring query to other database
When I log onto the mysql monitor and use any command I get this message.
This is strange because last time I used my copy of mysql it worked just
fine.
I am using MAC OSX and I was wondering if the latest
On 20 Oct 2005 10:13:56 +0200, Harald Fuchs wrote:
> Jochem van Dieten writes:
>>
>> Back in reality you don't enforce this using DDL. Apart from the fact
>> that I wouldn't know a single database that implements ASSERTIONs
>> according to the SQL standard, can you imagine having to run some
>> SEL
In article <[EMAIL PROTECTED]>,
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> Back in reality you don't enforce this using DDL. Apart from the fact
> that I wouldn't know a single database that implements ASSERTIONs
> according to the SQL standard, can you imagine having to run some
> SELECT fk
Hello Jochem,
> >> That doesn't help: check constraints are evaluated only on insert and
> >> update, not on delete. That's why you need an assertion.
> >
> > Hmmm, would that be SQL standard? Or implementation specific?
>
> It is at the very least implied in the SQL standard.
>
>
> > From a logic
On 10/20/05, Martijn Tonies wrote:
>>
>> That doesn't help: check constraints are evaluated only on insert and
>> update, not on delete. That's why you need an assertion.
>
> Hmmm, would that be SQL standard? Or implementation specific?
It is at the very least implied in the SQL standard.
> From
> First of all, is there any way of limiting the number of rows in a
> table, referencing to the same element of another table? For example,
> force a manager not to have more than 10 employees under his control.
> In a way this can be seen as checking the multiplicity of the
>
On 19 Oct 2005, at 20:30, Jochem van Dieten wrote:
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For
example,
force a manager not to have more than 10 empl
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For example,
force a manager not to have more than 10 employees under his control.
In a way this c
> >> First of all, is there any way of limiting the number of rows in a
> >> table, referencing to the same element of another table? For example,
> >> force a manager not to have more than 10 employees under his control.
> >> In a way this can be seen as checking the multiplicity of the
> >> rela
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> First of all, is there any way of limiting the number of rows in a
>> table, referencing to the same element of another table? For example,
>> force a manager not to have more than 10 employees under his control.
>> In a way this can be s
On 19 Oct 2005, at 15:58, Martijn Tonies wrote:
Second, is there any way of getting more details out of an error
message? So for example, when doing a bulk upload to the database,
rather than just getting "Cannot add or update a child row: a foreign
key constraint fails" I would like to know
> As part of my 4th Year Group Design Project, I am required to build a
> database system that will validate and then store the data. As such I
> am currently investigating different DB, to choose the most suitable
> one. I like many features of MySQL but there are a couple of things I
> am not
As part of my 4th Year Group Design Project, I am required to build a
database system that will validate and then store the data. As such I
am currently investigating different DB, to choose the most suitable
one. I like many features of MySQL but there are a couple of things I
am not very
ED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 07, 2003 16:45
> Subject: Re: error messages in different languages
>
>
>> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Yup, there is a comp-err.e
I use 4.0.14 and 4.1.0-Alpha
Thanks
Emery
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 16:45
Subject: Re: error messages in different languages
> "Director General: NEFAC
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>>
>> Yup, there is a comp-err.exe in the bin directory.
>
> I am sorry but I asked this after not finding it. Will you please give me an
> URL on the MySQL website where I can download it from ?
What version of MySQL do you use? I don't exa
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 11:21
Subject: Re: error messages in different languages
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> >
> > I have two questions about error messages in MySQL.
> >
> > 1.
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> I have two questions about error messages in MySQL.
>
> 1. Section 4.6.2 talks about Non-English error messages. It says that for
> recompiling the errmsg.sys file, one will issue a comp_err command at t
Hi group,
I have two questions about error messages in MySQL.
1. Section 4.6.2 talks about Non-English error messages. It says that for recompiling
the errmsg.sys file, one will issue a comp_err command at the SHELL prompt.
Does such a utility exist for Windows? I mean can someone tell me when
> I am changing a database and changing the user and password of an
> existing
> database. when I enter the line.
>
> mysql> insert into user (host, user, password) values ('localhost',
> 'newuser', password ('newpswrd'));
>
> the error 1062: Duplicate entry 'localhost-newuser' for key 1
> mysql>
I'm new to mysql but not databases or programming. I followed Julie
Meloni's PHP fast &easy to learn the basics. However, now that I am going
back through the material and trying to make changes, problems are rising
that I can't solve.
I am changing a database and changing the user and passwor
I'm new to mysql but not databases or programming. I followed Julie
Meloni's PHP fast &easy to learn the basics. However, now that I am going
back through the material and trying to make changes, problems are rising
that I can't solve.
I am changing a database and changing the user and passwor
error
030529 11:16:35 mysqld started
030529 11:16:36 Error message file
'/usr/share/mysql/english/errmsg.sys' had onl
y 218 error messages,
but it should contain at least 237 error messages.
Check that the above file is the right version for this program!
030529 11:16:36 Aborting
03
Sergei Golubchik wrote:
Though your changes looked innocent - that is they most probably could
do no harm - I failed to understand when they'll do any good.
You replaced a set of checks for buffer overflow by some other set of
checks, which looked equivalent to the old one.
Hi,
it turns out that m
oked equivalent to the old one.
Please, show at least one single test case where old code gets buffer
overflow.
First of all I must _apologize_ that in my bug report I _mixed_ remarks
about the behavior of MySQL with those for MyODBC: it is in fact MyODBC
which evidently does not do any overflow c
Hi!
On Mar 14, Maarten LITMAATH wrote:
> Sergei Golubchik wrote:
>
> >On Mar 12, Maarten LITMAATH wrote:
> >
> >>>Description:
> >>
> >>MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
> >>when formatting error message
Sergei Golubchik wrote:
On Mar 12, Maarten LITMAATH wrote:
Description:
MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
when formatting error messages: the code just assumes that no message
will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH)
or
Hi!
On Mar 12, Maarten LITMAATH wrote:
> >Description:
>
> MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
> when formatting error messages: the code just assumes that no message
> will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH)
>
>Description:
MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
when formatting error messages: the code just assumes that no message
will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH)
or MYSQL_ERRMSG_SIZE (200). This has been observed to lead to mem
Hi!
On Feb 17, Brandon Young wrote:
> Hello, all. I have been staring at this problem for an entire day.
> Googling turns up very little in the way of helpful information for
> solving my problem.
>
> I started a new tutorial, and ran into a problem. When I attempt to add
> a new database, I
Hello, all. I have been staring at this problem for an entire day.
Googling turns up very little in the way of helpful information for
solving my problem.
So here's the situation: I have installed mySQL on Debian testing. I'm
using mySQL version 3.23.52. It's running as a daemon. I have
su
Dear all (especially MySQL gurus),
I have another question regarding MySQL error messages. I know that
error messages are stored in errmsg.txt for different languages. We all
love error 1064 ("You have an error in your SQL syntax").
My question: Where can I find a list of _all_ (not j
This is the full romanian translation of the error messages from the MySQL
version included in RedHat 7.2.
I belive the version is: Ver 11.15 Distrib 3.23.41 from the Linux RedHat 7.2
RedHat put the file "errmsg.txt" in the folder /usr/share/mysql/romanian/
The messages were tra
Hello All:
I am using mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
on RH 7.2
So far, I am getting the following impression:
Mysql error messages can be delimited into 3 sections:
delimited by 2 colons.
1)Error code
example-> ERROR 1
http://www.mysql.com/doc/p/e/perror.html
use perror to get more information:
Error code 2: No such file or directory
Regards,
Dan
> -Original Message-
> From: user lacko [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 12 February 2002 4:15 a.m.
> To: MYSQL
> Subject:
Hi!
Where can I find the MySQL error messages ?
I have error message "can't find file host.MYD errno: 2"
Is it permission problems?
Lacko
-
Before posting, please check:
http://www.mysql.com/manual.ph
On Monday, 11. February 2002 16:15, user lacko wrote:
> Hi!
>
> Where can I find the MySQL error messages ?
> I have error message "can't find file host.MYD errno: 2"
> Is it permission problems?
>
No, it isnt a permission problem. He can't found your f
helped me!
Best of Luck
Ken
- Original Message -
From: "Lisa M. Venezia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 12:36 PM
Subject: SQL not working, but no error messages...
> Hi, I am new to this list and was wondering if so
Okay - that was silly of me. I was checking the return values of the
insert and the select, but I never did one for the connect.
It's failing on the connect - I'm assuming that all I have to do is ask
them what the proper way to connect to their database is.
Thanks for your help!
Lisa
At 11
At 12:36 -0500 1/26/02, Lisa M. Venezia wrote:
>Hi, I am new to this list and was wondering if someone can help me.
>
>I am running very simple SQL through PHP and mySQL to connect to a
>database, add data to it, and display this data. This will
>eventually be used for a guestbook for my organi
Hi, I am new to this list and was wondering if someone can help me.
I am running very simple SQL through PHP and mySQL to connect to a
database, add data to it, and display this data. This will eventually be
used for a guestbook for my organization, the New York Skyliners Sr. Drum
and Bugle C
guese. The translation of error messages to Brazilian
Portuguese idiom were again checked, revised and extended. So, they are now tracking
exactly the current 3.23.45 English version of mySQL.
Any problems, please, let me know.
Bug Report:
In addition, I'd like to inform you about a small bu
Hello,
I'm forwarding you the attached file
named - mysql_3.23.41_pt-brazil.zip - which contains the
updated Brazilian Portuguese idiom version of files ERRMSG.TXT and
ERRMSG.SYS, to be parked in directory mySQL\share\portuguese.
The translation of error messages to Braz
i have a strange problem here;
/usr/local/libexec/mysqld: Fatal error: Error message file
'/usr/local/share/mysql/english/errmsg.sys' had only 194 error messages,
but it should have at least 205 error messages.
Check that the above file is the right version for this program!
01050
I have been getting the same error message, but using perl and DBI. One
thing it MAY be but I haven't been able to pinpoint it is when for some
reason my program dies because of a bad query or the mysql server getting
sig11. Dunno.
Anyone else have this problem? Anyone know what causes it or if i
Hello
I get a lot of these in my hostname.err file. When the load is high i
get around 10 every minute.
010310 13:01:51 Aborted connection 215 to db: 'XXX' user: 'XXX' host:
`XXX' (Got an error reading communication packets)
What does it mean? Everything seems to work ok, except this strange
e
57 matches
Mail list logo