Can't open my queries anymore - No valid database connection found

Wappler General Bugs
1

Wappler Version : 4.7.1
Operating System : Windows 10
Server Model: PHP
Database Type: MYSQL
Hosting Type: Apache

Expected behavior

What do you think should happen?

I am having issue loading my remote database for a while now.

Actual behavior

What actually happens?

I am no longer able to open or create new db queries.
DB Connection is working fine:

image
image547×596 16 KB

But when I try to open or create a new query I get the following error:

image

How to reproduce

  • I have tried to delete/add database connection again > no change
  • Enabled/Disabled 'Direct Connection : also create a connection in dabatase manager' > no result and I sometimes get getaddrinfo EAI_AGAIN error
  • Created a new project, new database connection, etc. and the result is still the same.

Any guidance? help?

Thank you in advance.

2

Make sure you have your development target selected as active target and not your remote when editing server actions.

3

I have that setup and selected as well.

4

Hello Team,

Any workaround regarding this issue? All my work is being stopped now because of this.
Thank you in advance

5

Make sure in your project folder that you are set to ‘Local’ and not ‘Target’.

Screen Shot 2022-03-31 at 2.11.42 PM
Screen Shot 2022-03-31 at 2.11.42 PM854×436 29.3 KB

6

Thanks for your reply.
Yes, my project folder is set to Local.

Is it possible to use database connection without the database manager? I believe that is where my problem is…

7

Try turning on Direct Connection in your connection settings.

Screen Shot 2022-03-31 at 2.25.49 PM
Screen Shot 2022-03-31 at 2.25.49 PM1150×436 62.7 KB

Yes, I have never used the Database Manager myself.

8

I have used it locally but never for site with remote target.
I have created a new project and disable the ‘direct connection’ when creating the database connection, but I am still getting the same error when trying to create a query, security provider, etc.

Never had this issue before. Just noticed it after installing 4.7.1.
Upgrading to 4.7.2 is not resolving the issue …

9

Try turning it on, not off.

Can you see your connections and tables in the Database Manager?

10

@brad > I have disabled the experimental features, restarted Wappler and I can now add, edit queries again.

Thanks !

1 Like
11

That’s strange. But that’s awesome that you can continue working!

1 Like
12

Where is your database located?

Also are you able to fully view its schema in tge database manager?

We use indeed new ways to query database structure in the feature enabled with experimental features, so it should work and we should fix your problems otherwise when we make those features final you will have then a problem.

So let’s try to find out what your problem was with experimental features on.

And you can always turn them off later for your regular work.

13

Hey @George,

Thanks for your reply, and apologies for the delayed response.

Where is your database located?

At my hosting provider (iPower)

Also are you able to fully view its schema in tge database manager?

Yes, I can view the database tables.

I cannot remember exactly what it was, but I had issue a few months ago and it was resolved when I turned off the experimental features.

Thank you!