SimplePortal

Support => English Support => Topic started by: Armin on December 18, 2008, 05:50:36 PM

Title: Database Error on SimplePortal
Post by: Armin on December 18, 2008, 05:50:36 PM

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

Quote

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

Title: Re: Database Error on SimplePortal
Post by: Jakki on December 19, 2008, 12:38:19 PM

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

Title: Re: Database Error on SimplePortal
Post by: [SiNaN] on December 20, 2008, 06:44:39 AM

Run this query via phpMyAdmin:

Code: [Select]

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

Title: Re: Database Error on SimplePortal
Post by: Armin on December 21, 2008, 04:47:57 PM

Now I get:

Quote

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.

Title: Re: Database Error on SimplePortal
Post by: [SiNaN] on December 22, 2008, 05:28:41 AM

Now this one:

Code: [Select]

ALTER TABLE smf_sp_blocks
ADD allowed_groups TEXT NOT NULL

Title: Re: Database Error on SimplePortal
Post by: Armin on December 22, 2008, 06:05:54 PM

Quote from: Blue Dream on December 22, 2008, 05:28:41 AM

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

Title: Re: Database Error on SimplePortal
Post by: [SiNaN] on January 01, 2009, 08:38:12 AM

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