web2py Internal Error when creating database tables

[lukesarre]

Hello, I'm trying to follow the instructions for a full-install of OZtree, but I have run into a problem.

I have installed all dependencies and set up a database backend (I think!). I can successfully open web2py with the python3 web2py.py -i 127.0.0.1 -p 8000 -a pass command, but then when I navigate in my browser to http://127.0.0.1:8000/OZtree/default/ I hit an error.

I have attached the returned error ticket: ticket OZtree_127.0.0.1.2022-06-08.15-35-08.452b0d60-02ba-4716-b7eb-1e3197ed1077.html.txt

I really appreciate the resource you have created, and I hope I can use this tool for communicating my own research Thank you for all your work :) Luke

[hyanwong]

Hi Luke, sorry for the slow reply. The error seems to be this:

<class 'KeyError'> 255

in db.py

auth.define_tables(username=True, signature=False)

So that makes me think that either you have an old version of pymysql loaded, or you haven't set up access on the database correctly, or there's something weird about the database that isn't allowing access. Can you log in OK to the sql database using the username and password defined in the appconfig.ini file?

I guess the docker image is working for you, though?