search

tasfe / silverstripe-ecommerce

Automatically exported from code.google.com/p/silverstripe-ecommerce
0 stars 0 forks source link

Query Error when trying to access frontend pages with SS 2.4.6 #190

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
eCommerce version affected: trunk as of Nov 7 11.30am
SilverStripe version: 2.4.6

What steps will reproduce the problem?
1. Create a product under a product group on a fresh install of ecommerce and 
silverstripe. (no errors upon publishing in the backend). 
2. Access the product group in the front-end. 

Instead of displaying any page or products I get the following error on debug: 

[User Error] Couldn't run query: SELECT count(*) FROM SELECT 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END) all_distinct Out of sort memory; increase server sort buffer 
size
GET /blades/

Line 525 in /home/procut/public_html/dev/sapphire/core/model/MySQLDatabase.php

Source

516     }
517     
518     function databaseError($msg, $errorLevel = E_USER_ERROR) {
519         // try to extract and format query
520         if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, 
$matches)) {
521             $formatter = new SQLFormatter();
522             $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . 
"\n\n" . $matches[2];
523         }
524         
525         user_error($msg, $errorLevel);
526     }
527     
528     /**
529      * Return a boolean type-formatted string
530      * 
531      * @param array $values Contains a tokenised list of info about this data 
type
Trace

Couldn't run query: SELECT count(*) FROM SELECT "SiteTree_Live"."ClassName", 
"SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", 
"SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", 
"SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", 
"SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", 
"SiteTree_Live"."MetaKeywords", "SiteTree_Live"."ExtraMeta", 
"SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", 
"SiteTree_Live"."HomepageForDomain", "SiteTree_Live"."ProvideComments", 
"SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", 
"SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."Status", 
"SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", 
"SiteTree_Live"."CanEditType", "SiteTree_Live"."ToDo", 
"SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Product_Live"."Price", 
"Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END) all_distinct Out of sort memory; increase server sort buffer 
size 
Line 525 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: SELECT count(*) FROM (SELECT 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END) all_distinct | Out of sort memory; increase server sort buffer 
size,256) 
Line 123 of MySQLDatabase.php
MySQLDatabase->query(SELECT count(*) FROM (SELECT "SiteTree_Live"."ClassName", 
"SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", 
"SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", 
"SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", 
"SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", 
"SiteTree_Live"."MetaKeywords", "SiteTree_Live"."ExtraMeta", 
"SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", 
"SiteTree_Live"."HomepageForDomain", "SiteTree_Live"."ProvideComments", 
"SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", 
"SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."Status", 
"SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", 
"SiteTree_Live"."CanEditType", "SiteTree_Live"."ToDo", 
"SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Product_Live"."Price", 
"Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END) all_distinct,256) 
Line 129 of DB.php
DB::query(SELECT count(*) FROM (SELECT "SiteTree_Live"."ClassName", 
"SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", 
"SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", 
"SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", 
"SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", 
"SiteTree_Live"."MetaKeywords", "SiteTree_Live"."ExtraMeta", 
"SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", 
"SiteTree_Live"."HomepageForDomain", "SiteTree_Live"."ProvideComments", 
"SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", 
"SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."Status", 
"SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", 
"SiteTree_Live"."CanEditType", "SiteTree_Live"."ToDo", 
"SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Product_Live"."Price", 
"Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END) all_distinct,256) 
Line 404 of SQLQuery.php
SQLQuery->execute() 
Line 462 of SQLQuery.php
SQLQuery->unlimitedRowCount() 
Line 216 of DataObjectSet.php
DataObjectSet->parseQueryLimit(SELECT "SiteTree_Live"."ClassName", 
"SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", 
"SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", 
"SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", 
"SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", 
"SiteTree_Live"."MetaKeywords", "SiteTree_Live"."ExtraMeta", 
"SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", 
"SiteTree_Live"."HomepageForDomain", "SiteTree_Live"."ProvideComments", 
"SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", 
"SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."Status", 
"SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", 
"SiteTree_Live"."CanEditType", "SiteTree_Live"."ToDo", 
"SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Product_Live"."Price", 
"Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN 
"Product_Live" ON "Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree_Live"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18') WHERE 
("SiteTree_Live"."ClassName" IN ('Product')) AND (("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ) GROUP BY 
"SiteTree_Live"."ClassName", "SiteTree_Live"."Created", 
"SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", 
"SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", 
"SiteTree_Live"."Content", "SiteTree_Live"."MetaTitle", 
"SiteTree_Live"."MetaDescription", "SiteTree_Live"."MetaKeywords", 
"SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", 
"SiteTree_Live"."ShowInSearch", "SiteTree_Live"."HomepageForDomain", 
"SiteTree_Live"."ProvideComments", "SiteTree_Live"."Sort", 
"SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", 
"SiteTree_Live"."Status", "SiteTree_Live"."ReportClass", 
"SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", 
"SiteTree_Live"."ToDo", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", 
"Product_Live"."Price", "Product_Live"."Weight", "Product_Live"."Model", 
"Product_Live"."FeaturedProduct", "Product_Live"."AllowPurchase", 
"Product_Live"."InternalItemID", "Product_Live"."NumberSold", 
"Product_Live"."ImageID", "SiteTree_Live"."ID", CASE WHEN 
"SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 
'SiteTree' END ORDER BY "Title" ASC LIMIT 0, 12) 
Line 2739 of DataObject.php
DataObject->instance_get(("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ,"Title" ASC,LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18'),0, 
12,DataObjectSet) 
Line 2714 of DataObject.php
DataObject::get(Product,("ParentID" IN (18) OR 
"Product_ProductGroups"."ProductGroupID" = '18') ,"Title" ASC,LEFT JOIN 
"Product_ProductGroups" ON ("Product_ProductGroups"."ProductID" = 
"SiteTree"."ID" AND "Product_ProductGroups"."ProductGroupID" = '18'),0, 12) 
Line 141 of ProductGroup.php
ProductGroup->ProductsShowable(,1) 
call_user_func_array(Array,Array) 
Line 693 of Object.php
Object->__call(ProductsShowable,Array) 
Line 240 of ProductGroup.php
ProductGroup_Controller->ProductsShowable(,1) 
Line 240 of ProductGroup.php
ProductGroup_Controller->Products() 
Line 369 of ViewableData.php
ViewableData->obj(Products,,,1,) 
Line 411 of ViewableData.php
ViewableData->cachedCall(Products,) 
Line 424 of ViewableData.php
ViewableData->hasValue(Products) 
Line 226 of .cache.ecommerce.templates.Layout.ProductGroup.ss
include(/tmp/silverstripe-cache-home-procut-public_html-dev/.cache.ecommerce.tem
plates.Layout.ProductGroup.ss) 
Line 429 of SSViewer.php
SSViewer->process(ProductGroup_Controller,Zend_Cache_Frontend_Output) 
Line 420 of SSViewer.php
SSViewer->process(ProductGroup_Controller) 
Line 202 of Controller.php
Controller->handleAction(SS_HTTPRequest) 
Line 143 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest) 
Line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest) 
Line 199 of ContentController.php
ContentController->handleRequest(SS_HTTPRequest) 
Line 67 of ModelAsController.php
ModelAsController->handleRequest(SS_HTTPRequest) 
Line 282 of Director.php
Director::handleRequest(SS_HTTPRequest,Session) 
Line 125 of Director.php
Director::direct(/blades/) 
Line 127 of main.php

Original issue reported on code.google.com by wske...@gmail.com on 6 Nov 2011 at 11:01

GoogleCodeExporter commented 9 years ago 
Revision 1701 by the way.

Original comment by wske...@gmail.com on 6 Nov 2011 at 11:35

GoogleCodeExporter commented 9 years ago 
I recommend using the 0.8 branch at the moment if you want to use trunk code. 
That will become trunk soon. I'll assume you understand the risks of using 
trunk, rather than a tag also.

Some related discussion happening here now:
https://groups.google.com/forum/#!topic/silverstripe-ecommerce/8AxroUfiLb0
...feel free to sign up to the mailing list :)

Original comment by jeremybu...@gmail.com on 6 Nov 2011 at 11:40

GoogleCodeExporter commented 9 years ago 
When I revert back to 0.8 I get a similar error as above to in the backend as 
well as in the frontend, at least on the trunk I wasn't experiencing the error 
on the frontend.

The error in the backend is: 

ERROR [User Error]: Couldn't run query: 
SELECT count(*)
FROM 
SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", 
"SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", 
"SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", 
"SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", 
"SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", 
"SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", 
"SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", 
"SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", 
"SiteTree"."Version", "SiteTree"."ParentID", 
"ProductGroup"."ChildGroupsPermission", "SiteTree"."ID", CASE WHEN 
"SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' 
END AS "RecordClassName", CASE WHEN "ProductID" IS NULL THEN '0' ELSE '1' END 
AS "Checked"
FROM "SiteTree"
LEFT JOIN "ProductGroup" ON "ProductGroup"."ID" = "SiteTree"."ID" 
LEFT JOIN "Product_ProductGroups" ON ("SiteTree"."ID" = 
"Product_ProductGroups"."ProductGroupID" AND "ProductID" = '22')
WHERE ("SiteTree"."ClassName" IN ('ProductGroup'))
GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", 
"SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", 
"SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", 
"SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", 
"SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", 
"SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", 
"SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", 
"SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", 
"SiteTree"."Version", "SiteTree"."ParentID", 
"ProductGroup"."ChildGroupsPermission", "SiteTree"."ID", CASE WHEN 
"SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' 
END, "ProductID") all_distinct 

Out of sort memory; increase server sort buffer size
IN POST /admin/getitem?ID=22&ajax=1
Line 525 in /home/procut/public_html/dev/sapphire/core/model/MySQLDatabase.php

Source
======
  516:  }
  517:  
  518:  function databaseError($msg, $errorLevel = E_USER_ERROR) {

----

What version of silverstripe is ecommerce confirmed to work well on?

Original comment by wske...@gmail.com on 6 Nov 2011 at 11:50

GoogleCodeExporter commented 9 years ago 
SilverStripe 2.4.5 definitely works, but 2.4.6 has yet to be tested.

Have you also researched the error message you are given? "Out of sort memory; 
increase server sort buffer size"

That might be specific to your environment.

Original comment by jeremybu...@gmail.com on 6 Nov 2011 at 11:53

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
is your website available on a live server?

Original comment by nfranc...@gmail.com on 7 Nov 2011 at 1:37

GoogleCodeExporter commented 9 years ago 
what I mean is - can we have a look at it?

Original comment by nfranc...@gmail.com on 7 Nov 2011 at 2:33

GoogleCodeExporter commented 9 years ago 
I got around the buffer size problem by adjusting my mysql settings. I solved 
the issue with the cart not storing products by using your latest release 
candidate instead of the .8 branch. 

Thanks for your help.

Original comment by wske...@gmail.com on 7 Nov 2011 at 2:54