yes that is the dev console output, the error occurs when trying to generetate a new datable from wordpress mysql query - it sinply wont allow me to so - i get to screen where im supposed to pick the different cpts and custom meta, i finish that step and try to press the edit as excel editor or standrad editor - it simply wont generetabe the table (it does give me a preview of the first 5 rows - so that works, but it doesnt genereta the table when i try to create it - ill be happy give u accsess to try an see the werror from the backend - i mde an admin user just for u - if u can just create a table with all fileds of ad_listing from the admin -- i tihnk i can take and duplica the table from there - the credentials for login are - https://www.or-nadlan.com/wp-admin/
user name : datatable
password : datatable123
what i need is to Generate a query to WordPress database.
at firt i though it be related to the fact im using cloudflare so perhaps it isnt routingg requests proprely bu i tried on a sepreate site without clodflare - same issues...
hi, sry for taking a few days to come back - i checked with my hosting provider and inddeed they confirmed that mod_security is turned off. also i do not have any security plugins instaleed - what can i do? if i was to use another table to display the results - generating table by select from *table_name* works great but i do not know if it is scalable or not- if yes then i guess there is no issue as i was able to create a seperate table using my csv - just a quick question how would i go aboutimporting into that table from within wordpress - or would i need to use php myadmin to add records each time?
In regards to a site on your hosting account, the cause of the 404 error is usually due to a mod_security rule on the server. Mod_security is a security module in the Apache web server that is enabled by default on all hosting accounts. Apache web server, scans for violations of the rules it has set. If an action occurs that violates one of these rules, the server will throw a 404 or 406 error.
1. If you’re receiving this message when trying to save wpDataTable based on MySQL query from your WP Admin, it means your hosting provider is restricting access to some of WordPress’ native functionality. To solve it, contact your hosting provider to ask them to remove this restriction.
2. Adding the following to the top of your .htaccess file. (This should be a temporary measure. You could try it just to see if it will work, but you probably don’t want to leave it.) <IfModule mod_security.c> SecFilterEngine OffSec FilterScanPOST Off </IfModule>
3. Backup your .htaccess file if you have one in the public_html directory. Open the .htaccess file with any text editor and observe the lines between the “# BEGIN WordPress” and “# END WordPress” tags. Make sure the lines look somewhat like the following. If not then update the file with the following content and upload it to the ‘public_html’ directory. # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> # END WordPress
Ok so now as I can see from your attachment it is server error 500.
The
500 Internal Server Error is a server-side error, meaning the problem
probably isn't with your computer, Internet connection or plug ins
but instead is a problem with the web site's server.
Can
you please investigate your server log and see if there is some
errors.
this is the out put i get from a debug plugin i used to get the plugin - i tired in the mean time to install it on a free host too - same issue with latest wordpress - same with my local xaamp installation -
hi i cant access cpanel at the moment as the support on hosting are doing maintance - they also looked into it and said it might be on their end so they will try to reset all settings to default - ill get back toyou in 12 hours - gotta leave home now so...
ok the site is online on a different domain now (hosting is still looking into the issue with my other domain since it isnt working there.. - i have moved it to or-nadlan.com
now it is working (except the wordpress connection - but works ok on remote qsql connectin - also i think loads much faster as it isnt using the same domain for quering?) all good for me but one error - cant proply use the expand /close botton...
<span class="responsiveExpander"></span>
i think maybe it is due to span class being replaced to md class in bootstrap? how do i fix it?
if you could please take a look at this - when user presses the main plus botton to view the other content in table in the domain or-nadlan.com, he cannoot close it but instead it just keep expanding more rows?
so if you look you'll see on main page it loads on top (takes a few seconds to load) then if you try to expand the table to see the inner - it works but doesnt close after...(it opens other rows instead?)
this is the error log - maybe will shorten your fix time?
12wdt.frontend.min.js?ver=2.3:459 Uncaught TypeError: Cannot read property 'indexOf' of undefined at wdtCheckConditionalFormatting (wdt.frontend.min.js?ver=2.3:459) at HTMLLIElement.<anonymous> (wdt.frontend.min.js?ver=2.3:332) at Function.each (jquery.js?ver=1.12.4:2) at a.fn.init.each (jquery.js?ver=1.12.4:2) at Object.showDetail (wdt.frontend.min.js?ver=2.3:332) at Object.ResponsiveDatatablesHelper.showRowDetail (wdt.frontend.min.js?ver=2.3:288) at HTMLSpanElement.ResponsiveDatatablesHelper.showRowDetailEventHandler (wdt.frontend.min.js?ver=2.3:284) at HTMLTableCellElement.dispatch (jquery.js?ver=1.12.4:3) at HTMLTableCellElement.r.handle (jquery.js?ver=1.12.4:3)
is there a way to download the previous version maybe(2.23?) i had it and as i remember correctly in the first few days most features worked but not on the last release? maybe if i just use the older version it could fix all my issues?
these are the errors i get -
load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4 POST https://www.or-nadlan.com/wp-admin/admin-ajax.php?_fs_blog_admin=true 404 ()
send @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
ajax @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
(anonymous) @ wdt.constructor.js?ver=2.2.3:570
dispatch @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
r.handle @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4 Uncaught TypeError: jQuery(...).autocomplete is not a function
at HTMLDocument.eval (eval at <anonymous> (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2), <anonymous>:1:5795)
at i (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2)
at Object.add [as done] (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2)
at a.fn.init.n.fn.ready (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2)
at eval (eval at <anonymous> (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2), <anonymous>:1:4941)
at eval (<anonymous>)
at load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
at Function.globalEval (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2)
at text script (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4)
at Xb (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4)
(anonymous) @ VM305:1
i @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
add @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
n.fn.ready @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
(anonymous) @ VM305:1
(anonymous) @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
globalEval @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
text script @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
Xb @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
y @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
c @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
send @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
ajax @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
n._evalUrl @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
Ha @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
append @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
(anonymous) @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
Y @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
html @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
error @ wdt.constructor.js?ver=2.2.3:588
i @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
fireWith @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:2
y @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
c @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
XMLHttpRequest.send (async)
send @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
ajax @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:4
(anonymous) @ wdt.constructor.js?ver=2.2.3:570
dispatch @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
r.handle @ load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,thickbox,underscore,shortcode,media-upload,moxiejs,plupload&ver=4.9.8:3
Hi pablorotem9,
Thank you for your purchase.
Can you please tell me when this error occurs, on some button click or something else.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
yes that is the dev console output, the error occurs when trying to generetate a new datable from wordpress mysql query - it sinply wont allow me to so - i get to screen where im supposed to pick the different cpts and custom meta, i finish that step and try to press the edit as excel editor or standrad editor - it simply wont generetabe the table (it does give me a preview of the first 5 rows - so that works, but it doesnt genereta the table when i try to create it - ill be happy give u accsess to try an see the werror from the backend - i mde an admin user just for u - if u can just create a table with all fileds of ad_listing from the admin -- i tihnk i can take and duplica the table from there - the credentials for login are - https://www.or-nadlan.com/wp-admin/
user name : datatable
password : datatable123
what i need is to Generate a query to WordPress database.
at firt i though it be related to the fact im using cloudflare so perhaps it isnt routingg requests proprely bu i tried on a sepreate site without clodflare - same issues...
Hi pablorotem9,
Ok this is the error that I can see when i try to make a table from some your data using 4th option in table wizard ( attachment)
This can be related to some security on your site.
Can you please tell me do you maybe have mod_security installed and enabled on your server, or some plugin that can be related to security.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
hi, sry for taking a few days to come back - i checked with my hosting provider and inddeed they confirmed that mod_security is turned off. also i do not have any security plugins instaleed - what can i do? if i was to use another table to display the results - generating table by select from *table_name* works great but i do not know if it is scalable or not- if yes then i guess there is no issue as i was able to create a seperate table using my csv - just a quick question how would i go aboutimporting into that table from within wordpress - or would i need to use php myadmin to add records each time?
Hi pablorotem9,
In regards to a site on your hosting account, the cause of the 404 error is usually due to a mod_security rule on the server.
Mod_security is a security module in the Apache web server that is enabled by default on all hosting accounts.
Apache web server, scans for violations of the rules it has set.
If an action occurs that violates one of these rules, the server will throw a 404 or 406 error.
1. If you’re receiving this message when trying to save wpDataTable based on MySQL query from your WP Admin,
it means your hosting provider is restricting access to some of WordPress’ native functionality.
To solve it, contact your hosting provider to ask them to remove this restriction.
2. Adding the following to the top of your .htaccess file. (This should be a temporary measure.
You could try it just to see if it will work, but you probably don’t want to leave it.)
<IfModule mod_security.c>
SecFilterEngine OffSec
FilterScanPOST Off
</IfModule>
3. Backup your .htaccess file if you have one in the public_html directory.
Open the .htaccess file with any text editor and observe the lines between the “# BEGIN WordPress” and “# END WordPress” tags.
Make sure the lines look somewhat like the following. If not then update the file with the following content and upload it to the ‘public_html’ directory.
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi pablorotem9,
Ok so now as I can see from your attachment it is server error 500.
The 500 Internal Server Error is a server-side error, meaning the problem probably isn't with your computer, Internet connection or plug ins but instead is a problem with the web site's server.
Can you please investigate your server log and see if there is some errors.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
this is the out put i get from a debug plugin i used to get the plugin - i tired in the mean time to install it on a free host too - same issue with latest wordpress - same with my local xaamp installation -
>td >10>th >
init>td >100muplugins_loadedregistered_taxonomyregistered_post_typeplugins_loaded+Toggle button
wp_maybe_load_widgets()+Toggle button
wp_maybe_load_embeds()+Toggle button
_wp_customize_include()+Toggle button
QueryMonitor->action_plugins_loaded()+Toggle button
FEDT_Page_Loader::get_instance()+Toggle button
FED_Page_Template::get_instance()+Toggle button
load_i18n()+Toggle button
wdtLoadTextdomain()wp_roles_initauth_cookie_valid+Toggle button
rest_cookie_collect_status()set_current_user+Toggle button
kses_init()load_textdomainsanitize_comment_cookies+Toggle button
sanitize_comment_cookies()setup_themeunload_textdomainafter_setup_theme+Toggle button
twentyseventeen_setup()Hi pablorotem9,
Can you please send me the error log in some file so I can open it on my desktop.
Because when I open here in Ticksy it causes the page to crash.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
hi i cant access cpanel at the moment as the support on hosting are doing maintance - they also looked into it and said it might be on their end so they will try to reset all settings to default - ill get back toyou in 12 hours - gotta leave home now so...
Hi pablorotem9,
No problem. let me know when the site is up again.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
ok the site is online on a different domain now (hosting is still looking into the issue with my other domain since it isnt working there.. - i have moved it to or-nadlan.com
now it is working (except the wordpress connection - but works ok on remote qsql connectin - also i think loads much faster as it isnt using the same domain for quering?) all good for me but one error - cant proply use the expand /close botton...
the full domain address is https://www.or-nadlan.com/
so if you look you'll see on main page it loads on top (takes a few seconds to load) then if you try to expand the table to see the inner - it works but doesnt close after...(it opens other rows instead?)
also just a question - if i was to buy you plugin for gravity forms - can it add data to the table even if the table is on a seperetate db connection?
this is the error log - maybe will shorten your fix time?
12wdt.frontend.min.js?ver=2.3:459 Uncaught TypeError: Cannot read property 'indexOf' of undefined
at wdtCheckConditionalFormatting (wdt.frontend.min.js?ver=2.3:459)
at HTMLLIElement.<anonymous> (wdt.frontend.min.js?ver=2.3:332)
at Function.each (jquery.js?ver=1.12.4:2)
at a.fn.init.each (jquery.js?ver=1.12.4:2)
at Object.showDetail (wdt.frontend.min.js?ver=2.3:332)
at Object.ResponsiveDatatablesHelper.showRowDetail (wdt.frontend.min.js?ver=2.3:288)
at HTMLSpanElement.ResponsiveDatatablesHelper.showRowDetailEventHandler (wdt.frontend.min.js?ver=2.3:284)
at HTMLTableCellElement.dispatch (jquery.js?ver=1.12.4:3)
at HTMLTableCellElement.r.handle (jquery.js?ver=1.12.4:3)
is there any way to make entire row clickable to expand and close? something i can mabe add to custom css /js functions?
is there a way to download the previous version maybe(2.23?) i had it and as i remember correctly in the first few days most features worked but not on the last release? maybe if i just use the older version it could fix all my issues?
Hi pablorotem9,
Unfortunately it look like I can not login with the credentials below.
As for the clickable row you can take a look at our video from our documentation how you can hide columns on desktop.
I can send you any version that you would like the previous version from 2.3 is 2.2.3. If you want I can send you here.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables