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?
Attached files: cascade.png
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.
Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!
Kind Regards,Bogdan Radusinovicbogdan@touchmesoft.net
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.
thank you Bogdan.
Hi Bogdan, any news on update?
We are preparing the latest update of the plugin butI can not tell you precisely the date when it will be available.
Dear Bogdan, any ETA for the update?
Dear Bogdan, I converted checkbox to multiselect as you suggested but still the issue persists.
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 .
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.
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
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.
Hi Bogdan, any luck with the patch?
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.
This happens when cascade is on.
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.
Thank you Bogdan. For the time being I disabled Powerful Filters for wpDataTables.
I'm also having issues when the cascade option is 'on'. Any ideas when the next update is coming?
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.
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.
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.
Yup understandable - better to have it right than buggy. Looking forward to it!
Any updates on this by chance?
The newest versions are coming by the end of this week and hopefully everything will work fine.
Nice looking forward!
Hi, after upgrading the plugin to 2.2 version the issue persists. Should I wait for a new version of Powerful Filters for wpDataTables?
The update for the Add-ons is coming soon.
Today there was a upadate for main plugin and Report builder Add-on.
Sorry to be a pain but is it coming soon?
We are waiting for Envato approval, the new version is sent to them.
Nice - I'm sure the wait wil be well worth it!
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:
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.
Hi, yes, 2.2.1
old password should work now
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.
Attached files: Screen Shot 2018-06-05 at 11.04.09 AM.png Screen Shot 2018-06-05 at 11.04.04 AM.png
it works for country, city, type but it does not work for: Hindi Transcript, English Transcript
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.
Attached files: Screen Shot 2018-06-05 at 12.39.44 PM.png
I deactivated the old add on and uploaded the new version. Please delete the old one if it causes the problems
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.
thank you, I deleted both add-ons and uploaded new version again, but the issue is still there
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.
Attached files: Screen Shot 2018-06-05 at 2.36.43 PM.png
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)
Attached files: Screen Shot 2018-06-05 at 3.07.08 PM.png
If I remember correctly the icon appeared when I upgraded bootstrap to 4.1.1 version
my header looks like this:
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.
Attached files: Screen Shot 2018-06-06 at 2.04.21 PM.png
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.
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
SELECT * FROM r2_posts_agreg_v2
tables. I am assuming that there is a difference between that tables.
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: utf8collation_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: NULLtranslation 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 | |+----------------------------+--------------------------------------------+------+-----+---------+-------+
Unfortunately I can not create a VIEW from the information below ( attachments)
Can you please correct me if I am missing something.
Attached files: Screen Shot 2018-06-08 at 4.11.38 PM.png Screen Shot 2018-06-08 at 4.11.11 PM.png
mysql> show create function __thumb\G
*************************** 1. row ***************************
Create Function: CREATE DEFINER=`root`@`%` FUNCTION `__thumb`(s char(52)) RETURNS char(52) CHARSET utf8
Database Collation: utf8_general_ci
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.