I feel that UTF-8 collation should be included in docs either in requirements section or in the installation. Otherwise, it's too easy for anyone to get into this error.
Shakthi On Wed, Feb 18, 2009 at 4:06 AM, Chris Moffitt <[email protected]> wrote: > Make sure your collation on Mysql is set to utf-8. > > -Chirs > > > On Tue, Feb 17, 2009 at 12:51 PM, Robson <[email protected]> wrote: > >> >> Hello all ! >> >> That´s my first time trying to setup satchmo and after reading, re- >> reading and trying to make it work, i gave up. >> >> I´ve followed all steps described on >> http://www.satchmoproject.com/docs/svn/ >> , but unfortunately, it´s not working. >> >> Everything was ok, except when i was running manage.py >> load_satchmo_l10n >> >> Installing xml fixture 'l10n_data' from 'C:\Python25\lib\site-packages >> \satchmo-0.9_pre-py2.5.egg\l10n\fixtures'. >> Problem installing fixture 'C:\Python25\lib\site-packages >> \satchmo-0.9_pre-py2.5.egg\l10n\fixtures\l10n_data.xml': Traceback >> (most recent call last): >> File "C:\Python25\Lib\site-packages\django\core\management\commands >> \loaddata.py", line 153, in handle >> obj.save() >> File "C:\Python25\Lib\site-packages\django\core\serializers >> \base.py", line 163, in save >> models.Model.save_base(self.object, raw=True) >> File "C:\Python25\Lib\site-packages\django\db\models\base.py", line >> 379, in save_base >> rows = manager.filter(pk=pk_val)._update(values) >> File "C:\Python25\Lib\site-packages\django\db\models\query.py", line >> 468, in _update >> return query.execute_sql(None) >> File "C:\Python25\Lib\site-packages\django\db\models\sql >> \subqueries.py", line 119, in execute_sql >> cursor = super(UpdateQuery, self).execute_sql(result_type) >> File "C:\Python25\Lib\site-packages\django\db\models\sql\query.py", >> line 1980, in execute_sql >> cursor.execute(sql, params) >> File "C:\Python25\Lib\site-packages\django\db\backends\util.py", >> line 19, in execute >> return self.cursor.execute(sql, params) >> File "C:\Python25\Lib\site-packages\django\db\backends\mysql >> \base.py", line 83, in execute >> return self.cursor.execute(query, args) >> File "C:\Python25\lib\site-packages\MySQLdb\cursors.py", line 168, >> in execute >> if not self._defer_warnings: self._warning_check() >> File "C:\Python25\lib\site-packages\MySQLdb\cursors.py", line 82, in >> _warning_check >> warn(w[-1], self.Warning, 3) >> File "C:\Python25\Lib\warnings.py", line 62, in warn >> globals) >> File "C:\Python25\Lib\warnings.py", line 102, in warn_explicit >> raise message >> Warning: Incorrect string value: '\xC5\x9Feron' for column 'name' at >> row 1 >> >> Pointing the browser to http://127.0.0.1:8000/ generates an error: >> >> Environment: >> >> Request Method: GET >> Request URL: http://localhost:8000/ >> Django Version: 1.1 pre-alpha >> Python Version: 2.5.4 >> Installed Applications: >> ['satchmo_store.shop', >> 'django.contrib.sites', >> 'django.contrib.admin', >> 'django.contrib.auth', >> 'django.contrib.contenttypes', >> 'django.contrib.comments', >> 'django.contrib.sessions', >> 'django.contrib.sitemaps', >> 'registration', >> 'keyedcache', >> 'livesettings', >> 'l10n', >> 'sorl.thumbnail', >> 'satchmo_store.contact', >> 'tax', >> 'tax.modules.no', >> 'tax.modules.area', >> 'tax.modules.percent', >> 'shipping', >> 'product', >> 'payment', >> 'payment.modules.giftcertificate', >> 'satchmo_utils', >> 'app_plugins', >> 'mystore'] >> Installed Middleware: >> ('django.middleware.common.CommonMiddleware', >> 'django.contrib.sessions.middleware.SessionMiddleware', >> 'django.middleware.locale.LocaleMiddleware', >> 'django.contrib.auth.middleware.AuthenticationMiddleware', >> 'django.middleware.doc.XViewMiddleware', >> 'threaded_multihost.middleware.ThreadLocalMiddleware', >> 'satchmo_store.shop.SSLMiddleware.SSLRedirect') >> >> >> Traceback: >> File "C:\Python25\Lib\site-packages\django\core\handlers\base.py" in >> get_response >> 86. response = callback(request, *callback_args, >> **callback_kwargs) >> File "c:\python25\lib\site-packages\Satchmo-0.9_pre-py2.5.egg >> \satchmo_store\shop\views\home.py" in home >> 37. 'paginator' : paginator >> File "C:\Python25\Lib\site-packages\django\template\context.py" in >> __init__ >> 105. self.update(processor(request)) >> File "c:\python25\lib\site-packages\Satchmo-0.9_pre-py2.5.egg >> \satchmo_ext\recentlist\context_processors.py" in recent_products >> 7. maxrecent = config_value('PRODUCT','RECENT_MAX') >> File "c:\python25\lib\site-packages\Satchmo-0.9_pre-py2.5.egg >> \livesettings\functions.py" in config_value >> 205. return config_get(group, key).value >> File "c:\python25\lib\site-packages\Satchmo-0.9_pre-py2.5.egg >> \livesettings\functions.py" in config_get >> 150. return ConfigurationSettings().get_config(group, key) >> File "c:\python25\lib\site-packages\Satchmo-0.9_pre-py2.5.egg >> \livesettings\functions.py" in get_config >> 72. raise SettingNotSet('%s.%s' % (group, key)) >> >> Exception Type: SettingNotSet at / >> Exception Value: >> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" 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 this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
