TDbException

Description

TDbCommand failed to execute the query SQL "call sp_getsite(6)": SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user 'siteuser'@'187.45.214.24' for routine 'manager.sp_getsite'

Source File

/var/www/html/framework_3-1-4/Data/TDbCommand.php (230)

0219:         try
0220:         {
0221:             // Prado::trace('Query: '.$this->getDebugStatementText(), 'System.Data');
0222:             if($this->_statement instanceof PDOStatement)
0223:                 $this->_statement->execute();
0224:             else
0225:                 $this->_statement=$this->getConnection()->getPdoInstance()->query($this->getText());
0226:             return new TDbDataReader($this);
0227:         }
0228:         catch(Exception $e)
0229:         {
0230: throw new TDbException('dbcommand_query_failed',$e->getMessage(),$this->getDebugStatementText());
0231: } 0232: } 0233: 0234: /** 0235: * Executes the SQL statement and returns the first row of the result. 0236: * This is a convenient method of {@link query} when only the first row of data is needed. 0237: * @param boolean whether the row should be returned as an associated array with 0238: * column names as the keys or the array keys are column indexes (0-based). 0239: * @return array the first row of the query result, false if no result. 0240: * @throws TDbException execution failed 0241: */ 0242: public function queryRow($fetchAssociative=true)

Stack Trace

#0 /var/www/html/common/Data.php(47): TDbCommand->query()
#1 /var/www/html/common/Data.php(71): Data->Execute('call sp_getsite...')
#2 /var/www/html/common/DataAccess.php(18): Data->DataReader('call sp_getsite...')
#3 /var/www/html/common/GetData.php(24): DataAccess::GetData('call sp_getsite...')
#4 /var/www/html/feeds-rss/protected/App_Code/FeedProvider.php(36): GetData::GetDataReaderUsingCache('call sp_getsite...')
#5 /var/www/html/feeds-rss/protected/App_Code/FeedProvider.php(77): Site::GetSite('6')
#6 /var/www/html/feeds-rss/protected/App_Code/FeedProvider.php(122): FeedProvider->buildFeedContent()
#7 /var/www/html/framework_3-1-4/Web/Services/TFeedService.php(93): FeedProvider->getFeedContent()
#8 /var/www/html/framework_3-1-4/pradolite.php(9172): TFeedService->run()
#9 /var/www/html/framework_3-1-4/pradolite.php(8774): TApplication->runService()
#10 /var/www/html/feeds-rss/index.php(21): TApplication->run()
#11 {main}
2012-02-11 00:18 Apache PRADO/3.1.4