Ask Your Question
1

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

asked Jun 15 '10

raspi gravatar image raspi
63 1 2 6
http://raspi.fi/

updated Jun 15 '10

Evgeny gravatar image Evgeny flag of Chile
6715 31 49 96
http://askbot.org/

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.

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 (Jun 15 '10)
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 (Jun 15 '10)

1 Answer

Sort by ยป oldest newest most voted
0
raspi has selected this answer as correct

answered Jun 15 '10

Evgeny gravatar image Evgeny flag of Chile
6715 31 49 96
http://askbot.org/

updated Jun 15 '10

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
link

Comments

Ok. Got it to work. It was probably old South which caused some weird DB stuff. raspi (Jun 15 '10)
great. I'll update the version requirements in setup.py within a week. Evgeny (Jun 15 '10)

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
[hide preview]

Question tools

Follow

subscribe to rss feed

Stats

Asked: Jun 15 '10

Seen: 557 times

Last updated: Jun 15 '10