Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema is not in sync with the current Mapping #618

Open
HazemHeakal opened this issue Oct 27, 2022 · 5 comments
Open

Schema is not in sync with the current Mapping #618

HazemHeakal opened this issue Oct 27, 2022 · 5 comments
Assignees
Labels
Database Regarding Database Issues

Comments

@HazemHeakal
Copy link

Bug report

Title

Schema is not in sync with the current Mapping

Issue Description

After fresh installation I tried to check the schema validation and I get this issue.

Preconditions

Please provide as detailed information about your environment as possible.

1. Windows (5 Cores - Ram 8 - Bitnami with (Mariadb 10.4.25 - PHP 8.2).
2. Commit id.

Steps to reproduce

Same steps as installation guide
1- Download zip
2- run php bin/console uvdesk:configure-helpdesk and fill info

Expected result

should the schema be synced as this will effect on the modules installation and data.

Actual result

I get Schema is not in sync with the current Mapping during check schema validation
image

@komal-sh-27
Copy link
Contributor

Once you can check run these commands in your project root directory:

  • Run this command to show the differences in the SQL without having to dump your DB:

       php bin/console doctrine:schema:update --dump-sql
    
  • You can also run the following command to perform the changes:

       php bin/console doctrine:schema:update --force
    

=> You can follow these links:
https://stackoverflow.com/questions/13670471/database-fail-the-database-schema-is-not-in-sync-with-the-current-mapping-file

https://stackoverflow.com/questions/51854778/database-schema-is-not-in-sync-for-a-nullable-column

@HazemHeakal
Copy link
Author

I have tried those solutions before without changes, same errors.

I don't know if it possible to do it manually or is that is a bug.

@komal-sh-27
Copy link
Contributor

You can make try once the manual setup of UVdesk:
Check the below link for manual setup from #290 (comment)

If you still facing the same error let us know.

@HazemHeakal
Copy link
Author

HazemHeakal commented Oct 28, 2022

Same error, I don't know if there is another solution for that I disappointed.

There is some tables doesn't exist in database like userSaveReplies

2022-10-28 13_41_57-Command Prompt

@HazemHeakal
Copy link
Author

It's seems as a bug in the uvdesk

@komal-sh-27 komal-sh-27 added the Database Regarding Database Issues label Nov 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Database Regarding Database Issues
Projects
None yet
Development

No branches or pull requests

3 participants