#8548: Lengthy verbose_name results in fatal mysql 'warning' error during
syncdb.
-------------------------------------+-------------------------------------
Reporter: samt@… | Owner: marcelor
Type: Bug | Status: reopened
Component: Core (Management | Version: 1.4
commands) | Resolution:
Severity: Normal | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 1 | Patch needs improvement: 1
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Changes (by cdoussin@…):
* version: 1.3 => 1.4
Comment:
This is also an issue with long model names of 6-7 words and up (and
verbose names automatically generated from the model name). For example I
just hit the issue with
"PremiumAppSubscriptionIncludedIssueCreditProduct".
When you look at the MySQL table, the length of the fields doesn't make
sense for long model names: name is half as short as codename, when the
codename values are bound to be a bit shorter than the verbose name
values.
mysql> describe auth_permission;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | NULL | |
| content_type_id | int(11) | NO | MUL | NULL | |
| codename | varchar(100) | NO | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
As a result, I would be in favour of increasing the length of the "name"
field.
--
Ticket URL: <https://code.djangoproject.com/ticket/8548#comment:20>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit https://groups.google.com/groups/opt_out.
