======== TEMPLATE BUG FORM ========
Wappler Version : 4.9.1
Operating System : Mac
Server Model: NodeJS
Database Type: MariaDB
Hosting Type: Docket
Expected behavior
What do you think should happen?
I should be able to view data in a brand new databse created in Docker. (note I can insert data fine).
Actual behavior
What actually happens?
This error happens on every table I try to DB Manager Query. If I use navicat - I can query the table data no issue.
To reproduce:
Create a new docker/node/mariadb project.
Go to DB Manager and try to view data on a table.
Do you have dots in the database name?
You shouldn’t do that. Replace them with underscore at least.
You know, I thought that was going to be the cause of the issue. It was the name Wappler auto generated - I didn’t include the dot.
It then became impossible to manually change it in Wappler. Force change just broke the connection entirely and so I had to setup a new target and local DB but then it used the same name. I’ve tried changing the actual files etc too.
Perhaps I’ll just need to create a new project entirely. I’ll try to manually change again and report back if Wappler restricts me from doing this successfully.
You can indeed only specify database name on initial creation, you can’t rename it with Wappler afterwards.
Well you might be able to rename it with some external sql tools.
Was the database name picked by Wappler you say?
Yep, that’s correct.
I create the project folder as projectname_0_1
But mistakenly called the project in Wappler on creation of the project proejctname.io (the website url of the project).
Wappler then used this as the name for the DB, and all new project target creations DB names, too.
So it makes it impossible to change it.
I’ve managed to resolve it but creating an entirely fresh project, and manually copying over each file. I backed up the DB structure in a remote DB so I just cloned the structure and data to a new DB without the . in the name and all is well.