search

tiredofit / docker-osticket

Dockerized help desk application
MIT License
71 stars 56 forks source link

Problem with DB (DB Error # 1054) #13

Open mauricio-ibarra opened 2 years ago

mauricio-ibarra commented 2 years ago

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 Captura de pantalla de 2021-09-16 22-28-26 Captura de pantalla de 2021-09-16 22-31-56

.

llewellynhughes commented 2 years ago

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.