#1061 Disappearing FAQ

v3.3.8
open
John Finlay
None
5
2009-06-14
2006-08-30
Kerry Choy
No

This was previously reported as 1534495 but (I think)
should have been posted as a 4.1 bug.

I get the problem running in 4.0.l stable. I've
observed that I can set up a FAQ list which appears to
be hardened to the database (check the table and the
rows are present). After doing stuff, the whole FAQ
list dissappears. #1534495 and perhaps #1487594 seem to
refer to this.

The problem seems to be that the setBlocks function in
administration.php would hose all the rows related to
the userid that it's being invoked for. Since the
FAQ's are are kept in the same username as the default
for the GEDCOM, something like "Reset to Default
Blocks" will wipe the FAQ's. I assume there are other
circumstances in which setBlocks will be called.

Other defects suggest a separate table for FAQ's.
Another solution might be to assign a different, static
value for userid in the pgv_blocks table. Two
architectural questions:
1. Would you want different FAQ's for different GEDCOM
files?
2. Is this good design practice anyway?

Discussion

  • Kerry Choy
    Kerry Choy
    2006-09-06

    Logged In: YES
    user_id=979969

    Made a patch. See 1553362

     
  • Stephen Arnold
    Stephen Arnold
    2006-09-11

    Logged In: YES
    user_id=1061833

    Thanks for someone else noticing this most aggravating bug.
    We've been complaining about this unexpected action since
    Roland created this feature in response to our RFE.

    Just last week our 4.02 site's FAQ was hosed again, with all
    the FAQ line in the MySQL DB simply being removed. We have
    taken to doing a SQL backup periodically on the Blocks
    table, so we simply dropped it and restored to the BU, but
    this is annoying.
    -Stephen

     
  • KosherJava
    KosherJava
    2006-09-11

    • assigned_to: nobody --> yalnifj
     
  • nigelo
    nigelo
    2006-11-28

    Logged In: YES
    user_id=1254634
    Originator: NO

    I've just been working on the same problem with a user in the Help forum. I'll advise him to implement the patch - but whats the status of a proper fix?

     
  • Stephen Arnold
    Stephen Arnold
    2007-04-02

    Logged In: YES
    user_id=1061833
    Originator: NO

    FAQ is disappearing again! Any modification of the Welcome page and Portal layouts (blocks) seems to be a trigger. MySQL simply deletes the entries for the FAQs

     
  • Greg Roach
    Greg Roach
    2008-11-17

    • milestone: --> v3.3.8
     
  • Greg Roach
    Greg Roach
    2009-06-12

    • status: open --> pending
     
  • Greg Roach
    Greg Roach
    2009-06-12

    This code has been rewritten since the bug was reported, and I can't reproduce it.

    Can we close it?

     
  • Kerry Choy
    Kerry Choy
    2009-06-14

    Yes. Close thanks.

     
  • Kerry Choy
    Kerry Choy
    2009-06-14

    • status: pending --> open