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 [email protected].
To post to this group, send email to [email protected].
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.
For more options, visit https://groups.google.com/d/optout.
