Version 2.1.4 --> 2.1.5 --> 2.1.7 Forums disappeared

[Migrated From Jforum.net]

My host had to be moved and in the process I lost many things. I lost the JForum webapp, but managed to save my database. The database, I believe, was 2.1.4.

So, I decided to download JForum 2.1.7 and looked for the means to upgrade the database. I was able to find mysql_2.1.4_to_2.1.5.sql and mysql_2.1.6_to_2.1.7.sql, but could not locate mysql_2.1.5_to_2.1.6.sql anywhere.

Therefore, I decided that 2.1.5 == 2.1.6, and applied the two upgrades that I had SQL files for: 2.1.4 --> 2.1.5 and 2.1.6 --> 2.1.7.

The good news was that there were no errors reported when applying the upgrade SQL files, and the forum appears when I open it in my browser, and the list of users shows all of the registered users from before.

The bad news is that my Forum Index is empty!! Eek.

Can anyone point me to a proper 2.1.5 --> 2.1.6 mysql upgrade file?
Can anyone tell me how bad a position I am in?

[originally posted on jforum.net by time]

[Migrated From Jforum.net]

As a followup, please note that the forums are not seen by the Admin Control Panel either. Furthermore, the categories are not seen by Admin either, which makes me think that this is the crux of the problem (no categories). HOWEVER, when I pull up the permissions page for a defined group (yes, groups appear to have survived), the selection lists display all of the available forums, so the permissions page knows the forums.

Also, I have verified that the forums, and their categories are in the database and appear valid:

mysql> select * from jforum_forums
    -> ;
+----------+---------------+----------------------------+------------------------------------------------------------------------------------------------------------------------+-------------+--------------+--------------------+-----------+
| forum_id | categories_id | forum_name                 | forum_desc                                                                                                             | forum_order | forum_topics | forum_last_post_id | moderated |
+----------+---------------+----------------------------+------------------------------------------------------------------------------------------------------------------------+-------------+--------------+--------------------+-----------+
|        6 |             2 | Website                    | For the discussion of beta releases of the turtleweb website.                                                          |           6 |            0 |                  0 |         0 |
|        7 |             2 | BioLogo                    | For the discussion of beta releases of the BioLogo application.                                                        |           5 |            0 |                  0 |         0 |
|       10 |             5 | Using BioLogo              | Discussions about using the BioLogo application.                                                                       |           7 |            2 |                  8 |         0 |
|       11 |             6 | Using Turtle Web           | Discussions about using the Turtle Web website.                                                                        |           8 |            0 |                  0 |         0 |
|       12 |             5 | BioLogo Concepts           | Discussions about general concepts.                                                                                    |           9 |            1 |                  0 |         0 |
|       13 |             6 | Turtle Web Concepts        | Discussions about general concepts.                                                                                    |          10 |            1 |                  6 |         0 |
|       14 |             5 | Frequently Asked Questions | Frequently Asked Questions                                                                                             |          11 |            0 |                  0 |         0 |
|       15 |             6 | Frequently Asked Questions | Frequently Asked Questions                                                                                             |          12 |            2 |                  7 |         0 |
|       16 |             7 | Bugs                       | Report bugs in the BioLogo application, or the Turtle Web website in this forum.                                       |          13 |            0 |                  0 |         0 |
|       17 |             7 | TODO / New Features        | Propose new features and track todo items in this forum.                                                               |          16 |            0 |                  0 |         0 |
|       18 |             7 | Questions                  | General discussions about design, implementation, and other questions related to development of BioLogo or Turtle Web. |          15 |            0 |                  0 |         0 |
|       19 |             7 | Design                     | Documentation of the general design of BioLogo and TurtleWeb.                                                          |          14 |            0 |                  0 |         0 |
+----------+---------------+----------------------------+------------------------------------------------------------------------------------------------------------------------+-------------+--------------+--------------------+-----------+
12 rows in set (0.00 sec)

mysql> select * from jforum_categories;
+---------------+---------------------+---------------+-----------+
| categories_id | title               | display_order | moderated |
+---------------+---------------------+---------------+-----------+
|             2 | Beta                |             5 |         0 |
|             5 | BioLogo Application |             1 |         0 |
|             6 | Turtle Web Website  |             2 |         0 |
|             7 | Development         |             4 |         0 |
+---------------+---------------------+---------------+-----------+
4 rows in set (0.00 sec)

[originally posted on jforum.net by time]

[Migrated From Jforum.net]

DUH.

I read post after post mentioning "permissions", but it just did not register.

Finally, it sunk in. So I went to the Admin Control Panel, selected a group, edited the permissions, and the forums are now listed and all appears to be just fine.

Hope my stupidity benefits someone else in the same predicament.
[originally posted on jforum.net by time]