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

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'")

Env:

Request Method: POST
Request URL: http://127.0.0.1:8000/account/register/
Django Version: 1.1.1
Python Version: 2.6.5
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.admin',
 'django.contrib.humanize',
 'django.contrib.sitemaps',
 'debug_toolbar',
 'forum',
 'django_authopenid',
 'debug_toolbar',
 'south']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'forum.middleware.anon_user.ConnectToSessionMessagesMiddleware',
 'forum.middleware.pagesize.QuestionsPageSizeMiddleware',
 'forum.middleware.cancel.CancelActionMiddleware',
 'django.middleware.transaction.TransactionMiddleware',
 'debug_toolbar.middleware.DebugToolbarMiddleware',
 'forum.middleware.view_log.ViewLogMiddleware')

Log

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

Migration says:

$ python manage.py 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.

13.2k

Evgeny

updated 14 years ago

raspi

asked 14 years ago

Comments

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 (14 years ago)

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 (14 years ago)

see more comments

1 Answer

Sort by

oldest

newest

most voted

Hi Raspi,

I've just done the following:

git clone git://github.com/ASKBOT/askbot-devel.git
cd askbot-devel
cp settings_local.py.dist settings_local.py
#entered database credentials, then typed
python manage.py syncdb
python manage.py migrate forum #forum app database is under migrations
python manage.py 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 setup.py install

you can also try

easy_install askbot

13.2k

Evgeny

updated 14 years ago, answered 14 years ago

link

Comments

Ok. Got it to work. It was probably old South which caused some weird DB stuff.

raspi (14 years ago)

great. I'll update the version requirements in setup.py within a week.

Evgeny (14 years ago)

see more comments

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

Comments

1 Answer

Comments

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