? Pending

User tests: Successful: Unsuccessful:

avatar alikon
alikon
16 Aug 2021

Summary of Changes

cast to int client_id

Testing Instructions

go to Extensions: Update
click on Check for updates
use postgresql

Actual result BEFORE applying this Pull Request

`An error has occurred.

22 22P02, 7, ERROR: invalid input syntax for integer: "" LINE 3: ...ement = 'job' AND type = 'plugin' AND client_id = '' AND fol... ^ `

Expected result AFTER applying this Pull Request

it shows extension updates

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
3.00

avatar alikon alikon - open - 16 Aug 2021
avatar alikon alikon - change - 16 Aug 2021
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 16 Aug 2021
Category Libraries
avatar zero-24
zero-24 - comment - 16 Aug 2021

Can you show us the update server that gets this error? The client_id fallback in the XML is removed with 4.0 and the "client" [admininstator|site] should now be used without fallback

avatar zero-24
zero-24 - comment - 16 Aug 2021
avatar alikon
alikon - comment - 16 Aug 2021

merged
i was confused by : https://docs.joomla.org/Deploying_an_Update_Server

Warning! Plugins and front-end modules are automatically installed with a client of 0 (site), but you will need to specify the client in an update or it will default to 1 (administrator) and then found update would not be shown because it would not match any extension.

avatar alikon alikon - close - 16 Aug 2021
avatar alikon alikon - change - 16 Aug 2021
Status Pending Closed
Closed_Date 0000-00-00 00:00:00 2021-08-16 08:06:54
Closed_By alikon
Labels Added: ?
avatar ChristineWk
ChristineWk - comment - 16 Aug 2021

@alikon Similar to this Issue? widgetfactory/jce#95 (comment)
Don't know ...


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

avatar alikon
alikon - comment - 16 Aug 2021

yes alikon/testcom#6 fixed it, they need
<client>site</client> in the plugin manifest

avatar zero-24
zero-24 - comment - 16 Aug 2021

The new client setting works for 3.x already too but we had a fallback thats gone since nearly one year in 4.0: #28767

avatar shawn61cp
shawn61cp - comment - 13 Mar 2023

I am experiencing this issue on both an upgrade to, and a fresh install of, J! 4.2.8. I get this error any time I install an extension.
Joomla!: 4.2.8
PostgreSQL: 14
Ubuntu: 22.04


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

Add a Comment

Login with GitHub to post a comment