horilla-opensource / horilla

Horilla is a free and open source HR software.
https://www.horilla.com/
GNU Lesser General Public License v2.1
154 stars 102 forks source link

no such column #284

Open TSmiley12 opened 4 weeks ago

TSmiley12 commented 4 weeks ago

I just tried installing the system and after running the server i got this error :

Exception Value: | no such column: base_employeeshiftschedule.is_auto_punch_out_enabled -- | -- ![Screenshot 2024-08-17 155651](https://github.com/user-attachments/assets/10e3a1c4-8d69-4554-a21e-0788a0c2f708)

horilla-opensource commented 3 weeks ago

Hi @TSmiley12 , Can you run the followings command in the order given below and try again?

1. python3 manage.py migrate base
2. python3 manage.py migrate

With Regards, Team Horilla

MrcellSbst commented 3 weeks ago

Hi @TSmiley12 , Can you run the followings command in the order given below and try again?

1. python3 manage.py migrate base
2. python3 manage.py migrate

With Regards, Team Horilla

hi, i have the same problem, i already did the command, but still got the same problem.

horilla-opensource commented 3 weeks ago

Hi @MrcellSbst , If you are starting with a fresh database, please remove the contents from the __init__.pyfile in the base app migrations folder. ie remove all the contents from the file base/migrations/__init__.pyand run the above commands.

With Regards, Team Horilla

TSmiley12 commented 3 weeks ago

Hello there. Thank you very much for your support

On Mon, Aug 19, 2024, 9:37 AM Horilla @.***> wrote:

Hi @MrcellSbst https://github.com/MrcellSbst , If you are starting with a fresh database, please remove the contents from the init.py file in the base app migrations folder. ie remove all the contents from the file base/migrations/init.py and run the above commands.

With Regards, Team Horilla

— Reply to this email directly, view it on GitHub https://github.com/horilla-opensource/horilla/issues/284#issuecomment-2296119474, or unsubscribe https://github.com/notifications/unsubscribe-auth/AXJ4PQQNJ5U5WQOSP6MGXSLZSG4EDAVCNFSM6AAAAABMVQY4E6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJWGEYTSNBXGQ . You are receiving this because you were mentioned.Message ID: @.***>

MrcellSbst commented 3 weeks ago

Hi @MrcellSbst , If you are starting with a fresh database, please remove the contents from the __init__.pyfile in the base app migrations folder. ie remove all the contents from the file base/migrations/__init__.pyand run the above commands.

With Regards, Team Horilla

the solution worked, but can't you make this automatically? when I shutdown the server (physically) and when i try to run the server again, this problem pops up

horilla-opensource commented 3 weeks ago

You'll have to run that command only once and it'll be reflected in the database. You don't have to run the command each time you restart the server. The above commands makes the necessary changes in your database which doesn't affect whether your server is currently running or stopped. So you'll have to execute the command only once. The code inside the base/migrations/__init__.py was meant for existing users because of a major change we made in the inter app dependencies. For new users, this shouldn't have been an issue.