I seem to be having a problem loading a table with about 30K records. This happens when using a sql statement of "Select * from tablename". My page times out and a 404 page not found error is displayed. If I use a select statement limiting the results to about 3K records all is well.
My DB has an ID set as Primary and Auto Increment
Is this correct?
Any suggestions on how to load them all?
Thanks,
Frank
Additional info:
Error message
Warning: number_format() expects parameter 1 to be double, string given in /home/swflcom/public_html/wp-content/plugins/wpdatatables/source/class.wpdatacolumn.php on line 806
I successfully created a table from your file ( attachment)
And as I can see the loading speed is very fast.
Maybe the issue is with your server performance configuration.
Can you 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.
It looks like I am able to use this data by creating a table from a query, using the excel view, and loading each field individually and saving each time. This has been successful. Is there a way to change the view back to the standard view from the excel view? I'd like to see if that crashes the table. If it does I'll be happy to give you a login so you can take a look.
Looks like i answered too quickly. The table has reverted from the Excel view to the standard table view. Now when clicking the save button the page shows a 404 error - not found. Seems to work in Excel view and not the other. Will send you a login.
Ok, so the issue might be in the mod_security then.
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 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
My suggestion is to contact your hosting provider and ask them to disable the mod_security.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
Thanks.
Hi all
I seem to be having a problem loading a table with about 30K records. This happens when using a sql statement of "Select * from tablename". My page times out and a 404 page not found error is displayed. If I use a select statement limiting the results to about 3K records all is well.
My DB has an ID set as Primary and Auto Increment
Is this correct?
Any suggestions on how to load them all?
Thanks,
Frank
Additional info:
Error message
Warning: number_format() expects parameter 1 to be double, string given in /home/swflcom/public_html/wp-content/plugins/wpdatatables/source/class.wpdatacolumn.php on line 806
HI Frank,
Thank you for your purchase.
We have customers that are displaying 1 million of entries or more so this can be that there is some limitation on your side.
Can you please send me the file ( sql or zipped ) so I can upload it to my database and see what may cause the issue.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Bogdan
Just making sure you received my sql file?
Frank
HI Frank,
Can you just tell me where did you send me the sql file so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Sent to the email address below your signature.
Sent again. It's about 10MB.
[email protected]
HI Frank,
I successfully created a table from your file ( attachment)
And as I can see the loading speed is very fast.
Maybe the issue is with your server performance configuration.
Can you 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.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Bogdan
It looks like I am able to use this data by creating a table from a query, using the excel view, and loading each field individually and saving each time. This has been successful. Is there a way to change the view back to the standard view from the excel view? I'd like to see if that crashes the table. If it does I'll be happy to give you a login so you can take a look.
Thanks,
Frank
Looks like i answered too quickly. The table has reverted from the Excel view to the standard table view. Now when clicking the save button the page shows a 404 error - not found. Seems to work in Excel view and not the other. Will send you a login.
Thanks,
Frank
HI Frank,
I can see the issue now.
I successfully created a table and when I try to made some changes ( for example turn on Scrollable option ) i get this error ( attachment)
Due to our experience with this image can you please tell me do you have mod_security installed on your server or some other security plugin.
As I can see you have WordFence so can you please deactivate that plugin and tell me the result.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, mod security is installed.
I disabled Wordfence and made a couple of changes to your table. Same result. No table found.
I set Wordfence to "Learning mode". Same result.
I removed "Extended Protection Mode" from Wordfence. Same result.
Is there a setting in Modsecurity that you know of that I can change to test this?
Any other ideas or suggestions??
Thanks for your help on this.
F.
Hi Frank,
Ok, so the issue might be in the mod_security then.
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 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
My suggestion is to contact your hosting provider and ask them to disable the mod_security.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
You were right. I turned off modsecurity in my Cpanel and the table now can be created and saved.
Wordfence is running in Learning Mode and it still saves. Life is good.
Thanks for your help!
Great plugin.
Frank
Hi Frank,
Glad to hear that.
The pleasure is mine, you are welcome.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Comment added - Thanks again.
Frank