Mihkel Roomet

I resolved it by zipping all the files in wp-content/plugins/formidable in the old version of my site, then removing the plugin from the current version of my site, uploading the zip, then modifying the setting under Global Settings → Manage Styles → Assigned Style Templates for my page (didn’t matter which option I set it to, I just had to make a change and click “Update”; clearing cache didn’t seem to do anything).

I sent a direct email to your support email address, as the contact form wasn’t working for me. I do believe my WP Data Access is up to date, since it doesn’t seem possible to update it on the Plugins page and I have enabled automatic updates for it.

Well, that is strange. Whenever I add the “dom” option to advanced options, the page I had my table on just displays a WordPress message saying a critical error occurred on my site. Any idea why that could be? I did disable the Arrange option and I did try with multiple different parameters like the deafult “lfrtip”, your suggested “plrtip”, an empty string, and “lfiprtip”, which is what I was going for originally.

• This reply was modified 11 months, 1 week ago by Mihkel Roomet.
• This reply was modified 11 months, 1 week ago by Mihkel Roomet.

Hi Kim

It does help, I have been able to move the Summary and Pagination above the table, which is more what I want. But ideally these elements would also appear below the table, so there would be two instances of either of those elements present in the table. It doesn’t look like that’s possible, is it?

(also I will note that I did see the “Arrange” option, but wrongly assumed it was meant for arranging the buttons CSV, Excel, etc, because it was next to options that were meant only for configuring these buttons)

• This reply was modified 11 months, 2 weeks ago by Mihkel Roomet.
• This reply was modified 11 months, 2 weeks ago by Mihkel Roomet.

I wasn’t aware there was a WHERE Clause option?? it’s not going to do what I hoped for, but it could be useful someday.

Thanks for the clear explanation. It’s a bit disappointing there is no such functionality as I described, but it’s not a huge deal for me and I can work around it.

I sent a private message via the contact form since unfortunately no such page is fully public atm

Thank you so much! I’ll for sure check out Data Forms and knowing about the dtr-modal-content class seems useful as well.

Code: BMI-RJ94GPa3-30312

I had edited the wrong wp-config.php file ?? Not sure if that helps, though, as my site is very small.

It now says “Max execution time (in seconds): 0” and “Memory limit (wp-config): 1024M”, is this correct? I added the following in wp-config.php (the correct one this time):

define('WP_MEMORY_LIMIT', '1024M');
set_time_limit(300);

It also got to 1% this time before getting into the infinite loop.

I’m not actually sure whether “disabling PHP CLI checking” means I should disable the option to disable it as shown in this picture that has been linked to everybody or if it means that we should enable the option to disable it, which, without the picture, I would have guessed was what was meant. I’ve tried both and it doesn’t seem to make a significant difference — leaving the option unchecked just prints the extra line “Looking for PHP CLI executable file.” at the start.

After following these instructions, most of which seem to be the answer to nearly every backup-making issue, I was able to see the “Backup in progress” window for longer and saw it going over an infinite loop at 0%:

[STEP] [2023-08-15 07:43:16] Looking for PHP CLI executable file.
[WARN] [2023-08-15 07:43:16] PHP CLI is disabled in your php.ini file, the process may be unstable.
[WARN] [2023-08-15 07:43:16] PHP CLI will not run due to user settings in plugin other options.
[STEP] [2023-08-15 07:43:16] Initializing backup...
[INFO] [2023-08-15 07:43:16] Backup & Migration version: 1.2.9
[INFO] [2023-08-15 07:43:16] Site which will be backed up: ***site_url***
[INFO] [2023-08-15 07:43:16] PHP Version: 8.2.8
[INFO] [2023-08-15 07:43:16] WP Version: 6.3
[INFO] [2023-08-15 07:43:16] MySQL Version: 8.0.34
[INFO] [2023-08-15 07:43:16] MySQL Max Length: 268435456
[INFO] [2023-08-15 07:43:16] Web server: Apache
[INFO] [2023-08-15 07:43:16] Max execution time (in seconds): 30
[INFO] [2023-08-15 07:43:16] Memory limit (server): 128M
[INFO] [2023-08-15 07:43:16] Memory limit (wp-config): 40M
[INFO] [2023-08-15 07:43:16] Memory limit (wp-config admin): 256M
[INFO] [2023-08-15 07:43:16] Max rows per query (this site): 2000
[INFO] [2023-08-15 07:43:16] Checking if backup dir is writable...
[INFO] [2023-08-15 07:43:16] Initializing custom error handler
[SUCCESS] [2023-08-15 07:43:16] Yup it is writable...
[STEP] [2023-08-15 07:43:16] Scanning files...
[STEP] [2023-08-15 07:43:17] Checking free space, reserving...
[INFO] [2023-08-15 07:43:17] Requires at least 97108702 bytes. [92.61 MB]
[INFO] [2023-08-15 07:43:17] Disk free space function is not disabled - using it...
[INFO] [2023-08-15 07:43:17] Checking this path/partition: ***ABSPATH***/wp-content/***backup_path***/backups
[SUCCESS] [2023-08-15 07:43:17] There is 170,765.48 MB free. [166.76 GB]
[SUCCESS] [2023-08-15 07:43:17] Great! We have enough space.
[SUCCESS] [2023-08-15 07:43:17] Confirmed, there is more than enough space, checked: 97108702 bytes
[INFO] [2023-08-15 07:43:17] Scanning done - found 3970 files...
[SUCCESS] [2023-08-15 07:43:17] Backup initialized...
[STEP] [2023-08-15 07:43:17] Initializing archiving system...
[SUCCESS] [2023-08-15 07:43:17] Archive system initialized...
[STEP] [2023-08-15 07:43:17] Preparing map of files...
[SUCCESS] [2023-08-15 07:43:17] Files prepared.
[INFO] [2023-08-15 07:43:17] Starting compression process...
[STEP] [2023-08-15 07:43:17] Smart memory calculation...
[INFO] [2023-08-15 07:43:17] There is 384 MBs of memory to use
[INFO] [2023-08-15 07:43:17] WordPress memory limit: 256 MBs
[SUCCESS] [2023-08-15 07:43:17] Setting the safe limit to 86 MB
[INFO] [2023-08-15 07:43:17] Using PclZip module to create the backup
[INFO] [2023-08-15 07:43:17] Legacy setting: Using user browser as middleware for full capabilities
[INFO] [2023-08-15 07:43:17] Sending backup settings and identy to the browser
[SUCCESS] [2023-08-15 07:43:17] Background process initialized
[STEP] [2023-08-15 07:43:17] Starting database backup exporter
[STEP] [2023-08-15 07:43:17] Making database backup (using v3 engine, requires at least v1.2.2 to restore)
[INFO] [2023-08-15 07:43:17] Iterating database...
[INFO] [2023-08-15 07:43:17] Memory usage after initialization: 7.48 MB
[WARN] [2023-08-15 07:43:17] Database batching is disabled in options, consider to use this option if your database backup fails.
[INFO] [2023-08-15 07:43:17] Scan found 45 tables (4645 rows), estimated total size: 5.72 MB.
[INFO] [2023-08-15 07:43:17] Memory usage after getting table names: 7.50 MB 
[INFO] [2023-08-15 07:43:17] Getting table recipes...
[INFO] [2023-08-15 07:43:17] Table recipes have been exported.
[INFO] [2023-08-15 07:43:17] Memory usage after loading recipes: 7.54 MB 
[INFO] [2023-08-15 07:43:17] Saving recipes...
[WARN] [2023-08-15 07:43:17] Background process had some issues, more details printed to global logs.
[SUCCESS] [2023-08-15 07:43:17] Background process initialized
[STEP] [2023-08-15 07:43:17] Starting database backup exporter
...

