community-skeleton icon indicating copy to clipboard operation
community-skeleton copied to clipboard

Schema is not in sync with the current Mapping

Open HazemHeakal opened this issue 3 years ago • 5 comments

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

HazemHeakal avatar Oct 27 '22 08:10 HazemHeakal

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

komal-sh-27 avatar Oct 28 '22 07:10 komal-sh-27

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.

HazemHeakal avatar Oct 28 '22 10:10 HazemHeakal

You can make try once the manual setup of UVdesk: Check the below link for manual setup from https://github.com/uvdesk/community-skeleton/issues/290#issuecomment-661113642

If you still facing the same error let us know.

komal-sh-27 avatar Oct 28 '22 11:10 komal-sh-27

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 avatar Oct 28 '22 11:10 HazemHeakal

It's seems as a bug in the uvdesk

HazemHeakal avatar Oct 31 '22 19:10 HazemHeakal