Table 'database.jos_jevents' doesn't exist

I can see in the code where the error appears - I just can't think what you would be doing in Joomla to make it happen.

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

FROM jos_categories as c

LEFT JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_jevents'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id

LEFT JOIN `jos_jevents_vevent` AS i
ON i.`catid` = c.id
AND i.state = 1
AND (i.language = '*' OR i.language = 'cs-CZ')

WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,2,3,5,14,15)
AND c.published = 1
AND badcats.id is null

GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

ORDER BY c.lft


Error
Unknown column 'i.id' in 'field list' SQL=EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM jos_categories as c LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_jevents' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `jos_jevents_vevent` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'cs-CZ') WHERE (c.extension='com_jevents' OR c.extension='system') AND c.access IN (1,1,2,3,5,14,15) AND c.published = 1 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft


Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/components/com_jevents/helpers/category.php:43
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_jevents/libraries/dbmodel.php:76
JROOT/administrator/components/com_jevents/controllers/icalevent.php:115
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_jevents/jevents.php:158
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:47

Where do you see this error arising - its related to counting items in some way but I can't find in Joomla where you would be making this sort of call.

Can you enable debug and show us the full query? I see you are on Joomla! 3.4.2 so it might be slightly different to our tests.

Thanks
Tony

After changing error 1054 Unknown column 'i.id' in 'field list'

This is a bug - please change line 22 of components/com_jevents/helpers/category.php to read

$options['table'] = '#__jevents_vevent';

Thanks for highlighting the issue