Good morning,
I don't know much about databases, I just installed osTocket and during the user account I get this message:
[INSERT INTO os_user__cdata SET phone=888888888, user_id= 8 ON DUPLICATE KEY UPDATE phone=888888888]

Unknown column 'phone' in 'field list'<br />
<br />
I found a message to drop/delete table "os_user__cdata" but when I do this, the users do not work - can't log in.
What do I have to do to get rid of this error? This error appears from the beginning of a clean install.

Regards

    Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

    Environment details? (see Admin panel -> Dashboard -> Information)

    Also once you drop the user__cdata table you would need to search for a user to have it re-populate.

    3 months later

    dimuspl You should try to drop the db of 'ost_user__cdata' and recreate it (remember backup).
    Then remove the "phone" in admin panel and recreate it if needed. It works for me.

      Write a Reply...