Problem with DB (DB Error # 1054)

[mauricio-ibarra]

An error is generated when querying. Use your docker-compose.yml without any modification in a sandbox. When a user query is made the error is generated.
Thank you very much for your work, happy to help you.
Greetings

.

[llewellynhughes]

Hi,

Looks like the phone column is missing in the ost_user__cdata table.

I resolved this by using portainer, and open the bash shell from the ostickets_db docker.

I ran:-
mysql -u osticket -p
change the user to whatever user you set up for osticket mysql and put in the password when it prompts.

then i ran:-
use osticket;
change this to what database name you set up.

then i ran:-
select * from ost_user__cdata;
which shows the phone column missing.

lastly i ran:-
alter table ost_user__cdata add phone varchar(15) after email;
I'm not sure if varchar(15) is the right field type or length, but it's still in dev at mo.

I wouldn't recommend running this on production, but this fixed it for me.