Items do not want to change to active.

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
twoflower2
Posts: 19
Joined: Tue Feb 04, 2014 3:07 pm

Items do not want to change to active.

Post by twoflower2 »

Hi,

ver.2.9.7

All the data/items are not visible/active. I changed them to visible/active, but this invisible counter at the top just keep on adding when I select all visible, then select none, then select all again. Anyways selecting all do not make them visible.

In the DB I can see also see that active=yes for almost all data, but I see no items as a user of the FAQs.

Can I issue a SQL cmd (alter) against all data to make then active?

Is this an known issue?

This from my DB backup:

Code: Select all

-- Table: faqdata
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (1,'en',1000,4,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (2,'en',1001,2,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (3,'en',1002,1,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (4,'en',1003,3,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (12,'en',1011,5,'no',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (13,'en',1012,0,'no',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (14,'en',1013,0,'no',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (15,'en',1014,1,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (16,'en',1015,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (17,'en',1016,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (6,'en',1005,3,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (7,'en',1006,0,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (8,'en',1007,3,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (9,'en',1008,0,'yes',0,'
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (10,'en',1009,3,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (11,'en',1010,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (18,'en',1017,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (19,'en',1018,2,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (20,'en',1019,1,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (21,'en',1020,4,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (22,'en',1021,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (23,'en',1022,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (24,'en',1023,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (25,'en',1024,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (26,'en',1025,0,'yes',0,
INSERT INTO faqdata (id,lang,solution_id,revision_id,active,sticky,keywords,thema,content,author,email,comment,updated,links_state,links_check_date,date_start,date_end,created,notes) VALUES (27,'en',1026,0,'yes',0,
Post Reply