MySQL errors after joomla/jevents updates

By Guest on Tuesday, 06 June 2017

Replies 7

Likes 0

Views 1.1K

Votes 0

J 3.7.2
JEV 3.4.39

After upgrading to J3.7, any pages with JEvents content now display: the error "... #__jev_files' doesn't exist"
This is definitely the case, as I do not have a jev_files table. However, I'm not sure why it is asking for one. We've upgraded Jevents, but still getting the error.

Any ideas?

Thanks in advance!

Hello,

Can you please provide your JEvents Support Info from your JEvents control panel? jev_files is part of a club addon.

Many thanks
Tony

Guest

Thursday, 08 June 2017 09:35

0 Likes

0 Votes

0 Comments

#189286



PHP Version : 5.6.30

MySQL Version : 5.6.28-76.1-log

Server Information : Linux us6.siteground.us 3.12.18-clouder0 #85 SMP Mon Apr 3 10:28:14 EEST 2017 x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 3000

Club code set? : Yes  

User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36  

Joomla : 3.7.1

component_com_jevents : 3.4.3

component_com_jeventstags : 3.4.0

component_com_jevlocations : 3.4.0RC8

component_com_jce : 2.6.12

component_com_acymailing : 4.9.4

module_mod_acymailing : 3.7.0

module_mod_jevents_cal : 3.4.3

module_mod_jevents_custom : 3.4.3

module_mod_jevents_filter : 3.4.3

module_mod_jevents_latest : 3.4.3

module_mod_jevents_legend : 3.4.3

module_mod_jevents_switchview : 3.4.3

module_mod_jevlocations : 3.4.0RC8

layout_extplus : 3.4.0

layout_flatplus : 3.4.0

layout_iconic : 3.5.0

layout_ruthin : 3.4.0

layout_smartphone : 3.0.10

plugin_acymailing_contentplugin : 3.7.0 (not enabled)

plugin_acymailing_geolocation : 4.9.0

plugin_acymailing_managetext : 1.0.0

plugin_acymailing_online : 3.7.0

plugin_acymailing_plginboxactions : 4.9.0

plugin_acymailing_share : 1.0.0

plugin_acymailing_stats : 3.7.0

plugin_acymailing_tablecontents : 1.0.0

plugin_acymailing_tagcbuser : 3.7.0 (not enabled)

plugin_acymailing_tagcontent : 3.7.0

plugin_acymailing_tagmodule : 4.9.0

plugin_acymailing_tagsubscriber : 4.9.0

plugin_acymailing_tagsubscription : 4.9.0

plugin_acymailing_tagtime : 4.9.0

plugin_acymailing_taguser : 4.9.0

plugin_acymailing_template : 4.9.0

plugin_acymailing_urltracker : 4.9.0

plugin_content_jevents : 3.4.3

plugin_content_jevlocation_embed : 3.4.0RC8 (not enabled)

plugin_editors_acyeditor : 4.9.0

plugin_finder_jevents : 3.4.3

plugin_jevents_jevcalendar : 3.0.5

plugin_jevents_jevcustomfields : 3.1.23

plugin_jevents_jevfacebooksocial : 3.0.7 (not enabled)

plugin_jevents_jevfiles : 3.4.3

plugin_jevents_jevlocations : 3.4.0RC8

plugin_jevents_jevtags : 3.1.3

plugin_search_eventsearch : 3.4.3

plugin_search_jevlocsearch : 3.4.0RC8 (not enabled)

plugin_system_acymailingclassmail : 4.9.0 (not enabled)

plugin_system_acymailingurltracker : 4.9.0

plugin_system_gwejson : 3.4.3

plugin_system_regacymailing : 4.9.0

Guest

Wednesday, 14 June 2017 20:09

0 Likes

0 Votes

0 Comments

#189651

Please update your club addons. This one is a must:
https://www.jevents.net/download-area/silver-downloads/category/standard-image-file-uploads

Many thanks
Tony

Guest

Wednesday, 14 June 2017 21:03

0 Likes

0 Votes

0 Comments

#189659

I just updated that extension, and no luck.



PHP Version : 5.6.30

MySQL Version : 5.6.28-76.1-log

Server Information : Linux us6.siteground.us 3.12.18-clouder0 #85 SMP Mon Apr 3 10:28:14 EEST 2017 x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 3000

Club code set? : Yes  

User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36  

Joomla : 3.7.2

component_com_jevents : 3.4.39

component_com_jeventstags : 3.1.2

component_com_jevlocations : 3.4.17

component_com_jce : 2.6.12

component_com_acymailing : 4.9.4

module_mod_acymailing : 3.7.0

module_mod_jevents_cal : 3.4.39

module_mod_jevents_custom : 3.4.39

module_mod_jevents_filter : 3.4.39

module_mod_jevents_latest : 3.4.39

module_mod_jevents_legend : 3.4.39

module_mod_jevents_switchview : 3.4.39

module_mod_jevlocations : 3.4.17

layout_extplus : 3.4.0

layout_flatplus : 3.4.0

layout_iconic : 3.5.0

layout_ruthin : 3.2.4

plugin_acymailing_contentplugin : 3.7.0 (not enabled)

plugin_acymailing_geolocation : 4.9.0

plugin_acymailing_managetext : 1.0.0

plugin_acymailing_online : 3.7.0

plugin_acymailing_plginboxactions : 4.9.0

plugin_acymailing_share : 1.0.0

plugin_acymailing_stats : 3.7.0

plugin_acymailing_tablecontents : 1.0.0

plugin_acymailing_tagcbuser : 3.7.0 (not enabled)

plugin_acymailing_tagcontent : 3.7.0

plugin_acymailing_tagmodule : 4.9.0

plugin_acymailing_tagsubscriber : 4.9.0

plugin_acymailing_tagsubscription : 4.9.0

plugin_acymailing_tagtime : 4.9.0

plugin_acymailing_taguser : 4.9.0

plugin_acymailing_template : 4.9.0

plugin_acymailing_urltracker : 4.9.0

plugin_content_jevents : 3.4.39

plugin_content_jevlocation_embed : 3.4.17 (not enabled)

plugin_editors_acyeditor : 4.9.0

plugin_finder_jevents : 3.4.39 (not enabled)

plugin_installer_jeventsinstaller : 3.4.39

plugin_jevents_jevcustomfields : 3.1.23

plugin_jevents_jevfacebooksocial : 3.0.7

plugin_jevents_jevfiles : 3.7.14

plugin_jevents_jevlocations : 3.4.17

plugin_jevents_jevtags : 3.1.2

plugin_search_eventsearch : 3.4.39

plugin_search_jevlocsearch : 3.4.17 (not enabled)

plugin_system_acymailingclassmail : 4.9.0 (not enabled)

plugin_system_acymailingurltracker : 4.9.0

plugin_system_gwejson : 3.4.39

plugin_system_regacymailing : 4.9.0

Guest

Thursday, 15 June 2017 16:26

0 Likes

0 Votes

0 Comments

#189696

I found a couple of other outdated extensions. Once they were updated, it works fine.

Thanks for the help!

Guest

Thursday, 15 June 2017 20:25

0 Likes

0 Votes

0 Comments

#189707

Actually, now I get an error when trying to save an event from the backend – Unknown column 'tzid' in 'field list'

Any ideas on this one?

Guest

Friday, 16 June 2017 18:09

0 Likes

0 Votes

0 Comments

#189746

Hello,

Please reinstall JEvents from the download package. It should fix any tables.

Many thanks
Tony

Guest

Saturday, 17 June 2017 16:34

0 Likes

0 Votes

0 Comments

#189761