Support Forum
Support Forum
Offline
Yes, I have a sp-resources folder in wp-content, so best practice would be to not delete the V5 folders.
So, lets rewrite our instructions.
1 - Deactivate V5
2 - Download V4.5.1
3 - Install V4.5.1 via FTP
4 - Remove all sf tables from database? Not sure how to actually remove a table[s].
5 - Restore all sf tables from V4.3.5 back-up? see question for step 6
6 – Activate the V4.5.1? Will this recreate all the necessary sf tables? Should I do this before I restore from the back-up so all the appropriate tables will have been recreated and I can just repopulate them?
7 – Upgrade the V4.5.1 from admin
8 - Create a database back-up while on V4.5.1
9 - Deactivate the V4.5.1
10 - Activate V5
11 - Upgrade V5 from admin
12 - Delete all V4.5.1 folders
Offline
That's what I would be doing...
Ok - about questions 4-5-6. There is always something one does without thinking and then does not remember that other people may not do the same! So this depends upon the backup db script.
A good backup script will work through each table one at a time. It will (1) Delete the existing table (DROP TABLE) - (2) Create a new version of table (CREATE TABLE) and then insert all of the data.
You need to check yours. You can look at it with a text editor (PLAIN text editor not a word processor).
IF it performs a DROP TABLE then a CREATE TABLE and then lots of INSERT statements - perform step 4 as planned.
IF it performs CREATE TABLE and INSERT statements only - perform step 4 as planned.
IF it ONLY has INSERT statements (which is most unlikely) then come back to me and we will talk that bit through.
If one of the first two then stick to the order above.
 |
YELLOW
SWORDFISH
|
Offline
Heres the beginning of my sfposts table from the back-up:
# --------------------------------------------------------
# Table: `wp_sfposts`
# --------------------------------------------------------#
# Delete any existing table `wp_sfposts`
#DROP TABLE IF EXISTS `wp_sfposts`;
#
# Table structure of table `wp_sfposts`
#CREATE TABLE `wp_sfposts` (
So it does DROP the table, then reCREATEs the table and INSERTs the data (code not shown).
But when you said
I would remove all current 'sf' tables from your working database before you restore the older ones. The reason for this suggestion is that V5 does create some new ones and it would be better to have those recreated at step 15 below.
Is it possible to do that w/o using the backup? B/c the backup code will instantly recreate the tables.
When I did the restore the other day, I just copied and pasted each table from NP++ into phpMyAdmin via the SQL tab. Is there another more efficient method that would remove all current sf tables?
Offline
REMOVE OLD TABLES: Yes actually - that's a good question. In the WP plugins list against SP if you click on the Uninstall option instead of deactivate it will remove all of the old data - just follow the prompt.
RESTORING OLD TABLES: IF your sql restore script ONLY contains the forum 'sf' tables then the quickest and easiest way is to import it. When you view the list of database tables in phpMyAdmin, Import will be available on the top menu.
of course of the script contains all of the wp tables as well then you mustn't do this. But it would still be quicker to edit the script to remove the wp tables and just leave all of the forum tables for import than doing it one at a time,.
|
YELLOW
SWORDFISH
|
Offline
ok, back to 4-5-6
5 - my back-up does contain all my wp tables. but editing out the wp tables, saving it as a different file w/ only the sf tables, and then importing the sf tables file sounds easy enough
4 - i just installed V4.5.1 via FTP. I now have both V5.1.3 and V4.5.1 in my WP plugins lists, neither activated. How and what am I supposed to uninstall?
6 - this step makes sense, but will it overwrite the sf tables i just restored?
Offline
You now what. Let's make it easier and just cut out step 4 completely.
and step 6 - no.
|
YELLOW
SWORDFISH
|
Offline
Below is my final process. Right now I'm up to step 6. The forum looks/looked like it should be working properly, but none of my legacy forums, posts, or topics are there. But it does show all my users.
The forum and the admin pages looked complete and updated.
I investigated the sf tables in the database and found they were empty (except for the members which had all my legacy data). I then realized I have 2 databases (i realized this before, but didnt give it any attention. i thought 1 was not used) - _wp & _wp1. So, I had imported the sf tables into the _wp database, and thats when it updated correctly (but w/ only the members data). The sf tables in the _wp contained the legacy data, but the sf tables in the _wp1 database were empty (except for members). So I imported the sf tables into the _wp1 database. Now all my legacy data is in the _wp1 database and the even shows up in the forum admin. But the forum isnt showing on my forum page.
These are screenshots of my website from when the forum was updated correctly and then from when it the data was imported into the _wp1 and now isnt working currently.
1 – Deactivate V5
2 – Download V4.5.1
3 – Install V4.5.1 via FTP
4 – Restore all sf tables from V4.3.5 back-up using files that only contains sf tables via IMPORT
5 – Activate the V4.5.1
6 – Upgrade the V4.5.1 from admin. Forum should be functioning properly.
7 – Create a database back-up while on V4.5.1
8 – Deactivate the V4.5.1
9 – Activate V5
10 – Upgrade V5 from admin
11 – Delete all V4.5.1 folders
i wish somehow you could share my screen (goto meeting or something) to see all that I am talking about.
Offline
I continued on thru step 10. But the forum page and admin showed no groups or forum, but the admin page did show all the users. So, I restored the sf groups and sf forums tables, and they showed currently on the forum page and the admin. But now I'm back to this:
I am having two problems that I'm thinking may be related.
1) When I upgraded to V5, I lost my data. So I had to rebuild certain tables from a back-up. Certain tables were still in tact correctly. But some of the information in the tables isnt showing correctly on the website itself. The tables show content, and even the forum footer shows a topics and posts count. But the forum reports no topics in this forum.
2) When I try to add a new topic, I receive this error
Fatal error: Call to undefined function sf_pop_topic_page() in /problem-with-post-edit-buttonome/delreia/public_html/wp-content/themes/DELREIA_2.bkp/templates/post_title.php on line 61
The forum appears on http://delreia.com/forum/open-forum/
I'm not about to restore the sf options table
Offline
I have it working on V4.5.1
But something is wrong w/ the process to go to V5.
Offline
is your wp theme really calling that sp function? If so, try removing it as that is a 4.x function and not valid in 5.x... not even sure what you might be trying to do in that wp theme with that call...
or are you referring to something else?
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)