Unable to view FAQs after going to medium security

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Unable to view FAQs after going to medium security

Post by mmcgrath » Wed Jul 10, 2013 9:42 pm

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
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Thu Jul 11, 2013 7:19 am

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Re: Unable to view FAQs after going to medium security

Post by mmcgrath » Thu Jul 11, 2013 1:32 pm

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
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Thu Jul 11, 2013 1:35 pm

HI,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Re: Unable to view FAQs after going to medium security

Post by mmcgrath » Thu Jul 11, 2013 2:25 pm

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

Thorsten
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Thu Jul 11, 2013 7:06 pm

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Re: Unable to view FAQs after going to medium security

Post by mmcgrath » Thu Jul 11, 2013 7:54 pm

Thorsten wrote: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
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Thu Jul 11, 2013 8:03 pm

Hi,

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

Thanks!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Re: Unable to view FAQs after going to medium security

Post by mmcgrath » Wed Jul 17, 2013 4:41 pm

Thorsten wrote: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
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Wed Jul 17, 2013 5:20 pm

HI,

yes, but no time yet to look into it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

mmcgrath
Posts: 38
Joined: Wed Jul 10, 2013 9:31 pm

Re: Unable to view FAQs after going to medium security

Post by mmcgrath » Wed Jul 17, 2013 5:24 pm

Thorsten wrote:HI,

yes, but no time yet to look into it.

bye
Thorsten
Perfect. Thanks!

Thorsten
Posts: 14974
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Unable to view FAQs after going to medium security

Post by Thorsten » Sat Jul 20, 2013 11:34 am

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply