Support Forum

Errors after Upgrade from V4.5.1

MB Mack Biggs
Mack Biggs
Member
Member since Apr 2012
18 posts
May 3, 2015 · 5:28 pm · Edited

I just completed an upgrade to both WordPress and SimplePress.

WordPress V4.2.1

SimplePress Latest version 5.5.6

After login to the site as admin then going to Forum I get this message on the front page of the forum

The requested group does not exist or you do not have permission to view it.

I then went to Toolbox error logs and there are two in reddish color:

 

1. May 3, 2015 2:03 pm | spaErrError | 9 | database

file: General Website locations/wp-content/plugins/simple-press/forum/content/sp-common-view-functions.php

line: 2546

function: sp_get_members_online

error: Unknown column ‘forum_id’ in ‘field list’

SELECT trackuserid, display_name, user_options, forum_id, topic_id, pageview, display FROM wp_sftrack JOIN wp_sfmembers ON wp_sftrack.trackuserid = wp_sfmembers.user_id ORDER BY trackuserid

 

2.May 3, 2015 2:03 pm | spaErrError | 9 | database

file: General Website locations/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-support-functions.php

line: 113

function: sp_track_online

error: Unknown column ‘forum_id’ in ‘field list’

INSERT INTO wp_sftrack (trackuserid, trackname, forum_id, topic_id, trackdate, pageview, device, display) VALUES (1, ‘Neothink’, 0, 0, ‘2015-05-03 12:36:11’, ‘group’, ‘D’, ‘spType-Admin spRank-admin’)

Is this the reason for the forum front page message?

What can be done to correct this??

 

Here are other messages listed:

May 3, 2015 2:10 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-themes/forms/spa-themes-list-form.php

line: 86

function: spa_themes_list_form

Notice | Undefined index: parent
May 3, 2015 2:01 pm | spaErrWarning | 2 | php

file: /simple-press/admin/library/spa-support.php

line: 208

function: opendir

Warning | opendir(/problem-with-post-edit-buttonome1/devmack/public_html/neothinkmembers/wp-content/plugins/simple-forum/styles/icons/default/custom//) [function.opendir]: failed to open dir: No such file or directory
May 3, 2015 2:05 pm | spaErrNotice | 3 | php

file: /simple-press/admin/panel-admins/forms/spa-admins-your-options-form.php

line: 33

function: spa_admins_your_options_form

Notice | Undefined index: bypasslogout
May 3, 2015 12:42 pm | spaErrNotice | 3 | php

file: /simple-press/sp-startup/site/credentials/sp-credentials.php

line: 46

function: sp_logout_redirect

Notice | Undefined index: bypasslogout
May 3, 2015 2:11 pm | spaErrNotice | 3 | php

file: /simple-press/admin/panel-options/support/spa-options-prepare.php

line: 29

function: spa_get_global_data

Notice | Undefined index: blockprofile

May 3, 2015 2:03 pm | spaErrNotice | 472 | php

file: /simple-press/sp-api/sp-api-auths.php

line: 29

function: sp_get_auth

Notice | Undefined index: can_use_iframes

May 3, 2015 12:35 pm | spaErrNotice | 1 | php

file: /simple-press/sp-api/sp-api-plugins.php

line: 82

function: sp_get_plugins

Notice | Undefined variable: plugins_subdir
May 3, 2015 2:12 pm | spaErrNotice | 12 | php

file: /simple-press/sp-startup/admin/spa-admin-framework.php

line: 400

function: spa_check_warnings

Notice | Undefined index: active

11 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2015 · 6:57 pm

It appears perhaps some upgrade scripts did not run since you are missing columns in your db table…

can you detail the steps you took?  did you go from x to 4.5.1 and then direct to 5.5.6? or other…

you might go to forum – permissions – reset permissions and try resetting them…  some folks add an issue when moving from 4.5.5 to 5.x with old permissions that were corrupted…  note:  if you had any custom permission changes, you will need to remake them…

so try the permissions, then we can address the db errors….

MB Mack Biggs
Mack Biggs
Member
Member since Apr 2012
18 posts
May 3, 2015 · 7:17 pm

Mr Papa,

 

Thank you for your very quick response. Resetting the permissions solved the problem.

I was updating WordPress from 2.8.4 manually 3.0.6, 3.2.1, 3.4.2, 3.6.1, 3.8.5,4.0.1 auto to 4.2

I upgraded SimplePress to V4.5.1 at WP 3.6.1 then V5.5.6 at WP4.2

Should I have upgraded SimplePress with a version that corresponds to the WordPress Version? At each WordPress step the database was upgraded by WP.

If so I will need access to the SimplePress Corresponding plugin version.

Also, I created a file folder inside of wp-content/forum-custom-icons for the custom icons. (none yet)

 

I have two more sites to upgrade like this one.

The next site starts at WordPress 3.1.3 and SimplePress 4.4.4

Thank you in advance for your support.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2015 · 7:48 pm

wow, some old stuff 😉

if you need other versions of simple press, you can get them here:  https://simple-press.com/documentation/codex/installation/upgrading/previous-simplepress-versions/

MB Mack Biggs
Mack Biggs
Member
Member since Apr 2012
18 posts
May 3, 2015 · 7:50 pm

Do you know the corresponding WordPress version?

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2015 · 7:53 pm

no, afraid not… but any version you download in the main sp-control.php file, it will list the compatible wp version…

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2015 · 8:08 pm

glad to help… let us know how you make out or if you have any more questions…

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
May 3, 2015 · 11:23 pm

sorry, what db errors??  back in post 3, you said problem resolved…

if you mean the notices and/or warnings, they generally dont matter… and since you upgraded from so far back, may not be pertinent…  clear the error log…  and then if still getting errors, please post the error…  but not the warnings and notices…

MB Mack Biggs
Mack Biggs
Member
Member since Apr 2012
18 posts
May 3, 2015 · 11:25 pm

Ok. Sound good. Thank you.

On Sunday, May 3, 2015, Simple:Press Support wrote:

>