Django

Code

Ticket #4336 (closed: wontfix)

Opened 1 year ago

Last modified 2 weeks ago

Error when I add a "Poll" (from the tutorial) with the settings.py/language="fr"

Reported by: yml.nospam@gmail.com Assigned to: nobody
Component: Admin interface Version: SVN
Keywords: Cc:
Triage Stage: Accepted Has patch: 0
Needs documentation: 0 Needs tests: 0
Patch needs improvement: 0

Description

The Admin Interface fails to add object if the settings.py Language="fr". If I switch the language to the default "en-us" I can add a record. It seems that this is due to french character like "éàè".

Here it is an extract to traceback:

Warning at /admin/dj_survey/survey/add/ Data truncated for column 'message' at row 1 Request Method: POST Request URL: http://localhost:8000/admin/dj_survey/survey/add/ Exception Type: Warning Exception Value: Data truncated for column 'message' at row 1 Exception Location: /usr/lib/python2.5/warnings.py in warn_explicit, line 102 Traceback (innermost last) Switch to copy-and-paste view

  • /media/My Book/work/web_development/svn_views/django/core/handlers/base.py in get_response
    1. # Apply view middleware
    2. for middleware_method in self._view_middleware:
    3. response = middleware_method(request, callback, callback_args, callback_kwargs)
    4. if response:
    5. return response 75.
    6. try:
    7. response = callback(request, *callback_args, **callback_kwargs) ...
    8. except Exception, e:
    9. # If the view raised an exception, run it through exception
    10. # middleware, and if the exception middleware returns a
    11. # response, use that. Otherwise, reraise the exception.
    12. for middleware_method in self._exception_middleware:
    13. response = middleware_method(request, e)
  • ▶ Local vars

Attachments

Change History

05/18/07 18:34:52 changed by mtredinnick

  • status changed from new to closed.
  • needs_better_patch changed.
  • resolution set to invalid.
  • needs_tests changed.
  • needs_docs changed.

Non-ASCII input is not supported on Django trunk. That is being remedied in the UnicodeBranch. This problem has been fixed there already.

Closing as "invalid", although it really is a valid bug -- there's no other accurate resolution.

09/04/07 20:55:30 changed by anonymous

  • status changed from closed to reopened.
  • resolution deleted.

Is still get that kind of error when I use trunk today with language de-de

(follow-up: ↓ 6 ) 09/11/07 07:52:03 changed by reg@dav-muz.net

I have the same problem. In settings.LANGUAGE_CODE I have tested 'it-IT', 'it-it', 'it', 'it_it', 'it_IT'. Django trunk r6094, MySQLdb 1.2.2 final, MySQL 5.0.37. Same problem if I change the table collation to utf-8. 

Request Method:  	POST
Request URL: 	http://localhost:8000/admin/flatpages/flatpage/add/
Exception Type: 	Warning
Exception Value: 	Data truncated for column 'message' at row 1
Exception Location: 	/usr/lib/python2.5/warnings.py in warn_explicit, line 102
Python Executable: 	/usr/bin/python
Python Version: 	2.5.1

A solution that may help: set the default encoding to utf8_unicode_ci when you create the database, before the first syncdb.

Davide "Design" Muzzarelli

09/16/07 14:33:23 changed by ubernostrum

#3910 was a duplicate.

12/01/07 20:16:46 changed by Simon G <dev@simon.net.nz>

  • stage changed from Unreviewed to Accepted.

(in reply to: ↑ 3 ) 12/22/07 18:02:02 changed by Oleksandr Pryymak <write at-no-spam ua.fm>

Replying to reg@dav-muz.net:

A solution that may help: set the default encoding to utf8_unicode_ci when you create the database, before the first syncdb.

really helped - thanks. I've just changed in database dump all charsets and collations to ut8

05/01/08 03:46:05 changed by ubernostrum

  • status changed from reopened to closed.
  • resolution set to wontfix.

This ultimately seems to be a symptom of MySQL tables which were created with a charset/collation that can't handle UTF-8 or the result of translating UTF-8 into the active charset/collation. As such it's really outside the scope of Django -- getting the DB setup wrong is something we can't really help with.

Add/Change #4336 (Error when I add a "Poll" (from the tutorial) with the settings.py/language="fr")




Change Properties
Action