HI
I have just started using web2py, but have used MVC in other programming
languages, the problem I have gaot is importing a db from MySQL. I use the
script in the scripts folder for extracting from MySQL, which worked fine.
When I added to web2py, most of the tables work fine, but one table keeps
giving an flash error saying "Invalid query 1054, "Unknown column 'user.id'
in 'where clause'".
Not surw how to correct.
This is the full error
Traceback (most recent call last):
File
"/home/gazza/Downloads/web2py/applications/school/controllers/appadmin.py",
line 250, in select
nrows = db(query, ignore_common_filters=True).count()
File "/home/gazza/Downloads/web2py/gluon/dal.py", line 10325, in count
return db._adapter.count(self.query,distinct)
File "/home/gazza/Downloads/web2py/gluon/dal.py", line 1851, in count
self.execute(self._count(query, distinct))
File "/home/gazza/Downloads/web2py/gluon/dal.py", line 1916, in execute
return self.log_execute(*a, **b)
File "/home/gazza/Downloads/web2py/gluon/dal.py", line 1910, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'user.id' in 'where clause'")
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
