Thread

I upgraded to 2.2.2 last night and this morning when folks login they get the following error:

A Database Error Occurred

Error Number: 1054

Unknown column ‘in_forum’ in ‘field list’

UPDATE `exp_online_users` SET `member_id` = 1, `name` = 0, `ip_address` = ‘xx.xx.xx.xxx’, `in_forum` = ‘n’, `date` = 1315280646, `anon` = ‘n’, `site_id` = ‘1’ WHERE `ip_address` = ‘xx.xx.xx.xxx’ AND `member_id` = 1

Filename: modules/member/mod.member_auth.php

Line Number: 499

If they go back to the index page of the site they are then logged in, so the login process occurs, but there’s still clearly something wrong that I need to fix.

(IP address xx’d out for privacy.)

Do you know your way around MySQL? or how to use PHPMyAdmin?

If so, have a look at the exp_online_users table and check the ‘in_forum’ column exists… if it doesn’t add:

Field name: in_forum
Type: CHAR
Length: 1
Default: ‘n’

Awesome.  Thank you so much.  That did the trick.  I was askeered to add/remove anything for fear of gunking it up.

Everything seems to be back to normal.  (Until I break it in some other way, of course.)

<3

Thanks for the assist, Lee.

Liberty - If anything else comes up, please do let us know in a new thread..