#698 (in 2.5.0) Deleting a row with textarea and 2 lines

[Anonymous]

I have found out a bug that prevents a record to be
deleted using phpMyAdmin.
I have a table with 3 entrys, 1 id, a text and a date

I used a litle script to input in the text area. I use
$string=addslashes(nl2br($string)) to add the slashes
and replace a carriage return with a <br> for HTML
formating.

$string had the value "Testing" then carriage return
and "test"

I got the following saved in mysql
Testing \n\r <br> test

I was not able to delete this entry UNTIL i edited it
and removed the \n\r <br> caracteres.

Are you aware of this bug ?

Thank you for your time, was a pleasure to contribute

[Marc Delisle]

Logged In: YES
user_id=210714

It would be easier to test if you could attach a dump of
your table.

[Nobody/Anonymous]

Logged In: NO

# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 30, 2002 at 04:09 PM
# Server version: 3.23.47
# PHP Version: 4.1.2
# Database : `test`
# --------------------------------------------------------

#
# Table structure for table `test`
#

CREATE TABLE test (
id_test int(11) NOT NULL default '0',
textarea text NOT NULL,
date date NOT NULL default '0000-00-00',
KEY id_test (id_test)
) TYPE=MyISAM;

#
# Dumping data for table `test`
#

INSERT INTO test VALUES (1,
'Testing\r\n\\n\r\n\\r\r\n<br>\r\nTest', '2002-12-30');

!! Attention the recorded value in the table is
Testing
\r
\n
<br>
Test

[Nobody/Anonymous]

Logged In: NO

# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 30, 2002 at 04:09 PM
# Server version: 3.23.47
# PHP Version: 4.1.2
# Database : `test`
# --------------------------------------------------------

#
# Table structure for table `test`
#

CREATE TABLE test (
id_test int(11) NOT NULL default '0',
textarea text NOT NULL,
date date NOT NULL default '0000-00-00',
KEY id_test (id_test)
) TYPE=MyISAM;

#
# Dumping data for table `test`
#

INSERT INTO test VALUES (1,
'Testing\r\n\\n\r\n\\r\r\n<br>\r\nTest', '2002-12-30');

!! Attention the recorded value in the table is
Testing
\r
\n
<br>
Test

[Nobody/Anonymous]

Logged In: NO

# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 30, 2002 at 04:09 PM
# Server version: 3.23.47
# PHP Version: 4.1.2
# Database : `test`
# --------------------------------------------------------

#
# Table structure for table `test`
#

CREATE TABLE test (
id_test int(11) NOT NULL default '0',
textarea text NOT NULL,
date date NOT NULL default '0000-00-00',
KEY id_test (id_test)
) TYPE=MyISAM;

#
# Dumping data for table `test`
#

INSERT INTO test VALUES (1,
'Testing\r\n\\n\r\n\\r\r\n<br>\r\nTest', '2002-12-30');

The value in the table looked actually like this
Testing
\r
\n
<br>
Test

[Marc Delisle]

Logged In: YES
user_id=210714

The bugs happens also in a table without a primary key, when
the textarea contains more than one line.

[Garvin Hicking]

Logged In: YES
user_id=473563

Fixed in 2.4.1-dev.