Zend_Db_Statement_Exception making GET request to /kozmetometer/cistilni-gel-pena

PHP	/var/www/ats/planet-lepote.com/library/Zend/Db/Statement/Pdo.php, line 234
URI	GET /kozmetometer/cistilni-gel-pena

Zend_Db_Statement_Pdo->_execute [/var/www/ats/planet-lepote.com/library/Zend/Db/Statement.php, line 300]

? Args

Arg	Name	Value
0	$params	`array ( )`

? Src

{
/*
* Simple case - no query profiler to manage.
*/
if ($this->_queryId === null) {
return $this->_execute($params);
}
/*
* Do the same thing, but with query profiler
* management before and after the execute.

Zend_Db_Statement->execute [/var/www/ats/planet-lepote.com/library/Zend/Db/Adapter/Abstract.php, line 479]

? Args

Arg	Name	Value
0	$params	`array ( )`

? Src

$bind = array($bind);
}
// prepare and execute the statement with profiling
$stmt = $this->prepare($sql);
$stmt->execute($bind);
// return the results embedded in the prepared statement object
$stmt->setFetchMode($this->_fetchMode);
return $stmt;
}

Zend_Db_Adapter_Abstract->query [/var/www/ats/planet-lepote.com/library/Zend/Db/Adapter/Pdo/Abstract.php, line 238]

? Args

Arg	Name	Value
0	$sql	'SELECT `pv`.`name` AS `product_vendor_name`, `pv`.`product_vendor_url`, `pv`.`user_id`, `pv`.`affiliate_id`, `pv`.`thumbnail`, `pv`.`thumbnail_id`, `pv`.`product_vendor_id`, `pv`.`description`, `pv`.`date_published`, `pv`.`date_created`, `pv`.`published_by`, `pv`.`removed_by`, `pv`.`removed_by_role`, `pv`.`product_count`, `pv`.`website`, `pv`.`link_id`, `pv`.`show_link`, GROUP_CONCAT(p.category_id) AS `categories`, AVG(p.rating) AS `avg_rating`, SUM(p.ratings_count) AS `ratings_count`, `u`.`userDirectory`, `u`.`avatar`, `u`.`avatarMargin`, `u`.`cover`, `u`.`coverMargin`, `u`.`screenName`, `u`.`urlIdentifier` FROM `products_vendors` AS `pv` LEFT JOIN `products` AS `p` ON p.vendor_id = pv.product_vendor_id LEFT JOIN `users` AS `u` ON u.user_id = pv.affiliate_id WHERE (ISNULL(u.user_id) OR NOT ISNULL(u.user_id)) AND (ISNULL(p.vendor_id) OR NOT ISNULL(p.vendor_id)) AND (ISNULL(pv.removed_by)) GROUP BY `pv`.`product_vendor_id` ORDER BY `pv`.`name` ASC'
1	$bind	`array ( )`

? Src

}
}
}
try {
return parent::query($sql, $bind);
} catch (PDOException $e) {
/**
* @see Zend_Db_Statement_Exception
*/
require_once 'Zend/Db/Statement/Exception.php';

Zend_Db_Adapter_Pdo_Abstract->query [/var/www/ats/planet-lepote.com/library/Zend/Db/Select.php, line 686]

? Args

Arg	Name	Value
0	$sql	Zend_Db_Select::__set_state(array( '_bind' => array ( ), '_adapter' => Zend_Db_Adapter_Pdo_Mysql::__set_state(array( '_pdoType' => 'mysql', '_numericDataTypes' => array ( 0 => 0, 1 => 1, 2 => 2, 'INT' => 0, 'INTEGER' => 0, 'MEDIUMINT' => 0, 'SMALLINT' => 0, 'TINYINT' => 0, 'BIGINT' => 1, 'SERIAL' => 1, 'DEC' => 2, 'DECIMAL' => 2, 'DOUBLE' => 2, 'DOUBLE PRECISION' => 2, 'FIXED' => 2, 'FLOAT' => 2, ), '_defaultStmtClass' => 'Zend_Db_Statement_Pdo', '_config' => array ( 'host' => 'localhost', 'username' => 'ats', 'password' => 'b2acregaswarUp', 'dbname' => 'ats_pl_live', 'charset' => 'utf8', 'persistent' => false, 'options' => array ( 'caseFolding' => 0, 'autoQuoteIdentifiers' => true, 'fetchMode' => 2, ), 'driver_options' => array ( 1002 => 'SET NAMES \'utf8\'', ), ), '_fetchMode' => 2, '_profiler' => Zend_Db_Profiler::__set_state(array( '_queryProfiles' => array ( ), '_enabled' => false, '_filterElapsedSecs' => NULL, '_filterTypes' => NULL, )), '_defaultProfilerClass' => 'Zend_Db_Profiler', '_connection' => NULL, '_caseFolding' => 0, '_autoQuoteIdentifiers' => true, '_allowSerialization' => true, '_autoReconnectOnUnserialize' => false, )), '_parts' => array ( 'distinct' => false, 'columns' => array ( 0 => array ( 0 => 'pv', 1 => 'name', 2 => 'product_vendor_name', ), 1 => array ( 0 => 'pv', 1 => 'product_vendor_url', 2 => NULL, ), 2 => array ( 0 => 'pv', 1 => 'user_id', 2 => NULL, ), 3 => array ( 0 => 'pv', 1 => 'affiliate_id', 2 => NULL, ), 4 => array ( 0 => 'pv', 1 => 'thumbnail', 2 => NULL, ), 5 => array ( 0 => 'pv', 1 => 'thumbnail_id', 2 => NULL, ), 6 => array ( 0 => 'pv', 1 => 'product_vendor_id', 2 => NULL, ), 7 => array ( 0 => 'pv', 1 => 'description', 2 => NULL, ), 8 => array ( 0 => 'pv', 1 => 'date_published', 2 => NULL, ), 9 => array ( 0 => 'pv', 1 => 'date_created', 2 => NULL, ), 10 => array ( 0 => 'pv', 1 => 'published_by', 2 => NULL, ), 11 => array ( 0 => 'pv', 1 => 'removed_by', 2 => NULL, ), 12 => array ( 0 => 'pv', 1 => 'removed_by_role', 2 => NULL, ), 13 => array ( 0 => 'pv', 1 => 'product_count', 2 => NULL, ), 14 => array ( 0 => 'pv', 1 => 'website', 2 => NULL, ), 15 => array ( 0 => 'pv', 1 => 'link_id', 2 => NULL, ), 16 => array ( 0 => 'pv', 1 => 'show_link', 2 => NULL, ), 17 => array ( 0 => 'p', 1 => Zend_Db_Expr::__set_state(array( '_expression' => 'GROUP_CONCAT(p.category_id)', )), 2 => 'categories', ), 18 => array ( 0 => 'p', 1 => Zend_Db_Expr::__set_state(array( '_expression' => 'AVG(p.rating)', )), 2 => 'avg_rating', ), 19 => array ( 0 => 'p', 1 => Zend_Db_Expr::__set_state(array( '_expression' => 'SUM(p.ratings_count)', )), 2 => 'ratings_count', ), 20 => array ( 0 => 'u', 1 => 'userDirectory', 2 => NULL, ), 21 => array ( 0 => 'u', 1 => 'avatar', 2 => NULL, ), 22 => array ( 0 => 'u', 1 => 'avatarMargin', 2 => NULL, ), 23 => array ( 0 => 'u', 1 => 'cover', 2 => NULL, ), 24 => array ( 0 => 'u', 1 => 'coverMargin', 2 => NULL, ), 25 => array ( 0 => 'u', 1 => 'screenName', 2 => NULL, ), 26 => array ( 0 => 'u', 1 => 'urlIdentifier', 2 => NULL, ), ), 'union' => array ( ), 'from' => array ( 'pv' => array ( 'joinType' => 'from', 'schema' => NULL, 'tableName' => 'products_vendors', 'joinCondition' => NULL, ), 'p' => array ( 'joinType' => 'left join', 'schema' => NULL, 'tableName' => 'products', 'joinCondition' => 'p.vendor_id = pv.product_vendor_id', ), 'u' => array ( 'joinType' => 'left join', 'schema' => NULL, 'tableName' => 'users', 'joinCondition' => 'u.user_id = pv.affiliate_id', ), ), 'where' => array ( 0 => '(ISNULL(u.user_id) OR NOT ISNULL(u.user_id))', 1 => 'AND (ISNULL(p.vendor_id) OR NOT ISNULL(p.vendor_id))', 2 => 'AND (ISNULL(pv.removed_by))', ), 'group' => array ( 0 => 'pv.product_vendor_id', ), 'having' => array ( ), 'order' => array ( 0 => array ( 0 => 'pv.name', 1 => 'ASC', ), ), 'limitcount' => NULL, 'limitoffset' => NULL, 'forupdate' => false, ), '_tableCols' => array ( ), ))

? Src

{
if (!empty($bind)) {
$this->bind($bind);
}
$stmt = $this->_adapter->query($this);
if ($fetchMode == null) {
$fetchMode = $this->_adapter->getFetchMode();
}
$stmt->setFetchMode($fetchMode);
return $stmt;

Zend_Db_Select->query [/var/www/ats/planet-lepote.com/application/models/Products.php, line 265]

? Src

))
->where('ISNULL(u.user_id) OR NOT ISNULL(u.user_id)')
->where('ISNULL(p.vendor_id) OR NOT ISNULL(p.vendor_id)')
->where('ISNULL(pv.removed_by)')
->group('pv.product_vendor_id')
->order('pv.name')->query()->fetchAll();
$vendors = array();
//dump($result);
foreach ($result as $res) {
$res['name'] = $res['product_vendor_name'];
$res['categories'] = array_unique(explode(',', $res['categories']));

Products->_getVendors [/var/www/ats/planet-lepote.com/application/models/Products.php, line 1939]

? Src

}
}
$result['vendors'] = $this->_getVendors();
$result['vendors_count'] = count($result['vendors']);
if ($this->_categoryId && !$this->_itemId) {
$ctgs = array_keys($categories->getDescendants($this->_categoryId));
$ctgs[] = $this->_categoryId;
foreach ($result['vendors'] as $vendor) {

Products->get [/var/www/ats/planet-lepote.com/application/modules/default/controllers/ProductsController.php, line 130]

? Src

$found = true;
$products->setPropertiesFromRequest($this->_requestParams, $found);
if (!$found) {
throw new Zend_Controller_Action_Exception($this->_request->getRequestUri() . ' not found', 404);
}
$this->view->productsData = $products->get();
if (!is_array($this->view->productsData)) {
$this->_error = true;
$this->_errorCode = $this->view->productsData;
return;
}

ProductsController->indexAction [/var/www/ats/planet-lepote.com/library/Zend/Controller/Action.php, line 516]

? Src

// preDispatch() didn't change the action, so we can continue
if ($this->getInvokeArg('useCaseSensitiveActions') || in_array($action, $this->_classMethods)) {
if ($this->getInvokeArg('useCaseSensitiveActions')) {
trigger_error('Using case sensitive actions without word separators is deprecated; please do not rely on this "feature"');
}
$this->$action();
} else {
$this->__call($action, array());
}
}
$this->postDispatch();

Zend_Controller_Action->dispatch [/var/www/ats/planet-lepote.com/library/Zend/Controller/Dispatcher/Standard.php, line 295]

? Args

Arg	Name	Value
0	$action	`'indexAction'`

? Src

if (empty($disableOb)) {
ob_start();
}
try {
$controller->dispatch($action);
} catch (Exception $e) {
// Clean output buffer on error
$curObLevel = ob_get_level();
if ($curObLevel > $obLevel) {
do {

Zend_Controller_Dispatcher_Standard->dispatch [/var/www/ats/planet-lepote.com/library/Zend/Controller/Front.php, line 954]

? Args

Arg	Name	Value
0	$request	Zend_Controller_Request_Http::__set_state(array( '_paramSources' => array ( 0 => '_GET', 1 => '_POST', ), '_requestUri' => '/kozmetometer/cistilni-gel-pena', '_baseUrl' => '', '_basePath' => NULL, '_pathInfo' => '/kozmetometer/cistilni-gel-pena', '_params' => array ( 'id' => 'cistilni-gel-pena', 'module' => 'default', 'controller' => 'products', 'action' => 'index', ), '_rawBody' => NULL, '_aliases' => array ( ), '_dispatched' => true, '_module' => 'default', '_moduleKey' => 'module', '_controller' => 'products', '_controllerKey' => 'controller', '_action' => 'index', '_actionKey' => 'action', ))
1	$response	`Zend_Controller_Response_Http::__set_state(array( '_body' => array ( ), '_exceptions' => array ( ), '_headers' => array ( ), '_headersRaw' => array ( ), '_httpResponseCode' => 200, '_isRedirect' => false, '_renderExceptions' => false, 'headersSentThrowsException' => true, ))`

? Src

/**
* Dispatch request
*/
try {
$dispatcher->dispatch($this->_request, $this->_response);
} catch (Exception $e) {
if ($this->throwExceptions()) {
throw $e;
}
$this->_response->setException($e);

Zend_Controller_Front->dispatch [/var/www/ats/planet-lepote.com/library/Zend/Application/Bootstrap/Bootstrap.php, line 97]

? Src

'No default controller directory registered with front controller'
);
}
$front->setParam('bootstrap', $this);
$response = $front->dispatch();
if ($front->returnResponse()) {
return $response;
}
}

Zend_Application_Bootstrap_Bootstrap->run [/var/www/ats/planet-lepote.com/library/Zend/Application.php, line 366]

? Src

*
* @return void
*/
public function run()
{
$this->getBootstrap()->run();
}
/**
* Load configuration file of options
*

Zend_Application->run [/var/www/ats/planet-lepote.com/htdocs/index.php, line 142]

? Src

APPLICATION_STATE,
$finalConfig
);
$application->bootstrap()
->run();

Variable	Value
REDIRECT_APPLICATION_STATE	'production'
REDIRECT_HTTPS	'on'
REDIRECT_SSL_TLS_SNI	'www.planet-lepote.com'
REDIRECT_STATUS	'200'
APPLICATION_STATE	'production'
HTTPS	'on'
SSL_TLS_SNI	'www.planet-lepote.com'
HTTP_USER_AGENT	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_ACCEPT	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
HTTP_ACCEPT_LANGUAGE	'en-US,en;q=0.5'
HTTP_IF_MODIFIED_SINCE	'Mon, 06 Jul 2020 11:25:33 GMT'
HTTP_ACCEPT_ENCODING	'br,gzip'
HTTP_HOST	'www.planet-lepote.com'
HTTP_CONNECTION	'Keep-Alive'
PATH	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
SERVER_SIGNATURE	''
SERVER_SOFTWARE	'Apache/2.4.29 (Ubuntu)'
SERVER_NAME	'www.planet-lepote.com'
SERVER_ADDR	'144.76.83.145'
SERVER_PORT	'443'
REMOTE_ADDR	'100.24.125.162'
DOCUMENT_ROOT	'/var/www/ats/planet-lepote.com/htdocs/'
REQUEST_SCHEME	'https'
CONTEXT_PREFIX	''
CONTEXT_DOCUMENT_ROOT	'/var/www/ats/planet-lepote.com/htdocs/'
SERVER_ADMIN	'andrej.somrak@ats-on.net'
SCRIPT_FILENAME	'/var/www/ats/planet-lepote.com/htdocs/index.php'
REMOTE_PORT	'48126'
REDIRECT_URL	'/kozmetometer/cistilni-gel-pena'
GATEWAY_INTERFACE	'CGI/1.1'
SERVER_PROTOCOL	'HTTP/1.1'
REQUEST_METHOD	'GET'
QUERY_STRING	''
REQUEST_URI	'/kozmetometer/cistilni-gel-pena'
SCRIPT_NAME	'/index.php'
PATH_INFO	'/kozmetometer/cistilni-gel-pena'
PATH_TRANSLATED	'redirect:/index.php/kozmetometer/cistilni-gel-pena/cistilni-gel-pena'
PHP_SELF	'/index.php/kozmetometer/cistilni-gel-pena'
REQUEST_TIME_FLOAT	1604159550.725
REQUEST_TIME	1604159550

Zend_Db_Statement_Exception making GET request to /kozmetometer/cistilni-gel-pena

SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYHBW4lO' (Errcode: 28 - No space left on device)

Stacktrace ?

Request ?

Request (raw)

HEADERS

Request (parsed)

$_GET

$_POST

$_COOKIE

$_SERVER

$_ENV

Response ?

Headers