[Leonid Gauss Has successfully completed the online course Intermediate (200)Has successfully completed the online course Basics (100)]

1 year ago #35518

Hello, I can’t deploy schema to data source as shown in the course “Database Designer” Intermediate-200, although I do everything exactly as shown in the course, I get the error message: “There is a logic error in your database definition: Alter String column to other type”. what could be the reason?

Attachments:

You must be logged in to view attached files.

[Jennifer Häfner Has successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (310)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certification]

1 year ago #35687

Up

0

Down

::

Hi Leonid,

It seems that there is a problem with your scheme: in the ‘live’ tab in the database designer, the column ‘vote’ is of type String, and when executing the connector call ‘Feedback’ – ‘selectAllFromFeedback’, you can also see that the values for ‘vote’ are all Strings. There seems to be a problem when converting the column type to Integer, so you get the error when deploying the scheme.

This issue has also crashed the data editor unfortunately, it seems like your scheme is now in a broken intermediate state between old and new version. So I think the easiest way is to create a new scheme:

• In the new scheme, create the table ‘feedback’ with the columns as you see them in the ‘live’ tab (just set the data type for ‘vote’ to Integer). Deploy the scheme to the data source (Schema ausrollen starten)
• Then, use the connector call ‘Feedback’ – ‘insertMockDataIntoFeedback’ to re-insert the values
• Finally, adapt the scheme according to the instructions in the Intermediate course: add the table ‘orders’, add columns to the table ‘feedback’ etc., like you did in your screenshot above
• Deploy the scheme, you shouldn’t get any errors now

Let me know if you need any more advice.