search

speckcommerce / SpeckCatalog

BSD 2-Clause "Simplified" License
26 stars 16 forks source link

Building wrong query #114

Open dkaswan opened 9 years ago

dkaswan commented 9 years ago

20-12-2014 09-13-16 pm

I've just installed Speckcommerce via GitClone->composerInstall->SpeckInstaller, and on home page getting this error. In file '\speck\vendor\speckcommerce\speck-catalog\src\SpeckCatalog\Mapper\Category.php' on line 27: System replaces content of $joinString ('catalog_category_website.category_id = catalog_category.category_id') in join statement, so final query is exactly:

SELECT "catalogcategory"., "catalog_categorywebsite". FROM "catalog_category" INNER JOIN "catalog_category_website" ON "catalog_categ"or"y_website"."categ"or"y_id" = "catalog_categ"or"y"."categ"or"y_id" WHERE "website_id" = '1' AND "parent_category_id" IS NULL

Using new \Zend\Db\Sql\Expression($joinString) is fixing the issue but why system strangely replacing 'or'?

Perfect-Web commented 9 years ago

same happens to me, any ideas ?