Wednesday, 01 July 2015
  1 Replies
  1.2K Visits
0
Votes
Undo
Hello,

After the last joomla update, my site doesn't work with this error message :

Table 'mysitecw.newsite16_jevents' doesn't exist 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 newsite16_categories as c LEFT JOIN (SELECT cat.id as id FROM newsite16_categories AS cat JOIN newsite16_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 `newsite16_jevents` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'fr-FR') 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


The site work when I desactivate this module : JEvents Latest Events

Thank you for your help
Wednesday, 01 July 2015 09:35
·
#151751
0
Votes
Undo
Please update to JEvents 3.2.17 or 3.2.18 which is due out shortly.

Both this error.

Thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

  • Page :
  • 1
There are no replies made for this post yet.