Advertisement
Guest User

Untitled

a guest
Oct 13th, 2011
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.51 KB | None | 0 0
  1. SELECT `categId`, `name`, `description`, `parentId`, `hits` FROM `sj-wiki`.`tiki_categories` WHERE ParentId = '3' ORDER BY `categId` DESC LIMIT 1
  2.  
  3. error:
  4.  
  5. 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 'LIMIT 1 OFFSET 0' at line 10
  6. The query was:
  7.  SELECT `categId`, `name`, `description`, `parentId`, `hits` FROM `sj-wiki`.`tiki_categories` WHERE ParentId = ? ORDER BY `categId` DESC LIMIT 1
  8. VALUES:
  9. 1.3
  10.  
  11. The built query was likely:
  12.  SELECT `categId`, `name`, `description`, `parentId`, `hits` FROM `sj-wiki`.`tiki_categories` WHERE ParentId = '3' ORDER BY `categId` DESC LIMIT 1
  13. Stacktrace:
  14.  
  15.  * C:\inetpub\wwwroot\AutoOpretTest.php : 0 -> {main}(array ( ))
  16. * C:\inetpub\wwwroot\AutoOpretTest.php : 8 -> GetLastCreatedWikiSag(array ( ))
  17. * C:\inetpub\wwwroot\lib\sjlib\TikiObjectCreator.php : 99 -> getOne(array ( 'query' => '', 'values' => '', 'reporterrors' => '', 'offset' => '', ))
  18. * C:\inetpub\wwwroot\lib\core\TikiDb\Bridge.php : 42 -> getOne(array ( 'query' => '', 'values' => '', 'reporterrors' => '', 'offset' => '', ))
  19. * C:\inetpub\wwwroot\lib\core\TikiDb.php : 65 -> query(array ( 'query' => '', 'values' => '', 'numrows' => '', 'offset' => '', 'reporterrors' => '', ))
  20. * C:\inetpub\wwwroot\lib\core\TikiDb\Pdo.php : 118 -> handleQueryError(array ( 'query' => '', 'values' => '', 'result' => '', ))
  21. * C:\inetpub\wwwroot\lib\core\TikiDb.php : 148 -> handle(array ( 'db' => '', 'query' => '', 'values' => '', 'result' => '', ))
  22.  
  23.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement