, Catalogo utensili professionali USAG

Notice (8): Undefined offset: 0 [APP/models/thirdclassification.php, line 108]

        }    

        $results = $this->query($q);

        return $results[0];

$id	=	"1041"
$language	=	"it"
$newKey	=	false
$q	=	"SELECT Thirdclassification.title_it as title,Thirdclassification.descrizione_it as descrizione, firstclassifications_id, Firstclassification.id, Firstclassification.title_it as title
				  FROM thirdclassifications Thirdclassification
				  INNER JOIN secondclassifications Secondclassification ON (Secondclassification.id=Thirdclassification.secondclassifications_id)
				  INNER JOIN firstclassifications Firstclassification ON (Firstclassification.id=Secondclassification.firstclassifications_id)
				  WHERE Thirdclassification.id = 1041"
$results	=	array()

Thirdclassification::getThirdClassification() - APP/models/thirdclassification.php, line 108
ProductsController::families() - APP/controllers/products_controller.php, line 99
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"SELECT distinct productfamilies_id FROM articles where fourthclassifications_id in ();"
$error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 287
Model::query() - CORE/cake/libs/model/model.php, line 2463
Productfamily::getKeywordsFamilies() - APP/models/productfamily.php, line 617
ProductsController::families() - APP/controllers/products_controller.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Warning (2): Invalid argument supplied for foreach() [APP/models/productfamily.php, line 619]

Code | Context

        $id_list = $this->query($q_id_list);



        foreach ($id_list as $idf) {

$secondid	=	"1041"
$language	=	"it"
$familyId_list	=	""
$id_fourth_list	=	""
$keys	=	""
$q_fourth	=	"SELECT id FROM fourthclassifications where thirdclassifications_id = 1041;"
$id_fourth	=	array()
$q_id_list	=	"SELECT distinct productfamilies_id FROM articles where fourthclassifications_id in ();"
$id_list	=	false

Productfamily::getKeywordsFamilies() - APP/models/productfamily.php, line 619
ProductsController::families() - APP/controllers/products_controller.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

(0)