Database Insert not returning ID of inserted row anymore

Server Side Components Bugs
1

Hi,

The Database Insert Server Action is not returning anymore the ID of the inserted element although the output flag is selected and the entry is inserted correctly in the database.

This is what I receive when trying to debug:
image

and this is the Server Action:
image
Can you please confirm if this is a bug?

Wappler Version : 2.1.1
Operating System : Windows 10

Expected behavior

What do you think should happen?

The ServerAction should return the ID of the inserted element (ex: 91)

Actual behavior

What actually happens?

The serveraction returns null

How to reproduce

Create a database insert server action and check if an ID is returned when calling it from the frontend

1 Like
2

Just to confirm @George, I am seeing this bug also, could have quite serious consequences for both new and existing sites which rely on the identity returned from an insert action

4 Likes
3

Will investigate

3 Likes
4

Sorry I created a post on the same thing before searching. This is in fact a problem. Can I downgrade? If so any necessary steps?

5

The identity variables is there maybe just not in the picker but you can still just enter it by hand like insert1.identity where insert1 is the name of your insert step.

6

I assume from that then that old sites will not break with the 2.1.1 update then if query.identity is used. To be honest I have locked the ftp on every site I do in fear of this breaking them

7

Actually I just checked and the identity is there for me …

image
image.png796×666 31.8 KB

Are you sure you are checking it from the data picker?

like for example add a variable after the insert step and try to populate it with the identity.

8

And also on the client site, when the output of the insert step is on, you can see the identity as well:

image
image.png459×682 29.2 KB

Maybe reselect the insert server action of you don’t see it.

9

Mine looks like this on the repeat upload. The ins_insp.identity is before the upload. It did work before and now it does not.

{{$parent.ins_insp.identity}}

10

I need the identity value in the Server Action, not in App Structure / Data Binfings !!!
This is urgent for me !!!

11

Is it possible to have the download link of version 2.1.0? Thank you

12

it is there but its content is null

1 Like
13

I see - we had indeed some changes made to improve the identity handling for PostgreSQL and that might have caused problems for the rest of the PHP drivers.

@patrick will check it out and will post a solution here, so you can just replace a single php file to have it working.

14

well I found the bug and here is the fixed Connection.php file:

Connection.zip (1.4 KB)

extract it and replace the one in your www/dmxConnectLib/lib/db

let me know if it works.

5 Likes
15

Yes, that seems to be fixed, thanks @George

1 Like
16

Thank you @George for the weekend support! Much appreciated, confirmed works for me as well.

2 Likes
17

Thanks, Yes, that seems to be fixed, thanks @George