Unable to view FAQs after going to medium security
Moderator: Thorsten
Unable to view FAQs after going to medium security
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!?
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!?
Re: Unable to view FAQs after going to medium security
Hi,
please check all *_group tables if there's any data in it.
bye
Thorsten
please check all *_group tables if there's any data in it.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Unable to view FAQs after going to medium security
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)
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)
Re: Unable to view FAQs after going to medium security
HI,
looks like some datasets in _myfaqfaquser_group are missing. That's why you cannot see the entries...
bye
Thorsten
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
amazon.de Wishlist
Re: Unable to view FAQs after going to medium security
Is there an easy fix for what's causing my problem?
Re: Unable to view FAQs after going to medium security
Hi,
you can send me your database, I can check it then.
bye
Thorsten
you can send me your database, I can check it then.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Unable to view FAQs after going to medium security
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.Thorsten wrote:Hi,
you can send me your database, I can check it then.
bye
Thorsten
Max
Re: Unable to view FAQs after going to medium security
Hi,
please send me an e-mail: thorsten AT phpmyfaq DOT de
Thanks!
bye
Thorsten
please send me an e-mail: thorsten AT phpmyfaq DOT de
Thanks!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Unable to view FAQs after going to medium security
Hi Thorsten -Thorsten wrote:Hi,
please send me an e-mail: thorsten AT phpmyfaq DOT de
Thanks!
bye
Thorsten
Did my e-mail go through with the .sql attachment?
Re: Unable to view FAQs after going to medium security
HI,
yes, but no time yet to look into it.
bye
Thorsten
yes, but no time yet to look into it.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Unable to view FAQs after going to medium security
Perfect. Thanks!Thorsten wrote:HI,
yes, but no time yet to look into it.
bye
Thorsten
Re: Unable to view FAQs after going to medium security
Hi,
your faqdata_group table was empty, I sent you a query by email to fill it.
bye
Thorsten
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
amazon.de Wishlist