Thread: FAQ Manager

Page 1 of 37 12311 ... LastLast
Results 1 to 10 of 369
  1. #1
    Join Date
    Sep 2004
    Location
    London. UK.
    Posts
    164
    Plugin Contributions
    0

    Default FAQ Manager

    I am trying to install the FAQ Manager 1.(2) into our new test system running 1.3.5 of zencart.

    The files upload fine, but when I try to install the SQL I get the following error:

    1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
    in:
    [INSERT INTO zen_configuration VALUES ('', 'Show FAQ Category Counts', 'SHOW_FAQ_COUNTS', 'true', 'Count recursively how many FAQs are in each FAQ category', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    I deleted the tables in relation to faq_xxxxx but still get the same error as above.... ?

    If anyone has any suggestions that would be great.

    Many Thanks.
    Chris
    Regards,

    Chris (CCN1)

  2. #2
    Join Date
    Oct 2006
    Posts
    14
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Hello,

    Me too I have got the same problem. Can someone kindly help with a solution.

    Thanks

  3. #3
    Join Date
    May 2006
    Location
    Virginia U.S
    Posts
    173
    Plugin Contributions
    3

    Re: FAQ Manager

    I have the same exact errer.
    1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
    Can someone please fix this?
    Thanks

    The only partial solution I have come up with is that the reason this is happening is we are trying to enter data into the database that is already there, or at least some part of it is identical that must not be.

    What we are getting there is a duplicate key error. There's a column in the database that has a unique key defined on it, so any time it see's that data is being entered into that column that is identical to data already in the column, we get the error.
    Last edited by beasleybub; 30 Oct 2006 at 05:29 AM. Reason: Found additional information

  4. #4
    Join Date
    May 2006
    Location
    Virginia U.S
    Posts
    173
    Plugin Contributions
    3

    Idea or Suggestion Re: FAQ Manager I believe this will fix our problem

    Long story short, I simply replaced "INSERT" with "REPLACE" in the faq_manager.sql file and it worked like a charm. I am attaching the updated faq_manager.sql file.
    Worked for me BUT USE AT YOUR OWN RISK.
    Attached Files Attached Files

  5. #5
    Join Date
    May 2006
    Location
    Virginia U.S
    Posts
    173
    Plugin Contributions
    3

    Default Re: FAQ Manager I believe this will fix our problem

    Well before anyone runs and does this. It did work but it also failed.
    It did install data to mysql but at the same time it also replaced data already there. So my fix is a start but IT DID NOT WORK.
    Can someone with alot more experience give this a crack?
    Thanks!

  6. #6
    Join Date
    Jun 2004
    Location
    Irvine, Scotland
    Posts
    115
    Plugin Contributions
    0

    Default Re: FAQ Manager

    I'm Getting this error on where the sidebox should appear...

    1054 Unknown column 'p.products_date_available' in 'where clause'
    in:
    [select p.faqs_id from faqs p where p.faqs_status = '1' and p.products_date_available >=20061104 limit 1]

    Any ideas

  7. #7

    Default Re: FAQ Manager

    Fatal error: Cannot instantiate non-existent class: faq_category_tree in /home/fuzzibunz/www/www/store/includes/modules/sideboxes/faq_categories.php on line 22


    I'm getting the above error, so my index doesn't load fully and I have no idea if this mod will work.

    Anyone have a fix for this? I am running 1.3.6 and the site in question is www.fuzzibunzdepot.com

  8. #8
    Join Date
    Sep 2006
    Posts
    37
    Plugin Contributions
    0

    Default Re: FAQ Manager

    I'm also getting the following error:

    1054 Unknown column 'p.products_date_available' in 'where clause'
    in:
    [select p.faqs_id from plushc_faqs p where p.faqs_status = '1' and p.products_date_available >=20061104 limit 1]
    The Sql had a problem. Any help would be greatly appreciated.

    Thanks

  9. #9
    Join Date
    May 2006
    Location
    Virginia U.S
    Posts
    173
    Plugin Contributions
    3

    bug Re: FAQ Manager

    It looks like faq manager has a bunch of bugs.
    I just chose to scrap using it. "Much easier"
    How can there be nothing? Nothing is something!

  10. #10
    Join Date
    Jun 2005
    Location
    Pittsburgh
    Posts
    174
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Not sure this is a working contrib, suggest you remove the sql tables and wait for someone to post a solution:

    DROP TABLE IF EXISTS faq_categories;
    DROP TABLE IF EXISTS faq_categories_description;
    DROP TABLE IF EXISTS faq_reviews;
    DROP TABLE IF EXISTS faq_reviews_description;
    DROP TABLE IF EXISTS faq_type_layout;
    DROP TABLE IF EXISTS faq_types;
    DROP TABLE IF EXISTS faq_types_to_faq_category;
    DROP TABLE IF EXISTS faqs;
    DROP TABLE IF EXISTS `faqs_description`;
    DROP TABLE IF EXISTS faqs_to_faq_categories;

 

 
Page 1 of 37 12311 ... LastLast

Similar Threads

  1. FAQ manager
    By louisapple in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 8 Apr 2009, 03:08 PM
  2. FAQ Manager error
    By tpascubarat in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 23 Jan 2008, 12:48 PM
  3. FAQ Manager ?
    By winky3d in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 26 Jul 2007, 02:33 PM
  4. Faq Manager Character Limit
    By jaywhy in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 2 May 2007, 05:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR