Page 81 of 81 FirstFirst ... 3171798081
Results 801 to 807 of 807
  1. #801
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    562
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    I am trying to use this plugin with 157b and PHP 7.4., first I got the error
    Code:
    PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in C:\xampp73a\htdocs\Zencart157b\catalog\includes\modules\mytemplate\dynamic_filter.php on line 14.
    which Carlwhat fixed with
    Code:
    // replace
    while(list($key, $value) = each ($_GET))
    // with
    foreach ($_GET as $key => $value) .
    Now I have these PHP Notices when running the sql install patch and "WARNING: An Error occurred, please refresh the page and try again.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."
    Code:
    [15-May-2021 15:54:18 Europe/Berlin] PHP Notice:  Undefined offset: 1 in C:\xampp73a\htdocs\Zencart157b\catalog\Admin\sqlpatch.php on line 657
    [15-May-2021 15:54:18 Europe/Berlin] PHP Notice:  Undefined offset: 3 in C:\xampp73a\htdocs\Zencart157b\catalog\Admin\sqlpatch.php on line 658
    Then I ran the patch through a syntax checker and got
    Code:
    You have an error in your SQL syntax; it seems the error is around: ': = configuration_group_id FROM configuration_group WHERE configuration_grou' at line 2
    Any help appreciated.

  2. #802
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    562
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    Quote Originally Posted by marton_1 View Post
    I am trying to use this plugin with 157b and PHP 7.4., first I got the error
    Code:
    PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in C:\xampp73a\htdocs\Zencart157b\catalog\includes\modules\mytemplate\dynamic_filter.php on line 14.
    which Carlwhat fixed with
    Code:
    // replace
    while(list($key, $value) = each ($_GET))
    // with
    foreach ($_GET as $key => $value) .
    Now I have these PHP Notices when running the sql install patch and "WARNING: An Error occurred, please refresh the page and try again.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."
    Code:
    [15-May-2021 15:54:18 Europe/Berlin] PHP Notice:  Undefined offset: 1 in C:\xampp73a\htdocs\Zencart157b\catalog\Admin\sqlpatch.php on line 657
    [15-May-2021 15:54:18 Europe/Berlin] PHP Notice:  Undefined offset: 3 in C:\xampp73a\htdocs\Zencart157b\catalog\Admin\sqlpatch.php on line 658
    Then I ran the patch through a syntax checker and got
    Code:
    You have an error in your SQL syntax; it seems the error is around: ': = configuration_group_id FROM configuration_group WHERE configuration_grou' at line 2
    Any help appreciated.
    I tried the fix from this thread but it did not help
    https://www.zen-cart.com/showthread....tall-sql-files

  3. #803
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    562
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    I ran the install SQL as an SQL query directly on the DB and got a different error message
    Code:
    INSERT INTO configuration VALUES
      (NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
      (NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
      (NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
      (NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
      (NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
      (NULL, 'Enable on Search Page', 'FILTE[...]
    MySQL said: Documentation
    
    #1136 - Column count doesn't match value count at row 1

  4. #804
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,426
    Plugin Contributions
    11

    Default Re: Dynamic Filter [Support Thread]

    i would try adding a null into the end of all the insert values. it seems the structure of the table has changed:

    Code:
    INSERT INTO configuration VALUES
      (NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Search Page', 'FILTE[...]
    etc...

    although you will need to figure out what @cid is and replace accordingly if doing it manually....
    mxWorks now has premium plugins
    are you using square? have you shown any appreciation with cake on venmo or on paypal?
    called the savior by the chief bottle washer...

  5. #805
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    562
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    Quote Originally Posted by carlwhat View Post
    i would try adding a null into the end of all the insert values. it seems the structure of the table has changed:

    Code:
    INSERT INTO configuration VALUES
      (NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),", NULL),
      (NULL, 'Enable on Search Page', 'FILTE[...]
    etc...

    although you will need to figure out what @cid is and replace accordingly if doing it manually....
    Thanks, I see there are 12 fields in the DB and only 11 added in the SQL. Unfortunately, I have not had much time to work on this, I will report back when later.

  6. #806
    Join Date
    Jan 2008
    Posts
    84
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    Just curious if anyone is using this with the most current ZC version...1.5.7 or later? Seems like the plugin hasn't been updated in quite awhile, but I need something like this for my site. If anyone is successfully using it with 1.5.7 or later please let me know. If there is a newer/different plugin that is compatible with 1.5.7 would like to know that as well. Thanks in advance!

  7. #807
    Join Date
    Jan 2015
    Posts
    346
    Plugin Contributions
    0

    Default Re: Dynamic Filter [Support Thread]

    I am upgrading from 1.5.7 to 1.58.

    I noticed in the upgrade 1.58 they have excluded the directory which is a core edit…
    includes/modules/pages/advanced_search_result/header.php

    I then tried to copy it to this file to.
    includes/modules/pages/search_result/header.php

    Does anyone have any ideas on how to get this module to work from 1.57 to 1.58.

    I do have some warnings in my log
    PHP Warning: Undefined variable $products_tax in C:\xampp\htdocs\xxx.com\includes\templates\theme871\sideboxes\tpl_dynamic_filter .php on line 653.

    Code:
    // BOF tax fix by design75
    
        $text = $currency_symbol . round(zen_add_tax($start, $products_tax) * $conversion_rate) . TEXT_DYNAMIC_FILTER_DIVIDER . $currency_symbol . round(zen_add_tax($end, $products_tax) * $conversion_rate);
    
        }
    
        else
    
        {
    
          $text = $currency_symbol . round(zen_add_tax($start, $products_tax) * $conversion_rate) . TEXT_DYNAMIC_FILTER_AND_OVER;
    
    // EOF tax fix

 

 
Page 81 of 81 FirstFirst ... 3171798081

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. Empty Dynamic Filter
    By LadyoftheCave in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 6 Jun 2016, 12:47 PM
  3. v150 Dynamic filter
    By Dinoleix in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 13 Aug 2013, 10:23 AM
  4. v150 Dynamic filter - All pages
    By Okkwebmedia in forum Addon Sideboxes
    Replies: 0
    Last Post: 8 Jul 2013, 08:52 AM
  5. v138a Dynamic Filter
    By SoftCorpse in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 18 Jun 2012, 01:32 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