I upgraded first to the latest fullcalendar release and then to the latest dev version. I currently have installed:
Views 7.x-3.x-dev (2011-Oct-12) and
Date 7.x-2.x-dev (2011-Sep-08)

When I run update.php, I get this error message after no error messages on the upgrade page and then going to the home page:

Operating in maintenance mode. Go online.
Debug:

'Exception: 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 \'FROM
node node
WHERE (( (node.status = \'1\') ))\' at line 1'

in views_plugin_query_default->execute() (line 1386 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).

Error message

Notice: Undefined property: views_plugin_query_default::$fields in views_plugin_query_default->query() (line 1153 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->compile_fields() (line 1071 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Notice: Undefined property: views_plugin_query_default::$fields in views_plugin_query_default->query() (line 1153 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->query() (line 1155 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->compile_fields() (line 1071 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).

What am I doing wrong? Any guidance will be appreciated. Thanks.

Comments

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
CreditAttribution: tim.plunkett commented
Title: upgrade problems » Upgrade problem
Assigned: miasmo » Unassigned

That's on the homepage? Ouch, I'm sorry.
Are you able to edit your view at all?

miasmo’s picture

miasmo CreditAttribution: miasmo commented

Hi. Thanks for the response. I didn't try to edit the view. I just restored my site to the latest backup from before I upgraded to the newest FullCalendar version. I thought perhaps I had incompatible versions of Views or Date.

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
CreditAttribution: tim.plunkett commented

I'm glad to hear you had a backup. It is very likely FullCalendar is the culprit, but I'm not necessarily sure of that. 332 people are reported as using the new alpha version, with an additional 196 using some version of the dev (http://drupal.org/project/usage/fullcalendar), and you were the first to report an error.

If you attempt another upgrade, and it doesn't work, it would be very helpful if you could provide a sanitized database for me to test. Hopefully it won't come to that though :)

Geijutsuka’s picture

Geijutsuka CreditAttribution: Geijutsuka commented

This might shed some light on the situation...

I think the error message part of your problem may be Views. After changing my site's theme to a new one, I don't get the SQL syntax error message, but I do get the exact same slew of Views errors on every page:

Notice: Undefined property: views_plugin_query_default::$fields in views_plugin_query_default->query() (line 1153 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->compile_fields() (line 1071 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Notice: Undefined property: views_plugin_query_default::$fields in views_plugin_query_default->query() (line 1153 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->query() (line 1155 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Warning: Invalid argument supplied for foreach() in views_plugin_query_default->compile_fields() (line 1071 of /mywebsite/sites/all/modules/views/plugins/views_plugin_query_default.inc).

I don't even have the FullCalendar module installed, but Views was recently updated (7.x-3.0-rc3).

Geijutsuka’s picture

Geijutsuka CreditAttribution: Geijutsuka commented

Edit-

I only noticed the messages after changing the theme because the previous theme was not printing $messages.

ko-sh’s picture

ko-sh CreditAttribution: ko-sh commented

I had the same issue after I deleted a field.

A view was still refering to this field. After removing the reference to this field the error disappeared.

Maybe the fullcalendar-update renamed or deleted a field?

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
CreditAttribution: tim.plunkett commented
Status: Active » Closed (cannot reproduce)

No new info in a month. #6 is normal views behavior, not fullcalendar specific.

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
CreditAttribution: tim.plunkett commented
Issue summary: View changes

replaced my actual domain with "mywebsite"