[5.X] Global Checkin scheduler plugin fails on SQL Views about joomla-cms HOT 8 CLOSED

related issue #41149 ?

from joomla-cms.

i'm unable to reproduce with this view

CREATE VIEW `#__blog` AS SELECT `title` ,`checked_out` ,`checked_out_time` FROM `#__content`

global checkin task runs fine

from joomla-cms.

yes because this view is updateable, you need a view which does a bit more (I extract xml and override existing columns)

from joomla-cms.

related issue #41149 ?

no it's a completely different topic

from joomla-cms.

ah ok my bad

so with this view

CREATE VIEW j510_blog AS
 select title, checked_out, checked_out_time from j510_content
 union ALL
Select  'a', null, null 

then the task will fail

i think we need to exclude from $tables = $db->getTableList(); the non updatable views

i'll check better after work

from joomla-cms.

https://github.com/joomla-framework/database/blob/3.x-dev/src/Mysqli/MysqliDriver.php#L630

should only return tables (like the postgres version)

SHOW FULL TABLES WHERE Table_type='BASE TABLE'

should work, (it returns 2 columns but the called loadColumn() returns only the first column so should be fine)

from joomla-cms.

yes indeed

from joomla-cms.

thanks for the framework pr joomla-framework/database#297 I think we can close this here

from joomla-cms.