Can not Add new FAQ's from backend
Moderator: Thorsten
Can not Add new FAQ's from backend
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
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
Re: Can not Add new FAQ's from backend
Hi,
can you edit the user in the admin backend?
bye
Thorsten
can you edit the user in the admin backend?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Can not Add new FAQ's from backend
Thanks for your reply - Yes I can edit the user/s using phpMyAdmin
Re: Can not Add new FAQ's from backend
Hi,
no, I mean with the user administration in the phpMyFAQ admin section.
bye
Thorsten
no, I mean with the user administration in the phpMyFAQ admin section.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Can not Add new FAQ's from backend
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
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
Re: Can not Add new FAQ's from backend
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
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
amazon.de Wishlist
Re: Can not Add new FAQ's from backend
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.
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.
Re: Can not Add new FAQ's from backend
Hi,
please run these queries in phpMyAdmin:
bye
Thorsten
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');
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Can not Add new FAQ's from backend
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.
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.
Re: Can not Add new FAQ's from backend
Hi,
did you ran the other queries? If yes, is everything working again?
bye
Thorsten
did you ran the other queries? If yes, is everything working again?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Can not Add new FAQ's from backend
I was able to run the other queries but I still can not add any new FAQ's to the existing database.
Re: Can not Add new FAQ's from backend
Hi,
which error message do you see?
bye
Thorsten
which error message do you see?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist