1. Rob Swart
  2. General Talk
  3. Wednesday, 28 May 2014
  4.  Subscribe via email
Hi Yves,

I've found some bugs and solutions to them.
I'm not really a php programmer, so I don't know if my solutions are truly ok, but they work for me.

1. SQL error when publishing or unpublishing an event in the administrator eventlist.
When clicking on the publish icon or when selecting an event and clicking the publish of unpublish button this error appears:
"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 ')' at line 1 SQL=UPDATE vpcb_matukio_recurring SET published = '0' WHERE event_id IN ()"
As you can see the eventId is not filled.

My solution:
File: /administrator/components/com_matukio/controllers/eventlist.php
Find: public function publish() and after that // Update recurring events (line 106)
Add after this line the following code:
$db = JFactory::getDbo();
$cids = implode(',', $ids);

2. When editing a booking, my participants keep getting an error saying they did not accept the terms and conditions.
This is while the box for accepting is filled. I think it's because this box is disabled in some cases.

My solution:
File: /components/com_matukio/views/event/tmpl/default.php
Find: “// AGB-Bestaetigung anzeigen”
Disable the four lines of code on and after line 874:
// if ($this->art == 0 OR $this->art == 2 OR $this->art == 1 OR $this->art == 4 OR $tempdis != "";)
// {
// $htx1 .= " disabled";
// }

I have no idea if I've killed some other function by doing this, but after extensive testing everything seems fine.

Maybe you can use this. Maybe not. Do with it whatever you like B)
It's also possible that I have overlooked the obvious and that there are other solutions to these bugs. Please tell me if so.
Responses (13)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Hotspots Pro 6.0.13 compatability with Joomla 5.3.
Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
2 Replies
Posted on Friday, 04 July 2025
  • New
  • some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025
  • New
  • Trying to resize the image in the comments
    Hey everyone, Basically I am trying to make the images in the comments smalle...
    9 Replies
    Posted on Wednesday, 12 August 2009
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    2 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    error message when adding/cofiguring email address
    When configuring the email plugin that send a email message to admin when a new ...
    0 Replies
    Posted on Friday, 09 May 2025