| User | Post |
|
10:29 am
20 Jun 2008
|
erkki
Member
| | | |
|
| posts 5 |
|
|
I recently tried to update the forum to the latest version.
After I copied all the files and tried to run the plug-in, I got the following error on the admin page:
*WordPress database error:* [Table 'hilavitkutin.wp_sfpermissions' doesn't exist]
|SELECT forum_id, usergroup_id, permission_role FROM wp_sfpermissions ORDER BY permission_id|
*WordPress database error:* [Table 'hilavitkutin.wp_sfroles' doesn't exist]
|SELECT role_id, role_actions FROM wp_sfroles ORDER BY role_id|
*WordPress database error:* [Table 'hilavitkutin.wp_sfmembers' doesn't exist]
|SELECT user_id AS ID, display_name FROM wp_sfmembers WHERE pm = 1 ORDER BY display_name|
*WordPress database error:* [Table 'hilavitkutin.wp_sfmembers' doesn't exist]
|SELECT * FROM wp_sfmembers WHERE user_id = 1
When I go to the forum menu after that, I get following error:
*Fatal error*: Call to undefined function sf_set_first_visit() in */var/www/customers/hilavitkutincom/public_html/wp-content/plugins/simple-forum/install/sf-upgradesupport.php* on line *222
*
When I de-activate the plug-in, Wordpress runs just fine, but every time I try to activate the plug-in again, the same error appears.
The site is located at http://www.hilavitkutin.com The mysql version is 5.0.22.
Any help would be greatly appreciated!
|
|
|
2:45 pm
20 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
there is a bug in the current release where harmless errors are shown until the upgrade script is run but I dont think thats what you are seeing…
when you say 'forum menu' I take it from your post tht you get the *fatal error* message when attempting to run the upgrade script in the forum admin menu… it should be the only thing available in that menu… it this the case?
I would also hypothesize that something went awry in the uploading of the new version if it cant find that function… when the downloaded SPF zip archive is extracted, you should end up with a simple-forum directory. That directory and all of its contents should be uploaded to the plugins directory.
If this is the situation, then I would suggest deleting the entire directory from your plugins and re-uploading a new copy as it appears something got corrupted or didnt complete during the upload. Please note, if you try what I just suggested, you will want to save any customizatons you may have made (skins, icons, custom graphics, etc) before deleting the directory… also note, that v2.x skins are not compatible with v3.x
|
|
|
9:51 am
23 Jun 2008
|
erkki
Member
| | | |
|
| posts 5 |
|
|
Thanks for the clues.
Actually the “fatal error” when trying to upgrade appears already when i try to go to the forum top menu in WP.
I also tried now to delete the whole forum directory and uploading all files fresh. However the same erros still appear.
I uploaded now all the screens where errors appear, if that could provide better clues.
1. after activating plug-in: http://www.hilavitkutin.com/screens/scr1.jpg
2. after clicking forum-link on menu: http://www.hilavitkutin.com/screens/scr2.jpg
3. how the whole site looks like after activating the plug-in: http://www.hilavitkutin.com/screens/scr3.jpg
|
|
|
2:46 pm
23 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
The first screen is the errors talked about in this topic…
The second screen bothers me… that routine is called from a patch upgrade… but worse, I cant find it in the distribution either… your title doesnt make sense though either… what version are you upgrading to? 3.1.2? from 2.1? gonna have to figure out tonight (heading off to work) where that function its calling went…
the third screen is not an SPF error and is generated by a different plugin… likely having a conflict with spf though… the post2cat function no longer exists… what wp version are you running?
|
|
|
2:57 pm
23 Jun 2008
|
erkki
Member
| | | |
|
| posts 5 |
|
|
Yes, I tried to upgrade SPF from 2.1 to 3.1.2.
All the errros on the screens i sent appear only when I activate the forum plug-in.
I have the latest version (2.5,1) of Wordpress and i tried to update the forum after first updating to the latest WP.
Thanks again for any help you can provide!
|
|
|
7:39 pm
23 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
one of your plugins must not be 2.5 compatible if they are trying to access the post2cat table - it doesnt exist any more…. spf is not generating that error message…
after work tonight, need to understand that function calll error as I didnt see it in our distribution either…
|
|
|
2:26 am
24 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
erkki,
If my hunch is correct, you were actually running an old version of 2.1 (patch 1 or a build < 236)… and I believe this is a bug and have opened a ticket… that function that is called does not exist in the distribution but I believe it was entered incorrectly…
I dont think this is going to cause you any issues except some users may not have a proper time since their last visit displayed.
|
|
|
10:00 am
24 Jun 2008
|
erkki
Member
| | | |
|
| posts 5 |
|
|
The problem is, that I can not get the forum working, by following the installation steps. Every time i try to access the forum after update, i still get the errors:
WordPress database error: [Table 'hilavitkutin.wp_sfpermissions' doesn't exist]
SELECT forum_id, usergroup_id, permission_role FROM wp_sfpermissions ORDER BY permission_id
WordPress database error: [Table 'hilavitkutin.wp_sfroles' doesn't exist]
SELECT role_id, role_actions FROM wp_sfroles ORDER BY role_id
WordPress database error: [Table 'hilavitkutin.wp_sfmembers' doesn't exist]
SELECT user_id AS ID, display_name FROM wp_sfmembers WHERE pm = 1 ORDER BY display_name
WordPress database error: [Table 'hilavitkutin.wp_sfmembers' doesn't exist]
SELECT * FROM wp_sfmembers WHERE user_id = 1
Would it be possible to add these tables manually, when the script fails?
|
|
|
2:11 pm
24 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
could you please try something for me…
go to file sf-updgradesupport.php line 222 and change the function call (currently sf_set_first_visit($user->ID)) to be
sf_set_last_visited($user->ID)
when you are in the forum admin, you still have the upgrade link, correct? after the change, try running the upgrade once again… did you make a copy of your database before performing the upgrade?
|
|
|
11:19 am
25 Jun 2008
|
erkki
Member
| | | |
|
| posts 5 |
|
|
Hi, this solved the problem. Now the forum is back up and running perfectly again!
A big thak you for the fast and great support!
|
|
|
2:34 pm
25 Jun 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1167 |
|
|
good news! thanks for getting back to me on it… will get it fixed in next release…
|
|
Forums
