In our project , we used wpDataTable as the frontend displaying data in our MySQL database. However, when we tested on a table, whose size is about 60MB in MySQL databtase, the wpDataTable fail to display on the frontend. This is the error code:
Error There was an error while trying to save the table! OK Warning: Unknown: POST Content-Length of 8780274 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Warning: Cannot modify header information - headers already sent in Unknown on line 0 0
I was wondering if you could explain the error? Also, I was wondering if you could provide us a solution to solve this problem. We need to display a 60MB size MySQL table in the frontend using wpDataTable.
Hi,
In our project , we used wpDataTable as the frontend displaying data in our MySQL database. However, when we tested on a table, whose size is about 60MB in MySQL databtase, the wpDataTable fail to display on the frontend. This is the error code:
Error
There was an error while trying to save the table! OK Warning: Unknown: POST Content-Length of 8780274 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Warning: Cannot modify header information - headers already sent in Unknown on line 0
0
I was wondering if you could explain the error? Also, I was wondering if you could provide us a solution to solve this problem. We need to display a 60MB size MySQL table in the frontend using wpDataTable.
Thanks,
Moon
HI Moon,
Thank you for your purchase.
8388608 bytes is 8M , which is the default limit in PHP.
Update your post_max_size in php.ini to a larger value.
The solution would be to go to your php.ini file and increase
upload_max_filesize = 1000M;
post_max_size = 1000M;
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