Ask Your Question
1

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

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

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

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

Evgeny gravatar image Evgeny flag of Chile
11059 50 84 182
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.

delete close flag offensive retag edit

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 ( 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 ( 2010-06-15 02:07:48 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Evgeny gravatar image Evgeny flag of Chile
11059 50 84 182
http://askbot.org/

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

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

Comments

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

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]

Reliable Askbot Hosting

Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.

create your Q&A site
30 days free trial

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 670 times

Last updated: Jun 15 '10