Database manager Errors for Targets

[Wlady972]

Wappler Version : 5.3.0 to 5.4.1
Operating System : Windows 10
Server Model: PHP
Database Type: MySQL
Hosting Type: Custom / Cloud / local

Hello,

I know that the trend of the moment is around NodeJS, as well as mobile applications of this language, but PHP/MySql is not dead yet, and we do not see the shadow of Python in the development of websites…

I reread this post dozens of times before writing this one.

Errors when switching targets in the Database Manager

This happens when database schema needs to be refreshed but the connection it isn’t loaded yet, it will be fixed in the next update

I would like to pay special attention to the changes made in your last updates. Some things have disappeared or do not work anymore. But I didn’t have time to make a list yet.

Here is what I am working on the most.

1. • The database manager does not save settings for target sites since 5.3.0.

TypeError: Cannot read properties of null (reading 'data') at refreshSchemaForNode (file:///C:/Users/Wlad/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/databaseManager.js:8:163294) at HTMLButtonElement.<anonymous> (file:///C:/Users/Wlad/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/databaseManager.js:8:45179) at HTMLButtonElement.dispatch (C:\Users\Wlad\AppData\Local\Wappler\resources\app\node_modules\jquery\dist\jquery.js:5430:27) at HTMLButtonElement.elemData.handle (C:\Users\Wlad\AppData\Local\Wappler\resources\app\node_modules\jquery\dist\jquery.js:5234:28) at HTMLButtonElement.sentryWrapped (C:\Users\Wlad\AppData\Local\Wappler\resources\app\node_modules\@sentry\browser\dist\helpers.js:75:23)

If one would like to use Wappler as a NodeCode environment, this is not possible.

I have to modify my database configuration file manually:
/dmxConnect/modules/Connections/myDBconfigFileName.php

into
"connectionString": "mysql:host=localhost;dbname=mydatabase;user=root;password=password;sslverify=false;port=3306;charset=utf8",

2. • You can’t work directly on the target files anymore. On versions 5.2.x of Wappler, when I made a change on a file, in FTP target mode, this file was automatically saved.

Sincerely

[George]

Could you paste here your .wappler/project.json file contents, do make sure you delete all security sensitive info first. Note that the .wappler folder is hidden so you have to show hidden files first from the context menu of the file manager.

[Wlady972]

For example, my last website with an OVH DB

{
  "projectName": "MyPRG",
  "styleFile": "/css/style.css",
  "assetsFolder": "/assets",
  "designFramework": "bootstrap5",
  "frameworks": [
    {
      "name": "fontawesome_5",
      "type": "cdn"
    },
    {
      "name": "bootstrap5",
      "type": "local"
    },
    {
      "name": "appConnect",
      "type": "local"
    }
  ],
  "projectServerModel": "PHP",
  "runtime": "capacitor",
  "targets": [
    {
      "name": "Development",
      "remoteURL": "http://myprg.local",
      "access": "local",
      "localFolder": "file:///C:/Ampps/www/myprg.local",
      "databaseConnectionType": "custom",
      "db_host": "localhost",
      "db_port": "3306",
      "db_user": "root",
      "db_password": "mysql",
      "db_database": "myprg"
    },
    {
      "name": "Site MYPRG.com",
      "remoteURL": "https://myprg.com/",
      "access": "ftp",
      "databaseConnectionType": "custom",
      "db_host": "myprg.mysql.db",
      "db_port": "3306",
      "db_user": "myprguser",
      "db_password": "myprgdbpass",
      "db_database": "myprgdb",
      "usage": "production",
      "ftpServer": "ftp.myprg.hosting.net",
      "ftpPort": 21,
      "ftpRemoteFolder": "/www",
      "ftpUser": "myprguser",
      "ftpPassword": "myprghashpass"
    }
  ],
  "activeTarget": "Site MYPRG.com",
  "useRouting": true,
  "addBase": true,
  "routingHandler": "apache",
  "projectType": "web",
  "projectLinksType": "site"
}

[Teodor]

Fixed in Wappler 5.4.2