Submit Event as Menus causes error 500

  • Matthias Blaß
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 4 months ago #23502 by Matthias Blaß
Submit Event as Menus causes error 500 was created by Matthias Blaß
Hi Tuan,

i installed EB Version 1.5.2 on Joomla! 3.0.2 Stable with ZOO an Widgetkit.

Everything works fine but if i setup a menu item for "submit event" it causes an server error 500 after logging in an klicking the menu item.
I can open the "my events" page without problems. But "submit events doesn't work.

The error message ist "SQL=SELECT id, title FROM joskas_content WHERE sectionid=0 AND catid=0"

It doesn't work with admin nor registered users. The menu item is setup for registered users only.

Do you have any idea?

Best regards,
Matthias

Cheers Matthias

[I use Membershop Pro 1.5.3, with Event Booking 1.5.2 and Joomla 3.0.2]

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #23518 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Submit Event as Menus causes error 500
Hi

Yes. I can confirm this bug (it only happens with Joomla 3.0.x). Please follow instructions below to get it fixed :

1. Open the file components/com_eventbooking/views/event/view.html.php

2. Find the code below (line 228 if you are using latest version) :
Code:
$sql = 'SELECT id, title FROM #__content WHERE sectionid=0 AND catid=0 ';

3. Change it to :
Code:
$sql = 'SELECT id, title FROM #__content';

After that, the issue should be fixed.

Please do that and let me know the result !

Tuan

Please Log in or Create an account to join the conversation.

  • Matthias Blaß
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 4 months ago - 12 years 4 months ago #23522 by Matthias Blaß
Replied by Matthias Blaß on topic Re: Submit Event as Menus causes error 500
I found this code in line 258 ,)

But the fix works very well.

Thanks for the quick reply.

Cheers Matthias

[I use Membershop Pro 1.5.3, with Event Booking 1.5.2 and Joomla 3.0.2]
Last edit: 12 years 4 months ago by Matthias Blaß.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #23539 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Submit Event as Menus causes error 500
OK Mathias. Thanks for confirming. I will update the download package with this fix shortly .

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc