[solved] another error

Printable View

12/04/2011, 13:34
desperados

[solved] another error

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}
12/04/2011, 13:39
desperados

Re: another error

solved deleting my user session cache
10/05/2012, 19:28
ricardoonline

Fatal error: Uncaught exception Exception with message Query

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

Quote:

solved deleting my user session cache

mean? Could it also solve my problem?

Thanks in advance,
Richard
10/08/2012, 11:23
desperados

Re: [solved] another error

go in backend > personal data > and check all option under session data