Ask Your Question

Unknown column 'auth_user.is_approved' in 'field list' [fixed]

asked 2010-06-15 01:09:13 -0500

raspi gravatar image

updated 2010-06-15 20:28:17 -0500

Evgeny gravatar image

I just installed fresh askbot from github and when I try to login with Google OpenID, I get:

Exception Type: OperationalError at /account/register/
Exception Value: (1054, "Unknown column 'auth_user.is_approved' in 'field list'")


Request Method: POST
Request URL:
Django Version: 1.1.1
Python Version: 2.6.5
Installed Applications:
Installed Middleware:


/home/raspi/web/bv/forum/utils/ TIME: 2010-06-15 09:49:28,083 MSG: next url is /
/home/raspi/web/bv/django_authopenid/ TIME: 2010-06-15 09:49:28,084 MSG: request method is POST
/home/raspi/web/bv/django_authopenid/ TIME: 2010-06-15 09:49:28,084 MSG: trying to create new account associated with openid
/home/raspi/web/bv/forum/utils/ TIME: 2010-06-15 09:49:28,084 MSG: next url is /
/home/raspi/web/bv/forum/middleware/ TIME: 2010-06-15 09:49:28,099 MSG: have exception (1054, "Unknown column 'auth_user.is_approved' in 'field list'")

Migration says:

$ python migrate forum
Running migrations for forum:
- Nothing to migrate.
 - Loading initial data for forum.

I checked the DB with MySQL Query Browser and there is authuser table, but not that *isapproved* field. I also tried to remove all tables and then ran syncdb & migrate forum again.

edit retag flag offensive close merge delete


uh sorry. I'm leaving for the day, please add information about your system, database and version of mysql-python module if you can't fix this soon.
Evgeny gravatar imageEvgeny ( 2010-06-15 02:02:50 -0500 )edit
maybe your db user does not have privileges to alter, delete and create tables? I usually grant all privilieges: grant all privileges on dbname.* to username@localhost identified by 'somepass';
Evgeny gravatar imageEvgeny ( 2010-06-15 02:07:48 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2010-06-15 01:21:28 -0500

Evgeny gravatar image

updated 2010-06-15 01:38:12 -0500

Hi Raspi,

I've just done the following:

git clone git://
cd askbot-devel
#entered database credentials, then typed
python syncdb
python migrate forum #forum app database is under migrations
python runserver `hostname -i`:8000

and could log in with google no problems. I'm guessing that you did not run migrate forum command. I've noticed an issue with skin - the search button is wrapped around, will fix tomorrow.

Btw, experimental branch,(but not master yet) is now under setuptools installation will work as

python install

you can also try

easy_install askbot
edit flag offensive delete link more


Ok. Got it to work. It was probably old South which caused some weird DB stuff.
raspi gravatar imageraspi ( 2010-06-15 03:18:07 -0500 )edit
great. I'll update the version requirements in within a week.
Evgeny gravatar imageEvgeny ( 2010-06-15 11:58:13 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools


Asked: 2010-06-15 01:09:13 -0500

Seen: 2,087 times

Last updated: Jun 15 '10