CDbException

DEBUG MODE on stage.priceless.com (stage1) 2025-07-18 01:08:49

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'iocontentdb.seriesproducts' doesn't exist. The SQL statement executed was: SELECT sp.productId, sp.seriesScheduledDateTime, IF(spi.productId IS NOT NULL, spi.count, sp.initialInventoryCount) AS count
FROM iocontentdb.seriesproducts sp
LEFT JOIN ioserverdb.seriesproductinventories spi ON spi.productId = sp.productId AND
spi.seriesScheduledDateTime = sp.seriesScheduledDateTime
WHERE (sp.productId = :productId1 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime1) OR (sp.productId = :productId2 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime2) OR (sp.productId = :productId3 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime3) OR (sp.productId = :productId4 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime4) OR (sp.productId = :productId5 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime5) OR (sp.productId = :productId6 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime6) OR (sp.productId = :productId7 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime7) OR (sp.productId = :productId8 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime8) OR (sp.productId = :productId9 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime9) OR (sp.productId = :productId10 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime10) OR (sp.productId = :productId11 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime11) OR (sp.productId = :productId12 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime12) OR (sp.productId = :productId13 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime13) OR (sp.productId = :productId14 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime14) OR (sp.productId = :productId15 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime15) OR (sp.productId = :productId16 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime16) OR (sp.productId = :productId17 AND sp.seriesScheduledDateTime = :seriesScheduledDateTime17)

/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(290): CDbCommand->queryAll(true, array(":productId1" => "210640", ":seriesScheduledDateTime1" => "2025-05-10 20:00:00", ":productId2" => "210640", ":seriesScheduledDateTime2" => "2025-05-15 19:00:00", ...)) 
285             try {
286                 self::$queryCounter++;
287                 if (self::$useServerdbOnly && $this->getConnection()->name === 'serverdbread') {
288                     return Unlogger::run(fn() => Yii::app()->serverdb->createCommand()->setText($this->getText())->queryAll($fetchAssociative, $params));
289                 } else {
290                     return Unlogger::run(fn() => parent::queryAll($fetchAssociative, $params));
291                 }
292             }
293             catch (CDbException $ex) {
294                 $this->logException($ex, $attempt, $params); // log always
295                 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(290): Unlogger::run(Closure) 
285             try {
286                 self::$queryCounter++;
287                 if (self::$useServerdbOnly && $this->getConnection()->name === 'serverdbread') {
288                     return Unlogger::run(fn() => Yii::app()->serverdb->createCommand()->setText($this->getText())->queryAll($fetchAssociative, $params));
289                 } else {
290                     return Unlogger::run(fn() => parent::queryAll($fetchAssociative, $params));
291                 }
292             }
293             catch (CDbException $ex) {
294                 $this->logException($ex, $attempt, $params); // log always
295                 if ($attempt === 1 && $this->isSwitchable()) {
2025-07-18 01:08:49 nginx/1.21.6 Yii Framework/1.1.28