Monday, 15 February 2010

silverstripe - SortableGridField causing SQL error -


After a lot of searches, I found: for example usage.

However, implementing it in code results:

[user error] Could not run the query: Select "Sidebar" from the "Sidebar" Inner on "Two column_sidebar" The column 'sort order' is unclear in the "sidebar id" field in the "to-column sidebar" = "sidebar" field list

I am using SS3 and it is installed in SortableGridField (although no message Does not indicate successful establishment) "id" ("Two column_indurbar".) "Do not load CMS" ("server error"), with the "two column IDID" = '2' dev mode running, though, when Dev mode is enabled, I get the above SQL error. However, it is working properly, I have to find out why this error has been thrown.

UPDATE

Below this error, most of the stack marks generated Is up (page 2 [user error] are blue headers):

  [user error] Quay Could not be played: "Select" DIXINT MAX "(SortOrder") from the sidebar "Inner Join" in the field list Column 'Sort Order' is unclear The query could not be run: Select Distance Max ("SortOrder") from "Sidebar "Internal" TwoColumn_Sidebars "include but" TwoColumn_Sidebars ". "SidebarID" = "Sidebar". Where "id" ("TwoColumn_Sidebars". "TwoColumnID" = '2') Columns in the 'SortOrder' field are obscure MySQLDatabase.php: 580 MySQLDatabase- & gt; Database Error (Question: Choose "Separ Bar" on "Sidebar ID" = "Sidebar" on "Sidebar" Join INNER on "Two Columns_sybar". Where "ID" ("Two column_sidebar" "Two column_id" = '2') | Area list Column 'SortOrder' is unclear, 256) MySQLDatabase.php:. 132 MySQLDatabase- & gt; Include "sidebar" internals from the query (select "DISTINCT MAX" ("SortOrder"), "TwoColumn_Sidebars" on "TwoColumn_Sidebars", "SidebarID" = "Sidebar" "ID" ("Two Column_Edbars". "Two ColumnIDID" = '2 '), 256) DB.FP: 200 dB :: Query ("Sort Order") Select "Sidebar" Inner Join "Two Column Cyber" "Sidebar ID" = "Sidebar" "Id" ou ("two column_sybarbar". "Two column idid" = '2'), 256) SQLQuery.php: 949 SQLQuery-> Execute () DataQuery.php: 372 DataQuery-> Total (Max ("SortOrder")) DataQuery.php: 338 DataQuery-> MaxOr (SortOrder) DataList.php: 676 DataList-> MaxOr (SortOrder) GridFieldSortableRows.php: 148GridFieldSortableRows-> FixSortColumn (GridFieldSortableRows.php: 99GridFieldSortableRows-> MillipulateData (Gridfield, severalMonlineList) GridField.php: 215 Gridfield-> Millipeded List () GridField.php: 255 GridField-> FieldHolder () ... [User Error] "Sidebar" Where "ID" (Where to separate "Two column sidebar" (different "Sidebar". "ID") "Sidebar" to "0" as "Two Columns" Sidebars "" two columnimid "= '2') and (" sort order "= 0) column in the 'sort order' where the sections are unclear The query can not be run: Select "Different" (different "Sidebar". "ID") as "0" from "Sidebar" to the internal "TwoColumn_Sidebars" but "TwoColumn_Sidebars". "SidebarID" = "Sidebar" Where "ID" ("TwoColumn_Sidebars". "TwoColumnID" = '2') and (= 0 "SortOrder") column 'SortOrder' where the section is ambiguous MySQLDatabase.php: 580 MySQLDatabase- & gt; Database error (query triggered Could not go: Select different distance (separate "sidebar". "ID") from "0" to "sidebar" INNER "two column sidebars" on "sidebar id" "sidba ID "=" sidebar ". Where "id" ("two column sidebar". "Two column id" = '2') and ("sort order" = 0). The column 'SortOrder', where the section is ambiguous, 256) MySQLDatabase.php: 132 MySQLDatabase- & gt; Include "0" from "sidebar" as the query internal "TwoColumn_Sidebars" on (. DISTINCT count (select "different sidebar" "separate") "sidebar id" = "sidebar". Where "id" ("two column_sidebar "." "Two column ID" = '2') and ("Sort Order" = 0), 256) DB.FP: 200dB :: Query (Choose DISTINCT Count (Separate "Sidebar". "ID") as "0 "SidebarID" = "Sidebar". Where "ID" ("TwoColumn_Sidebars". "TwoColumnID" = '2') AND ("SortOrder" = 0), "SidebarID" = "Sidebar" and "(" SortOrder "= 0)," SideBarBird " 256) SQLQuery.php: 949 SQLQuery-> Execute () SQLQuery.php: 1054 SQLQuery-> Count (DISTINCT "Sidebar". "ID") Datacol .php: 329 Ductical-> Count () DataList.php: 666 Data List-> Count () GridFieldSortableROS.PHP: 150 GridFieldSortableRO- & gt; FixSortCollum (Gridfield, several commonList) GridfieldSortableROSPP: 99 GridFieldSertableRO- & gt; Millipliedadata (Gridfield, many more lists) GridField.php: 215 Gridfield- & gt; GetManipulatedList () GridField.php: 255 GridField-> FieldHolder () ViewableData.php: 366 ViewableData- & gt; Obj (FieldHolder ,, 1) ...    

I'm having trouble with SortableGridField After I used the EdgeSports Gridfield extension

No comments:

Post a Comment