Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Errors after Upgrade from V4.5.1
Avatar
Mack Biggs
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2015 - 5:28 pm

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

Best Regards,
Mack

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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....

Avatar
Mack Biggs
Member
Free Members
sp_UserOfflineSmall Offline
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.

Best Regards,
Mack

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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/docum.....-versions/

Avatar
Mack Biggs
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2015 - 7:50 pm

Do you know the corresponding WordPress version?

Best Regards,
Mack

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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...

Avatar
Mack Biggs
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2015 - 7:54 pm

Ah! Great thank you.

Best Regards,
Mack

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 3, 2015 - 8:08 pm

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

Avatar
Mack Biggs
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2015 - 8:39 pm

How can I fix the database errors?

Best Regards,
Mack

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625