Wednesday, 24 June 2015
  26 Replies
  7.2K Visits
0
Votes
Undo
After updating two test sites, one works OK, but on the second is error jos_jevents table does not exist

PHP Version : 5.6.10
MySQL Version : 5.5.5-10.1.5-MariaDB
Joomla : 3.4.2-rc
component_com_jevents : 3.2.15
component_com_jce : 2.5.2
module_mod_jevents_cal : 3.2.15
module_mod_jevents_custom : 3.2.15
module_mod_jevents_filter : 3.2.15
module_mod_jevents_latest : 3.2.15
module_mod_jevents_legend : 3.2.15
module_mod_jevents_switchview : 3.2.15
plugin_content_jevents : 3.2.15
plugin_finder_jevents : 3.2.15
plugin_search_eventsearch : 3.2.15

1146 Table 'database.jos_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 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` 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
Wednesday, 01 July 2015 10:13
·
#151278
0
Votes
Undo
You are very welcome.

Thank you
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!

Wednesday, 01 July 2015 09:56
·
#151277
0
Votes
Undo
Perfect. Thank you for the quick support!
Wednesday, 01 July 2015 09:52
·
#151276
0
Votes
Undo
hello
ok thank you very much, now everything works again, great support.
Greeting Oli
Wednesday, 01 July 2015 09:48
·
#151275
0
Votes
Undo
Do not uninstall first since Joomla will remove all your categories if you do that.

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!

Wednesday, 01 July 2015 09:47
·
#151274
0
Votes
Undo
Hello,

No it does't make and changes like that. All our packages and installable over.

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!

Wednesday, 01 July 2015 09:42
·
#151273
0
Votes
Undo
hi
I can simply download and install the 3.2:18 on enlargement the zip ok heights that it overrides my settings?
thanks
Greeting Oli
Wednesday, 01 July 2015 09:36
·
#151272
0
Votes
Undo
Hello,

For some reason the package hasn't worked correctly.

Geraint is uploading 3.2.18 now.

Please update.

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!

Wednesday, 01 July 2015 09:24
·
#151271
0
Votes
Undo
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
Wednesday, 01 July 2015 09:19
·
#151270
0
Votes
Undo
hi
ok where I can then download the update, so that I need not make any new templates.
thanks for the help
Greeting Oli
Wednesday, 01 July 2015 08:57
·
#151269
0
Votes
Undo
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

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!

Wednesday, 01 July 2015 08:30
·
#151268
0
Votes
Undo
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
Wednesday, 01 July 2015 07:31
·
#151267
0
Votes
Undo
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.
Friday, 26 June 2015 09:29
·
#151266
0
Votes
Undo
Thank you for confirming it!!
Thursday, 25 June 2015 12:10
·
#151265
0
Votes
Undo
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
Thursday, 25 June 2015 11:00
·
#151264
0
Votes
Undo
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

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!

Thursday, 25 June 2015 07:52
·
#151263
0
Votes
Undo
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
Wednesday, 24 June 2015 15:38
·
#151262
0
Votes
Undo
Is it still exactly the same error message?

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

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!

Wednesday, 24 June 2015 13:51
·
#151261
0
Votes
Undo
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
Wednesday, 24 June 2015 13:32
·
#151260
0
Votes
Undo
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.

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!

Wednesday, 24 June 2015 13:27
·
#151259
0
Votes
Undo
it's just a duplicate test site, no problem
if know where the error, write here the result
  • Page :
  • 1
  • 2
There are no replies made for this post yet.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.