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,