I have an application that include Unicode strings (Greek and Hebrew),
running on a dev machine and an (inside the firewall) release machine
configured (to the best of my ability) with the same Python, Django,
MySql and connector.

When editing an object containing one of these strings on the release
machine, in the admin interface, when i save i get:
OperationalError at /admin/realia/lemmarelation/1597/

(1366, "Incorrect string value: '\\xE1\\xBC\\x80\\xCE\\xAE\\xCF...'
for column 'message' at row 1")

Request Method:         POST
Request URL:    http://debuild/admin/realia/lemmarelation/1597/
Exception Type:         OperationalError
Exception Value:

(1366, "Incorrect string value: '\\xE1\\xBC\\x80\\xCE\\xAE\\xCF...'
for column 'message' at row 1")

Exception Location:     C:\Python24\Lib\site-packages\MySQLdb
\connections.py in defaulterrorhandler, line 35
Python Executable:      C:\Program Files\Apache Software Foundation
\Apache2.2\bin\httpd.exe
Python Version:         2.4.3
Python Path:    ['c:/design.ed/django/logos/', 'C:\\Python24\\lib\\site-
packages\\setuptools-0.6c6-py2.4.egg', 'C:\\Python24\\Lib\\site-
packages\\django', 'C:\\design.ed\\django', 'C:\\Program Files\\Apache
Software Foundation\\Apache2.2', 'C:\\WINDOWS\\system32\
\python24.zip', 'c:\\python24\\lib\\site-packages', 'C:\\Python24\
\Lib', 'C:\\Python24\\DLLs', 'C:\\Python24\\Lib\\lib-tk', 'C:\\Program
Files\\Apache Software Foundation\\Apache2.2\\bin', 'C:\\Python24', 'c:
\\design.ed\\python\\libronix', 'C:\\Python24\\lib\\site-packages\
\win32', 'C:\\Python24\\lib\\site-packages\\win32\\lib', 'C:\\Python24\
\lib\\site-packages\\Pythonwin']
Server time:    Fri, 20 Feb 2009 16:51:59 -0800

'message' isn't in my model, so it's breaking somewhere in the Django
part, but i'm not sure why, or how to fix it. And i can't find
anything different about my two environments that explains why it
breaks on one machine, but works fine on the other. What seems like
the likely culprit is a UTF-8 string, whose collating method is
utf8_general_ci. It's not a single data value: attempting to edit any
object in this table seems to raise this error.

Here's the traceback:
Environment:

Request Method: POST
Request URL: http://debuild/admin/realia/lemmarelation/1597/
Django Version: 1.0.2 final
Python Version: 2.4.3
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.admin',
 'logos.lcv',
 'logos.places',
 'logos.names',
 'logos.agents',
 'logos.realia']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware')


Traceback:
File "C:\Python24\Lib\site-packages\django\core\handlers\base.py" in
get_response
  86.                 response = callback(request, *callback_args,
**callback_kwargs)
File "C:\Python24\Lib\site-packages\django\contrib\admin\sites.py" in
root
  157.                 return self.model_page(request, *url.split('/',
2))
File "C:\Python24\Lib\site-packages\django\views\decorators\cache.py"
in _wrapped_view_func
  44.         response = view_func(request, *args, **kwargs)
File "C:\Python24\Lib\site-packages\django\contrib\admin\sites.py" in
model_page
  176.         return admin_obj(request, rest_of_url)
File "C:\Python24\Lib\site-packages\django\contrib\admin\options.py"
in __call__
  197.             return self.change_view(request, unquote(url))
File "C:\Python24\Lib\site-packages\django\db\transaction.py" in
_commit_on_success
  238.                 res = func(*args, **kw)
File "C:\Python24\Lib\site-packages\django\contrib\admin\options.py"
in change_view
  587.                 return self.response_change(request,
new_object)
File "C:\Python24\Lib\site-packages\django\contrib\admin\options.py"
in response_change
  454.             self.message_user(request, msg + ' ' + _("You may
edit it again below."))
File "C:\Python24\Lib\site-packages\django\contrib\admin\options.py"
in message_user
  363.         request.user.message_set.create(message=message)
File "C:\Python24\Lib\site-packages\django\db\models\fields
\related.py" in create
  310.                 return super(RelatedManager, self).create
(**kwargs)
File "C:\Python24\Lib\site-packages\django\db\models\manager.py" in
create
  99.         return self.get_query_set().create(**kwargs)
File "C:\Python24\Lib\site-packages\django\db\models\query.py" in
create
  319.         obj.save(force_insert=True)
File "C:\Python24\Lib\site-packages\django\db\models\base.py" in save
  311.         self.save_base(force_insert=force_insert,
force_update=force_update)
File "C:\Python24\Lib\site-packages\django\db\models\base.py" in
save_base
  383.                 result = manager._insert(values,
return_id=update_pk)
File "C:\Python24\Lib\site-packages\django\db\models\manager.py" in
_insert
  138.         return insert_query(self.model, values, **kwargs)
File "C:\Python24\Lib\site-packages\django\db\models\query.py" in
insert_query
  894.     return query.execute_sql(return_id)
File "C:\Python24\Lib\site-packages\django\db\models\sql
\subqueries.py" in execute_sql
  309.         cursor = super(InsertQuery, self).execute_sql(None)
File "C:\Python24\Lib\site-packages\django\db\models\sql\query.py" in
execute_sql
  1734.         cursor.execute(sql, params)
File "C:\Python24\Lib\site-packages\django\db\backends\util.py" in
execute
  19.             return self.cursor.execute(sql, params)
File "C:\Python24\Lib\site-packages\django\db\backends\mysql\base.py"
in execute
  83.             return self.cursor.execute(query, args)
File "C:\Python24\Lib\site-packages\MySQLdb\cursors.py" in execute
  166.             self.errorhandler(self, exc, value)
File "C:\Python24\Lib\site-packages\MySQLdb\connections.py" in
defaulterrorhandler
  35.     raise errorclass, errorvalue

Exception Type: OperationalError at /admin/realia/lemmarelation/1597/
Exception Value: (1366, "Incorrect string value: '\\xE1\\xBC\\x80\\xCE\
\xAE\\xCF...' for column 'message' at row 1")

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to