Table 'database.jos_jevents' doesn't exist

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

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

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

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.

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

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.

it's just a duplicate test site, no problem
if know where the error, write here the result

I'd like to know which Joomla menu item in the backend you have selected?

You could try adding

$options['field'] = 'catid';

at line 23 of the file referred to above as a fix.

add $ options ['field'] = 'catid'; no effect

menu item Manage events
administrator / index.php? option = com_jevents & task = icalevent.list

but the error is also displayed in the frontend

Is it still exactly the same error message?

Can you send me login details via PM so I can take a look?

test site is on a local network not access

I tested some different situations

1) uninstall Jev3.2.15 -> clean directories and DB -> new installation Jev3.2.15 - error
2) transfer of empty tables from functional installation - error
3) clean install J3.4.1 -> update J3.4.2rc -> Installation Jev3.2.15 - OK
4) clean install J3.4.1 -> update J3.4.2rc -> Installation Jev3.2.15 -> transfer of old Jev. data tables - OK
5) another test site (different data and components / same server) update J3.4.2rc, Jev3.2.15 - OK
6) clean install J3.4.1 -> update J3.4.2rc -> Installation Jev3.2.15 -> transfer of complete old J database table - error

the only difference is the addition of DB query from the parent class JCategories

LEFT JOIN `jos_jevents` AS i
   ON i.`id` = c.id
   AND i.state = 1
   AND (i.language = '*' OR i.language = 'en-GB')

error probably relates only to this concrete installation

I will personally deal with migrating data to a clean install (associated with the upgrade server)

Thanks for your help

Is it still exactly the same error message?

the change in the table option value should remove references to the non-existent jos_jevents table

first error Table 'database.jos_jevents' doesn't exist
after add $options['table'] = '#__jevents_vevent'; - show error Unknown column 'i.id' in 'field list'
after add $options['field'] = 'catid'; show error Unknown column 'i.id' in 'field list'
after change to $options['_key'] = 'catid'; show error Unknown Column i.language' in where clause

after application update_package from older versions J3.4.1 is all OK

Thank you for confirming it!!

Hello,

could you Please explain what you mean with "after application update_package from older versions J3.4.1 is all OK". Thanks.
I have exactly the same error on my page.

Hello
i have the same Problem, im updating the jommla to 3.4.2 after the jevents dosent run:

PHP Version : 5.3.28

MySQL Version : 5.5.40

Joomla : 3.4.2

component_com_jevents : 3.1.45

module_mod_jevents_cal : 3.1.45

module_mod_jevents_custom : 3.1.45

module_mod_jevents_filter : 3.1.45

module_mod_jevents_latest : 3.1.45

module_mod_jevents_legend : 3.1.45

module_mod_jevents_switchview : 3.1.45

plugin_content_jevents : 3.2.0

plugin_finder_jevents : 3.1.45 (not enabled)

plugin_search_eventsearch : 3.1.45

The errorCode is like this:

1054 - Unknown column 'i.id' in 'field list' SQL=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 joo32_categories as c LEFT JOIN (SELECT cat.id as id FROM joo32_categories AS cat JOIN joo32_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 `joo32_jevents_vevent` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'de-DE') WHERE (c.extension='com_jevents' OR c.extension='system') AND c.access IN (1,1) 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


Thanks for help
Oli

I'll upload version 3.1.46 with a workaround in a few minutes - but you should really upgrade to JEvents 3.2.17 as a preferred solution

hi
ok where I can then download the update, so that I need not make any new templates.
thanks for the help
Greeting Oli

I just upgraded to 3.2.17 and still get the same error if I enable the "JEvents Latest Events"-Module. You can see the error message on www willroth de

PHP Version : 5.4.40-nmm1

MySQL Version : 5.5.43-nmm1-log

*** CONFIG NOT SAVED*** 

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Load JEvents Bootstrap JS? : Yes

Max Input Vars ? : 1000

Club code set? : No  

Joomla : 3.4.2

component_com_jevents : 3.2.16

component_com_jce : 2.5.2

module_mod_jevents_cal : 3.2.17

module_mod_jevents_custom : 3.2.17

module_mod_jevents_filter : 3.2.17

module_mod_jevents_latest : 3.2.17

module_mod_jevents_legend : 3.2.17

module_mod_jevents_switchview : 3.2.17

plugin_content_jevents : 3.2.17

plugin_finder_jevents : 3.2.17 (not enabled)

plugin_search_eventsearch : 3.2.17 (not enabled)

BR

Hello,

For some reason the package hasn't worked correctly.

Geraint is uploading 3.2.18 now.

Please update.

Thanks
Tony