Error trying to PostgreSQL

Wappler General
1

I enabled the PDO driver for PostgreSQL but when trying to login through the site’s Admin panel, the system returns an error as shown in the attached image. In Mysql it works normally but I’m migrating my sites to PostgreSQL. I need help to solve this problem.

Captura de ecrã 2023-04-05 132914
Captura de ecrã 2023-04-05 1329141855×382 30.5 KB

2

Do I have to enable some more detail in Laragon or do some configuration in my files?
I need help to solve this problem. Somebody? @patrick or @Teodor?

4

Hi @patrick.
Sorry… me again. I’ve tried everything (what I know to try to resolve). You’re giving me some detail that I can’t find. In Mysql it works normally in all my projects. In this project in question, I created a new connection with PosgreSQL and named it PosttgreSQL and went to all the APIs and changed the connection for the new one but it always gives the same error:

  1. {code: 0, file: “C:\laragon\www\nussdesign\dmxConnectLib\lib\auth\DatabaseProvider.php”, line: 27,…}

  2. code: 0

  3. file: “C:\laragon\www\nussdesign\dmxConnectLib\lib\auth\DatabaseProvider.php”

  4. line: 27

  5. message: “Undefined property: stdClass::$users”

  6. trace: “#0 C:\laragon\www\nussdesign\dmxConnectLib\lib\auth\DatabaseProvider.php(27): exception_error_handler(2, ‘Undefined prope…’, ‘C:\\laragon\\www\\…’, 27)\n#1 C:\laragon\www\nussdesign\dmxConnectLib\lib\auth\Provider.php(140): lib\auth\DatabaseProvider->validate(‘vinicios@nussem…’, ‘dd7c26a9ba9d4fa…’, false)\n#2 C:\laragon\www\nussdesign\dmxConnectLib\modules\auth.php(54): lib\auth\Provider->login(‘vinicios@nussem…’, ‘dd7c26a9ba9d4fa…’, NULL)\n#3 C:\laragon\www\nussdesign\dmxConnectLib\lib\App.php(204): modules\auth->login(Object(stdClass), ‘identity’, Array)\n#4 C:\laragon\www\nussdesign\dmxConnectLib\lib\App.php(144): lib\App->execSteps(Object(stdClass))\n#5 C:\laragon\www\nussdesign\dmxConnectLib\lib\App.php(133): lib\App->exec(Object(stdClass), false)\n#6 C:\laragon\www\nussdesign\dmxConnectLib\lib\App.php(111): lib\App->exec(Object(stdClass))\n#7 C:\laragon\www\nussdesign\dmxConnect\api\users\login.php(8): lib\App->define(Object(stdClass))\n#8 {main}”

5

Hello everyone.
Could someone who has already done a project in Wappler with PostgreSQL try to help me with this question?
Is there a driver or configuration missing?

6

I use postgresql for all my projects. Unfortunately I don’t use PHP, only nodejs

1 Like