Can not Add new FAQ's from backend

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Can not Add new FAQ's from backend

Post by mauswara »

Hi,

I have 2 admin accounts both have lost the ability to add a new FAQ but I can, for example, add a new category.

I can log into the backend using - login / sitename / admin - so the password is correct. I have only lost the ability to ADD that has gone. Is there a "flag" that can be set to allow adding records? I can not add a new user either.

I can use PHPMyAdmin to view the various tables. What value/s do I need to change and in what tables so that I can add a new FAQ? I am using v3.09

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

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

can you edit the user in the admin backend?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Re: Can not Add new FAQ's from backend

Post by mauswara »

Thanks for your reply - Yes I can edit the user/s using phpMyAdmin
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

no, I mean with the user administration in the phpMyFAQ admin section.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Re: Can not Add new FAQ's from backend

Post by mauswara »

Sorry I misunderstood.

I get "You are not authorized" if I click on the Users tab.

I can, however, click on change password under "users" but I do not want to in case I lose the ability to log in completely.

thanks for your help
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

looks like some permissions got lost somehow... to clarify, you can't see anything in the user administration view for the user "admin"?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Re: Can not Add new FAQ's from backend

Post by mauswara »

yes, that is correct. If I click on Users I get "not authorised"

If I click on Content I can no longer see an option to add or edit FAQ's

I no longer have permission for those options.
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

please run these queries in phpMyAdmin:

Code: Select all

DELETE  FROM faquser_right;
INSERT INTO faquser_right ('user_id', 'right_id') VALUES
(1, 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, 17),
(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),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53);
ALTER TABLE 'faquser_right' ADD PRIMARY KEY ('user_id', 'right_id');
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Re: Can not Add new FAQ's from backend

Post by mauswara »

Thanks for the help. It is appreciated.

I was able to do everything except --

ALTER TABLE 'faquser_right' ADD PRIMARY KEY ('user_id', 'right_id');

I receive this error.

SQL query:

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''faquser_right' ADD PRIMARY KEY ('user_id', 'right_id')' at line 1

I ran the command one at a time.
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

did you ran the other queries? If yes, is everything working again?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mauswara
Posts: 11
Joined: Sat Nov 12, 2011 6:14 am

Re: Can not Add new FAQ's from backend

Post by mauswara »

I was able to run the other queries but I still can not add any new FAQ's to the existing database.
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Can not Add new FAQ's from backend

Post by Thorsten »

Hi,

which error message do you see?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply