TOPIC: SQL Error 1064 with sorting categories and event registration form, help!!

Please help me out

I just opened/published an event and got the following error. Since people want to register at this moment I am urgenlty looking for a sollutiuo

When I go to the (front end) 'register for event' form I get the following 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 'order by member desc LIMIT 0, 1' at line 1 SQL=select SQL_CALC_FOUND_ROWS * from zrr_dtregister_event_detail where slabId=3 and member <= order by member desc LIMIT 0, 1

The fields are displayed. The total registration costs on top of the fields is missing and is substituted with this error message. When I press F5, the error is gone and the registration costs are displayed. Every time I go again to the registration page this error is displayed and dissapears after pressing F5. It doesn't matter if I go via the event list or via the single event registration.

On the backend, when I go to the categories and click on the arrow to sort the list I get the following 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 rgt <= ) order by lft asc' at line 1 SQL=Select * from zrr_dtregister_categories where parent_id > 0 and NOT(lft >= and rgt <= ) order by lft asc

Then I am redirected to the Joomla main menu

This is not crucial, but perhaps this is related?

Help is very much appreciated!!

(joomla 3.3.6, DT-register 3.0.9a)

Maybe I found something but I don't know how to fix it or how it is caused.

In the SQL statement "member <= order" there is no number after '<=".

The second error I also see a number missing : "NOT(lft >= and rgt <= )"

I am having a similar error with my event registration. Only with group registration here is the error!

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 36 SQL=select g.id as group_id , g.member as group_member , g.type as group_type , g.amount as group_amount , epc.prerequisite_id as prerequisitecategory_prerequisite_id, ep.prerequisite_id as prerequisite_prerequisite_id , f.id as file_id , f.path as file_path , f.event_id as file_event_id, fo.id as feeorder_id , fo.eventId as feeorder_eventId , fo.type as feeorder_type ,fo.reference_id as feeorder_reference_id , fo.title as feeorder_title , fo.ordering as feeorder_ordering , l.id as location_id , l.name as location_name , l.address as location_address , l.address2 as location_address2 , l.city as location_city , l.state as location_state , l.zip as location_zip , l.country as location_country , l.phone as location_phone , l.email as location_email , l.website as location_website , l.image as location_image , l.showimage as location_showimage from qaumw_dtregister_group_event e left join qaumw_dtregister_event_detail g on e.slabId = g.slabId left join qaumw_dtregister_prerequisite_category epc on epc.event_id = e.slabId left join qaumw_dtregister_prerequisite ep on ep.event_id = e.slabId left join qaumw_dtregister_files f on f.event_id = e.slabId left join qaumw_dtregister_feeorder fo on fo.eventId = e.slabId left join qaumw_dtregister_locations l on l.id = e.location_id where e.slabId =
It appears the page you were looking for doesn't exist. Sorry about that.

@ZeilraceRally please submit a ticket referencing this post. We have fixed this issue for the next update. We can apply it to your site if you'll provide admin access in the ticket. Thanks!

I submitted a ticket as well with a similar issue.

This was VERY frustrating...as I had recently switched to cloudflare at the same time and I thought that caching was my problem. I even spent $100 purchasing a competitors event registration trying to get this to work.

I guess I should have checked the forums first. Please check my ticket and apply the update to my....I was about to burst a blood vessel.

@nathan I am getting the same error except the error number is 1107. I put in a ticket towards the end of december and updated it, but have received no response. This is my busiest sales time of the year and I'm unable to do business! Please check my ticket!