Ask Your Question
1

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

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

raspi gravatar image

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

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

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.

edit retag flag offensive 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 gravatar imageEvgeny ( 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 gravatar imageEvgeny ( 2010-06-15 02:07:48 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Evgeny gravatar image

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

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
edit flag offensive delete link more

Comments

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 -0600 )edit
great. I'll update the version requirements in setup.py within a week.
Evgeny gravatar imageEvgeny ( 2010-06-15 11:58:13 -0600 )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

Stats

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

Seen: 2,010 times

Last updated: Jun 15 '10