error "Can't find record in tbaleName"

i saw this error is sometimes caused by a bug ...


what should i do to fix this problem?

i obtain an error : Can't find record in 'iv_messaggi'

every time i try to delete record from the table.... :S

p.s.: the record obvioulsy ARE in the table ^^

<slepland@italianvampires.it> schreef in bericht
news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
>i saw this error is sometimes caused by a bug ...
>
>
> what should i do to fix this problem?
>
> i obtain an error : Can't find record in 'iv_messaggi'
>
> every time i try to delete record from the table.... :S
>
> p.s.: the record obvioulsy ARE in the table ^^
>
>
>

first of all,
try to give the name of the program, or package you're working with....
second option,
contact the provider of that application....

"Luuk" <luuk@invalid.lan> ha scritto nel messaggio
news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
>
> <slepland@italianvampires.it> schreef in bericht
> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
> >i saw this error is sometimes caused by a bug ...
> >
> >
> > what should i do to fix this problem?
> >
> > i obtain an error : Can't find record in 'iv_messaggi'
> >
> > every time i try to delete record from the table.... :S
> >
> > p.s.: the record obvioulsy ARE in the table ^^
> >
> >
> >
>
> first of all,
> try to give the name of the program, or package you're working with....
> second option,
> contact the provider of that application....
>
>
>

it's a c# site .. made by myself ... the bug is in the mysql not in the
application! .. i have seen a lot of post with that bug but i have not
understand what i have to do for fixing ....

slepland@italianvampires.it wrote:
> "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
> news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
>> <slepland@italianvampires.it> schreef in bericht
>> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
>>> i saw this error is sometimes caused by a bug ...
>>>
>>>
>>> what should i do to fix this problem?
>>>
>>> i obtain an error : Can't find record in 'iv_messaggi'
>>>
>>> every time i try to delete record from the table.... :S
>>>
>>> p.s.: the record obvioulsy ARE in the table ^^
>>>
>>>
>>>
>> first of all,
>> try to give the name of the program, or package you're working with....
>> second option,
>> contact the provider of that application....
>>
>>
>>
>
> it's a c# site .. made by myself ... the bug is in the mysql not in the
> application! .. i have seen a lot of post with that bug but i have not
> understand what i have to do for fixing ....
>
>
>

Sorry, my crystal ball isn't working. You've posted no code, no table
definitions, no sample data. Nothing for us to figure out what's going
wrong.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> ha scritto nel messaggio
news:_radnXBqkMBft_janZ2dnUVZ_tjinZ2d@comcast.com. ..
> slepland@italianvampires.it wrote:
> > "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
> > news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
> >> <slepland@italianvampires.it> schreef in bericht
> >> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
> >>> i saw this error is sometimes caused by a bug ...
> >>>
> >>>
> >>> what should i do to fix this problem?
> >>>
> >>> i obtain an error : Can't find record in 'iv_messaggi'
> >>>
> >>> every time i try to delete record from the table.... :S
> >>>
> >>> p.s.: the record obvioulsy ARE in the table ^^
> >>>
> >>>
> >>>
> >> first of all,
> >> try to give the name of the program, or package you're working with....
> >> second option,
> >> contact the provider of that application....
> >>
> >>
> >>
> >
> > it's a c# site .. made by myself ... the bug is in the mysql not in the
> > application! .. i have seen a lot of post with that bug but i have not
> > understand what i have to do for fixing ....
> >
> >
> >
>
> Sorry, my crystal ball isn't working. You've posted no code, no table
> definitions, no sample data. Nothing for us to figure out what's going
> wrong.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
>

