• Resolved zzanna

    (@zzanna)


    Hello,
    today i updated the plugin and the database to version 2.1.3
    all go well but all users lost their group.
    Can you help me?

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author GM_Alex

    (@gm_alex)

    The only know constellation to me where that could happen is if the database update isn’t performed or run successfully. Try to revert the data base to the latest version 1.5 for example and do the database update again.

    Thread Starter zzanna

    (@zzanna)

    Hi Alex,
    I’ve reverted the database to 1.5 but the problem is still there.
    Any other idea?

    Plugin Author GM_Alex

    (@gm_alex)

    And updated it again to the latest (1.6.1)?

    Thread Starter zzanna

    (@zzanna)

    Yes

    Plugin Author GM_Alex

    (@gm_alex)

    Only thing I can do now is debug it live, if you want me to give me access to your server…

    Thread Starter zzanna

    (@zzanna)

    here some screenshot of the db:

    Tabelle database

    Table to_object

    Table to-object 1.5.1

    Plugin Author GM_Alex

    (@gm_alex)

    The column general_object_type is missing. This row was introduced at db version 1.4. Do you have an backup of 1.3 or earlier? But keep in mind that you will loose all assignments since then. The other option could add the column by hand with

    
    ALTER TABLE zz_uam_accessgroup_to_object
    ADD general_object_type VARCHAR(64) NOT NULL AFTER object_id
    

    and run the following queries

    
    UPDATE zz_uam_accessgroup_to_object
    SET general_object_type = '_role_'
    WHERE object_type = 'role';
    
    UPDATE zz_uam_accessgroup_to_object
    SET general_object_type = '_user_'
    WHERE object_type = 'user';
    
    UPDATE zz_uam_accessgroup_to_object
    SET general_object_type = '_term_'
    WHERE object_type = 'term'";
    
    UPDATE zz_uam_accessgroup_to_object
    SET general_object_type = '_post_'
    WHERE object_type IN ('post', 'page', 'attachment')
    
    Thread Starter zzanna

    (@zzanna)

    Alex!!! Thank you!!!
    I run the queries manually and now all is fine!!!!

    again thank you!!!

    Plugin Author GM_Alex

    (@gm_alex)

    Nice. Maybe I should implement a database validation…

    I’ve updated to version 2.1.3 and all users have lost their group, so everyone can see the confidential pages. If I use the previous version 2.0.13 this does not happen. What can I do?

    Plugin Author GM_Alex

    (@gm_alex)

    Please check if the tables are correct, see the post above.

    always updated the plugin to version 2.0.13 without any problems and everything was running automatically, only now since I updated from version 2.1.0 to version 2.1.3 on the role role column I no longer see the roles I had created and I can not insert them

    GM_Alex
    What is your e-mail to send screen-shot

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘After 2.1.3 update all user lost the UAM User Groups’ is closed to new replies.