Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
5.5.32
-
Debian Wheezy using mariadb.org repository
Description
Help files don't completely install. Logs show this:
Jul 19 07:11:40 mail1 mysqld_safe[3617]: WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
|
Jul 19 07:11:40 mail1 mysqld_safe[3617]: The "HELP" command might not work properly.
|
Manually trying to add the help tables results in this:
mysql -u root mysql < /usr/share/mysql/fill_help_tables.sql
|
ERROR 1406 (22001) at line 75: Data too long for column 'url' at row 1
|
MariaDB [mysql]> desc help_topic; |
--------------
|
desc help_topic |
--------------
|
 |
+------------------+----------------------+------+-----+---------+-------+ |
| Field | Type | Null | Key | Default | Extra | |
+------------------+----------------------+------+-----+---------+-------+ |
| help_topic_id | int(10) unsigned | NO | PRI | NULL | | |
| name | char(64) | NO | UNI | NULL | | |
| help_category_id | smallint(5) unsigned | NO | | NULL | | |
| description | text | NO | | NULL | | |
| example | text | NO | | NULL | | |
| url | char(128) | NO | | NULL | | |
+------------------+----------------------+------+-----+---------+-------+ |
6 rows in set (0.01 sec) |
These urls exceed the 128 length:
==> grep 'insert into help_topic ' /usr/share/mysql/fill_help_tables.sql | perl -ne " m/.,'(.)'/; print \$1.\"\n\" if (length(\$1) > 128) "
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
See this discussion http://bugs.mysql.com/bug.php?id=61520 where a solution was implemented.
"The url columns in the mysql datatbase help tables were too short to
hold some of the URLs in the help content. These columns are now type
TEXT to accommodate longer URLs."