Message: Some features of WP Data Access are currently not available

Hi rswebmaster,

Looks like you’re missing the plugin data project tables. Can you please check if all the repository table are available?

This is how:
– in the plugin menu navigate to “Manage Plugin”
– click tab “Manage Repository”

If there are any tables missing, you should see a message and a button to (re)create them. Please let me know if this solves your problem.

Best regards,
Peter

Hi Peter,
the table wp261_wpda_menu_items is not found and two its triggers wp261_wpda_menu_items_before_insert and wp261_wpda_menu_items_before_update have not found.

I see only the button “Recreate WP Data Access repository”.
I have tried to re-create the repository several times but there is always an issue.

Regards
R

Hi R,

What message do you get? Are the other plugin tables available? (wp261_wpda_table_design, wp261_wpdp_project, wp261_wpdp_page, wp261_wpdp_table) Or are they missing as well? Do you have permission to create tables?

The missing table is certainly the problem. Let’s find out why…

Best regards,
Peter

Hi Peter,
all the other table you listed were found, the only one not found is the wp261_wpda_menu_items table and its triggers as already mentioned.

Below some pictures, I hope it helps
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_err.png
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS.png

I have tried to re-create the repository several times but there is always this issue.

Regards
R

Hi R,

I’m interested in the error message you get when you try to create the table. Below you’ll find the create table script for the menu items table. Can you please copy this statement in a script and run that script from the data explorer? When you uncheck the hide errors checkbox you should see the error on your dashboard.

CREATE TABLE wp261_wpda_menu_items (
menu_name VARCHAR(100) NOT NULL,
menu_table_name VARCHAR(64) NOT NULL,
menu_capability VARCHAR(100) NOT NULL,
menu_slug VARCHAR(100),
PRIMARY KEY (menu_name, menu_table_name, menu_capability)
);

Best regards,
Peter

Hi Peter,
I have created a blank .sql file format and copied and pasted your script.
When trying to import from Data Explorer section I receive the following error.
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_import_error-1.png
Could you please send the script file?

Regards
R

Hi R,

You can download the script from the link below:
https://drive.google.com/file/d/1rtHDhhbvgUfJcdMIL8FiCK-G8Xf1MW-z/view?usp=sharing

But that should result in the same error. Did you uncheck the “Hide errors” checkbox? I expected to see a MySQL error message. Do you have access to the MySQL command line? It looks like a database problem to me.

Best regards,
Peter

Hi Peter,
running the script in the mySQL interface of my hosting (Aruba), I received the error message shown in the picture. I hope it helps.

https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_import_error_SQL.png

Without the Primary key I am to create the table. Now I have deleted it.

Regards
R

Hi R,

This is a limitation of the MySQL version 5.6 and prior. Can you update to version 5.7 or higher? That would solve the problem.

You can also create the table without the primary key. Without the primary key you will not be able to use the dashboard menus feature, but you will be able to use the other features.

Best regards,
Peter

Hi Peter,
unfortunately, I cannot update the MySQL version of my hosting.
I will try to create the table as you suggested.
Thanks for your support

Regards
R

Hi R,

I will close this topic. In the next release I’ll change the create table script to prevent future users with older MySQL installation having the same problem. Thank you for pointing out this issue!

Best regards,
Peter