Okay
  Public Ticket #1436945
Cascade does not work
Closed

Comments

  •  2
    radoslawoska started the conversation

    Hi, on my website when I tick for example Hindi Transcript  Draft then I can't choose the 'type' (see the attachment).

    Could you be so kind and help me?

    thank you

    Radoslaw

    Attached files:  cascade.png

  •  455
    Bogdan replied

    HI Radoslaw,
    Thank you for your purchase.

    Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Also point me to the table ID so I can take a look.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   radoslawoska replied privately
  •  455
    Bogdan replied

    HI Radoslaw,
     

    I logged in successfully and I can see the issue.

    This is a small bug on our side with the multiselectboxes, selectboxes and this issue is solved for our next update of the plugin which I hope that it will be released soon.

    As a workaround for now, may I suggest you to try some other filter type for that column .

    Sorry for any inconvenience and thank you for understanding.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    thank you Bogdan.

  •  2
    radoslawoska replied

    Hi Bogdan, any news on update?

  •  455
    Bogdan replied

    Hi Radoslaw,

    We are preparing the latest update of the plugin butI can not tell you precisely the date when it will be available.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Dear Bogdan, any ETA for the update?

    thank you

    Radoslaw

  •  2
    radoslawoska replied

    Dear Bogdan, I converted checkbox to multiselect as you suggested but still the issue persists. 

  •  455
    Bogdan replied

    HI Radoslaw,

    We are testing the latest version as we speak and preparing for release.

    May I ask you to send me the _takls file ( sql or zipped) so I can upload it to my database and test it .

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   radoslawoska replied privately
  •  455
    Bogdan replied

    Hi Radoslaw, 

    I tested your table with the latest version of our plugin and I did not encountered the issue.

    Can you please tell me is it possible for you to send me the theme that you are using so I can test it further.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Sure I'm using free theme https://wordpress.org/themes/catch-responsive/

    I hope it helps, you can also upload the latest version directly to my website

  •  455
    Bogdan replied

    Hi Radoslaw, 

    No issue with the theme also so everything is working.

    I will ask my college which fixed this issue to point me what files did he changed so I can patch your site also.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Hi Bogdan, any luck with the patch?

    thank you

  •  455
    Bogdan replied

    HI Radoslaw,

    Can you please tell me do you have the same issue when the Powerful filters add on is disabled or this is happening only when the Cascade filtering is on.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    This happens when cascade is on. 

  •  455
    Bogdan replied

    HI Radoslaw,

    I will ask my team again is it possible to patch the plugin on your side because it needs to  change a lot of addon files which is not recommended if it is not an regular update of the plugin.

    If not unfortunately you will need to wait for the next update of the add on which we are currently testing and hopefully it will be released soon.

    Sorry for any inconvenience and thank you for understanding.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Thank you Bogdan. For the time being I disabled Powerful Filters for wpDataTables.

  •  3
    spektacle replied

    I'm also having issues when the cascade option is 'on'. Any ideas when the next update is coming?

  •  455
    Bogdan replied

    HI spektacle,

    I can not tell you precisely when it will be out but we are on testing stage still. It is very time consuming because the addon needs to be coordinated with all of the features ( like foreign keys, predefined values etc) with the main plugin.

    As for the select boxes we developed some major changes so this issue will not happen again.

    Sorry for any inconvenience and thank you for understanding.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  3
    spektacle replied

    Hi there - thanks for getting back. Good to see you that you're in the testing phase but...should this plugin even be for sale on Codecanyon if it's not working? I purchased it with the expectation that I'd be able to utilze the cascading menus. 

  •  455
    Bogdan replied

    Hi spektacle,

    Sorry for any inconvenience.

    The Powerful filters add on is our latest release and unfortunately there are some minor bugs that we are working on fixing it with the newest version of our  plugin ( because there was some major changes for the select boxes).
    Because of that changes I can not just patch the plugins and unfortunately the best way to avoid any issues is to wait for the release.

    Thank you for understanding.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  3
    spektacle replied

    Yup understandable - better to have it right than buggy. Looking forward to it!

  •  3
    spektacle replied

    Any updates on this by chance?

  •  455
    Bogdan replied

    HI spektacle,

    The newest versions are coming by the end of this week and hopefully everything will work fine.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  3
    spektacle replied

    Nice looking forward!

  •  2
    radoslawoska replied

    Hi, after upgrading the plugin to 2.2 version the issue persists. Should I wait for a new version of Powerful Filters for wpDataTables?

  •  455
    Bogdan replied

    Hi 

    The update for the Add-ons is coming soon.

    Today there was a upadate for main plugin and Report builder Add-on.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  3
    spektacle replied

    Sorry to be a pain but is it coming soon?

  •  455
    Bogdan replied

    HI spektacle,

    We are waiting for Envato approval, the new version is sent to them.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  3
    spektacle replied

    Nice - I'm sure the wait wil be well worth it!

  •  2
    radoslawoska replied

    Hi. Today I updated the add-on of the plugin. But still cascade does not work.

    When I tick for example Hindi Transcript  Draft then I see all  types ('type' column).

    Also 'show search filters button' does not work, see:

  •  455
    Bogdan replied

    HI Radoslaw,

    Can you please tell me which version of our main plugin do you use. Is it 2.2.1


    I can not login with the old credentials so can you please provide me a new one just check Private Reply so nobody can see them except us.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Hi, yes, 2.2.1

    old password should work now

  •  455
    Bogdan replied

    Hi Radoslaw,

    Strange, I can not reproduce this issue as you can see from my attachments. 

    Can you please clear your browser cache and tell me the result.

    Best regards.

    Attached files:  Screen Shot 2018-06-05 at 11.04.09 AM.png
      Screen Shot 2018-06-05 at 11.04.04 AM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    it works for country, city, type but it does not work for: Hindi Transcript, English Transcript

  •  455
    Bogdan replied

    Hi Radoslaw,

    I think I might find where the issue is.

    Can you please tell me how did you updated the Add-on?

    Because as I can see there are 2 add-on versions in the WordPress plugins dashboard ( attachment) which can be the reason why some of the filters are not working.

    Best regards.

    Attached files:  Screen Shot 2018-06-05 at 12.39.44 PM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    I deactivated the old add on and uploaded the new version. Please delete the old one if it causes the problems 

  •  455
    Bogdan replied

    Hi Radoslaw,

    Our support policy does not allows us to delete the plugins.

    Can you please follow this steps so you can properly update the plugin:

    Please take a look at our documentation where you can see how you can successfully update the plugin.

    You can follow this guide :

    1.) Download zip from this link ( you already have the newest version of Powerful filters so you can skip this) 

    2.) Use FTP to open /yourwordpressfolder/wp-content/plugins

    3.) Delete existing wpdatatables folder.

    4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)

    5.)  Go to WP-admin panel, open Plugins section.

    6.) Deactivate wpDataTables, and then activate it again.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    thank you, I deleted both add-ons and uploaded new version again, but the issue is still there

  •  455
    Bogdan replied

    Hi Radoslaw,

    Strange, if you go filter by filter everything seems to be fine ( attachment) 

    But if you first choose for example English Transcript and then France for country the city will not be cascade filtered.

    I just tested out on my table from your file and everything seems to work fine.

    It looks like some other plugin is causing this issue. I will investigate further.

    Best regards.

    Attached files:  Screen Shot 2018-06-05 at 2.36.43 PM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  455
    Bogdan replied

    Hi Radoslaw,

    I think i might know where the issue is,

    can you please tell me do you know from which plugin does this second icon in the select box appears ( attachment) 

    Best regards.

    Attached files:  Screen Shot 2018-06-05 at 3.07.08 PM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    If I remember correctly the icon appeared when I upgraded bootstrap to 4.1.1 version

    my header looks like this:

    link

  •  455
    Bogdan replied

    Hi Radoslaw,

    When I go to the link below I can not see anything ( attachment) 

    Also the selectboxes, tooltips etc will not work with the bootstrap 4+ versions, so can you please tell me is it possible to downgrade the bootstrap version.

    Best regards.

    Attached files:  Screen Shot 2018-06-06 at 2.04.21 PM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    Hi Bogdan, the link points to 4.1.1 version:

    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" integrity="sha384-WskhaSGFgHYWDcbwN70/dfYBj47jz9qbsMId/iRN3ewGhXQFZCSftd1LZCfmhktB" crossorigin="anonymous">
    

    I temporarily downgraded to 3.3.7 but the issue is still there. 

  •  455
    Bogdan replied

    Hi Radoslaw,

    Very strange.

    I just created wpdatatables support on your site from the table r2_posts_agreg_v2 and as I can see when selecting first English translation and then other filters everything is working fine.

    So can you please tell me the difference between 

    select * from _talks

    and 

    SELECT * FROM r2_posts_agreg_v2

    tables. I am assuming that there is a difference between that tables.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied

    yes there is a difference

    _talks is a view:

    mysql> show create view _talks\G
    *************************** 1. row ***************************
                    View: _talks
             Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `_talks` AS select `e`.`pid` AS `ID`,date_format(`e`.`date`,get_format(DATE, 'iso')) AS `date`,concat('/?p=',`e`.`pid`,'||',`e`.`title`) AS `title`,`e`.`country` AS `country`,`e`.`city` AS `city`,`e`.`place` AS `place`,`e`.`transcripts_en` AS `transcript EN`,`h`.`transcripts_hi` AS `transcript HI`,`m`.`transcripts_mr` AS `transcript MR`,`e`.`translations_h` AS `translation from HI`,`e`.`translations_m` AS `translation from MR`,`e`.`audio` AS `audio`,`e`.`video` AS `video`,`e`.`dp` AS `DP`,`e`.`type` AS `type`,`e`.`language` AS `language`,`e`.`puja` AS `puja`,round((`e`.`duration` / 60),0) AS `duration`,if((`e`.`thumb` <> 'CaqTQDu-ofs'),concat(`__thumb`(`e`.`thumb`),'||',`__ytlnk`(`e`.`thumb`)),`__thumb`(`e`.`thumb`)) AS `thumb` from ((`r2_posts_agreg_v2` `e` left join `r2_posts_agreg_mr_v2` `m` on((`m`.`pid_en` = `e`.`pid`))) left join `r2_posts_agreg_hi_v2` `h` on((`h`.`pid_en` = `e`.`pid`))) where ((`e`.`eventType` = 'Nirmala') and (`e`.`transcripts_en` <> 'NOT needed'))
    character_set_client: utf8
    collation_connection: utf8_general_ci

    mysql> SELECT * FROM _talks limit 1\G
    *************************** 1. row ***************************
                     ID: 5
                   date: 1991-08-04
                  title: /?p=5||Shri Buddha Puja, You must become desireless
                country: Belgium
                   city: Deinze
                  place: Brielpoort Deinze
          transcript EN: Draft, In Progress
          transcript HI:
          transcript MR: NULL
    translation from HI:
    translation from MR:
                  audio: Y
                  video: Y
                     DP: Y
                   type: Buddha
               language: English
                   puja: Y
               duration: 55
                  thumb:


     

    and this is a table

    mysql> desc r2_posts_agreg_v2;
    +----------------------------+--------------------------------------------+------+-----+---------+-------+
    | Field                      | Type                                       | Null | Key | Default | Extra |
    +----------------------------+--------------------------------------------+------+-----+---------+-------+
    | pid                        | bigint(20) unsigned                        | NO   | PRI | NULL    |       |
    | date                       | datetime                                   | YES  |     | NULL    |       |
    | title                      | text                                       | YES  |     | NULL    |       |
    | place                      | varchar(255)                               | YES  |     | NULL    |       |
    | city                       | varchar(255)                               | YES  |     | NULL    |       |
    | country                    | varchar(255)                               | YES  |     | NULL    |       |
    | dp                         | enum('Y','N')                              | YES  |     | N       |       |
    | transcripts_en             | varchar(180)                               | YES  |     | NULL    |       |
    | translations_h             | varchar(180)                               | YES  |     | NULL    |       |
    | translations_m             | varchar(180)                               | YES  |     | NULL    |       |
    | audio                      | enum('Y','N')                              | YES  |     | N       |       |
    | video                      | enum('Y','N')                              | YES  |     | N       |       |
    | type                       | varchar(50)                                | YES  |     | NULL    |       |
    | language                   | varchar(23)                                | YES  |     | NULL    |       |
    | transcriber_en             | text                                       | YES  |     | NULL    |       |
    | transcriber_en_handed_date | int(11)                                    | YES  |     | NULL    |       |
    | translator_mr              | text                                       | YES  |     | NULL    |       |
    | translator_mr_handed_date  | int(11)                                    | YES  |     | NULL    |       |
    | translator_hi              | text                                       | YES  |     | NULL    |       |
    | translator_hi_handed_date  | int(11)                                    | YES  |     | NULL    |       |
    | eventType                  | enum('Nirmala','Yogi','Desired','Unknown') | YES  |     | Unknown |       |
    | puja                       | enum('Y','N')                              | YES  |     | N       |       |
    | thumb                      | char(11)                                   | YES  |     | NULL    |       |
    | duration                   | smallint(6)                                | YES  |     | NULL    |       |
    +----------------------------+--------------------------------------------+------+-----+---------+-------+

  •  455
    Bogdan replied

    Hi Radoslaw,

    Unfortunately I can not create a VIEW from the information below ( attachments) 

    Can you please correct me if I am missing something.

    Best regards.

    Attached files:  Screen Shot 2018-06-08 at 4.11.38 PM.png
      Screen Shot 2018-06-08 at 4.11.11 PM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •  2
    radoslawoska replied
    mysql> show create function __thumb\G
    *************************** 1. row ***************************
                Function: __thumb
                sql_mode: NO_ENGINE_SUBSTITUTION
         Create Function: CREATE DEFINER=`root`@`%` FUNCTION `__thumb`(s char(52)) RETURNS char(52) CHARSET utf8
    return concat('https://img.youtube.com/vi/',s,'/mqdefault.jpg')
    character_set_client: utf8
    collation_connection: utf8_general_ci
      Database Collation: utf8_general_ci
  •  455
    Bogdan replied

    HI Radoslaw,

    Sorry this way is very inconvenient to debug, so can you please send me dump of your database so we can debug this issue.

    Probably this is happening because you have custom functions in the vide and because of that cascade filtering get confused in this particular case.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   radoslawoska replied privately
  •   Milan replied privately