DB Error #1045 - phone - osTicket Forum

DB Error #1045 - phone

dimuspl

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

IssacChan

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.

ntozier

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.