Hello friends, I'm having a deep Django-MySQLDB error and I'm doing some debugging to trace exactly where the problem is. It seems to me that this is very related to MySQLDB cursor implementaton.
What I want to do is to run the raw sql from the interactive mode like this: import MySQLdb db=MySQLdb.connect(passwd="pass",db="dname") c=db.cursor() max_price=5 c.execute(RAW_SQL_HERE) In case you don't mind, here is the full stack trace: Traceback (most recent call last): File "C:\Python27\lib\site-packages\celery-2.3.2-py2.7.egg\celery\execute\trace.py" , line 36, in trace return cls(states.SUCCESS, retval=fun(*args, **kwargs)) File "C:\Python27\lib\site-packages\celery-2.3.2-py2.7.egg\celery\app\task\__init__ .py", line 232, in __call__ return self.run(*args, **kwargs) File "C:\Python27\lib\site-packages\celery-2.3.2-py2.7.egg\celery\app\__init__.py", line 172, in run return fun(*args, **kwargs) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\transaction.py", line 217, in inner res = func(*args, **kwargs) File "api\tasks.py", line 146, in queue_transaction txn.save() File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\base.py", line 460, in save self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\base.py", line 570, in save_base created=(not record_exists), raw=raw, using=using) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\dispatch\dispatcher .py", line 172, in send response = receiver(signal=self, sender=sender, **named) File "C:\Python27\lib\site-packages\django_audit_log-0.2.2-py2.7.egg\audit_log\mode ls\managers.py", line 64, in post_save self.create_log_entry(instance, created and 'I' or 'U') File "C:\Python27\lib\site-packages\django_audit_log-0.2.2-py2.7.egg\audit_log\mode ls\managers.py", line 61, in create_log_entry manager.create(action_type = action_type, **attrs) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\manager.p y", line 138, in create return self.get_query_set().create(**kwargs) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\query.py" , line 360, in create obj.save(force_insert=True, using=self.db) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\base.py", line 460, in save self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\base.py", line 553, in save_base result = manager._insert(values, return_id=update_pk, using=using) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\manager.p y", line 195, in _insert return insert_query(self.model, values, **kwargs) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\query.py" , line 1436, in insert_query return query.get_compiler(using=using).execute_sql(return_id) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\sql\compi ler.py", line 791, in execute_sql cursor = super(SQLInsertCompiler, self).execute_sql(None) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\models\sql\compi ler.py", line 735, in execute_sql cursor.execute(sql, params) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\backends\util.py ", line 34, in execute return self.cursor.execute(sql, params) File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db\backends\mysql\b ase.py", line 86, in execute return self.cursor.execute(query, args) File "build\bdist.win32\egg\MySQLdb\cursors.py", line 176, in execute if not self._defer_warnings: self._warning_check() File "build\bdist.win32\egg\MySQLdb\cursors.py", line 92, in _warning_check warn(w[-1], self.Warning, 3) Warning: Data truncated for column 'jno' at row 1 None Some of the solutions I found on the internet such as changing teh default character set to utf8 has been done. I also consulted MySQL doc ref by changing the sql_mode to TRADITIONA both at session and global level, as well as in settings.py. Still no luck. Please how do I get the raw SQL executed by Django? Any help will be appreciated. -- Odeyemi 'Kayode O. http://www.sinati.com. t: @charyorde -- 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.
