By Guest on Monday, 24 August 2015
Replies 3
Likes 0
Views 2.1K
Votes 0
Hello guys,
in my jevents installation, I got an error trying to delete some events. The events were created by synchronising with a google calendar but now I can't delete the calendar and also no events of that.
I got the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND language='de-DE'' at line 1 SQL=SELECT *, summary as title, description as content FROM asY2V_jevents_translation WHERE evdet_id IN() AND language='de-DE'


My support info:

PHP Version : 5.6.10-nmm1
MySQL Version : 5.5.43-nmm1-log
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Load JEvents Bootstrap JS? : Yes
Max Input Vars ? : 1000
Club code set? : No
Joomla : 3.4.3
component_com_jevents : 3.2.19
component_com_jce : 2.5.2
module_mod_jevents_cal : 3.2.19
module_mod_jevents_custom : 3.2.19
module_mod_jevents_filter : 3.2.19
module_mod_jevents_latest : 3.2.19
module_mod_jevents_legend : 3.2.19
module_mod_jevents_switchview : 3.2.19
plugin_content_jevents : 3.2.19
plugin_finder_jevents : 3.2.19 (not enabled)
plugin_search_eventsearch : 3.2.19


I hope you can help me out with that?

Thanks,
Simon
Hi Simon,

Can you send me super user logins please?

And the name of the event you want to delete?

Looks like there is an issue with our query on multi-language sites.

Thanks
Tony
·
Monday, 24 August 2015 10:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I have fixed this on your site.

The fix was always in JEvents 3.4RC. Unfortunately we didn't make a 3.2.20 release yet.

Many thanks
Tony
·
Monday, 24 August 2015 22:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,


thank your for your support!
Everything is ok now.

Greetings,
Simon
·
Wednesday, 26 August 2015 10:00
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post