Advertisement
Guest User

Untitled

a guest
Aug 20th, 2014
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1. Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."Version", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."TitleElement", "Page_Live"."HeadingCTA", "Page_Live"."Summary", "Page_Live"."Type", "Page_Live"."Admins", "Page_Live"."cutomDisqusIdentifier", "Page_Live"."PageHeaderID", "Page_Live"."ThumbnailID", "Page_Live"."CTAImageID", "Page_Live"."FBImageID", "Pass_Live"."PassShortName", "Pass_Live"."Price", "Pass_Live"."Discount", "Pass_Live"."PassByLine", "Pass_Live"."PassDays", "Pass_Live"."PassLocationLine", "Pass_Live"."PassStart", "Pass_Live"."PassEnd", "Pass_Live"."PassType", "Pass_Live"."Featured", "Pass_Live"."BayOfIslands", "Pass_Live"."ComingSoon", "Pass_Live"."HideTimetableTab", "Pass_Live"."PassCategory", "Pass_Live"."RecommendedDays", "Pass_Live"."WetSeasonDeparts", "Pass_Live"."DrySeasonDeparts", "Pass_Live"."TimetableText", "Pass_Live"."AddonPack", "Pass_Live"."ItineraryText", "Pass_Live"."ActivitiesText", "Pass_Live"."UnlimitedTravel", "Pass_Live"."ShowOptionalConnections", "Pass_Live"."ImageID", "Pass_Live"."MapID", "Pass_Live"."MiniatureMapID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM LEFT JOIN "SiteTree_Live" ON "Country_Passes"."CountryID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Pass_Live" ON "Pass_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "Country_Passes" ON "Country_Passes"."PassAsiaID" = "SiteTree_Live"."ID" LEFT JOIN "Country" ON "Country_Passes"."CountryID" = "Country"."ID" WHERE ("Country"."ID" = '840') AND ("SiteTree_Live"."ClassName" IN ('PassAsia')) ORDER BY "SiteTree_Live"."Sort" ASC 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 'LEFT JOIN "SiteTree_Live" ON "Country_Passes"."CountryID" = "SiteTree_Live"."ID"' at line 1
  2. MySQLDatabase.php:592
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement