[libraries][installer] - ModuleAdapter

[alikon]

Pull Request for a partial fix to Issue #22949 .

Summary of Changes

cast to int for postgresql

Testing Instructions

see #22949

[twister65]

It fixes plugin update issue.
Very strange, the changes are in ModuleAdapter.
The module update issue is still there.

[twister65]

Please, replace $db->quote by $db->quoteName

joomla-cms/libraries/src/Installer/Adapter/ModuleAdapter.php

Line 705 in 1ea6ca6

->where($db->quote('client_id') . ' = ' . (int) $this->extension->client_id);

->where($db->quoteName('client_id') . ' = ' . (int) $this->extension->client_id);

[twister65]

I think, this line :
joomla-cms/libraries/src/Installer/Adapter/ModuleAdapter.php

Line 701 in 1ea6ca6

	$this->extension->delete($this->extension->extension_id); 

should be placed after the query (line 717), when we have finished using it.
It is better to delete the object, when we no longer need it.

[mbabker]

@twister65 That should really be a separate pull request instead of lumped in with another unrelated change.

[twister65]

See (test) PR #22993 please.

[csthomas]

I have tested this item ✅ successfully on 3617699

Code review

---

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

[Quy]

I have tested this item ✅ successfully on 3617699

---

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

[Quy]

RTC

---

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