Can you share some of your code from the controller where you're receiving the error?
On Friday, February 2, 2018 at 7:31:59 AM UTC-5, jbu...@wgu.edu wrote: > > > I currently have a mysql database that is defined using pydal and used by > several other applications. I am trying to use Web2py to create an > interface with the existing database. > > For testing I mirrored the schema of the database using sqlite and now > that the project is ready I want to connect it to the mysql database, but > I'm receiving the following error when trying to query the database from > the controller: > > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > > Traceback (most recent call last): > File "/Users/jon/github/build/web/gluon/restricted.py", line 219, in > restricted > exec(ccode, environment) > File > "/Users/jon/github/build/web/applications/project/controllers/scenarios.py" > <http://localhost:8000/admin/edit/cerebro/controllers/scenarios.py>, line > 349, in <module> > File "/Users/jon/github/build/web/gluon/globals.py", line 414, in <lambda> > self._caller = lambda f: f() > File "/Users/jon/github/build/web/gluon/tools.py", line 3981, in f > return action(*a, **b) > File "/Users/jon/github/build/web/applications/ > <http://localhost:8000/admin/edit/cerebro/controllers/scenarios.py>project > <http://localhost:8000/admin/edit/cerebro/controllers/scenarios.py>/controllers/scenarios.py" > <http://localhost:8000/admin/edit/cerebro/controllers/scenarios.py>, line > 207, in show > use_case_set = list({row.use_case_name for row in > mysql_db(mysql_db.build_scenarios).select()}) > File "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/objects.py", > line 2250, in select > return adapter.select(self.query, fields, attributes) > File > "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/adapters/base.py", > line 762, in select > return self._select_aux(sql, fields, attributes, colnames) > File > "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/adapters/base.py", > line 718, in _select_aux > rows = self._select_aux_execute(sql) > File > "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/adapters/base.py", > line 712, in _select_aux_execute > self.execute(sql) > File > "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/adapters/__init__.py", > line 63, in wrap > if not args[0].connection: > File > "/Users/jon/.env/build/lib/python2.7/site-packages/pydal/connection.py", line > 36, in connection > return getattr(THREAD_LOCAL, self._connection_uname_) > AttributeError: 'thread._local' object has no attribute > '_pydal_connection_4382647568_28651' > > > To make things stranger, the query is sometimes successful on the first > attempt after restarting the server, but a refresh always results in the > error. Also using the web2py shell and loading the modules from the > project, I am able to connect to the mysql database without error, and run > the same query repeatedly without any issues. > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
