By susata on

I am using Drupal 5.5. I'm a newbie.

I am trying to follow the instructions for adding a Calendar View, which are found here: http://drupal.org/node/133341

In the Filters Fields, when I click to Add Node=Type, this error message displays:

user warning: 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 (( REPLACE(node_data_field_when.field_when_value2,'T',' ') >='2008-01-01' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_when.field_when_value AS node_data_field_when_field_when_value, node_data_field_when.field_when_value2 AS node_data_field_when_field_when_value2, node.type FROM node node LEFT JOIN content_type_calendar_event node_data_field_when ON node.vid = node_data_field_when.vid WHERE (node.status = '1') AND (. '') AND (( REPLACE(node_data_field_when.field_when_value2,'T',' ') >='2008-01-01 00:00:00' AND REPLACE(node_data_field_when.field_when_value,'T',' ') <='2008-01-31 23:59:59')) LIMIT 0, 999 in /www/markholdaway.com/web/includes/database.mysql.inc on line 172.
_____________________________

Could someone please tell me what the database is trying to do that it can't do and possibly advise me how to fix whatever is wrong?

Thank you,
staunton

⋅ Categories: Drupal 5.x

Comments

susata’s picture

susata commented

This is fixed (I hope). This is what I did:

1) I removed all calendar content, removed the calendar view and removed the calendar event content type (that's what is used to put an entry onto the calendar).

2)Then I uninstalled the Date, Views and Calendar modules.

3)I ran Cron (absolutely no idea if that was useful, but figured it wouldn't hurt).

4)I deleted the actual module folders for Date, Views and Calendar from sites/all/modules/.

5)I downloaded from drupal.org these modules and extracted them into sites/all/modules/.

6)I enabled the 3 modules, checked access roles (they were all still checked, actually).

7)I went back and followed the step-by-step guide at: http://drupal.org/node/133341

And this time I did not get the SQL syntax error. All looks fine.

VERY happy to not see that error anymore! However, it's a bit disquieting to not understand why that error was popping up. If someone out there has a moment and knows what was making the database unhappy, I would immensely appreciate a little elucidation.

staunton