PDOException

Description

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Source File

/nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php (172)

0170:         $dbh = db::getInstance();
0171:         $query = "SELECT _price_{$priceType} AS price,_price_action_{$priceType} AS action_price, _price_private_nodph FROM i_product WHERE Id={$prodID}";
0172: $sth = $dbh->query($query);
0173: if ($sth->rowCount() >= 1) { 0174: $row = $sth->fetch(PDO::FETCH_ASSOC); 0175: if ($row['action_price'] > 0 AND $row['action_price'] < $row['price']) {

Stack Trace

#0 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(172): PDO->query('SELECT _price_p...')
#1 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(859): product::getPrice(NULL)
#2 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(824): product->getVariationsPresent('default', '209')
#3 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(670): product->printVariationsPresent('default')
#4 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(420): product->printProductContentPresent('', 'eshop', 'default')
#5 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/modules/models/product.php(1597): product->printProductContent('', 'eshop', 'default')
#6 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(369): product->ReplaceCustomTag('CONTENT', 'default', 'eshop', 'default', '', 0)
#7 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(437): base_class->ProcessTag('CONTENT', 'default', 'eshop', 'default', 0)
#8 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(473): base_class->ProcessTemplate('<.CONTENT.>\n<.R...', 'default', 'eshop', 'default', 0)
#9 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/mainclass.php(74): base_class->Render('default', 'eshop', 'default')
#10 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/mainclass.php(743): mainclass->printActiveObject('eshop', 'default')
#11 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(369): mainclass->ReplaceCustomTag('OBJECT', 'default', 'eshop', 'default', '', 0)
#12 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(437): base_class->ProcessTag('OBJECT', 'default', 'eshop', 'default', 0)
#13 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/core/base_class.php(473): base_class->ProcessTemplate('<!DOCTYPE html ...', 'default', 'eshop', 'default', 0)
#14 /nfsmnt/hosting2_2/3/5/35d69ddc-d3bf-4cb1-891e-5c7623552350/sothys.sk/sub/eshop/eshop/index.php(76): base_class->Render('default', 'eshop', 'default')
#15 {main}
2018-04-21 07:33