1

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.

Evgeny's avatar
13.2k
Evgeny
updated 2010-06-15 20:28:17 -0600
raspi's avatar
63
raspi
asked 2010-06-15 01:09:13 -0600
edit flag offensive 0 remove flag close merge delete

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's avatar Evgeny (2010-06-15 02:02:50 -0600) 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's avatar Evgeny (2010-06-15 02:07:48 -0600) edit
add a comment see more comments

1 Answer

0

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
Evgeny's avatar
13.2k
Evgeny
updated 2010-06-15 01:38:12 -0600, answered 2010-06-15 01:21:28 -0600
edit flag offensive 0 remove flag delete link

Comments

Ok. Got it to work. It was probably old South which caused some weird DB stuff.
raspi's avatar raspi (2010-06-15 03:18:07 -0600) edit
great. I'll update the version requirements in setup.py within a week.
Evgeny's avatar Evgeny (2010-06-15 11:58:13 -0600) edit
add a comment see more comments