by krupali » Fri Nov 23, 2012 11:31 am
Leave summary form is not open and "internal error" comes.. and log file indicate folloing errrors.. please help
Next exception 'DaoException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION scpltd_hr.CONCAT does not exist' in /home/scpltd/public_html/hr/symfony/plugins/orangehrmCoreLeavePlugin/lib/dao/LeaveSummaryDao.php:135
Stack trace:
#0 /home/scpltd/public_html/hr/symfony/plugins/orangehrmCoreLeavePlugin/lib/service/LeaveSummaryService.php(80): LeaveSummaryDao->searchLeaveSummary(Array, 0, 20)
#1 /home/scpltd/public_html/hr/symfony/plugins/orangehrmCoreLeavePlugin/modules/leave/actions/viewLeaveSummaryAction.class.php(130): LeaveSummaryService->searchLeaveSummary(Array, 0, 20)
#2 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(952): viewLeaveSummaryAction->execute(Object(sfWebRequest))
#3 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(947): sfExecutionFilter->executeAction(Object(viewLeaveSummaryAction))
#4 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(933): sfExecutionFilter->handleAction(Object(sfFilterChain), Object(viewLeaveSummaryAction))
#5 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): sfExecutionFilter->execute(Object(sfFilterChain))
#6 /home/scpltd/public_html/hr/symfony/lib/vendor/symfony/lib/filter/sfCommonFilter.class.php(29): sfFilterChain->execute()
#7 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): sfCommonFilter->execute(Object(sfFilterChain))
#8 /home/scpltd/public_html/hr/symfony/plugins/orangehrmCorePlugin/lib/filter/orangehrmPostExecutionFilter.php(22): sfFilterChain->execute()
#9 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): orangehrmPostExecutionFilter->execute(Object(sfFilterChain))
#10 /home/scpltd/public_html/hr/symfony/apps/orangehrm/lib/filter/ModuleFilter.php(56): sfFilterChain->execute()
#11 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): ModuleFilter->execute(Object(sfFilterChain))
#12 /home/scpltd/public_html/hr/symfony/plugins/orangehrmCorePlugin/lib/authorization/filter/ohrmAuthorizationFilter.php(97): sfFilterChain->execute()
#13 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): ohrmAuthorizationFilter->execute(Object(sfFilterChain))
#14 /home/scpltd/public_html/hr/symfony/apps/orangehrm/lib/filter/SessionInfoFetcherFilter.php(67): sfFilterChain->execute()
#15 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): SessionInfoFetcherFilter->execute(Object(sfFilterChain))
#16 /home/scpltd/public_html/hr/symfony/apps/orangehrm/lib/filter/OrangeI18NFilter.php(58): sfFilterChain->execute()
#17 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): OrangeI18NFilter->execute(Object(sfFilterChain))
#18 /home/scpltd/public_html/hr/symfony/apps/orangehrm/lib/filter/ExceptionCatcherFilter.php(26): sfFilterChain->execute()
#19 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): ExceptionCatcherFilter->execute(Object(sfFilterChain))
#20 /home/scpltd/public_html/hr/symfony/lib/vendor/symfony/lib/filter/sfBasicSecurityFilter.class.php(72): sfFilterChain->execute()
#21 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): sfBasicSecurityFilter->execute(Object(sfFilterChain))
#22 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(995): sfFilterChain->execute()
#23 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(1031): sfRenderingFilter->execute(Object(sfFilterChain))
#24 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(665): sfFilterChain->execute()
#25 /home/scpltd/public_html/hr/symfony/cache/orangehrm/prod/config/config_core_compile.yml.php(2352): sfController->forward('leave', 'viewLeaveSummar...')
#26 /home/scpltd/public_html/hr/symfony/lib/vendor/symfony/lib/util/sfContext.class.php(170): sfFrontWebController->dispatch()
#27 /home/scpltd/public_html/hr/symfony/web/index.php(22): sfContext->dispatch()
#28 {main}