Page 81 of 81 FirstFirst ... 3171798081
Results 801 to 805 of 805
  1. #801
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    530
    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
    530
    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
    530
    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
    1,919
    Plugin Contributions
    6

    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....
    #getAJabWhenYouCan
    if you feel so inclined, feel free to send some cake....

  5. #805
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    530
    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.

 

 
Page 81 of 81 FirstFirst ... 3171798081

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 16
    Last Post: 22 Mar 2021, 01:11 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