Memory error between WordPress and MySQL when changing the data. WordPress indicates saving, but the new value will not be saved in Tabele. not in MySQL either.
Yes there is a limit on Mysql side that have limit where you can have a maximum row size of 65,535 bytes and size for sting columns is set to VARCHAR( 255),selectboxes are set to default on VARCHAR( 2000)... All default settings for column type size you can find in function defineColumnProperties which you can find in file wp-content/plugins/wpdatatables/source/class.constructor.php around line 95. There you can reduce this sizes and then try to save a table.
We double-checked all our data, everywhere we are not exceed limits (nor for the separate fields, niether for whole row - our rows are 250-400 symbols maximum)
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 provide me table id where you have this issue so I can investigate.
Please note that standard item support (as defined by Envato's definition of support) does not include:
Customization services;
Installation services;
Writing MySQL queries;
Writing advanced CSS;
Resolving and debugging third party software and hardware issues;
Preparing files and tables;
Skype, Teamviewer calls or etc.
Support with such requests can be provided on a paid basis.
Can you take a screencast of this issue so we can see it? You can turn on Private replay so nobody can see it except us.
Do you have maybe in cell in one column more then 255 characters?
No, there are no more than 255 characters in a column!
There are about 2958 records, each with 10 columns.
Makes 29580 dates.
The plugin description can handle up to 3,000,000 - 5,000,000 data.
SQL Query is: SELECT * FROM `mssql` Database is properly set up in phpMyAdmin. The query took 0.0000 seconds in phpMyAdmin.
I hired an extra system administrator for the job (Windows Server - database linkages with phpMyAdmin). He has over 20 years of professional experience and is at a loss where the problem lies ..
First you let me wait 1.5 Days.
Without even looking at where the problem lies?
Here is a video with the problem:
such an error must also be covered by Support from Envato (codecanyon.net). Plugin is properly installed. phpMyAdmin also running smoothly. It is system error of the plugin.
Previous post about standard item support was meant for Teamviewer calls and issue that you have is covered with standard item support so we will help you.
As you can see on support page on Envato "This author's response time can be up to 5 business days."
Yes we can see the issue, but we are not sure what cause the issue until we investigate.Can you please export that table from database and send me so we can investigate in our local environment?
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
We check your table and we found out that you don't have unique id column for editing. Can you please add one more column in database that will be for example row_id and set it to AUTO_INCREMENT and then set it in ID column for editing on Editing tab in table settings.
This column MUST be a unique auto-increment integer in table in database so insert/edit/delete would work correctly! wpDataTables will guess the correct column if it is called.
Memory error between WordPress and MySQL when changing the data. WordPress indicates saving, but the new value will not be saved in Tabele. not in MySQL either.
Where is the problem?
Hi AAARob,
Thank you for yogur purchase.
Yes there is a limit on Mysql side that have limit where you can have a maximum row size of 65,535 bytes and size for sting columns is set to VARCHAR( 255),selectboxes are set to default on VARCHAR( 2000)... All default settings for column type size you can find in function defineColumnProperties which you can find in file wp-content/plugins/wpdatatables/source/class.constructor.php around line 95. There you can reduce this sizes and then try to save a table.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
We double-checked all our data, everywhere we are not exceed limits (nor for the separate fields, niether for whole row - our rows are 250-400 symbols maximum)
HI AAARob,
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 provide me table id where you have this issue so I can investigate.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
HI AAARob,
Please note that standard item support (as defined by Envato's definition of support) does not include:
Customization services; Installation services; Writing MySQL queries; Writing advanced CSS; Resolving and debugging third party software and hardware issues; Preparing files and tables; Skype, Teamviewer calls or etc. Support with such requests can be provided on a paid basis.
Can you take a screencast of this issue so we can see it? You can turn on Private replay so nobody can see it except us.
Do you have maybe in cell in one column more then 255 characters?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
No, there are no more than 255 characters in a column!
There are about 2958 records, each with 10 columns.
Makes 29580 dates.
The plugin description can handle up to 3,000,000 - 5,000,000 data.
SQL Query is: SELECT * FROM `mssql`
Database is properly set up in phpMyAdmin.
The query took 0.0000 seconds in phpMyAdmin.
I hired an extra system administrator for the job (Windows Server - database linkages with phpMyAdmin).
He has over 20 years of professional experience and is at a loss where the problem lies ..
First you let me wait 1.5 Days.
Without even looking at where the problem lies?
Here is a video with the problem:
such an error must also be covered by Support from Envato (codecanyon.net). Plugin is properly installed. phpMyAdmin also running smoothly.
It is system error of the plugin.
System configuration is correct!
Hi AAARob,
Sorry for misunderstanding,
Previous post about standard item support was meant for Teamviewer calls and issue that you have is covered with standard item support so we will help you.
As you can see on support page on Envato "This author's response time can be up to 5 business days."
Yes we can see the issue, but we are not sure what cause the issue until we investigate.Can you please export that table from database and send me so we can investigate in our local environment?
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi AAARob,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
We check your table and we found out that you don't have unique id column for editing. Can you please add one more column in database that will be for example row_id and set it to AUTO_INCREMENT and then set it in ID column for editing on Editing tab in table settings.
This column MUST be a unique auto-increment integer in table in database so insert/edit/delete would work correctly! wpDataTables will guess the correct column if it is called.
Like this editing will work fine.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables