API tools faq
paste
Advertisement
Guest User

error

a guest
Feb 19th, 2014
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.55 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3. Error: Couldn't run query: SELECT "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END AS "RecordClassName" FROM "Protocol" INNER JOIN "CategoryPage_Protocols" ON "CategoryPage_Protocols"."ProtocolID" = "Protocol"."ID" WHERE ("CategoryPage_Protocols"."CategoryPageID" = 226) AND ("Protocol"."Locale" = 'en_US') GROUP BY "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END Unknown column 'Protocol.Locale' in 'FIELD list'
  4. At line 525 in /var/www/vhosts/anesloop.org/httpdocs/v4.4/sapphire/core/model/MySQLDatabase.php
  5.  
  6.    Couldn't run query: SELECT "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END AS "RecordClassName" FROM "Protocol" INNER JOIN "CategoryPage_Protocols" ON "CategoryPage_Protocols"."ProtocolID" = "Protocol"."ID" WHERE ("CategoryPage_Protocols"."CategoryPageID" = 226) AND ("Protocol"."Locale" = 'en_US') GROUP BY "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END UNKNOWN COLUMN 'Protocol.Locale' IN 'field list'
  7.     Line 525 OF MySQLDatabase.php
  8.     MySQLDatabase->databaseError(Couldn't run query: SELECT "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END AS "RecordClassName" FROM "Protocol" INNER JOIN "CategoryPage_Protocols" ON "CategoryPage_Protocols"."ProtocolID" = "Protocol"."ID" WHERE ("CategoryPage_Protocols"."CategoryPageID" = 226) AND ("Protocol"."Locale" = 'en_US') GROUP BY "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END | Unknown column 'Protocol.Locale' in 'FIELD list',256)
  9.    Line 123 of MySQLDatabase.php
  10.    MySQLDatabase->query(SELECT "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END AS "RecordClassName" FROM "Protocol" INNER JOIN "CategoryPage_Protocols" ON "CategoryPage_Protocols"."ProtocolID" = "Protocol"."ID" WHERE ("CategoryPage_Protocols"."CategoryPageID" = 226) AND ("Protocol"."Locale" = 'en_US') GROUP BY "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END,256)
  11.    Line 129 of DB.php
  12.    DB::query(SELECT "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END AS "RecordClassName" FROM "Protocol" INNER JOIN "CategoryPage_Protocols" ON "CategoryPage_Protocols"."ProtocolID" = "Protocol"."ID" WHERE ("CategoryPage_Protocols"."CategoryPageID" = 226) AND ("Protocol"."Locale" = 'en_US') GROUP BY "Protocol"."ClassName", "Protocol"."Created", "Protocol"."LastEdited", "Protocol"."Name", "Protocol"."Title", "Protocol"."Description", "Protocol"."URLSegment", "Protocol"."MetaTitle", "Protocol"."protocolId", "Protocol"."date_debut", "Protocol"."date_fin", "Protocol"."nb_inc_theorique", "Protocol"."EIaction", "Protocol"."EIactionParameter1", "Protocol"."EIactionParameter2", "Protocol"."EIactionParameter3", "Protocol"."closed", "Protocol"."update", "Protocol"."Locale", "Protocol"."ImageID", "Protocol"."InvPrincipalID", "Protocol"."ID", CASE WHEN "Protocol"."ClassName" IS NOT NULL THEN "Protocol"."ClassName" ELSE 'Protocol' END,256)
  13.    Line 404 of SQLQuery.php
  14.    SQLQuery->execute()
  15.    Line 1384 of DataObject.php
  16.    DataObject->getManyManyComponents(Protocols)
  17.    call_user_func_array(Array,Array)
  18.    Line 711 of Object.php
  19.    Object->__call(protocols,Array)
  20.    CategoryPage->protocols()
  21.    call_user_func_array(Array,Array)
  22.    Line 693 of Object.php
  23.    Object->__call(Protocols,Array)
  24.    Line 55 of CategoryPage.php
  25.    CategoryPage_Controller->Protocols()
  26.    Line 55 of CategoryPage.php
  27.    CategoryPage_Controller->getProtocolsForTemplate()
  28.    Line 369 of ViewableData.php
  29.    ViewableData->obj(getProtocolsForTemplate)
  30.    Line 33 of .cache.themes.loop3r2.templates.Layout.CategoryPage.ss
  31.    include(/var/www/vhosts/anesloop.org/httpdocs/v4.4/silverstripe-cache/.cache.themes.loop3r2.templates.Layout.CategoryPage.ss)
  32.    Line 429 of SSViewer.php
  33.    SSViewer->process(CategoryPage_Controller,Zend_Cache_Frontend_Output)
  34.    Line 420 of SSViewer.php
  35.    SSViewer->process(CategoryPage_Controller)
  36.    Line 202 of Controller.php
  37.    Controller->handleAction(SS_HTTPRequest)
  38.    Line 143 of RequestHandler.php
  39.    RequestHandler->handleRequest(SS_HTTPRequest)
  40.    Line 147 of Controller.php
  41.    Controller->handleRequest(SS_HTTPRequest)
  42.    Line 200 of ContentController.php
  43.    ContentController->handleRequest(SS_HTTPRequest)
  44.    Line 185 of ContentController.php
  45.    ContentController->handleRequest(SS_HTTPRequest)
  46.    Line 67 of ModelAsController.php
  47.    ModelAsController->handleRequest(SS_HTTPRequest)
  48.    Line 282 of Director.php
  49.    Director::handleRequest(SS_HTTPRequest,Session)
  50.    Line 125 of Director.php
  51.    Director::direct(/my-protocols/actives/)
  52.    Line 196 of main.php
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!