I have configured a table based on a MSSQL table, updated column display and many items without issue.
Then, I tried to configure the edition of table, and for a parameter, I select the "values based on an existing table" to use only values already present in the table…. Seems it was not a good idea, after save of the table, I have an error message "Fatal error: Allowed memory size exhausted". Looks like a recursive request.
Is there a solution to undo the last change I have done? or to correct it? Table is no more accessible, each time I try to view or edit it, I have error message:
"Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8192 bytes) in D:xampphtdocswordpresswp-contentpluginswpdatatablessourceclass.wpdatatable.php on line 2653
There has been a critical error on your website. Please check your site admin email inbox for instructions."
It looks like there's something eating up your memory, since you have 512MB of memory on the website. It could be that the amount of data in the table caused this, but it shouldn't.
Anyway, to alter this, you would need to go through the database. In table "wp_wpdatatables_columns", in the row of a column you applied this change to, look for the column "possible_values". Delete that cell (leave it blank), and edit the last column for that row "advanced_settings". Set the last option in there to this:
"possibleValuesType":"read"
If you're not sure how to do this, please provide me the ID of that table, and to which column you applied this rule.
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.
Yes! Great, it works with editing the table with MySQL phpmyadmin. I have identified the line in error, then copy and compare with line from another parameter, then paste a correct value and it solved the issue, I can now access to everything.
I was looking for an "undo" button, but this solution is better.
Hello,
I have configured a table based on a MSSQL table, updated column display and many items without issue.
Then, I tried to configure the edition of table, and for a parameter, I select the "values based on an existing table" to use only values already present in the table…. Seems it was not a good idea, after save of the table, I have an error message "Fatal error: Allowed memory size exhausted". Looks like a recursive request.
Is there a solution to undo the last change I have done? or to correct it? Table is no more accessible, each time I try to view or edit it, I have error message:
"Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8192 bytes) in D:xampphtdocswordpresswp-contentpluginswpdatatablessourceclass.wpdatatable.php on line 2653
There has been a critical error on your website. Please check your site admin email inbox for instructions."
Hello Jerome
It looks like there's something eating up your memory, since you have 512MB of memory on the website. It could be that the amount of data in the table caused this, but it shouldn't.
Anyway, to alter this, you would need to go through the database. In table "wp_wpdatatables_columns", in the row of a column you applied this change to, look for the column "possible_values". Delete that cell (leave it blank), and edit the last column for that row "advanced_settings". Set the last option in there to this:
"possibleValuesType":"read"
If you're not sure how to do this, please provide me the ID of that table, and to which column you applied this rule.
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.
Kind Regards,
Aleksandar Vuković
[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
Hello Aleksandar,
Yes! Great, it works with editing the table with MySQL phpmyadmin. I have identified the line in error, then copy and compare with line from another parameter, then paste a correct value and it solved the issue, I can now access to everything.
I was looking for an "undo" button, but this solution is better.
Thanks for your help.
You're welcome Jerome
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[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