[solved] another error

**desperados** · 12/04/2011, 13:34

I've deleted a product attribute, and so now when in backend I click on "products" I have this error:

Code:

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/vhosts/mysite.it/httpdocs/store/system/libraries/Database.php on line 677

#0 /var/www/vhosts/mysite.it/httpdocs/store/system/libraries/Database.php(624): Database_Statement->query()
#1 /var/www/vhosts/mysite.it/httpdocs/store/system/libraries/Database.php(164): Database_Statement->execute()
#2 /var/www/vhosts/mysite.it/httpdocs/store/system/libraries/Controller.php(2810): Database->execute('SELECT id, pid ...')
#3 /var/www/vhosts/mysite.it/httpdocs/store/system/libraries/Controller.php(2952): Controller->getChildRecords(0, 'tl_iso_products', true)
#4 /var/www/vhosts/mysite.it/httpdocs/store/system/drivers/DC_Table.php(225): Controller->eliminateNestedPages(Array, 'tl_iso_products', true)
#5 /var/www/vhosts/mysite.it/httpdocs/store/system/modules/backend/Backend.php(210): DC_Table->__construct('tl_iso_products')
#6 /var/www/vhosts/mysite.it/httpdocs/store/contao/main.php(101): Backend->getBackendModule('iso_products')
#7 /var/www/vhosts/mysite.it/httpdocs/store/contao/main.php(286): Main->run()
#8 {main}

**desperados** · 12/04/2011, 13:39

solved deleting my user session cache

**ricardoonline** · 10/05/2012, 19:28

Hi,

I am still new to Contao and a complete beginner when it comes to Isotope.

I manage a website for a charity. The programming was donated by a company but they were not able to install and configure Isotope for us. Therefore I tried to do it myself and worked myself through the manual. I followed the configuration step by step but at then end after I entered the first product I received the following error message:

Code:

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 /homepages/19/d405022096/htdocs/system/libraries/Database.php on line 689
#0 /homepages/19/d405022096/htdocs/system/libraries/Database.php(636): Database_Statement->query()
#1 /homepages/19/d405022096/htdocs/system/libraries/Database.php(164): Database_Statement->execute()
#2 /homepages/19/d405022096/htdocs/system/libraries/Controller.php(2811): Database->execute('SELECT id, pid ...')
#3 /homepages/19/d405022096/htdocs/system/libraries/Controller.php(2953): Controller->getChildRecords(0, 'tl_iso_products', true)
#4 /homepages/19/d405022096/htdocs/system/drivers/DC_Table.php(225): Controller->eliminateNestedPages(Array, 'tl_iso_products', true)
#5 /homepages/19/d405022096/htdocs/system/drivers/DC_ProductData.php(71): DC_Table->__construct('tl_iso_products')
#6 /homepages/19/d405022096/htdocs/system/modules/backend/Backend.php(210): DC_ProductData->__construct('tl_iso_products')
#7 /homepages/19/d405022096/htdocs/contao/main.php(101): Backend->getBackendModule('iso_products')
#8 /homepages/19/d405022096/htdocs/contao/main.php(286): Main->run()
#9 {main}

I have to close the backend then and log in again. But when I click on "Products" the error comes again.

I hope that anybody can help me since I have no clue at all.

What does

solved deleting my user session cache

mean? Could it also solve my problem?

Thanks in advance,
Richard