I have a view that is very simple. Several fields from my content type. I am having issues with sorting on some of the fields. several fields are normal (text & date) and other fields are node reference fields. They both get the same error:
Notice: Undefined index: field_wr_value in views_handler_field_field->click_sort() (line 130 of C:\wamp\www\backoffice\sites\all\modules\views\modules\field\views_handler_field_field.inc).
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 \'ASC
LIMIT 20 OFFSET 0\' at line 3'
in views_plugin_query_default->execute() (line 1314 of C:\wamp\www\backoffice\sites\all\modules\views\plugins\views_plugin_query_default.inc).
Does anyone know how to fix this?
Thanks
Comments
more details.
Which version of drupal core and views module are you using? there are some versions or combination of versions that cause such errors.
I am running the current
I am running the current release of 7 ddupal and 7.x-3 alpha1 of views
Testing View problems.
I am also testing creating a new content type and often have an issue saving the view. I created a new small content type and when adding the fields to a view I get a page that displays this
The content type that I created has only 4 fields Title, Body, Text, and Date field. I only added the Text and Date field to the view.
Thanks
Another Error
I also get this popup some times:
An AJAX HTTP request terminated abnormally.
Debugging information follows.
Path: /admin/structure/views/ajax/preview/testview
ResponseText:
ReadyState: 4
Update
Ok I have determined that when I create a sort it has an html path of testsort?order=entity_id&sort=asc or some variation of that. Not containing the field I want to sort on. The fields that work have the field name in the path such as testsort?order=title&sort=asc
I feel like I am getting closer....but...I am not sure how to fix that!!!
Found Bug Report
I found this bug report and will be trying it.
SQLSTATE[42000]: Syntax error or access violation
This is in the latest dev release and will be trying it.
Thanks
im getting the same error
im getting the same error ¿anyone reported it as a bug?
Yeah it is reported to be
Yeah it is reported to be fixed in the latest dev release. here is the bug info
http://drupal.org/node/1027274