Can’t change menu

If they request it, here is the code that installs the table:

`
global $wpdb;

$charset_collate = $wpdb->get_charset_collate();

$sql = “CREATE TABLE {$wpdb->prefix}cd_customizations (
role VARCHAR(100) NOT NULL UNIQUE,
menu LONGTEXT,
submenu LONGTEXT,
dashboard LONGTEXT,
PRIMARY KEY (role)
) $charset_collate;”;

require_once ABSPATH . ‘wp-admin/includes/upgrade.php’;
dbDelta( $sql );
`

The host says there is no restrictions to install plugins in mysql. ??

Perhaps try to deactivate and then reactivate Client Dash AFTER all other plugins are deactivated.

You are the first person to report not being able to write the tables, so unfortunately I have to assume there must be something in your system preventing it :/.

WordPress databasefejl: [Table ‘pyrotest_dk.pyrotest_cd_customizations’ doesn’t exist]
TRUNCATE TABLE pyrotest_cd_customizations

Warning: call_user_func_array() expects parameter 1 to be a valid callback, class ‘ClientDash_PluginPages’ does not have a method ‘reset_admin_page’ in /customers/0/6/a/pyrotest.dk/httpd.www/wp-includes/class-wp-hook.php on line 286 Warning: Cannot modify header information – headers already sent by (output started at /customers/0/6/a/pyrotest.dk/httpd.www/wp-includes/wp-db.php:1399) in /customers/0/6/a/pyrotest.dk/httpd.www/wp-includes/pluggable.php on line 1219

I enabled debug on wordpress trying to find any problems, and i found this.
And i have tried to put client dash to 777 on files an folders.
Still nothing works ??

Where do i insert the code, that you send? so i can install the tables manually.

I tried in phpmyadmin after af lot of reading and added the code getting this error.

Error
SQL query:

GLOBAL $wpdb;

MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘global $wpdb’ at line 1

Well, that isn’t actually an executable SQL query, it is PHP code. You will have better luck creating the table via PHPMyAdmin tools. You will need to find someone knowledgeable to help you or do some research.

If you want to simply execute the query, here is the actual SQL query itself:

CREATE TABLE pyrotest_cd_customizations (
role VARCHAR(100) NOT NULL UNIQUE,
menu LONGTEXT,
submenu LONGTEXT,
dashboard LONGTEXT,
PRIMARY KEY (role)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

The issue is I do not know what your character and collation is, so this example code may not properly align with your current database. Again, I highly advise getting professional support for getting the table up, but you are more than welcome to attempt that SQL. I make no promises.

It’s funny.
The plugin works on another site i have without any problems. But when i install it on the site i need it on, it does not work ??

I will try have a look at it.

I have via the sql managed to get the plugin to work, until i find the problem on why i don’t work properly.

How do i see the actual preview of the users menu?
As it looks the preview is how my owm menu are.

As you are customizing, it shows a live preview. You should see the preview window refresh on each change. If you do not, it could be having issues writing to your new table. Make sure the database user in your wp-config.php file has full read/write access to the new table.

It does refresh.
But does it not show the menu depending on the user role?

@joelworsham I’ve deleted your offer to login to your user’s site. I’m am 100% sure you mean well but please never ask for credentials on these forums.

https://www.ads-software.com/support/guidelines/#the-bad-stuff

Now for the why: The internet is a wonderful place full of very nice people and a few very bad ones. I’m sure everyone here is very nice however, by giving some ones keys to your house you are trusting they wont steal anything. Likewise the person who takes the keys is now responsible for the house FOREVER.

If something was to go wrong, then you the author may well legally become liable for damages, which they would not normally have been as their software is provided without warranty.

Please be aware that repeatedly asking for credentials will result in us asking you to repeatedly stop before escalating up to the plugins team.

There are many ways to get information you need and accessing the user’s site is not one of them. That’s going too far.

• Ask for a link to the https://pastebin.com/ log of the user’s web server error log.
• Ask the user to create and post a link to their phpinfo(); output.
• Ask the user to install the Health Check plugin and get the data that way.
• Walk the user through enabling WP_DEBUG and how to log that output to a file and how to share that file.
• Walk the user through basic troubleshooting steps such and disabling all other plugins, clear their cache and cookies and try again.
• Ask the user for the step-by-step on how they can reproduce the problem.

You get the idea.

Volunteer support is not easy. But these forums need to a safe place for all users, experienced or new. Accessing their system that way is a short cut that will get you into real trouble in these forums.