CDbException

CDbCommand failed to execute the SQL statement: 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 'N' Sold Corp. until 9-06
Former' at line 1. The SQL statement executed was: INSERT INTO `mailbox` SET id='179406',timestamp='1363371223',msg_status='' ,message_read='',to_userid='3023',from_userid ='2136',to_name='kimodog',from_name='Lmcat',message=' 
List of failed GDSM companies! SEVENTEEN years of failures !
 
Formerly= Gold Coast Mining until 3/2013
Formerly=Hot Web, Inc. until 7-2009
Formerly=Snap 'N' Sold Corp. until 9-06
Formerly=Raptor Investments, Inc. until 7-05
Formerly=Paramark Enterprises, Inc. until 11-01
Note=12-01 State of Incorporation Delaware changed to Florida
Formerly=T.J. Cinnamons, Inc. until 8-96
 '

/var/www/vhosts/InvestorsHangout.com/httpdocs/framework/db/CDbCommand.php(516)

504             return $result; 

505         } 

506         catch(Exception $e) 

507         { 

508             if($this->_connection->enableProfiling) 

509                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 

510             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 

511             $message = $e->getMessage(); 

512             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 

513                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 

514             if(YII_DEBUG) 

515                 $message .= '. The SQL statement executed was: '.$this->getText().$par; 

516             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 

517                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 

518         } 

519     } 

520  

521     /** 

522      * Builds a SQL SELECT statement from the given query specification. 

523      * @param array $query the query specification in name-value pairs. The following 

524      * query options are supported: {@link select}, {@link distinct}, {@link from}, 

525      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 

526      * {@link limit}, {@link offset} and {@link union}. 

527      * @return string the SQL statement 

528      * @since 1.1.6

Stack Trace

#0	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/db/CDbCommand.php(355): CDbCommand->queryInternal("", 0, array())
#1	– /var/www/vhosts/InvestorsHangout.com/httpdocs/protected/modules/messages/controllers/YumMessagesController.php(233): CDbCommand->query() 228 229 { 230 231 $sql="INSERT INTO `mailbox` SET id='".$model->id."',timestamp='".time()."',msg_status='".$data."' ,message_read='".$data."',to_userid='".$data."',from_userid ='".Yii::app()->user->id."',to_name='".$uname1[0]."',from_name='".$uname[0]."',message='".$data."'"; 232 $command=$connection->createCommand($sql); 233 $mailbox=$command->query(); 234 235 } 236 237 ////////////////////////////////////////////////////////////// 238
#2	unknown(0): YumMessagesController->actionCompose(null)
#3	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/actions/CAction.php(104): ReflectionMethod->invokeArgs(YumMessagesController, array(null))
#4	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/actions/CInlineAction.php(48): CAction->runWithParamsInternal(YumMessagesController, ReflectionMethod, array())
#5	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CController.php(300): CInlineAction->runWithParams(array())
#6	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/filters/CFilterChain.php(134): CController->runAction(CInlineAction)
#7	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/filters/CFilter.php(41): CFilterChain->run()
#8	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CController.php(1144): CFilter->filter(CFilterChain)
#9	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/filters/CInlineFilter.php(59): CController->filterAccessControl(CFilterChain)
#10	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(CFilterChain)
#11	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CController.php(283): CFilterChain->run()
#12	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CController.php(257): CController->runActionWithFilters(CInlineAction, array("accessControl"))
#13	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CWebApplication.php(277): CController->run("compose")
#14	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/web/CWebApplication.php(136): CWebApplication->runController("messages/messages/compose")
#15	+ /var/www/vhosts/InvestorsHangout.com/httpdocs/framework/base/CApplication.php(159): CWebApplication->processRequest()
#16	– /var/www/vhosts/InvestorsHangout.com/httpdocs/index.php(13): CApplication->run() 08 error_reporting(E_ALL & ~E_NOTICE); 09 10 defined('YII_DEBUG') or define('YII_DEBUG',true); 11 require_once($investor); 12 // calling for creating main application 13 Yii::createWebApplication($config)->run();

(0)