>> Products >>



QUERY: select top 2000 tblItem.fItemID, (select top 1 fPhotosFile from tblphotos where tblphotos.fitemid=tblitem.fitemid and tblphotos.fmain=1) as photo, (select top 1 fShortTexten as text from tblText where flinkedid=tblitem.fitemid and fname='name') as title_fr, (select top 1 fTexten as text from tblText where flinkedid=tblitem.fitemid and fname='item-desc') as desc_fr, (select top 1 fTexten as text from tblText where flinkedid=tblitem.fitemid and fname='item-shortdesc') as shortdesc_fr, tblItem.fRefSupplier, tblItem.fItemNumero, tblItem.fItemID FROM tblItem where fCompanyID='244' and tblItem.fActiveWeb=1 and tblItem.fItemID in (select tblitemactive.fitemid from tblitemactive where tblitemactive.factive=1 and tblItemActive.fItemID=tblItem.fItemID and tblItemActive.fOutletID='46') and tblItem.fSubGroup1ID like '%%' ORDER BY tblItem.fOrder, fItemNumero
Fatal error: Uncaught exception 'Exception' with message 'Memory limit of 10240 KB exceeded for buffered query' in F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php:193 Stack trace: #0 F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php(47): ns\core\db\drivermssql->checkError('select top 2000...') #1 F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\v1\db.php(38): ns\core\db\drivermssql->execute('select top 2000...', Array) #2 F:\inetpub\nouveau.multipsi.com\web\pages\Category.php(538): ns\core\db->execute('select top 2000...', Array) #3 F:\inetpub\nouveau.multipsi.com\xone\ns\core\base\v1\base.php(323): require_once('F:\\inetpub\\nouv...') #4 F:\inetpub\nouveau.multipsi.com\xone\ns\web\layout\page\v1\page.php(18): ns\core\base->includeWorkingFile('Category.php') #5 F:\inetpub\nouveau.multipsi.com\xone\ns\web\layout\v1\layout.php(17): ns\web\layout\page->myrun() #6 F:\inetpub\nouveau.multipsi.com\xone\ns\core\v1\core.php(85): ns\web\layout->__run() #7 F:\inetpub\nouvea in F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php on line 193