Could not execute query [Native Error: 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 'ORDER BY category.ORDERVIEW ASC' at line 2] [User Info: SELECT category.CATEGORYID FROM category WHERE category.LANGUAGEID=2 AND category.DELETED='0' AND category.HIDDEN='0' AND category.SITEID=0 AND category.PARENTID= ORDER BY category.ORDERVIEW ASC]
/home/alhedaya/public_html/protected/DataAccess/creole/drivers/mysql/MySQLConnection.php (201)
0190: {
0191: $this->lastQuery = $sql;
0192: //echo '<b style="color:red">'.$this->i++.'<b>';
0193: //echo '<hr>';
0194: if ($this->database) {
0195: if (!@mysql_select_db($this->database, $this->dblink)) {
0196: throw new SQLException('No database selected', mysql_error($this->dblink));
0197: }
0198: }
0199: $result = @mysql_query($sql, $this->dblink);
0200: if (!$result) {
0201: throw new SQLException('Could not execute query', mysql_error($this->dblink), $sql);
0202: }
0203: return new MySQLResultSet($this, $result, $fetchmode);
0204: }
0205:
0206: /**
0207: * @see Connection::executeUpdate()
0208: */
0209: function executeUpdate($sql)
0210: {
0211: $this->lastQuery = $sql;
0212:
0213: if ($this->database) {
#0 /home/alhedaya/public_html/protected/DataAccess/creole/common/StatementCommon.php(242): MySQLConnection->executeQuery('SELECT category...', NULL)
#1 /home/alhedaya/public_html/protected/Layouts/shiasites/LayoutHomeShiaSites.php(144): StatementCommon->executeQuery('SELECT category...')
#2 /home/alhedaya/public_html/protected/Layouts/shiasites/LayoutHomeShiaSites.php(133): LayoutHomeShiaSites->LoadCas('')
#3 /home/alhedaya/public_html/protected/Layouts/shiasites/LayoutHomeShiaSites.php(77): LayoutHomeShiaSites->LoadDataCategories('')
#4 /home/alhedaya/public_html/protected/Layouts/shiasites/LayoutHomeShiaSites.php(29): LayoutHomeShiaSites->loadSelectiveSite()
#5 /home/alhedaya/public_html/framework/Web/UI/TControl.php(1270): LayoutHomeShiaSites->OnInit(NULL)
#6 /home/alhedaya/public_html/framework/Web/UI/TCompositeControl.php(35): TControl->initRecursive(Object(shiasites))
#7 /home/alhedaya/public_html/framework/Web/UI/TTemplateControl.php(240): TCompositeControl->initRecursive(Object(shiasites))
#8 /home/alhedaya/public_html/framework/Web/UI/TControl.php(1255): TTemplateControl->initRecursive(Object(shiasites))
#9 /home/alhedaya/public_html/framework/Web/UI/TCompositeControl.php(35): TControl->initRecursive(NULL)
#10 /home/alhedaya/public_html/framework/Web/UI/TTemplateControl.php(240): TCompositeControl->initRecursive(NULL)
#11 /home/alhedaya/public_html/framework/Web/UI/TPage.php(202): TTemplateControl->initRecursive()
#12 /home/alhedaya/public_html/framework/Web/UI/TPage.php(193): TPage->processNormalRequest(Object(THtmlWriter))
#13 /home/alhedaya/public_html/framework/Web/Services/TPageService.php(474): TPage->run(Object(THtmlWriter))
#14 /home/alhedaya/public_html/framework/Web/Services/TPageService.php(420): TPageService->runPage(Object(shiasites), Array)
#15 /home/alhedaya/public_html/framework/TApplication.php(1066): TPageService->run()
#16 /home/alhedaya/public_html/framework/TApplication.php(376): TApplication->runService()
#17 /home/alhedaya/public_html/ar.php(141): TApplication->run()
#18 {main}