@LoveWeb2py
Two questions:
1) Are you running web2py from windows distribution binary or source?
2) can you view ANY other tables besides my_table in that application?
I have seen this error too, and my steps to reproduce are below. Still
analyzing the root cause.
Here is how I reproduced this error:
1) bad install of web2py source from git. See Exhibit A.
2) Create an application and then use signup form to add a user to the
auth_user table.
3) try to view any table after that, I get the same KeyError citing that
column auth_user.id does not exist in table.
4) try the same steps from windows compiled distribution of web2py and
everything works fine.
I am guessing that there is some missing or misversioned library that
creates a bad insert statement screwing up the db.
Thanks,
Peter
Exhibit A - my install from source had problems.
Here is how I installed web2py from source. Because the git submodule
update --init --recursive failed (still researching why), I instead pip'd
pydal in and got the server running.
*Windows Command Prompt*
Microsoft Windows [Version 10.0.14393]
(c) 2016 Microsoft Corporation. All rights reserved.
C:\>c:\python27\python.exe c:\web2py-master\web2py.py
Traceback (most recent call last):
File "c:\web2py-master\web2py.py", line 21, in <module>
import gluon.widget
File "c:\web2py-master\gluon\__init__.py", line 31, in <module>
"You can also download a complete copy from http://www.web2py.com.";
RuntimeError: web2py depends on pydal, which apparently you have not
installed.
Probably you cloned the repository using git without '--recursive'
To fix this, please run (from inside your web2py folder):
git submodule update --init --recursive
You can also download a complete copy from http://www.web2py.com.
C:\>cd c:\web2py-master
c:\web2py-master>git submodule update --init --recursive
fatal: 'submodule' appears to be a git command, but we were not
able to execute it. Maybe git-submodule is broken?
c:\web2py-master>c:\python27\python.exe -m pip install pydal
Collecting pydal
Using cached pyDAL-17.3-py2.py3-none-any.whl
Installing collected packages: pydal
Successfully installed pydal-17.3
On Sunday, March 12, 2017 at 6:27:08 PM UTC-5, LoveWeb2py wrote:
>
> Keep getting this error for all of my tables!! What is going on?
>
> What information would be helpful for me to post to get help?
>
--
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.
