[5.3] fix preprocess rule if contains alias (pgsql)

heelc29 commented 1 week ago

Summary of Changes

fix database exception in preprocessrule (new in #43992)

Only with PostgreSQL database

Testing Instructions

create an contact
create an menu item for the new contact
open https://example.com/index.php?option=com_contact&view=contact&id={contact.id}:{contact.alias}

Actual result BEFORE applying this Pull Request

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: "xx:xxx"
CONTEXT:  unnamed portal parameter $1 = '...'

redirect to home menu item (see also systemtests in upmerge pr #44456)

Expected result AFTER applying this Pull Request

redirect to contact menu item

Link to documentations

Please select:

[x] No documentation changes for docs.joomla.org needed
[x] No documentation changes for manual.joomla.org needed

richard67 commented 1 week ago

I have tested this item :white_check_mark: successfully on 998dfad63721fc2b7e633517206057f0b6a7268a

Hint for other testers: The error mentioned in the actual result of the testing instructions is not shown anywhere on the site. It can be found in the database server log, e.g. on Ubuntu with PostgreSQL 14 in file "/var/log/postgresql/postgresql-14-main.log".

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/44459.}

richard67 commented 1 week ago

@alikon Could you test this PR here with PostgreSQL?

joomla / joomla-cms