HELP BOUT CDbException Error

Archives Yii 1.0.x Discussions
1

We are new to Yii framework and we could not determine the cause of this kind of error generated when we try to run the project application…

pls do help…

CDbException

Description

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1305 PROCEDURE silas.GetAdsSummary does not exist

Source File

C:\wamp\www\hkclassified\framework\db\CDbCommand.php(285)

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:            Yii::log('Error in executing SQL: '.$this->getText(),CLogger::LEVEL_ERROR,'system.db.CDbCommand');

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

00286:                array('{error}'=>$e->getMessage())));

00287:        }

00288:    }

00289: }

Stack Trace

#0 C:\wamp\www\hkclassified\framework\db\CDbCommand.php(205): CDbCommand->queryInternal('', 0)

#1 C:\wamp\www\hkclassified\protected\models\BL\SiteBL.php(49): CDbCommand->query()

#2 C:\wamp\www\hkclassified\protected\controllers\SiteController.php(118): SiteBL->ListAdsSummary()

#3 C:\wamp\www\hkclassified\framework\web\actions\CInlineAction.php(32): SiteController->actionIndex()

#4 C:\wamp\www\hkclassified\framework\web\CController.php(279): CInlineAction->run()

#5 C:\wamp\www\hkclassified\framework\web\CController.php(257): CController->runAction(Object(CInlineAction))

#6 C:\wamp\www\hkclassified\framework\web\CController.php(236): CController->runActionWithFilters(Object(CInlineAction), Array)

#7 C:\wamp\www\hkclassified\framework\web\CWebApplication.php(332): CController->run('')

#8 C:\wamp\www\hkclassified\framework\web\CWebApplication.php(120): CWebApplication->runController('')

#9 C:\wamp\www\hkclassified\framework\base\CApplication.php(133): CWebApplication->processRequest()

#10 C:\wamp\www\hkclassified\index.php(13): CApplication->run()

#11 {main}

2

It complains silas.GetAdsSummary (a column?) is not found. Could you verify that? Also, could you turn on logging and see what is the complete SQL being executed? The more context information you give, the easier and faster we can help.

3

i think functions are lack on that kind of error since on the sitecontroller the code is:

public function actionIndex()

{


	$data = array();


	$bl = new SiteBL;


	$data = $bl->ListAdsSummary();


	


	$this->render('index', array('data'=>$data));


}

then im trying to find wat s d error w/ dat?

4

Please provide more information: what is inside listAdsSummary? What is the generated SQL? Did you verify the existence of GetAdsSummary column?