CDbException

DEBUG MODE on stage.priceless.com (stage2) 2025-07-16 20:15:52

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'iocontentdb.products' doesn't exist. The SQL statement executed was: SELECT count(*) as count FROM iocontentdb.products p JOIN iocontentdb.productsitemappings psm ON (psm.productId = p.productId AND psm.siteId = 5) LEFT JOIN ioserverdb.inventories v ON v.productId = p.productId WHERE IF(psm.activeType = 0, ( p.active = 1 ) AND (p.startDate IS NULL OR p.startDate < NOW()),
IF(psm.activeType = 1, psm.activeType = IF(1 = 0, 1, -1),
psm.activeType = 2)
) AND p.showOnListPages = 1 AND IFNULL(v.count, 1) > 0 AND p.celebId = :celebId

/home/ifonly/web/yii/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#1
+
 /home/ifonly/web/common/protected/components/IfOnlyDbCommand.php(318): CDbCommand->queryRow(true, array(":celebId" => "19934"))
313             try {
314                 self::$queryCounter++;
315                 if (self::$useServerdbOnly && $this->getConnection()->name === 'serverdbread') {
316                     return Unlogger::run(fn() => Yii::app()->serverdb->createCommand()->setText($this->getText())->queryRow($fetchAssociative, $params));
317                 } else {
318                     return Unlogger::run(fn() => parent::queryRow($fetchAssociative, $params));
319                 }
320             }
321             catch (CDbException $ex) {
322                 $this->logException($ex, $attempt, $params); // log always
323                 if ($attempt === 1 && $this->isSwitchable()) {
#2
+
 /home/ifonly/web/common/protected/components/Unlogger.php(31): IfOnlyDbCommand->{closure}()
26 
27         $logger = Yii::getLogger();
28         Yii::setLogger(self::$unlogger);
29 
30         try {
31             return $callable();
32         } finally {
33             Yii::setLogger($logger);
34         }
35     }
36 }
#3
+
 /home/ifonly/web/common/protected/components/IfOnlyDbCommand.php(318): Unlogger::run(Closure)
313             try {
314                 self::$queryCounter++;
315                 if (self::$useServerdbOnly && $this->getConnection()->name === 'serverdbread') {
316                     return Unlogger::run(fn() => Yii::app()->serverdb->createCommand()->setText($this->getText())->queryRow($fetchAssociative, $params));
317                 } else {
318                     return Unlogger::run(fn() => parent::queryRow($fetchAssociative, $params));
319                 }
320             }
321             catch (CDbException $ex) {
322                 $this->logException($ex, $attempt, $params); // log always
323                 if ($attempt === 1 && $this->isSwitchable()) {
2025-07-16 20:15:52 nginx/1.21.6 Yii Framework/1.1.28

Warning: Undefined array key "P" in /home/ifonly/web/yii/framework/logging/CLogFilter.php on line 134