Wappler Version : 6.4.0
Operating System : Windows 11
Server Model: Node
Database Type: MariaDB
Hosting Type: Docker local
Expected behavior
Creation and first appearance in Database Manager was correct. As Example, the initial subtable name was “Structure”.
Actual behavior
As soon as Schema gets saved, the first digit of the given name disappears in the UI and Wappler internally. In MySQL workbench, the names are given correctly (e.g. Screenhots). Further working with db manager in Wappler is not possible, because of naming discrepancy between DB state and Wappler State.
How to reproduce
- Create DB with a subtable called “Structure”
- Wappler UI after saving the Table file (Missing first digit letter “S”)
- MYSQL workbench seems to be ok with “Structure” Table. So on DB side everything is ok.
- All further work is not possible because of false naming convention in knex.
Seems, that Wappler’s behaviour is stripping out the first digit.
Restart of Wappler and DB didn’t fix it.
UPDATE:
Seems to be a behaviour of naming conventions and automatic conversion by wappler.
Scenario 1:
Table called “Meetings” (Wappler UI)
SubTable called “Settings” (Wappler UI)
Table called “Meeting” (SQL Workbench)
SubTable called “MeetingSettings” (SQL Workbench)
Scenario2:
Table called “Meetings” (Wappler UI)
SubTable called “Topics” (Wappler UI)
Table called “Meetings” (SQL Workbench)
SubTable called “MeetingTopics” (SQL Workbench)
This subtable is shown in Wappler and works correctly
It seems if the maintable is called meetings and the subtable settings, while creating the subtable as combined reference table in SQL, the “meetings table” become “meeting” prefix and settings get applied after the name meeting. It seems that meetings get automatically stripped to meeting for all subtable and in case the s gets stripped, it also takes the starting S of Settings out of the UI name in wappler 