[Resolved] Meta missing from Toolset with user import

[Author]

Posts

[Philippe Ryf]

Hi,

We created a big wordpress website for our company and we transfered all our user from a Drupal database to the WordPress database.

Everything works fine except for one thing with access. There is a CRED form for the user's personnal informations and we can't access it with the users we transfered.

We took a look at the database to find the meta missing and we can't find the right meta field missing in our users.

But if we change the user's role by the admin dashboard, it resolve the problem.

We are using ACCESS to control the CRED FORM

[Shane]

Hi Phillippe,

Thank you for contacting our support forum.

So the essential issue here is that the user is unable to access the CRED form to modify their information correct?

If so would you mind providing me with admin access so that I can have a look.

Thanks,
Shane

[Shane]

Hi Phillippe,

As far as I know the user role information is stored within the user meta table, Access does not have a table for itself so all the user role information is found here.

Thanks,
Shane

[Philippe Ryf]

Do you know what else could be updated when we save a user's profile? It's really bothering me and we have 7'000 user on our database so we need to do the update from MySQL directly.

[Philippe Ryf]

Isn't there a hook from Toolset that need to be activated to update a relation between the plugin ACCESS/Types/CRED and the WP user database?

[Shane]

Hi Phillipe,

Not that i'm aware of however I worked on an issue recently where I noticed my user permissions were not being added whenever I added a new user through the database and even updated the usermeta table.

What I did was to check that the record was actually added by checking the usermeta table that the wp_capabilities record was added for that user.

Thanks,
Shane

[Philippe Ryf]

That's the first thing we checked, we event added the wp_user_level to be sure, and the issue is the same.

The only way we can guarantee the access and the correct rights to the CRED Form, is by updating the profil throught the wp-admin.

I even tried to copy-paste the content from a user with the working rights, the result is the same.

So I don't see any other solution than finding what hook is used with the update. I just need to be sure if something is added throught a Toolset plugin

[Shane]

Hi Phillipe,

Nothing is being added regarding the user meta from the access plugin. There is no new table of such added.

It works by checking what is in the usermeta table to see if the user has the correct permissions.
However as I said check the wp_capabilities record to see if everything is ok with the record there.

It should look something like this.

a:17:{s:13:"administrator";b:1;s:26:"wpcf_custom_post_type_view";b:1;s:26:"wpcf_custom_post_type_edit";b:1;s:33:"wpcf_custom_post_type_edit_others";b:1;s:25:"wpcf_custom_taxonomy_view";b:1;s:25:"wpcf_custom_taxonomy_edit";b:1;s:32:"wpcf_custom_taxonomy_edit_others";b:1;s:22:"wpcf_custom_field_view";b:1;s:22:"wpcf_custom_field_edit";b:1;s:29:"wpcf_custom_field_edit_others";b:1;s:25:"wpcf_user_meta_field_view";b:1;s:25:"wpcf_user_meta_field_edit";b:1;s:32:"wpcf_user_meta_field_edit_others";b:1;s:17:"ddl_create_layout";b:1;s:28:"ddl_assign_layout_to_content";b:1;s:15:"ddl_edit_layout";b:1;s:17:"ddl_delete_layout";b:1;}

Thanks,
Shane

[Philippe Ryf]

I checked theses entries in the database, tried to copy the one from a working user to another, the contents are exactly the same :

wp_capabilities,"a:1:{s:6:""member"";b:1;}"

[Shane]

Hi Phillippe,

There must be something else amiss here as i've just inserted a user into the db using an SQL query and the only thing i've added into the db for the user meta was.

wp_capabilities = a:1:{s:9:"test_role";b:1;}


wp_user_level = 7

From there I was able to access a form that only test_role users can access.

Thanks,
Shane

[Philippe Ryf]

Well, the last two days, I tried to understand what is going on but I am at the same point and on monday, the website must be online for users. I'll have to disable this CRED form and do the form all by myself.

I tried so many things right now but it's the same thing for every user already in the database and with every new role I could create.

I created new roles like "member", "membre mda", "mdamda" to be sure it wasn't something with the name, I put a second CRED form with the EXACT same rights, checked the capabilities from the ACCESS plugin to be sure they have the wpcf_custom_post_type_view and all the others capabilities from TYPES and the result is the same.

The only way my user can access to his CRED form is for an admin to go on his profil page, through the admin dashboard, check if the role is the right one, save the user and there you go.

I am tired and I can't understand what is going on

[Shane]

Hi Philippe,

Would it be possible for me to get a copy of the website to help you out better?

This way I can go through the steps to see if I can find anything that is amiss .

Thanks,
Shane