I've uploaded my application on server and get the following error:
CDbException Description CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet Source File /****/httpdocs/Yii/db/CDbCommand.php(284) 00272: if($this->_statement instanceof PDOStatement) 00273: $this->_statement->execute(); 00274: else 00275: $this->_statement=$this->getConnection()->getPdoInstance()->query($this->getText()); 00276: if($method==='') 00277: return new CDbDataReader($this); 00278: $result=$this->_statement->{$method}($mode); 00279: $this->_statement->closeCursor(); 00280: return $result; 00281: } 00282: catch(Exception $e) 00283: { 00284: throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 00285: array('{error}'=>$e->getMessage()))); 00286: } 00287: } 00288: }
Here is the application log:
2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "log" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "urlManager" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "request" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "db" application component 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SELECT p.*, s.name shop FROM Product p INNER JOIN Shop s ON p.shopID=s.shopID WHERE p.dtAdded > :dtAdded ORDER BY dtAdded DESC LIMIT 0, 5 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SELECT p.*, s.name shop FROM Product p INNER JOIN Shop s ON p.shopID=s.shopID WHERE p.dtReduced > :dtReduced AND p.productID NOT IN (2815,974,845,2263,2975) ORDER BY dtReduced DESC, discount DESC LIMIT 0,5 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SELECT p.*, s.name shop FROM Product p INNER JOIN Shop s ON p.shopID=s.shopID WHERE p.productID NOT IN (2815,974,845,2263,2975,64,2923,1922,2269,2656) ORDER BY viewsNum DESC LIMIT 0,5 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "clientScript" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "assetManager" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "user" application component 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "session" application component 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SELECT c.*, count(p.productID) productsNum FROM Category c LEFT JOIN Product p ON c.categoryID=p.categoryID GROUP BY c.categoryID 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SHOW COLUMNS FROM `Shop` 2009/02/17 12:15:03 [trace] [system.db.CDbCommand] query with SQL: SHOW CREATE TABLE `Shop` 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "coreMessages" application component 2009/02/17 12:15:03 [error] [exception.CDbException] Object id #77 REQUEST_URI=/ 2009/02/17 12:15:03 [trace] [system.base.CApplication] Loading "errorHandler" application component
This is very urgent problem, any help is highly appreciated!