isotope / core

Core repository of Isotope eCommerce, an eCommerce extension for Contao Open Source CMS
https://isotopeecommerce.org
135 stars 107 forks source link

"Allowed product types" in group settings leads to query error #368

Closed ghost closed 11 years ago

ghost commented 11 years ago

While configuring user permissions I came upon a bug (at least I think so): If I select an "Allowed product type[s]" in "User groups > Edit group > Isotope eCommerce" I get the following error for users belonging to this group on the page "Product Management" and "Edit product":

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'sorting' in 'order clause'
(SELECT id, pid FROM tl_iso_products WHERE pid IN(0) ORDER BY FIND_IN_SET(pid, '0'), sorting) thrown in /var/www/*/contao/system/libraries/Database.php on line 689
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/libraries/Database.php(636): Database_Statement->query()
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/libraries/Database.php(164): Database_Statement->execute()
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/libraries/Controller.php(2811): Database->execute('SELECT id, pid ...')
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/libraries/Controller.php(2953): Controller->getChildRecords(0, 'tl_iso_products', true)
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/drivers/DC_Table.php(225): Controller->eliminateNestedPages(Array, 'tl_iso_products', true)
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/drivers/DC_ProductData.php(71): DC_Table->__construct('tl_iso_products')
http://www.contao-forge.org/issues/
 /var/www/*/contao/system/modules/backend/Backend.php(210): DC_ProductData->__construct('tl_iso_products')
http://www.contao-forge.org/issues/
 /var/www/*/contao/contao/main.php(101): Backend->getBackendModule('iso_products')
http://www.contao-forge.org/issues/
 /var/www/*/contao/contao/main.php(286): Main->run()
http://www.contao-forge.org/issues/
 {main}

Indeed the column "sorting" does not exist in table "tl_iso_products"

--- Originally created by JaiBee on 2012-03-01 13:22:05 (ID 2944)

ghost commented 11 years ago

Same error for page admin on "Product Management > Advanced Filters > Added this week / Added this month". However no error on "Added today".

--- Originally created by JaiBee on 2012-03-01 13:43:47

Toflar commented 11 years ago

What version of Contao?

--- Originally created by Toflar on 2012-03-01 13:45:53

ghost commented 11 years ago

2.10.4…

--- Originally created by JaiBee on 2012-03-01 13:46:40

Toflar commented 11 years ago

Isotope doesn't work for Contao 2.10.3 and 2.10.4. See description: http://www.contao.org/en/extension-list/view/isotope.html

--- Originally created by Toflar on 2012-03-01 13:48:42

ghost commented 11 years ago

Yeah, everything works fine after having downgraded Contao to 2.10.2.

--- Originally created by JaiBee on 2012-03-01 15:18:52