rc169

Hello Kim,

Thanks for your message. I am currently trying to build an app with the App Builder, but there seem to be some problems. In the “Table Builder”, I have selected the columns from the selected table. When I clicked on the “Hooks” column heading, the timer icon rotated for a couple of minutes; after that everything from the window disappeared, leaving just the words “App Builder” in the top left corner.

The hosting then seemed to crash so that other sites on my account became unavailable for a few minutes. As far as I can tell, there were no problems with availability of the servers, so I am concerned about what exactly happened when the App Builder crashed. I have not yet tested the “Hooks” column – as far as I can see from the “tutorial” page ( Creating a Data Table App ), this is not essential.

Having created and saved the app, I can also see it in the browser – at least, the first two columns of each row. However, when I click on the symbol at the left hand end of a row (to see all columns of the record) then the app window disappears from the page. Can you advise what is wrong here?

Thanks in advance for your help.

Nigel

Hello Kim,

Thanks – yes, I do see the old Table Builder button, and it opens the correct page.

Going back to your first post on t his thread, I have again tested the use of the “edit” button for a single record in the new Data Explorer, but it still shows a blank window. I will therefore send a ticket, as per your suggestion.

Thank you.

Nigel

Hello Kim,

Thanks for your message. I have tried to enable the legacy tools, as you describe above. However, I received this error message:-

“There has been a critical error on this website. Please check your site admin email inbox for instructions. If you continue to have problems, please try the support forums.”

WordPress has provided an error message in the email, as follows:-

“In this case, WordPress caught an error with one of your plugins, WP Data Access.

First, visit your website (https://dev.bristol-re.co.uk/) and check for any visible issues. Next, visit the page where the error was caught (https://dev.bristol-re.co.uk/wp-admin/admin.php?page=wpda_navi) and check for any visible issues.”

The error message below:-

“When seeking help with this issue, you may be asked for some of the following information:
WordPress version 6.7.1
Active theme: Ephemeris (version 1.5.2)
Current plugin: WP Data Access (version 5.5.22)
PHP version 8.2.26 Error Details

An error of type E_ERROR was caused in line 24 of the file <website host>/wp-content/plugins/wp-data-access/WPDataAccess/Utilities/WPDA_Legacy_Tool_Visibility.php. Error message: Uncaught Error: Class “WPDataAccess\Premium\WPDAPRO_Dashboard\WPDAPRO_Dashboard” not found in /<website host>/wp-content/plugins/wp-data-access/WPDataAccess/Utilities/WPDA_Legacy_Tool_Visibility.php:24
Stack trace: 0 <website host>wp-content/plugins/wp-data-access/admin/class-wp-data-access-admin.php(964): WPDataAccess\Utilities\WPDA_Legacy_Tool_Visibility::get() 1 <website host>/wp-includes/class-wp-hook.php(324): WP_Data_Access_Admin->data_navi() 2 /<website host>/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() 3 <website host>/wp-includes/plugin.php(517): WP_Hook->do_action() 4 <website host>/wp-admin/admin.php(259): do_action() 5 {main}

thrown”

Please let me know if you need the exact URL of the website host.

Thanks in advance for your help.

Nigel

Thanks, Kim and Peter,

Now working correctly again!

Nigel (RC169)

Hi Kim,

Thanks for that information. In the “Advanced settings” page, I also found the command to show just one row in the upper table – which was the main issue in this case.

A couple more questions arise in my mind. Firstly, the “Advanced settings” page ( https://wpdataaccess.com/docs/data-tables-advanced-features/advanced-settings/ ) has some examples of the use of JSON, but my understanding is that these are not all of the possibilities. Is there a comprehensive documentation showing all (or most) of the available settings? The general JSON documentation seems to cover several different topics and approaches, but I presume that not all of those are relevant in WPDA.

Secondly, I have only briefly looked at the “Data projects” documentation in WPDA ( https://wpdataaccess.com/docs/data-apps/data-projects/ ), and I am wondering if the creation of a project might be a more suitable approach in this case?

Thanks once again for your prompt and efficient help!

Nigel

• This reply was modified 2 years, 8 months ago by rc169.

Hi Kim,

The issue with “NULL” values is now resolved from my perspective, since I do not want anything to be displayed in the cell if there is no valid data. However, I didn’t make any changes to settings, so I am not sure why the problem arose – the comment about phpMyAdmin was only a suggestion. If there is a specific way to control what is displayed in those circumstances, I guess that would also answer Mihkel’s question.

Thanks again,

Nigel

Hello,

I’m not sure why this has happened, but I deleted and re-created the fields in the plugin, and now the word “NULL” has disappeared from the view in “Data Explorer” – which is the desired effect. Possibly the earlier issue arose because I had created the fields in phpMyAdmin rather than in the plugin.

Nigel

Hi Kim and Peter,

Thanks for your message and the update. The issue with saving the queries with “CONCAT” entries seems to be resolved, but can you clarify whether empty spaces (to separate the entries in the CONCAT field) always need to be identified by double quotes? I have found that with single quotes (either vertical or angled) I get an error when I try to run the query in the “Query Builder” in WP Data Acceses, although they seem to be acceptable in phpMyAdmin.

Thanks in advance for your help.

Nigel