Hi, I foud only the first error, and I solved au contraire: "boolean NOT NULL DEFAULT false"

I found same erroneous definition in installer/create-database.php:
// failed_login_attempts
$oDB->createCommand()->createTable('{{failed_login_attempts}}', array(
'id' => "pk",
'ip' => "string(40) NOT NULL",
'last_attempt' => "string(20) NOT NULL",
'number_attempts' => "integer NOT NULL",
'is_frontend' => "boolean NOT NULL DEFAULT 0"
), $options);

which is correct field type? int or bool ?

Hi, may be is better your solution (boolean NOT NULL DEFAULT false), because at the code which read the field is_frontend hopes a boolean var.

I'm going to test these changes in a test enviroment.
Error log:
LINE 1: ...E number_attempts > 10 AND ip = '147.156.9.8' AND is_fronten...
^. La sentencia SQL ejecutada fue: SELECT * FROM "lime_failed_log in_attempts" "t" WHERE number_attempts > :attempts AND ip = :ip AND is_frontend = :is_frontend LIMIT 1

Regards

@DenisChenu please check this.

Ah wait, this is related to Patricia's fix.

Yeah, this is related to Patricia's fix, we did not test with Postgress

The second problem is update 482 by Denis, I think.

Arg : need to reset PK during update …

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33326

Resolved or only first part resolved?

Also should be tested. And reviewed?

Seems PK reset broken ?

Dunno. @DarioRoig Can you test with the latest master branch too, perhaps?

Fixed in Release 5.3.4+220309