SQLSTATE[42000]: Syntax error or access violation: 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(( (node.type IN ('agreservations_unittype')) )))) subquery' at line 3

Followed steps exactly

Comments

agill’s picture

agill commented

Hello!
Could you please post the full error message
and where it occured? That way it is easier to debug.

Naturalist’s picture

Naturalist commented

Agill
That is the full error message and it occurs when viewing agreservations catalog view (views) in edit mode.

agill’s picture

agill commented

if you use the newest dev of the views module this error should be fixed.
also there where some notices about undefined indexes when viewing the agres_uc_catalog view
these should be solved with the newest commit i did.
The new dev should have the date 2012-01-31.

Naturalist’s picture

Naturalist commented

Tried the dev no luck still there. I also get this when trying to view the booking calendar
Fatal error: Class 'calendar_plugin_row' not found in /xxxxxxxxx.com/modules/agreservations/agres_views/includes/agres_views_plugin_row_node.inc on line 25
Availability calendar works fine

Great the views dev didn't do anything but your new dev did! Booking Calendar still no go. I almost sure there was a module for the booking calendar in the alpha version but there isn't one in the dev? I think that is the problem.

agill’s picture

agill commented

Hello,
the calendar_plugin_row class which is used and extended in the ages_view modules
agres_views_plugin_row and agres_views_plugin_row_node classes is new, so
it could be, that you do not have it yet in your calendar module. try upgrading
the calendar module.

Naturalist’s picture

Naturalist commented

Your new def fixed it. I was pointing out that the new views dev did not. Thx Agill