horilla-opensource / horilla

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

Clean install missing Table 'horilla.recruitment_surveytemplate' doesn't exist #88

Closed curtishall closed 8 months ago

curtishall commented 8 months ago

Bug Report

Description

I'm trying to access Recruitments ->Recruitments (which opens /recruitment/recruitment-view) and I get this error:

Clean install missing Table 'horilla.recruitment_surveytemplate' doesn't exist

Steps to Reproduce

  1. [Detailed step-by-step instructions to reproduce the issue.]
    
    <html>
    <body>
    <!--StartFragment--><div id="summary" style="padding: 10px 20px; margin: 0px; border-bottom: 1px solid rgb(221, 221, 221); background: rgb(255, 255, 204);"><h1 style="padding: 0px; margin: 0px; font-weight: normal;">ProgrammingError at /recruitment/recruitment-view</h1><pre class="exception_value" style="padding: 0px; margin: 10px 0px; font-size: 1.5em; white-space: pre-wrap; word-break: break-word; font-family: sans-serif; color: rgb(87, 87, 87);">(1146, "Table 'horilla.recruitment_surveytemplate' doesn't exist")</pre>
    Request Method: | GET
    -- | --
    http://DELETED/recruitment/recruitment-view
    4.2.7
    ProgrammingError
    (1146, "Table 'horilla.recruitment_surveytemplate' doesn't exist")
    /usr/local/lib/python3.10/dist-packages/MySQLdb/connections.py, line 254, in query
    horilla.decorators.wrapped_view
    /usr/bin/python3
    3.10.12
    ['/root/horilla',  '/usr/lib/python310.zip',  '/usr/lib/python3.10',  '/usr/lib/python3.10/lib-dynload',  '/usr/local/lib/python3.10/dist-packages',  '/usr/lib/python3/dist-packages']
    Sun, 18 Feb 2024 12:06:35 -0600

You’re seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard page generated by the handler for this status code.




## Actual Behavior

_[What actually happened.]_

## Screenshots

_[If applicable, provide screenshots illustrating the issue.]_

## Environment

- **Django Version:** _[Django version you're using, e.g., 3.2.1]_
- **Python Version:** _[Python version, e.g., 3.9]_
- **Operating System:** _[Your OS, e.g., Windows 10, Ubuntu 20.04]_
- **Browser:** _[If applicable, specify the browser and version you're using.]_

## Additional Information

_[Any other relevant information, logs, error messages, or context that might help in understanding and fixing the issue.]_

## Possible Solution

_[If you have any ideas or suggestions on how to fix the issue, feel free to provide them here. This is optional.]_

## Labels

_[If your project uses labels, suggest any labels that might apply to this issue, such as 'bug', 'needs investigation', etc.]_

## Priority

_[Specify the priority level for this issue, such as 'high', 'medium', 'low', etc.]_

## Assignees

_[If you want to suggest an assignee or tag a specific person to look into this issue, mention their GitHub username here.]_

## Related Issues

_[If there are any related issues or pull requests, mention them here. This is optional.]_

**Note:** _Remember to search through existing issues before submitting a new one to ensure that the issue hasn't been reported already. Provide as much information as possible to help the maintainers understand and address the problem effectively._
horilla-opensource commented 8 months ago

Hi @curtishall , Can you please check if there is any migration to be completed in the database? Using the command

python manage.py makemigrations
python manage.py migrate
curtishall commented 8 months ago

thanks....that fixed it.

How do I load the sample database?

horilla-opensource commented 8 months ago

Currently we have provided the test database only in psql. Or else you can try it out in the demo website. Horilla Demo username: admin password: admin

With Regards, Team Horilla

horilla-opensource commented 8 months ago

Hi @curtishall , Can we close this issue as it is fixed?

With Regards, Team Horilla