Topic: Database Error on SimplePortal

[Armin]

When ever i only go to the block list in admin cp of SimplePortal, it says

Unknown column 'force_view' in 'field list'
File: /home/armin/public_html/glitchrock/forums/Sources/Subs-SPortal1-1.php
Line: 43

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php

Anyone know how to fix this, Id appropriate it. Thanks

[Jakki]

I had the same error...still have not fixed my problem.

[[SiNaN]]

Run this query via phpMyAdmin:

Code: [Select]

ALTER TABLE smf_sp_blocks
ADD force_view TINYINT(2) unsigned DEFAULT '0' NOT NULL

[Armin]

Now I get:

Unknown column 'allowed_groups' in 'field list'
File: /home/armin/public_html/glitchrock/forums/Sources/Subs-SPortal1-1.php
Line: 43

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.

[[SiNaN]]

Now this one:

Code: [Select]

ALTER TABLE smf_sp_blocks
ADD allowed_groups TEXT NOT NULL

[Armin]

Now this one:

Code: [Select]

ALTER TABLE smf_sp_blocks
ADD allowed_groups TEXT NOT NULL

its funny, now i get "permission_type" as the error, I'm going to do the sql code for every table until it will hopefully work, thanks.

EDIT: it worked after permission_type, thanks!!!!!!!!!!!!
EDIT2: For some reason the portal won't take effect in the index anymore when I click enable. Also when its enabled, when people login it goes to /forums/action=forum instead of /forums/index.php?action=forum

[[SiNaN]]

Is it possible to see the forum? Do you have "Redirect to portal" setting enabled?