Getting error after installing 1.1 beta 3

[-Scott]

After installing 1.1 beta 3 when I try to view the message index or a topic I get this error Unknown column 'b.permission_mode' in 'field list' How do I fix this?


Thanks,
-Scott

[Ben_S]

Can you do a detailed version check to make sure everythings upto date, and make sure you ran upgrade.php?

[-Scott]

Detailed version check is good all sources and default templates are 1.1 Beta 3. When I tried to run upgrade.php again
I get this

Updating Settings.php... Successful.
Updating and creating indexes... Successful.
Reorganizing configuration settings... Successful.
Adding and updating member data... Successful.
Updating holidays and calendar... Successful.
Adding custom message icons... Successful.
Adding package servers... Successful.
Cleaning up database... Successful.
Adjusting uploadable avatars... Successful.
Updating thumbnails... Successful.
Updating ban system... Unsuccessful!

This query:
CREATE TABLE smf_ban_items (
ID_BAN mediumint( unsigned NOT NULL auto_increment,
ID_BAN_GROUP smallint(5) unsigned NOT NULL default '0',
ip_low1 tinyint(3) unsigned NOT NULL default '0',
ip_high1 tinyint(3) unsigned NOT NULL default '0',
ip_low2 tinyint(3) unsigned NOT NULL default '0',
ip_high2 tinyint(3) unsigned NOT NULL default '0',
ip_low3 tinyint(3) unsigned NOT NULL default '0',
ip_high3 tinyint(3) unsigned NOT NULL default '0',
ip_low4 tinyint(3) unsigned NOT NULL default '0',
ip_high4 tinyint(3) unsigned NOT NULL default '0',
hostname tinytext NOT NULL default '',
email_address tinytext NOT NULL default '',
ID_MEMBER mediumint( unsigned NOT NULL default '0',
hits mediumint( unsigned NOT NULL default '0',
PRIMARY KEY (ID_BAN),
KEY ID_BAN_GROUP (ID_BAN_GROUP)
) TYPE=MyISAM;
Caused the error:
Table 'smf_ban_items' already exists


-Scott

[[Unknown]]

Sounds like a permissions issue to me.  The upgrader needs to be able to RENAME and DROP tables.

Try the attached upgrade_1-1.sql.  Upload it into the directory of upgrade.php and try again.

-[Unknown]

[-Scott]

Here's what I got....



Updating ban system...
    Splitting ban table... Unsuccessful!

This query:
SELECT ID_BAN_GROUP, restriction_type
FROM smf_ban_groups
ORDER BY ban_time ASC;
Caused the error:
Unknown column 'restriction_type' in 'field list'



-Scott

[[Unknown]]

Try this.

-[Unknown]

[-Scott]

Thank you very much guys.....that did the trick! 



-Scott