So the 13 lines from “Background process initialized” to “Background process had some issues, more details printed to global logs.” would be the ones repeating over and over.

After 300 seconds it hicked up as expected.

• This reply was modified 1 year, 7 months ago by Mihkel Roomet.

Thanks for the encouragement, I do hope using CSS will be enough for me ??

How exactly would you write the same thing as in that example in Advanced Options? It’s not

"responsive": {
        "details": {
            "display": "DataTable.Responsive.display.modal()",
            "renderer": "DataTable.Responsive.renderer.tableAll()"
        }
    }

is it? For me that’s not working, at least. I suspect the syntax for the values of "display" and "renderer” needs to be different, but I don’t know what. I feel like I’ve tried all the options I could find from DataTables docs.

I managed to use CSS to achieve some of it, using the selector .wpda-child-value .my_custom_class, where my_custom_class is the class I’ve assigned to text in cells using Javascript. I’ve adjusted the image alignment and size and removed text truncation this way.

Thank you! I just happened to stumble upon a similar solution myself as you were writing this. Here’s my solution in case anyone looking for the same thing is interested:

Under Advanced Options I have the following line in every entry inside “columns”:

"render": "function(data, type, row, meta) { return truncateText(data); }"

Here’s the Javascript function I’m running on my page:

function truncateText(text) { return '<div class="my_custom_class"' + text + '</div>' }

And here’s the custom CSS I’m running:

.my_custom_class {
  overflow: hidden;
  display: -webkit-box;
  -webkit-line-clamp: 3;
  -webkit-box-orient: vertical;
}

The line clamp determines the amount of lines displayed.

Thanks for the reply!

As for adding “page” : “all” to “exportOptions” → “modifier” (to essentially make it export all rows not just the current page), which is the task that I was working on that led to this post, I found that simply disabling server side processing right above the Advanced Options did the trick (which is apparently the same as writing “serverSide”: false in Advanced Options). I guess when using client-side processing with paging enabled the rows not in view aren’t loaded in memory or something, so there is no way export them.

So for now, problem solved ?? thanks again (if you did manage to add the capability of listing all the default option set by the plugin though, that would still be awesome, I imagine that could help new users understand and get a grasp on the Advanced Options much quicker)

How would you do the opposite? I would like to differentiate between NULLs and empty strings as in my table a NULL value means that the value is unknown, whereas an empty string means that it is known that there is no value. I’ve noticed, however, that already in the Explorer the NULLs show up as empty cells, so when trying to add a function to “columns” → “render” option under Advanced Settings, the data that gets passed in is an empty string in both cases, so there seems to be no way to tell whether it was originally a NULL or “”.

Also, while on the topic of NULLs — I’ve enabled the search panes in my table and they nicely give me the option to view all rows with a NULL in a certain column, however when I click on one it will only display the rows that had empty strings in the respective column originally and keep playing the loading animation forever.

Wow, thank you so much! I understood all of it and got all the issues sorted ??

I do appreciate all the background information as well, especially on DataTables. I see they have lots of customization options which is lovely.