User tests: Successful: Unsuccessful:
cast to int client_id
go to Extensions: Update
click on Check for updates
use postgresql
`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... ^ `
it shows extension updates
Status | New | ⇒ | Pending |
Category | ⇒ | Libraries |
See: alikon/testcom#6
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.
Status | Pending | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2021-08-16 08:06:54 |
Closed_By | ⇒ | alikon | |
Labels |
Added:
?
|
@alikon Similar to this Issue? widgetfactory/jce#95 (comment)
Don't know ...
yes alikon/testcom#6 fixed it, they need
<client>site</client>
in the plugin manifest
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
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