Unable to view FAQs after going to medium security

[mmcgrath]

Hi All -

Just upgraded to 2.8.1. I want to utilize groups so I went from basic to medium security. Now, when I login (even as Admin), I can't see the FAQs. I can see how many FAQs are in a category...but I can't drill down to see the actual FAQs.

When I go to edit categories, the group permissions are set to "Access for all groups" and the user permissions are set to "Access for all users". Why can't I view FAQs after moving to medium security?

Please help!?

[Thorsten]

Hi,

please check all *_group tables if there's any data in it.

bye
Thorsten

[mmcgrath]

This is what I see:

Database changed
mysql> show tables;
+----------------------------+
| Tables_in_myfaq |
+----------------------------+
| _myfaqfaqadminlog |
| _myfaqfaqattachment |
| _myfaqfaqattachment_file |
| _myfaqfaqcaptcha |
| _myfaqfaqcategories |
| _myfaqfaqcategory_group |
| _myfaqfaqcategory_user |
| _myfaqfaqcategoryrelations |
| _myfaqfaqchanges |
| _myfaqfaqcomments |
| _myfaqfaqconfig |
| _myfaqfaqdata |
| _myfaqfaqdata_group |
| _myfaqfaqdata_revisions |
| _myfaqfaqdata_tags |
| _myfaqfaqdata_user |
| _myfaqfaqglossary |
| _myfaqfaqgroup |
| _myfaqfaqgroup_right |
| _myfaqfaqinstances |
| _myfaqfaqinstances_config |
| _myfaqfaqnews |
| _myfaqfaqquestions |
| _myfaqfaqright |
| _myfaqfaqsearches |
| _myfaqfaqsessions |
| _myfaqfaqstopwords |
| _myfaqfaqtags |
| _myfaqfaquser |
| _myfaqfaquser_group |
| _myfaqfaquser_right |
| _myfaqfaquserdata |
| _myfaqfaquserlogin |
| _myfaqfaqvisits |
| _myfaqfaqvoting |
+----------------------------+
35 rows in set (0.00 sec)

mysql> select * from _myfaqfaquser_group;
+---------+----------+
| user_id | group_id |
+---------+----------+
| 2 | 5 |
| 2 | 6 |
| 3 | 5 |
| 3 | 6 |
+---------+----------+
4 rows in set (0.00 sec)

mysql> select * from _myfaqfaqcategory_group;
+-------------+----------+
| category_id | group_id |
+-------------+----------+
| 1 | -1 |
| 2 | -1 |
| 3 | -1 |
| 4 | -1 |
| 5 | -1 |
| 6 | -1 |
| 7 | -1 |
| 8 | -1 |
| 9 | -1 |
| 10 | -1 |
| 11 | -1 |
| 12 | -1 |
| 13 | -1 |
| 14 | -1 |
| 15 | -1 |
| 16 | -1 |
| 18 | -1 |
| 19 | -1 |
| 20 | -1 |
| 21 | -1 |
| 22 | -1 |
| 23 | -1 |
| 24 | -1 |
| 25 | -1 |
| 26 | -1 |
| 27 | -1 |
| 28 | -1 |
| 29 | -1 |
| 30 | -1 |
| 31 | -1 |
| 32 | 5 |
| 33 | -1 |
| 34 | -1 |
| 35 | -1 |
| 36 | -1 |
| 37 | -1 |
| 38 | -1 |
| 39 | -1 |
| 41 | 6 |
| 42 | 7 |
| 43 | 5 |
| 44 | 6 |
+-------------+----------+
42 rows in set (0.00 sec)

mysql> select * from _myfaqfaqdata_group;
Empty set (0.01 sec)

[Thorsten]

HI,

looks like some datasets in _myfaqfaquser_group are missing. That's why you cannot see the entries...

bye
Thorsten

[mmcgrath]

Is there an easy fix for what's causing my problem?

[Thorsten]

Hi,

you can send me your database, I can check it then.

bye
Thorsten

[mmcgrath]

Hi,

you can send me your database, I can check it then.

bye
Thorsten

Excellent! How can I get it to you? I am unable to attach a .sql to this port -- and I couldn't figure out how to send a file via PM.

Max

[Thorsten]

Hi,

please send me an e-mail: thorsten AT phpmyfaq DOT de

Thanks!

bye
Thorsten

[mmcgrath]

Hi,

please send me an e-mail: thorsten AT phpmyfaq DOT de

Thanks!

bye
Thorsten

Hi Thorsten -

Did my e-mail go through with the .sql attachment?

[Thorsten]

HI,

yes, but no time yet to look into it.

bye
Thorsten

[mmcgrath]

HI,

yes, but no time yet to look into it.

bye
Thorsten

Perfect. Thanks!

[Thorsten]

Hi,

your faqdata_group table was empty, I sent you a query by email to fill it.

bye
Thorsten