i write because i see lot of people have founded the same bug .. maybe
someone know exactly how to fix ... i have read on mysql site but my english
is very bad and i don't understand :'(

On Sun, 16 Dec 2007 13:34:03 +0100, <slepland@italianvampires.it> wrote:
>
> "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
> news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
>>
>> <slepland@italianvampires.it> schreef in bericht
>> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
>> >i saw this error is sometimes caused by a bug ...
>> >
>> >
>> > what should i do to fix this problem?
>> >
>> > i obtain an error : Can't find record in 'iv_messaggi'
>> >
>> > every time i try to delete record from the table.... :S
>> >
>> > p.s.: the record obvioulsy ARE in the table ^^
>> >
>> >
>> >
>>
>> first of all,
>> try to give the name of the program, or package you're working with....
>> second option,
>> contact the provider of that application....
>>
>>
>>
>
> it's a c# site .. made by myself ... the bug is in the mysql not in the
> application! .. i have seen a lot of post with that bug but i have not
> understand what i have to do for fixing ....

Data would help, as would version of MySQL. It SOUNDS like

http://bugs.mysql.com/bug.php?id=13191

which was fixed in April. Essentially, if you have INNODB tables with
unique UTF-8 TEXT or CHAR keys and you insert records that are key
duplicated up to the length of the key, but not duplicates further along
in the value, it spits out this error message. VARCHAR not affected.

That page was also the *first* hit on Google for "Can't find record in",
BTW..

--
Kyle J Cardoza <admin@zetachannel.com> sigged:
>Faith does not, in fact, move mountains;
Mainly because they won't let her loose with a drilling crew and enough
dynamite. -- Chris Suslowicz in the Monastery

"Peter H. Coffin" <hellsop@ninehells.com> ha scritto nel messaggio
news:slrnfmamuh.a4c.hellsop@abyss.ninehells.com...
> On Sun, 16 Dec 2007 13:34:03 +0100, <slepland@italianvampires.it> wrote:
> >
> > "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
> > news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
> >>
> >> <slepland@italianvampires.it> schreef in bericht
> >> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
> >> >i saw this error is sometimes caused by a bug ...
> >> >
> >> >
> >> > what should i do to fix this problem?
> >> >
> >> > i obtain an error : Can't find record in 'iv_messaggi'
> >> >
> >> > every time i try to delete record from the table.... :S
> >> >
> >> > p.s.: the record obvioulsy ARE in the table ^^
> >> >
> >> >
> >> >
> >>
> >> first of all,
> >> try to give the name of the program, or package you're working with....
> >> second option,
> >> contact the provider of that application....
> >>
> >>
> >>
> >
> > it's a c# site .. made by myself ... the bug is in the mysql not in the
> > application! .. i have seen a lot of post with that bug but i have not
> > understand what i have to do for fixing ....
>
> Data would help, as would version of MySQL. It SOUNDS like
>
> http://bugs.mysql.com/bug.php?id=13191
>
> which was fixed in April. Essentially, if you have INNODB tables with
> unique UTF-8 TEXT or CHAR keys and you insert records that are key
> duplicated up to the length of the key, but not duplicates further along
> in the value, it spits out this error message. VARCHAR not affected.
>
> That page was also the *first* hit on Google for "Can't find record in",
> BTW..
>
> --
> Kyle J Cardoza <admin@zetachannel.com> sigged:
> >Faith does not, in fact, move mountains;
> Mainly because they won't let her loose with a drilling crew and enough
> dynamite. -- Chris Suslowicz in the Monastery


i have not char keys!! my keys are all int...


> That page was also the *first* hit on Google for "Can't find record in",
> BTW..
i saw that link on google but in the end there are a lot of fix to resolve
that problem... but i can't understand which one i have to install ...
ehm... what does pushed into means?

cause i get this error while tryng to delete a record, not inserting!

p.s.: My version is 5.0.37

<slepland@italianvampires.it> ha scritto nel messaggio
news:4767931a$0$17948$4fafbaef@reader1.news.tin.it ...
>
> "Peter H. Coffin" <hellsop@ninehells.com> ha scritto nel messaggio
> news:slrnfmamuh.a4c.hellsop@abyss.ninehells.com...
> > On Sun, 16 Dec 2007 13:34:03 +0100, <slepland@italianvampires.it> wrote:
> > >
> > > "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
> > > news:47629dea$0$85794$e4fe514c@news.xs4all.nl...
> > >>
> > >> <slepland@italianvampires.it> schreef in bericht
> > >> news:476293a3$0$36444$4fafbaef@reader5.news.tin.it ...
> > >> >i saw this error is sometimes caused by a bug ...
> > >> >
> > >> >
> > >> > what should i do to fix this problem?
> > >> >
> > >> > i obtain an error : Can't find record in 'iv_messaggi'
> > >> >
> > >> > every time i try to delete record from the table.... :S
> > >> >
> > >> > p.s.: the record obvioulsy ARE in the table ^^
> > >> >
> > >> >
> > >> >
> > >>
> > >> first of all,
> > >> try to give the name of the program, or package you're working
with....
> > >> second option,
> > >> contact the provider of that application....
> > >>
> > >>
> > >>
> > >
> > > it's a c# site .. made by myself ... the bug is in the mysql not in
the
> > > application! .. i have seen a lot of post with that bug but i have not
> > > understand what i have to do for fixing ....
> >
> > Data would help, as would version of MySQL. It SOUNDS like
> >
> > http://bugs.mysql.com/bug.php?id=13191
> >
> > which was fixed in April. Essentially, if you have INNODB tables with
> > unique UTF-8 TEXT or CHAR keys and you insert records that are key
> > duplicated up to the length of the key, but not duplicates further along
> > in the value, it spits out this error message. VARCHAR not affected.
> >
> > That page was also the *first* hit on Google for "Can't find record in",
> > BTW..
> >
> > --
> > Kyle J Cardoza <admin@zetachannel.com> sigged:
> > >Faith does not, in fact, move mountains;
> > Mainly because they won't let her loose with a drilling crew and enough
> > dynamite. -- Chris Suslowicz in the Monastery
>
>
> i have not char keys!! my keys are all int...
>
>
> > That page was also the *first* hit on Google for "Can't find record in",
> > BTW..
> i saw that link on google but in the end there are a lot of fix to resolve
> that problem... but i can't understand which one i have to install ...
> ehm... what does pushed into means?
>
> cause i get this error while tryng to delete a record, not inserting!
>
> p.s.: My version is 5.0.37
>
>

here is the table query ....

# Server version 5.0.37-community-nt

#

# Table structure for table iv_messaggi

#

CREATE TABLE `iv_messaggi` (

`id_messaggio` int(11) NOT NULL auto_increment,

`titolo` varchar(60) default NULL,

`testo` text NOT NULL,

`poster` varchar(120) default NULL,

`id_utente` int(11) NOT NULL default '0',

`data_post` datetime NOT NULL default '0000-00-00 00:00:00',

`allegato` varchar(200) default NULL,

`thread` enum('true','false') NOT NULL default 'false',

`visite` int(10) NOT NULL default '0',

`forum` int(3) default '0',

`id_thread` int(11) default NULL,

`hot` tinyint(3) NOT NULL default '0',

`locked` tinyint(2) default '0',

PRIMARY KEY (`id_messaggio`),

KEY `id_thread` (`id_thread`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#

# Foreign keys for table iv_messaggi

#

ALTER TABLE `iv_messaggi`

ADD FOREIGN KEY (`id_thread`) REFERENCES `iv_messaggi` (`id_messaggio`) ON
DELETE CASCADE ON UPDATE CASCADE;





As u can see there are no char keys... and also i notice that the errors
appear if i try to delete a record with some "son" record ...

if i try to delete a record that is a son i don't obtain any error and it
works perfectly...

On Tue, 18 Dec 2007 10:30:01 +0100, <slepland@italianvampires.it> wrote:
>
> "Peter H. Coffin" <hellsop@ninehells.com> ha scritto nel messaggio
> news:slrnfmamuh.a4c.hellsop@abyss.ninehells.com...
>> On Sun, 16 Dec 2007 13:34:03 +0100, <slepland@italianvampires.it> wrote:
>> >
>> > "Luuk" <luuk@invalid.lan> ha scritto nel messaggio
>> >> first of all,
>> >> try to give the name of the program, or package you're working with....
>> >> second option,
>> >> contact the provider of that application....
>> >>
>> >>
>> >>
>> >
>> > it's a c# site .. made by myself ... the bug is in the mysql not in the
>> > application! .. i have seen a lot of post with that bug but i have not
>> > understand what i have to do for fixing ....
>>
>> Data would help, as would version of MySQL. It SOUNDS like
>>
>> http://bugs.mysql.com/bug.php?id=13191
>>
>> which was fixed in April. Essentially, if you have INNODB tables with
>> unique UTF-8 TEXT or CHAR keys and you insert records that are key
>> duplicated up to the length of the key, but not duplicates further along
>> in the value, it spits out this error message. VARCHAR not affected.
>>
>> That page was also the *first* hit on Google for "Can't find record in",
>> BTW..
>>
>> --
>> Kyle J Cardoza <admin@zetachannel.com> sigged:
>> >Faith does not, in fact, move mountains;
>> Mainly because they won't let her loose with a drilling crew and enough
>> dynamite. -- Chris Suslowicz in the Monastery
>
>
> i have not char keys!! my keys are all int...

You didn't mention THAT before at all.

>> That page was also the *first* hit on Google for "Can't find record in",
>> BTW..
> i saw that link on google but in the end there are a lot of fix to resolve
> that problem... but i can't understand which one i have to install ...

Any of the versions released after the fix was added.

> ehm... what does pushed into means?

"Added to", in this case.

> cause i get this error while tryng to delete a record, not inserting!
>
> p.s.: My version is 5.0.37

Nor did you mention that before either.

The page says:

[30 Apr 14:56] Bugs System
Pushed into 4.1.23
[30 Apr 14:58] Bugs System
Pushed into 5.0.42
[30 Apr 14:59] Bugs System
Pushed into 5.1.18-beta

Which means for version 4.1.x, maintenance releases 23 and after have
this fix. So, your version doesn't.

--
The greatest dangers to liberty lurk in insidious encroachment by men of
zeal, well-meaning but without understanding. -Justice Louis D. Brandeis

On Tue, 18 Dec 2007 10:51:15 +0100, <slepland@italianvampires.it> wrote:
>
><slepland@italianvampires.it> ha scritto nel messaggio
> news:4767931a$0$17948$4fafbaef@reader1.news.tin.it ...
>>
>> "Peter H. Coffin" <hellsop@ninehells.com> ha scritto nel messaggio
>> news:slrnfmamuh.a4c.hellsop@abyss.ninehells.com...
>> > Data would help, as would version of MySQL. It SOUNDS like
[..]
>
> here is the table query ....
>
> # Server version 5.0.37-community-nt
>
> #
>
> # Table structure for table iv_messaggi
>
> #
>
> CREATE TABLE `iv_messaggi` (
>
> `id_messaggio` int(11) NOT NULL auto_increment,
>
> `titolo` varchar(60) default NULL,
>
> `testo` text NOT NULL,
>
> `poster` varchar(120) default NULL,
>
> `id_utente` int(11) NOT NULL default '0',
>
> `data_post` datetime NOT NULL default '0000-00-00 00:00:00',
>
> `allegato` varchar(200) default NULL,
>
> `thread` enum('true','false') NOT NULL default 'false',
>
> `visite` int(10) NOT NULL default '0',
>
> `forum` int(3) default '0',
>
> `id_thread` int(11) default NULL,
>
> `hot` tinyint(3) NOT NULL default '0',
>
> `locked` tinyint(2) default '0',
>
> PRIMARY KEY (`id_messaggio`),
>
> KEY `id_thread` (`id_thread`)
>
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
> #
>
> # Foreign keys for table iv_messaggi
>
> #
>
> ALTER TABLE `iv_messaggi`
>
> ADD FOREIGN KEY (`id_thread`) REFERENCES `iv_messaggi` (`id_messaggio`) ON
> DELETE CASCADE ON UPDATE CASCADE;
>
>
>
>
>
> As u can see there are no char keys... and also i notice that the errors
> appear if i try to delete a record with some "son" record ...
>
> if i try to delete a record that is a son i don't obtain any error and it
> works perfectly...

Data would still help. If this is an issue at all similar to the fixes
posted about before, unless I've got your data, I can't reproduce the
error.

--
63. Bulk trash will be disposed of in incinerators, not compactors. And they
will be kept hot, with none of that nonsense about flames going through
accessible tunnels at predictable intervals.
--Peter Anspach's list of things to do as an Evil Overlord