Database Error

Error: 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 'INT) ASC' at line 1

SQL Query: SELECT `EvaluationToDoc`.`id`, `EvaluationToDoc`.`evaluation_id`, `EvaluationToDoc`.`test`, `EvaluationToDoc`.`rezolvare`, `EvaluationToDoc`.`is_new` FROM `evaluations_to_doc` AS `EvaluationToDoc` WHERE `EvaluationToDoc`.`evaluation_id` = (5) ORDER BY CAST(replace(replace(replace(replace(replace(replace(test,"T",""),"PPCExB",""),".pdf",""),"PCA",""),"CPExB-ES",""),"CPA","") as INT) ASC

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

#0 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(436): PDOStatement->execute(Array)
#1 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(403): DboSource->_execute('SELECT `Evaluat...', Array)
#2 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(647): DboSource->execute('SELECT `Evaluat...', Array, Array)
#3 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(1282): DboSource->fetchAll('SELECT `Evaluat...', false)
#4 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(1150): DboSource->fetchAssociated(Object(Evaluation), 'SELECT `Evaluat...', Array)
#5 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Datasource/DboSource.php(1069): DboSource->queryAssociation(Object(Evaluation), Object(EvaluationToDoc), 'hasMany', 'EvaluationToDoc', Array, Array, true, Array, 0, Array)
#6 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Model/Model.php(2460): DboSource->read(Object(Evaluation), Array)
#7 /home/c18revista/public_html/old.isfin.ro/app/Controller/EvaluationsController.php(79): Model->find('first', Array)
#8 [internal function]: EvaluationsController->view('ppi-angajat-al-...')
#9 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Controller/Controller.php(473): ReflectionMethod->invokeArgs(Object(EvaluationsController), Array)
#10 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Routing/Dispatcher.php(107): Controller->invokeAction(Object(CakeRequest))
#11 /home/c18revista/public_html/old.isfin.ro/lib/Cake/Routing/Dispatcher.php(89): Dispatcher->_invoke(Object(EvaluationsController), Object(CakeRequest), Object(CakeResponse))
#12 /home/c18revista/public_html/old.isfin.ro/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#13 {main}