? ? Pending

User tests: Successful: Unsuccessful:

avatar SharkyKZ
SharkyKZ
9 Mar 2020

Summary of Changes

Fixes module loading on PostgreSQL.

Testing Instructions

This needs to be tested on PostgreSQL.

Insert a module into an article.
View the article in frontend.

Expected result

Module appears.

Actual result

Module doesn't appear.

Documentation Changes Required

No.

avatar SharkyKZ SharkyKZ - open - 9 Mar 2020
avatar SharkyKZ SharkyKZ - change - 9 Mar 2020
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 9 Mar 2020
Category Libraries
avatar richard67
richard67 - comment - 9 Mar 2020

@SharkyKZ How is that related to PR #28269 ? I see that one and this one here do concurrent changes in the same file, and I think for the same purpose, one in staging and one in 4.0-dev. Or do I understand something wrong?

avatar mbabker
mbabker - comment - 9 Mar 2020

The two PRs are unrelated.

avatar SharkyKZ
SharkyKZ - comment - 9 Mar 2020

It's ultimately the same issue. The issue exists in staging and should be fixed there. Also #28269 doesn't work correctly on PDO as noted in the comments. Meanwhile, this works correctly on all database drivers and will work when it reaches 4.0.

avatar SharkyKZ
SharkyKZ - comment - 9 Mar 2020

Though for 4.0 we could change argument type to integer as discussed in #26531.

avatar mbabker
mbabker - comment - 9 Mar 2020

FWIW this is needed regardless of whatever external facing API changes someone wants to propose. The issue here is the database results come back in an inconsistent type so typecasting is needed to not break the function’s internal flow.

How is this different than the other PR? That is aiming to change the public API of the method, this one typecasts the database results to align with the currently documented public API (so you still have to pass a string identifier in here, a non-string will fail the strict comparison).

avatar richard67
richard67 - comment - 12 Mar 2020

@SharkyKZ I've applied your patch and done as instructed but still can't see that bloody module. Am using PotsgreSQL 11 on PHP 7.3 with the native postgresql driver. Should I use the PDO driver instead? I'll try in a while.

avatar richard67
richard67 - comment - 12 Mar 2020

@SharkyKZ False alarm, used the wrong module, popular tags. Seems there are none. With Breadcrumbs it works ;-)

avatar richard67
richard67 - comment - 12 Mar 2020

I have tested this item successfully on f02c086

Hint for other testers: You have to use PostgreSQL (PDO) to reproduce the issue. With the native PostgreSQL driver the issue doesn't happen here with PostgreSQL 11.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/28278.

avatar richard67 richard67 - test_item - 12 Mar 2020 - Tested successfully
avatar jwaisner
jwaisner - comment - 14 Apr 2020

I have tested this item successfully on f02c086

Tested successful on PostgreSQL (PDO) 11.3


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/28278.

avatar jwaisner jwaisner - test_item - 14 Apr 2020 - Tested successfully
avatar jwaisner jwaisner - change - 14 Apr 2020
Status Pending Ready to Commit
avatar jwaisner
jwaisner - comment - 14 Apr 2020

RTC


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/28278.

avatar richard67
richard67 - comment - 14 Apr 2020

I've just tested that nothing is broken for MySQLi and MySQL (PDO). All ok.

avatar richard67 richard67 - change - 14 Apr 2020
Labels Added: ? ?
avatar HLeithner HLeithner - close - 14 Apr 2020
avatar HLeithner HLeithner - merge - 14 Apr 2020
avatar HLeithner HLeithner - change - 14 Apr 2020
Status Ready to Commit Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2020-04-14 21:05:39
Closed_By HLeithner
Labels
avatar HLeithner
HLeithner - comment - 14 Apr 2020

Thanks

Add a Comment

Login with GitHub to post a comment