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

websule’s picture

Which version of drupal core and views module are you using? there are some versions or combination of versions that cause such errors.

rfulcher’s picture

I am running the current release of 7 ddupal and 7.x-3 alpha1 of views

rfulcher’s picture

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

[{"command":"settings","settings":{"basePath":"\/","ajaxPageState":{"theme":"seven","theme_token":"-umcHEwpbJCEs2mAcwM11i9dd_-0GmgTNiNC-QOlaAY","css":[]},"CTools":{"dependent":{"edit-options-alter-text":{"values":{"edit-options-alter-alter-text":[1]},"num":1,"type":"hide"},"edit-options-alter-path":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-absolute":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-link-class":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-alt":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-rel":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-prefix":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-suffix":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"edit-options-alter-target":{"values":{"edit-options-alter-make-link":[1]},"num":1,"type":"hide"},"views-tokens-help":{"values":{"edit-options-alter-make-link":[1],"edit-options-alter-alter-text":[1]},"num":1,"type":"hide"},"edit-options-alter-max-length":{"values":{"edit-options-alter-trim":[1]},"num":1,"type":"hide"},"edit-options-alter-word-boundary":{"values":{"edit-options-alter-trim":[1]},"num":1,"type":"hide"},"edit-options-alter-ellipsis":{"values":{"edit-options-alter-trim":[1]},"num":1,"type":"hide"},"edit-options-alter-html":{"values":{"edit-options-alter-trim":[1]},"num":1,"type":"hide"},"edit-options-alter-preserve-tags":{"values":{"edit-options-alter-strip-tags":[1]},"num":1,"type":"hide"}}},"ajax":{"edit-options-type":{"event":"change","url":"\/admin\/structure\/views\/ajax\/config-item\/testview\/default\/field\/entity_id","submit":{"_triggering_element_name":"options[type]"}}}},"merge":true},{"command":"viewsSetForm","output":"\u003cform action=\"\/admin\/structure\/views\/ajax\/config-item\/testview\/default\/field\/entity_id\" method=\"post\" id=\"views-ui-config-item-form\" accept-charset=\"UTF-8\"\u003e\u003cdiv\u003e\u003cdiv class=\"form-item description\"\u003e\u003c\/div\u003e\u003cdiv class=\"form-item form-type-textfield form-item-options-ui-name\"\u003e\n \u003clabel for=\"edit-options-ui-name\"\u003eAdministrative Title \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-ui-name\" name=\"options[ui_name]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThis title will be displayed on the views edit page instead of the default one. This might be useful if you have the same item twice.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-exclude\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-exclude\" name=\"options[exclude]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-exclude\"\u003eExclude from display \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eCheck this box to not display this field, but still load it in the view. Use this option to not show a grouping field in each record, or when doing advanced theming, or when you want to use this field as a token in other fields.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-select form-item-options-element-type\"\u003e\n \u003clabel for=\"edit-options-element-type\"\u003eHTML element \u003c\/label\u003e\n \u003cselect id=\"edit-options-element-type\" name=\"options[element_type]\" class=\"form-select\"\u003e\u003coption value=\"\" selected=\"selected\"\u003e- Use default -\u003c\/option\u003e\u003coption value=\"0\"\u003e- None -\u003c\/option\u003e\u003coption value=\"div\"\u003eDIV\u003c\/option\u003e\u003coption value=\"span\"\u003eSPAN\u003c\/option\u003e\u003coption value=\"h1\"\u003eH1\u003c\/option\u003e\u003coption value=\"h2\"\u003eH2\u003c\/option\u003e\u003coption value=\"h3\"\u003eH3\u003c\/option\u003e\u003coption value=\"h4\"\u003eH4\u003c\/option\u003e\u003coption value=\"h5\"\u003eH5\u003c\/option\u003e\u003coption value=\"h6\"\u003eH6\u003c\/option\u003e\u003coption value=\"p\"\u003eP\u003c\/option\u003e\u003coption value=\"strong\"\u003eSTRONG\u003c\/option\u003e\u003coption value=\"em\"\u003eEM\u003c\/option\u003e\u003c\/select\u003e\n\u003cdiv class=\"description\"\u003eMost styles provide wrappers for fields. If the chosen style supports wrappers, wrap the field in this HTML element. The default will usually be either DIV or SPAN.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-element-class\"\u003e\n \u003clabel for=\"edit-options-element-class\"\u003eElement class \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-element-class\" name=\"options[element_class]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe class to provide on the wrapper element. You may enter data from this view as per the \"Replacement patterns\" used in \"Rewrite the output of this field\".\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-label\"\u003e\n \u003clabel for=\"edit-options-label\"\u003eLabel \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-label\" name=\"options[label]\" value=\"field_testdate\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe label for this field that will be displayed to end users if the style requires it.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-select form-item-options-element-label-type\"\u003e\n \u003clabel for=\"edit-options-element-label-type\"\u003eLabel HTML element \u003c\/label\u003e\n \u003cselect id=\"edit-options-element-label-type\" name=\"options[element_label_type]\" class=\"form-select\"\u003e\u003coption value=\"\" selected=\"selected\"\u003e- Use default -\u003c\/option\u003e\u003coption value=\"0\"\u003e- None -\u003c\/option\u003e\u003coption value=\"div\"\u003eDIV\u003c\/option\u003e\u003coption value=\"span\"\u003eSPAN\u003c\/option\u003e\u003coption value=\"h1\"\u003eH1\u003c\/option\u003e\u003coption value=\"h2\"\u003eH2\u003c\/option\u003e\u003coption value=\"h3\"\u003eH3\u003c\/option\u003e\u003coption value=\"h4\"\u003eH4\u003c\/option\u003e\u003coption value=\"h5\"\u003eH5\u003c\/option\u003e\u003coption value=\"h6\"\u003eH6\u003c\/option\u003e\u003coption value=\"p\"\u003eP\u003c\/option\u003e\u003coption value=\"strong\"\u003eSTRONG\u003c\/option\u003e\u003coption value=\"em\"\u003eEM\u003c\/option\u003e\u003c\/select\u003e\n\u003cdiv class=\"description\"\u003eWhat HTML Element type to use to wrap the label.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-element-label-class\"\u003e\n \u003clabel for=\"edit-options-element-label-class\"\u003eLabel class \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-element-label-class\" name=\"options[element_label_class]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe class to provide on the label wrapper element.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-element-label-colon\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-element-label-colon\" name=\"options[element_label_colon]\" value=\"1\" checked=\"checked\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-element-label-colon\"\u003ePlace a colon after the label \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf the label is to be inline with the value, place a colon between them. Not valid for styles such as table where the label is not placed with the value.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-select form-item-options-element-wrapper-type\"\u003e\n \u003clabel for=\"edit-options-element-wrapper-type\"\u003eWrapper HTML element \u003c\/label\u003e\n \u003cselect id=\"edit-options-element-wrapper-type\" name=\"options[element_wrapper_type]\" class=\"form-select\"\u003e\u003coption value=\"\" selected=\"selected\"\u003e- Use default -\u003c\/option\u003e\u003coption value=\"0\"\u003e- None -\u003c\/option\u003e\u003coption value=\"div\"\u003eDIV\u003c\/option\u003e\u003coption value=\"span\"\u003eSPAN\u003c\/option\u003e\u003coption value=\"h1\"\u003eH1\u003c\/option\u003e\u003coption value=\"h2\"\u003eH2\u003c\/option\u003e\u003coption value=\"h3\"\u003eH3\u003c\/option\u003e\u003coption value=\"h4\"\u003eH4\u003c\/option\u003e\u003coption value=\"h5\"\u003eH5\u003c\/option\u003e\u003coption value=\"h6\"\u003eH6\u003c\/option\u003e\u003coption value=\"p\"\u003eP\u003c\/option\u003e\u003coption value=\"strong\"\u003eSTRONG\u003c\/option\u003e\u003coption value=\"em\"\u003eEM\u003c\/option\u003e\u003c\/select\u003e\n\u003cdiv class=\"description\"\u003eWhat HTML Element type to use to wrap the field (and the label). This is not supported by some styles such as tables.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-element-wrapper-class\"\u003e\n \u003clabel for=\"edit-options-element-wrapper-class\"\u003eWrapper class \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-element-wrapper-class\" name=\"options[element_wrapper_class]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe class to provide on the wrapper element.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-element-default-classes\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-element-default-classes\" name=\"options[element_default_classes]\" value=\"1\" checked=\"checked\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-element-default-classes\"\u003eAdd default classes \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eUse default Views classes to identify the field, field label and field content.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cfieldset class=\"form-wrapper\" id=\"edit-options-alter\"\u003e\u003clegend\u003e\u003cspan class=\"fieldset-legend\"\u003eRewriting\u003c\/span\u003e\u003c\/legend\u003e\u003cdiv class=\"fieldset-wrapper\"\u003e\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-alter-text\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-alter-text\" name=\"options[alter][alter_text]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-alter-text\"\u003eRewrite the output of this field \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, you can alter the output of this field by specifying a string of text with replacement tokens that can use any existing field output.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textarea form-item-options-alter-text\"\u003e\n \u003clabel for=\"edit-options-alter-text\"\u003eText \u003c\/label\u003e\n \u003cdiv class=\"form-textarea-wrapper resizable\"\u003e\u003ctextarea id=\"edit-options-alter-text\" name=\"options[alter][text]\" cols=\"60\" rows=\"5\" class=\"form-textarea\"\u003e\u003c\/textarea\u003e\u003c\/div\u003e\n\u003cdiv class=\"description\"\u003eThe text to display for this field. You may include HTML. You may enter data from this view as per the \"Replacement patterns\" below.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-make-link\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-make-link\" name=\"options[alter][make_link]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-make-link\"\u003eOutput this field as a link \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, this field will be made into a link. The destination must be given below.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-path\"\u003e\n \u003clabel for=\"edit-options-alter-path\"\u003eLink path \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-path\" name=\"options[alter][path]\" value=\"\" size=\"60\" maxlength=\"255\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe Drupal path or absolute URL for this link. You may enter data from this view as per the \"Replacement patterns\" below.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-absolute\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-absolute\" name=\"options[alter][absolute]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-absolute\"\u003eUse absolute path \u003c\/label\u003e\n\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-link-class\"\u003e\n \u003clabel for=\"edit-options-alter-link-class\"\u003eLink class \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-link-class\" name=\"options[alter][link_class]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe CSS class to apply to the link.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-alt\"\u003e\n \u003clabel for=\"edit-options-alter-alt\"\u003eAlt text \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-alt\" name=\"options[alter][alt]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eText to place as \"alt\" text which most browsers display as a tooltip when hovering over the link.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-rel\"\u003e\n \u003clabel for=\"edit-options-alter-rel\"\u003eRel Text \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-rel\" name=\"options[alter][rel]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eInclude Rel attribute for use in lightbox2 or other javascript utility.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-prefix\"\u003e\n \u003clabel for=\"edit-options-alter-prefix\"\u003ePrefix text \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-prefix\" name=\"options[alter][prefix]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eAny text to display before this link. You may include HTML.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-suffix\"\u003e\n \u003clabel for=\"edit-options-alter-suffix\"\u003eSuffix text \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-suffix\" name=\"options[alter][suffix]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eAny text to display after this link. You may include HTML.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-target\"\u003e\n \u003clabel for=\"edit-options-alter-target\"\u003eTarget \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-target\" name=\"options[alter][target]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eTarget of the link, such as _blank, _parent or an iframe's name. This field is rarely used.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cfieldset id=\"views-tokens-help\"\u003e\u003clegend\u003eReplacement patterns\u003c\/legend\u003e\u003cp\u003eThe following tokens are available for this field. Note that due to rendering order, you cannot use fields that come after this field; if you need a field not listed here, rearrange your fields.\nIf you would like to have the characters %5B and %5D please use the html entity codes '%5B' or '%5D' or they will get replaced with empty space.\u003c\/p\u003e\u003cdiv class=\"item-list\"\u003e\u003cFields\u003e\u003cli class=\"first last\"\u003e[entity_id] == Fields: field_testdate\u003c\/li\u003e\n\u003c\/Fields\u003e\u003c\/div\u003e\u003c\/fieldset\u003e\u003c\/div\u003e\u003cinput type=\"hidden\" name=\"options[alter][help]\" value=\"\" \/\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-trim\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-trim\" name=\"options[alter][trim]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-trim\"\u003eTrim this field to a maximum length \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, this field be trimmed to a maximum length in characters.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-max-length\"\u003e\n \u003clabel for=\"edit-options-alter-max-length\"\u003eMaximum length \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-max-length\" name=\"options[alter][max_length]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eThe maximum number of characters this field can be.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-word-boundary\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-word-boundary\" name=\"options[alter][word_boundary]\" value=\"1\" checked=\"checked\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-word-boundary\"\u003eTrim only on a word boundary \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, this field be trimmed only on a word boundary. This is guaranteed to be the maximum characters stated or less. If there are no word boundaries this could trim a field to nothing.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-ellipsis\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-ellipsis\" name=\"options[alter][ellipsis]\" value=\"1\" checked=\"checked\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-ellipsis\"\u003eAdd an ellipsis \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, a \"...\" will be added if a field was trimmed.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-html\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-html\" name=\"options[alter][html]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-html\"\u003eField can contain HTML \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, HTML corrector will be run to ensure tags are properly closed after trimming.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-alter-strip-tags\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-alter-strip-tags\" name=\"options[alter][strip_tags]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-alter-strip-tags\"\u003eStrip HTML tags \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf checked, all HTML tags will be stripped.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-alter-preserve-tags\"\u003e\n \u003clabel for=\"edit-options-alter-preserve-tags\"\u003ePreserve certain tags \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-alter-preserve-tags\" name=\"options[alter][preserve_tags]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eList the tags that need to be preserved during the stripping process. example \u0026quot;\u0026lt;p\u0026gt; \u0026lt;br\u0026gt;\u0026quot; which will preserve all p and br elements\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/fieldset\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-empty\"\u003e\n \u003clabel for=\"edit-options-empty\"\u003eEmpty text \u003c\/label\u003e\n \u003cinput type=\"text\" id=\"edit-options-empty\" name=\"options[empty]\" value=\"\" size=\"60\" maxlength=\"128\" class=\"form-text\" \/\u003e\n\u003cdiv class=\"description\"\u003eIf the field is empty, display this text instead.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-empty-zero\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-empty-zero\" name=\"options[empty_zero]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-empty-zero\"\u003eCount the number 0 as empty \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eIf the field contains the number zero, display the empty text instead\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-checkbox form-item-options-hide-empty\"\u003e\n \u003cinput type=\"checkbox\" id=\"edit-options-hide-empty\" name=\"options[hide_empty]\" value=\"1\" class=\"form-checkbox\" \/\u003e \u003clabel class=\"option\" for=\"edit-options-hide-empty\"\u003eHide if empty \u003c\/label\u003e\n\n\u003cdiv class=\"description\"\u003eDo not display anything for this field if it is empty. Note that the field label may still be displayed. Check style or row style settings to hide labels for empty fields.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-select form-item-options-type\"\u003e\n \u003clabel for=\"edit-options-type\"\u003eFormatter \u003c\/label\u003e\n \u003cselect id=\"edit-options-type\" name=\"options[type]\" class=\"form-select\"\u003e\u003coption value=\"date_default\" selected=\"selected\"\u003eDefault\u003c\/option\u003e\u003coption value=\"format_interval\"\u003eAs Time Ago\u003c\/option\u003e\u003coption value=\"date_long\"\u003eLong\u003c\/option\u003e\u003coption value=\"date_medium\"\u003eMedium\u003c\/option\u003e\u003coption value=\"date_short\"\u003eShort\u003c\/option\u003e\u003c\/select\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-select form-item-options-settings-format-type\"\u003e\n \u003clabel for=\"edit-options-settings-format-type\"\u003eFormat: \u003c\/label\u003e\n \u003cselect id=\"edit-options-settings-format-type\" name=\"options[settings][format_type]\" class=\"form-select\"\u003e\u003coption value=\"long\" selected=\"selected\"\u003eLong\u003c\/option\u003e\u003coption value=\"medium\"\u003eMedium\u003c\/option\u003e\u003coption value=\"short\"\u003eShort\u003c\/option\u003e\u003c\/select\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-settings-multiple-number\"\u003e\n \u003clabel for=\"edit-options-settings-multiple-number\"\u003eMultiple values: \u003c\/label\u003e\n \u003cspan class=\"field-prefix\"\u003eShow \u003c\/span\u003e \u003cinput type=\"text\" id=\"edit-options-settings-multiple-number\" name=\"options[settings][multiple_number]\" value=\"\" size=\"5\" maxlength=\"128\" class=\"form-text\" \/\u003e \u003cspan class=\"field-suffix\"\u003e value(s)\u003c\/span\u003e\n\u003cdiv class=\"description\"\u003eIdentify a specific number of values to display, or leave blank to show all values.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-settings-multiple-from\"\u003e\n \u003cspan class=\"field-prefix\"\u003estarting from \u003c\/span\u003e \u003cinput type=\"text\" id=\"edit-options-settings-multiple-from\" name=\"options[settings][multiple_from]\" value=\"\" size=\"15\" maxlength=\"128\" class=\"form-text\" \/\u003e \u003cspan class=\"field-suffix\"\u003e\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"form-item form-type-textfield form-item-options-settings-multiple-to\"\u003e\n \u003cspan class=\"field-prefix\"\u003eending with \u003c\/span\u003e \u003cinput type=\"text\" id=\"edit-options-settings-multiple-to\" name=\"options[settings][multiple_to]\" value=\"\" size=\"15\" maxlength=\"128\" class=\"form-text\" \/\u003e \u003cspan class=\"field-suffix\"\u003e\u003c\/span\u003e\n\u003cdiv class=\"description\"\u003eIdentify specific start and\/or end dates in the format YYYY-MM-DDTHH:MM:SS, or leave blank for all available dates.\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"clearfix\"\u003e\u003cdiv class=\"form-buttons\"\u003e\u003cinput type=\"submit\" id=\"edit-submit\" name=\"op\" value=\"Update\" class=\"form-submit\" \/\u003e\u003cinput type=\"submit\" id=\"edit-cancel\" name=\"op\" value=\"Cancel\" class=\"form-submit\" \/\u003e\u003cinput type=\"submit\" id=\"edit-remove\" name=\"op\" value=\"Remove\" class=\"form-submit\" \/\u003e\u003c\/div\u003e\u003c\/div\u003e\u003cinput type=\"hidden\" name=\"form_build_id\" value=\"form-gcZBBEkXd7U5sM0zuh-YFtHmhVu7mZPFZR0YqG_brds\" \/\u003e\n\u003cinput type=\"hidden\" name=\"form_token\" value=\"cFS-c0wgDIyYc5Vi5_D9xSoc1MAIs0Sm_95kJShOvy0\" \/\u003e\n\u003cinput type=\"hidden\" name=\"form_id\" value=\"views_ui_config_item_form\" \/\u003e\n\u003c\/div\u003e\u003c\/form\u003e","title":"Defaults: Configure field \u003cem class=\"placeholder\"\u003eFields: field_testdate\u003c\/em\u003e","url":"http:\/\/backoffice.everhartandhoover.com\/admin\/structure\/views\/ajax\/config-item\/testview\/default\/field\/entity_id"},{"command":"viewsHilite","selector":".default-field-entity-id"},{"command":"viewsDisableButtons"}]

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

rfulcher’s picture

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

rfulcher’s picture

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!!!

rfulcher’s picture

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

rodrigoaguilera’s picture

im getting the same error ¿anyone reported it as a bug?

rfulcher’s picture

Yeah it is reported to be fixed in the latest dev release. here is the bug info

http://drupal.org/node/1027274