Aug 18 version partially breaks views administration

I found that if I disabled migrate, uninstalled migrate, and then re-enabled it, the views came back. I lost my content-sets, but that's OK, I can build them again.

I'll build them and then see if things continue to work.

Yes, it was the white screen, but only on the default or "list" part of the admin/build/views.

As to the date/version of migrate--I don't know. I tend to install just about every update, except I was on vacation last week so I could have missed some.

It is possible that the problem was associated with the mappingkit module, as I was also installing and testing that. I actually had a white screen first show up in one of the parts of that project (the mapserver module, but just the page where one is supposed to be able to edit/create a map file for the mapserver application). It was about a half-hour later (after I had uninstalled mappingkit) that I found that I could not see the list of views in my administration. Things seem to be back working now that I've uninstalled migrate, and reinstalled and rebuilt my content set (however I have not yet rerun a migrate process).

I'm not too familiar with the logging, but in looking through the watchdog table, and doing a query for type like PHP, and location like %views% I get several entries that have the following variables which includes an SQL error. But, I'm not convinced that these were from the right problem time. Actually, I'm pretty darned sure that these are related to something else:

a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:1923:"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 'AS node_data_field_il_county_field_il_county_value,
node_data_field_il_county' at line 13
query: SELECT node.nid AS nid,
node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid,
node_data_field_image.field_image_list AS node_data_field_image_field_image_list,
node_data_field_image.field_image_data AS node_data_field_image_field_image_data,
node.type AS node_type,
node.vid AS node_vid,
node.title AS node_title,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
SRID(geo) as geo_srid,
AsBinary(geo) AS geo_wkb,
AsBinary(Envelope(geo)) AS geo_bbox,
AsBinary(Centroid(geo)) AS geo_centroid AS node_data_field_il_county_field_il_county_value,
node_data_field_il_county_geo.county_nam AS node_data_field_il_county_geo_county_nam,
node_data_field_il_county_geo.co_fips AS node_data_field_il_county_geo_co_fips,
node_data_field_lname.field_lname_value AS node_data_field_lname_field_lname_value,
node_data_field_lname.field_fname_value AS node_data_field_lname_field_fname_value
FROM node node
LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN content_type_bios node_data_field_il_county ON node.vid = node_data_field_il_county.vid
LEFT JOIN geo_data_illinoiscounty node_data_field_il_county_geo ON node_data_field_il_county.field_il_county_value = node_data_field_il_county_geo.co_fips
LEFT JOIN content_type_bios node_data_field_lname ON node.vid = node_data_field_lname.vid
WHERE node.type in ('bios')
ORDER BY node_data_field_lname_field_lname_value ASC, node_data_field_lname_field_fname_value ASC
LIMIT 0, 10";s:5:"%file";s:76:"/local/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc";s:5:"%line";i:1091;

Ah Ha, I bet that was it. I had plenty of views.

I have an external script in which I use the map tables, but it was an easy modify. But I didn't make the connection with views.

Thanks for the update information.