Hi Michel, I’ve reviewed your code and everything looks like it should be working fine. Have you tried using a fresh, blank database? Could it be an issue with your settings? I can’t imagine what else it could be at the moment. Thanks, Matthew
From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Michel Lavoie Sent: Monday, October 8, 2018 9:30 AM To: django-users@googlegroups.com Subject: Re: "No such table" error, with different tablename as in query Hi Matthew, Thank you for the suggestion, but as I mentioned the error is not limited to my views.py; it's also present in the auto generated admin page. Basically in the example I gave, I call the delete() method from my transaction object, by id. There's also the "main."prefix in the error that bothers me, in addition to the "s" at the end of the table name. But I'm sure that it doesn't come from my views.py, this error appeared after upgrading to 2.1. My app's code is on GitHub: https://github.com/miek770/huitcent/tree/master/finance Thanks, Michel On Mon, Oct 8, 2018, 09:46 Matthew Pava, <matthew.p...@iss.com<mailto:matthew.p...@iss.com>> wrote: Hi Michel, The error states that there is no such table finance_transactions with an s on the end. Maybe you could show us your view code, but that would be the place that I would start at. From: django-users@googlegroups.com<mailto:django-users@googlegroups.com> [mailto:django-users@googlegroups.com<mailto:django-users@googlegroups.com>] On Behalf Of Michel Lavoie Sent: Sunday, October 7, 2018 6:17 AM To: Django users Subject: "No such table" error, with different tablename as in query Hi, I've just upgrade my Django installation from 1.11 to 2.0, and then to 2.1, and am now getting a weird bug with one of my applications. Whenever I try to execute a view that either deletes or saves a transation in my "finance" app, I get the following error: OperationalError at /finance/2/1776/delete_transaction/ no such table: main.finance_transactions The SQL query is fine though, looking at the traceback. It shows the correct table name which is: finance_transaction /srv/http/myserver/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py in execute def execute(self, query, params=None): if params is None: return Database.Cursor.execute(self, query) query = self.convert_query(query) return Database.Cursor.execute(self, query, params) ▼ Local vars Variable Value params (1776,) query 'DELETE FROM "finance_transaction" WHERE "finance_transaction"."id" IN (?)' self <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0xb55cf608> I checked the database and table finance_transaction is present. All views that just show data work fine, only the ones that modify data generate this error. The other apps from this instance all work 100% fine, only this one has this bug. I also didn't modify anything from the code for the Django upgrade, except a few changes to views.py and urls.py to turn of warnings. Any idea what could be causing this? I looked at all lines from the traceback and can't see what could be changing the table name after the SQL string get created. BTW, I get the same error from the auto-generated admin page when trying to delete a transaction, as well as a custom management script. Thus, it shouldn't be related to my views.py. Thanks, Michel -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com<mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dbdeafaf-1d6c-434e-8ac6-97a57a555e9f%40googlegroups.com<https://groups.google.com/d/msgid/django-users/dbdeafaf-1d6c-434e-8ac6-97a57a555e9f%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com<mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8195eef3c605409a8a5d7711ad234ba9%40ISS1.ISS.LOCAL<https://groups.google.com/d/msgid/django-users/8195eef3c605409a8a5d7711ad234ba9%40ISS1.ISS.LOCAL?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com<mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAK%3D8-REYHuLAMgAMR0RAATcZ-auJQrbHb_TExyNztna1EYTEqA%40mail.gmail.com<https://groups.google.com/d/msgid/django-users/CAK%3D8-REYHuLAMgAMR0RAATcZ-auJQrbHb_TExyNztna1EYTEqA%40mail.gmail.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/410776f4197f46e2892c62971e246246%40ISS1.ISS.LOCAL. For more options, visit https://groups.google.com/d/optout.
