Thread: FAQ Manager

Page 5 of 37 FirstFirst ... 3456715 ... LastLast
Results 41 to 50 of 369
  1. #41
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: FAQ Manager

    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - Categories Box', 'FAQ Manager Categories Box Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - Categories Box';
    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''), ');
    INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', '&nbsp;(', 'What do you want to Prefix the FAQ count with?<br />Default= (', @t4, 10, NULL, now(), NULL, 'zen_cfg_textarea_small(');
    INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', 'What do you want as a Suffix to the FAQ count?<br />Default= )', @t4, 11, NULL, now(), NULL, 'zen_cfg_textarea_small(');
    INSERT INTO zen_configuration VALUES ('', 'FAQ Categories SubCategories Indent', 'FAQ_CATEGORIES_SUBFAQ_CATEGORIES_INDENT', '&nbsp;&nbsp;', 'What do you want to use as the FAQ subcategories indent?<br />Default= &nbsp;&nbsp;', @t4, 12, NULL, now(), NULL, 'zen_cfg_textarea_small(');
    INSERT INTO zen_configuration VALUES ('', 'FAQ Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '0', 'Show FAQ Count for 0 FAQs?<br />0= off<br />1= on', @t4, 13, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
    INSERT INTO zen_configuration VALUES ('', 'Separator between links Status', 'SHOW_FAQ_CATEGORIES_SEPARATOR_LINK', '1', 'Show FAQ Category Separator between Category Names and Links?<br />0= off<br />1= on', @t4, 14, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
    INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Count', 'FAQ_CATEGORIES_SEPARATOR', '-&gt;', 'What separator do you want between the FAQ Category name and the count?<br />Default = -&amp;gt;', @t4, 15, NULL, now(), NULL, 'zen_cfg_textarea_small(');
    INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Sub Categories', 'FAQ_CATEGORIES_SEPARATOR_SUBS', '|_&nbsp;', 'What separator do you want between the FAQ Category name and FAQ Sub Category Name?<br />Default = |_&amp;nbsp;', @t4, 16, NULL, now(), NULL, 'zen_cfg_textarea_small(');
    INSERT INTO zen_configuration VALUES ('', 'Always Open to Show FAQ SubCategories', 'SHOW_FAQ_CATEGORIES_SUBFAQ_CATEGORIES_ALWAYS', '1', 'Always Show Categories and SubCategories<br />0= off, just show Top Categories<br />1= on, Always show Categories and SubCategories when selected', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
    INSERT INTO zen_configuration VALUES ('', 'Show New FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW', 'true', 'Show FAQs New Link in the FAQ Categories Box', @t4, 18, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    INSERT INTO zen_configuration VALUES ('', 'Show All FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL', 'true', 'Show FAQs All Link in the FAQ Categories Box', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Info Page', 'FAQ Manager FAQ Info Page Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - FAQ Info Page';
    INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT', '1', 'Location of Previous/Next Navigation Bar<br />0= off<br />1= Top of Page<br />2= Bottom of Page<br />3= Both Top and Bottom of Page', @t4, 30, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Top of Page''), array(''id''=>''2'', ''text''=>''Bottom of Page''), array(''id''=>''3'', ''text''=>''Both Top & Bottom of Page'')),');
    INSERT INTO zen_configuration VALUES ('', 'Previous Next - Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', 'FAQs Display Order by<br />0= FAQ ID<br />1= FAQ Name<br />6= FAQ Sort Order', @t4, 31, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''FAQ ID''), array(''id''=>''1'', ''text''=>''Name''), array(''id''=>''6'', ''text''=>''FAQ Sort Order'')),');
    INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Status', 'SHOW_FAQ_PREVIOUS_NEXT_STATUS', '0', 'Button and FAQ Image status settings are:<br />0= Off<br />1= On', @t4, 32, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');
    INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Settings', 'SHOW_FAQ_PREVIOUS_NEXT_IMAGES', '0', 'Show Previous/Next Button and FAQ Image Settings<br />0= Button Only<br />1= Button and FAQ Image<br />2= FAQ Image Only', @t4, 33, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Button Only''), array(''id''=>''1'', ''text''=>''Button and FAQ Image''), array(''id''=>''2'', ''text''=>''FAQ Image Only'')),');
    INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Includes FAQ Category', 'FAQ_INFO_FAQ_CATEGORIES', '1', 'FAQs Category Image and Name Alignment Above Previous/Next Navigation Bar<br />0= off<br />1= Align Left<br />2= Align Center<br />3= Align Right', @t4, 34, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Align Left''), array(''id''=>''2'', ''text''=>''Align Center''), array(''id''=>''3'', ''text''=>''Align Right'')),');
    INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Count', 'SHOW_FAQ_INFO_REVIEWS_COUNT', '1', 'Display FAQ Reviews Count on FAQ Info 0= off 1= on', @t4, 35, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
    INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Button', 'SHOW_FAQ_INFO_REVIEWS', '1', 'Display FAQ Reviews Button on FAQ Info 0= off 1= on', @t4, 36, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
    INSERT INTO zen_configuration VALUES ('', 'Show Date Added', 'SHOW_FAQ_INFO_DATE_ADDED', '1', 'Display Date Added on FAQ Info 0= off 1= on', @t4, 37, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
    INSERT INTO zen_configuration VALUES ('', 'Show FAQ URL', 'SHOW_FAQ_INFO_URL', '1', 'Display URL on FAQ Info 0= off 1= on', @t4, 38, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
    INSERT INTO zen_configuration VALUES ('', 'Show FAQ Tell a Friend button', 'SHOW_FAQ_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on FAQ Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on', @t4, 39, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');

    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Listing', 'FAQ Manager FAQ Listing Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - FAQ Listing';
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_LIST_NAME', '1', 'Do you want to display the FAQ Name?', @t4, 50, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Prev/Next Split Page Navigation (1-top, 2-bottom, 3-both)', 'PREV_NEXT_FAQ_BAR_LOCATION', '1', 'Sets the location of the FAQ Prev/Next Split Page Navigation', @t4, 51, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''3''), ');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Listing Default Sort Order', 'FAQ_LISTING_DEFAULT_SORT_ORDER', '', 'FAQ Listing Default sort order?<br />NOTE: Leave Blank for FAQ Sort Order. Sort the FAQ Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a', @t4, 52, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Number Per Page', 'MAX_DISPLAY_FAQS_LISTING', '10', 'Maximum Number of FAQs to list per page on main page', @t4, 53, NULL, now(), '', '');


    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - New FAQs Page', 'FAQ Manager New FAQs Page Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - New FAQs Page';
    INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_NEW', '10', 'Number of new FAQs listings per page', @t4, 70, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_NEW_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 71, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_NEW_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 72, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_NEW_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 73, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_NEW_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?<br />0= off<br />1= on', @t4, 74, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
    INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_NEW_LIST_SORT_DEFAULT', '6', 'What Sort Order Default should be used for New FAQs Display?<br />Default= 6 for Date New to Old<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 75, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
    INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_NEW_LISTING_WIDTH', '50', 'Default = 50', @t4, 76, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_NEW_LISTING_HEIGHT', '40', 'Default = 40', @t4, 77, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_ALL', '10', 'Number of faqs to list per screen', @t4, 80, NULL, now(), NULL, '');
    INSERT INTO zen_configuration VALUES ('', 'New FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_NEW', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');
    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - All FAQs Page', 'FAQ Manager All FAQs Page Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - All FAQs Page';
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_ALL_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 81, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 82, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_ALL_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 83, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_ALL_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?', @t4, 84, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
    INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_ALL_LIST_SORT_DEFAULT', '1', 'What Sort Order Default should be used for All FAQs Display?<br />Default= 1 for FAQ Name<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 85, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
    INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_ALL_LISTING_WIDTH', '50', 'Default = 50', @t4, 86, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_ALL_LISTING_HEIGHT', '40', 'Default = 40', @t4, 87, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'ALL FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');

    INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - General Config', 'FAQ Manager General Config Settings', '1' , '0');
    UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
    SET @t4=0;
    SELECT (@t4:=configuration_group_id) as t4
    FROM zen_configuration_group
    WHERE configuration_group_title= 'FAQ Manager - General Config';

    INSERT INTO zen_configuration VALUES ('', 'FAQ Categories - FAQ Categories To List Per Row', 'MAX_DISPLAY_FAQ_CATEGORIES_PER_ROW', '1', 'How many FAQ categories to list per row', @t4, 91, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Allow faqs To Go Live As Submitted', 'FAQ_LIST_LIVE', 'false', 'Do you want faqs to go live as submitted<br>Set to false for admin approval.', @t4, 92, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    INSERT INTO zen_configuration VALUES ('', 'Define FAQs Submit', 'DEFINE_FAQS_SUBMIT_STATUS', '1', 'Enable the Defined faqs_submit text?<br />0= OFF<br />1= ON', @t4, 93, NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');
    INSERT INTO zen_configuration VALUES ('', 'Allow FAQS submission', 'ALLOW_FAQS_SUBMISSION', 'true', 'Allow users to submit FAQs.', @t4, 94, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    INSERT INTO zen_configuration VALUES ('', 'If Allow FAQS submission = true, allow unregistered users submit FAQs', 'UNREGISTERED_FAQS_SUBMIT', 'true', 'Allow unregistered users to submit FAQs.', @t4, 95, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    INSERT INTO zen_configuration VALUES ('', 'Allow Image Upload', 'SUBMIT_FAQ_ALLOW_IMAGE_UPLOAD', 'true', 'Allow Image Upload on FAQ Submit', @t4, 96, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    INSERT INTO zen_configuration VALUES ('', 'Send FAQ Submit Notification Emails To:', 'SEND_FAQ_SUBMIT_EMAILS_TO_EMAILS_TO', '[email protected]', 'Enter the email address that FAQ submit notifications should be sent to', @t4, 97, NULL, now(), '', '');
    INSERT INTO zen_configuration VALUES ('', 'Define No FAQs Allowed', 'DEFINE_NO_FAQS_ALLOWED', '1', 'Enable the No FAQs Allowed text?<br>0= OFF<br>1= ON', @t4, 98, NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  2. #42
    Join Date
    Jan 2007
    Location
    Bellingham, Wa
    Posts
    174
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Thanks man!!

    I got an error though
    Code:
    Error
    
         SQL query:     
                   INSERT  INTO zen_configuration_group
    VALUES ( '',  'FAQ Manager - Categories Box',  'FAQ Manager Categories Box Settings',  '1',  '0'
    );
    
         
          MySQL said: 
      #1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist
    I exported the DB ( selected all ) to a zip.
    The store is still working fine though.
    I've never backed up a DB before.

  3. #43
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Quote Originally Posted by Pablosan View Post
    Thanks man!!

    I got an error though
    Code:
    Error
     
         SQL query:     
                   INSERT  INTO zen_configuration_group
    VALUES ( '',  'FAQ Manager - Categories Box',  'FAQ Manager Categories Box Settings',  '1',  '0'
    );
     
     
          MySQL said:  
      #1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist
    I exported the DB ( selected all ) to a zip.
    The store is still working fine though.
    I've never backed up a DB before.
    I think it is because your original shop database hasn't got 'zen_' prefix. In this case, you need to delete 'zen_' prefix in the sql file, then import it to your DB again. Besides 10 new faq tables are added (i believe they are in your DB already), two old zc shop tables are affected (new entries are inserted), one is zen_configuration_group, the other is zen_configuration (note: you may not have 'zen_' prefix). When you import the sql, if there is a duplicate error, go to the table, find these new entries and delete them, then try the sql again. (make sure the entries you delete are FAQ related, not others)

    Because this faq sql only add new tables or entries, it will not affect your existing shop operation.
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  4. #44
    Join Date
    Jan 2007
    Location
    Bellingham, Wa
    Posts
    174
    Plugin Contributions
    0

    Default Re: FAQ Manager

    No error for duplicates. I removed zen_ from the file enitrely.
    But now I got this one.
    Sorry I'm SQL noob.


    : Missing parameter: import_type
    : Missing parameter: format

    Heres the file.

    Also when clicking faq manager in admin, but I assmune thats because the SQL never finished.

    1146 Table 'haskellg_estore.faqs' doesn't exist
    in:
    [select count(*) as count from faqs where faqs_status = '1']
    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.
    Attached Files Attached Files
    Last edited by Pablosan; 8 Feb 2007 at 11:55 PM.

  5. #45
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: FAQ Manager

    I don't know why it doen't work for you. Try to add attached FAQ tables first. It should absolutely work fine.
    Attached Files Attached Files
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  6. #46
    Join Date
    Mar 2006
    Posts
    131
    Plugin Contributions
    0

    Default Re: FAQ Manager

    the mod works fine except 1 thing.... the main page is pulled on all category (that do not contain product listing) pages. The only way to stop it seems to be removing the faq_application_top.php in open-operations folder.

    BTW
    Hizen your shop seems to have the same issue. Although it's not a major concern since you only have 1 text line there. For me it cannot work because i have more content on the main page

  7. #47
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Quote Originally Posted by Alik View Post
    the mod works fine except 1 thing.... the main page is pulled on all category (that do not contain product listing) pages. The only way to stop it seems to be removing the faq_application_top.php in open-operations folder.

    BTW Hizen your shop seems to have the same issue. Although it's not a major concern since you only have 1 text line there. For me it cannot work because i have more content on the main page
    I can see the problem now. That's very strange, the status doesn't change even I changed the value of FAQ 'Categories with 0 FAQs Status' in both zen admin 'extras->faq manager' and in db.
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  8. #48
    Join Date
    Jan 2007
    Location
    Bellingham, Wa
    Posts
    174
    Plugin Contributions
    0

    Default Re: FAQ Manager

    Well I noticed the original sql doesn't have the zen prefix which solved that problem.

    I cleaned out all faq related from DB and cut and pasted the orignal sql in.

    No errors importing that sql.

    There are warnings in faq_types_to_faq_category No index defined!
    &
    configuration UNIQUE and INDEX keys should not both be set for column `configuration_key`

    I can't make a faq or category with getting fatal error of undefined functions.
    Fatal error: Call to undefined function zen_get_faq_path()

    So I'm stumped. Take a look... http://www.estore.haskellgraphics.co..._page=faqs_all

    Thanks for your help.

  9. #49
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: FAQ Manager

    I have the same warning message in my db. However, it doesn't seem to cause some problems for me, or perhaps I haven't noticed them.

    For undefined functions, check if you have uploaded all the files, and if you have done the 2nd step in the readme file, some codes need to be added to includes/applicatio_top.php
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  10. #50
    Join Date
    Jan 2007
    Location
    Bellingham, Wa
    Posts
    174
    Plugin Contributions
    0

    Default Re: FAQ Manager

    I added the code
    Code:
    // get customers unique IP that paypal does not touch
    $customers_ip_address = $_SERVER['REMOTE_ADDR'];
    if (!isset($_SESSION['customers_ip_address'])) {
      $_SESSION['customers_ip_address'] = $customers_ip_address;
    }
    ?><?php
    // include the list of extra open-operations files
      if ($za_dir = @dir(DIR_WS_INCLUDES . 'open-operations')) {
        while ($zv_file = $za_dir->read()) {
          if (strstr($zv_file, '.php')) {
            require(DIR_WS_INCLUDES . 'open-operations/' . $zv_file);
          }
        }
      }
      ?>
    All the files were there I went through it several times. Errors everytime.

    Think I better just wait for the working copy and use wordpress in the meantime. After thinking about it wordpress should do the same thing.

    Thanks for your help.

 

 
Page 5 of 37 FirstFirst ... 3456715 ... 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