Autoaction throws SQL error

I wrote my own point reward system where various user actions get points in my own table.

One is a simple SQL after onAfterFirstLogin:
This was working great in J3 and now throws this error in J4:

Incorrect integer value: '' for column `numnalac`.`ngury_user_points_history`.`user_id` at row 1

But the table is actually updated correctly with the correct user_id. It's like the SQL runs twice but the 1st time has "incorrect integer value"?

I have no condition to execute the SQL and output is none.  There are no constraints on the columns in the table.

Perhaps something needs to be changed for J4?

Are you sure that error is coming from CB Auto Actions? CB Auto Actions catches all errors and would only display that error if debug mode for the auto action is enabled. It would also display it in the following format.

Is it possible you've something else configured or installed that could be making the query that's erroring?

OK, I think I found it. I had 2 autoactions for onAfterFirstLogin. The one above works fine but the other one is attempting to give points to the person who invited them. It's the only one with debug on.

But the test person I was using was added manually with no invite, so I had this Condition to exclude it:
Field: Value
Custom Value: $( '#cb_referrer_id' )
Operator: Not Empty

cb_referrer_id is a field I created that runs Query:
SELECT `user_id`
FROM `#__comprofiler_plugin_invites`
WHERE `user` = '[user_id]'
LIMIT 1

I don't know why that condition fails and tries to run the auto action sql anyway.

But then the "no page found" error page I get is because CB was still configured to go to J3 profile, so I fixed that.  Now when I repeat the new member process, he logs into his profile but just sees the error message "Incorrect integer value: '' for column `numnalac`.`ngury_user_points_history`.`user_id` at row 1 " at the top.

Field: Value
Custom Value: $( '#cb_referrer_id' )
Operator: Not Empty

That's not a valid condition. You seam to be trying to run jQuery? If you want to check if they have a referrer id just select that field from the dropdown or condition against [cb_referrer_id] custom value.

lol. I think I was copying some post on here....  So I just selected the field instead and no more error.

Thanks.