Query runs in Wappler but not in browser

[myllermeireles]

Hello,
I use WAMP 3.3.7 + PHP 8.2.

I can access the DB and all tables through Wappler, but when I open the API in the browser, the error below appears:

Help-me, please!

[franse]

Hello @myllermeireles

Where you succesfully run your query is under a Direct Database Method and that will only work in Wappler Editor

However, for testing in browser you need to configure it under Globals -> Database Connections

So the issue must be on some bad configuration there.
Server Address should not start with http:// or https:// so check that first...

Remember that depends on what target you are:

Define Database Connection Settings per Target

Intro When working on different targets, for example development and production, they usually have different addresses, database names, usernames and passwords. With Wappler you can easily define different database connection settings for your different targets. Setup Database Connection As you know, the active target you are working on can be selected using the Target menu: [Screenshot_1] Our project has two different targets - the local development target and the remote server which is o…

[franse]

Now I see it clearly:
I believe this is the issue

Server address should be mydomain.com and not http://mydomain.com or https://mydomain.com

[myllermeireles]

Hello @franse

I checked the item you suggested (Data Base Connection) and managed to solve the problem.

Thank you very much!!!