Knex: Required configuration option 'client' is missing

Wappler General
1

What does

knex: Required configuration option 'client' is missing.

mean? I can't get access to the database for that project.

2

Hi.
How have you configured the project? DB connection settings setup should be similar to other server models.

3

Where are you getting this? In the Database Manager or when running Server Connect actions?

Maybe add a screenshot of the exact error and state the Wappler version.

4

Version 4.1.2

Is see this in the Database Manager tree:

Bildschirmfoto-2021-10-08-um-12.15.03
Bildschirmfoto-2021-10-08-um-12.15.03541×829 55.8 KB

In the the query manager, I can’t access to any of the tables/views anymore

I see that no direct Database Manager connection is configured for this project right now

5

well revisit the database connection properties, see if it is all still correct.

and you should enter the database connection properties of course

6

Added connection, but I still get this:

Bildschirmfoto 2021-10-08 um 12.19.13
Bildschirmfoto 2021-10-08 um 12.19.131021×603 16.1 KB

7

this happens when you are on a different target - and the database schema isn’t fetched there yet.

8

Thanks George. I’ll check this later today, as I’ve got a meeting. Will let you know if I was able to fix it.

9

This is not really working. Some of the tables/view can be found by the query builde but most of them not. Looks like the refresh is not working.

I’m getting this kind of logfile error:

Bildschirmfoto 2021-10-09 um 09.22.07
Bildschirmfoto 2021-10-09 um 09.22.073306×271 141 KB

10

Just to confirm:

  • you have a direct database connection defined and working in the database manager?

  • how do you do tables refresh?

  • can’t you refresh specific tables are not a single one?

  • does it happen again after Wappler restart?

  • maybe shoot a short movie to show the problem.

Please restart Wappler with logging, reproduce the problem and attach the debug log. See:

11

Could it be that multiple refresh in the database manager is not working only one table/view at once?

12

I reinstalled the database conncetion but still get undefined database table.

I can’t add a log because Wappler didn’t generate one …

I refresh the database schema like this:

Bildschirmfoto-2021-10-10-um-12.58.19
Bildschirmfoto-2021-10-10-um-12.58.19454×663 170 KB

But this doesn’t work at all. Only refresh of each of the tables/views. But even then I get undefined table in the database query and I’ve got to manually reapply the table/view which requires to check the used table/view in code view first …

13

Having the same issue too. Getting the same error, to a project that it was working alright. Database connection is set up through ‘Conncetion options’ not a ‘Direct Database Connection’. The issue appeared today when I added a new table (through phpmyadmin) into the database, and tried to refresh ther schema in Wappler. I am connecting to a remote db, not localhost.

14

Here is a solution to the issue. Create a new database with the same credentials.
Then rename the ‘old’ one (with the knex issue) to another name
Rename the ‘new’ connection to the name that the ‘old’ one had.

The newly created database connection won’t have this issue.

Thank you

16

Unfortunatelly the issue is not resolved. Although the new tables are visible in the database schema, the database query manager does not display those changes.

17

How do you mean? Don't you have a direct connection to the database?

18

no just from the connections options

19

with the direct seems to be working

20

Yes it is better to always have direct connection defined as well