Division by zero error in wpdatatables plugin admin

having no answer I tried again after reinstalling wordpress with a blank database and nothing helps this plugin does not work … there when I want to import a file (either and xls, an xlsx or a csv) I have the hourglass for tens of minutes then a message which tells me that the page does not respond … I of course modified the wp-config with this value define ('WP_MAX_MEMORY_LIMIT', ' 512M ');

I tested a lot of plugins on this server and a priori everything works well…
but i really need to run wpdatatables … thanks for your help

nobody can help me? please

Hi Souscaf,
Sorry for inconvenience,

We have some National holiday in our country which cause not working days from 14feb-18feb.

Can you please provide us that Excel file, so we can investigate the issue? If you have sensitive data then please provide us file with some dummy data with which you have this issue, so we can test it?

Best regards.

Hi,

no problem

the xls file

thank

Hi Souscaf,

We check your file, and we notice that you have over 65 thousands rows which is overwhelmed for creating tables from Excel file. This table will not be stable with this option. You are getting errors because your first columns starts with numbers and then after some thousands rows there are only strings and wpdatatables try to assume what your column have based on first entries and because of that all strings which will be treated as null. When you have Excel file larger than 5000 rows, the page load and generation time will be slow and even it will break the page.

There is a solution for you but with our premium version with which you will use third option in table wizard and import that Excel file from which will be created table in database. Like this you will have server-side tables and loading of the table will be very fast. Please note that even with the premium version you will not be able to show all data on the page at once.

Best regards.

Hi,

thank a lot four your replie

I will therefore install the premium version and go through mysql … however I did not understand the last sentence of your answer: “Please note that even with the premium version you will not be able to show all data on the page at once. ” (my level of English is pitiful) can you explain it to me?

thank

Hi Souscaf,

You are welcome.

In wpDataTables you have option how many rows you will show on table load and rest of it users will access over pagination buttons. By default, this option is set to 10, but you also have option to set to ALL which means that all your data(all 65000 rows of data) will be loaded on page which can cause breaking your page.

Best regards.

ha ok thank you it’s clearer but I was planning to use pagination and not “all”;)

Hi Souscaf,

You are welcome,

Then it will be all fine.