[wikka-community] AdminUsers action - error received

[Nils Lindenberg]

Looks like your upgrade did not run that smoothly:

Am 21.10.2009 um 20:06 schrieb Frank Kibbish:

> Hello again...
>
> My upgrade from 1.1.6.2 is going smoothly since I reran the  
> installation.  My CSS is all fixed, and the site is looking good.
>
> So now I'm going through all the pages to validate functionality, etc.
>
> I noticed the two new admin pages -- AdminUsers and AdminPages --  
> that were created, but they were both blank.  Is this normal, or  
> should the {{adminusers}} and {{adminpages}} actions have been added  
> to those pages as part of the upgrade?
>

yes, that should have been the case

> I've added the {{adminpages}} action to the AdminPages wiki page,  
> and it works OK.
>
> However, when I add the {{adminusers}} action to the AdminUsers  
> page, I get the following error:
> Query failed: SELECT COUNT(*) FROM wikka_users WHERE (status IS NULL  
> OR status != 'deleted') AND 1 (Unknown column 'status' in 'where  
> clause')
>
> Do I need to add the "status" column to my wikka_users table?  Is  
> this a change to the database since 1.1.6.2?
>

Yes, you need to add the column behind default_comment_display:

status enum('invited','signed- 
up','pending','active','suspended','banned','deleted')

you might want to check setup/install.php (below 'case "1.1.6.2":') to  
see if other things where left out as well
>