Some kind of error in a fresh install - ref: unpublished option [#1261922]

Fresh install and I get this

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 \'= \'1\') )AND (field_data_field_job_workflow_state.field_job_workflow_state_value \' at line 3'
in views_plugin_query_default->execute() (line 1346 of /Applications/MAMP/htdocs2/recruiter-7.x-1.0-beta4/profiles/recruiter/modules/views/plugins/views_plugin_query_default.inc).

when I click on manage jobs -> unpublished tab.

what does this mean?

Comments

Comment #1

Adam S CreditAttribution: Adam S commented 29 August 2011 at 05:52

This is an issue with the Views UI. http://drupal.org/node/1192962 Views does not automatically make the connection between items that require database joins such as in this case an author relationship. It's a bug.

If you go to admin/structure/views/view/job_manage/edit/page_2 while the Views UI module is enabled, click on Filter Criteria -> User: Current (Yes) and click update it will reset the relationship. Save the view. Notice how it's now (author) User: Current (Yes).

Looking at it now I can tell what happened. The person who created the View overrode the Filter Criteria but not the Relationships. He (she, perhaps, never know) made the change in on of the styles but since the Filters are overridden the change did not precipitate to across all the Views styles. The missing relationship causes the error. Just clicking on the filter and updating it will reset it. This should be done by the maintainer too and exported to beta 5.