PDO Connection Error: SQLSTATE[HY000] [2002]

OrangeHRM
2010-12-21
2013-06-05
  • I saw this posted for Beta - I am not sure why I am getting this on a fresh install.
    I added PDO to PHP

    bz2
    calendar
    ctype
    curl
    date
    dbase
    exif
    ftp
    gettext
    gmp
    hash
    iconv
    ldap
    libxml
    mime_magic
    openssl
    pcntl
    pcre
    PDO
    pdo_sqlite
    posix
    pspell
    Reflection
    session
    shmop
    SimpleXML
    sockets
    SPL
    standard
    sysvmsg
    sysvsem
    sysvshm
    tokenizer
    wddx
    xml
    zlib

    the error is :

    500 | Internal Server Error | PerformanceServiceException
    PDO Connection Error: SQLSTATE  Invalid argument
    stack trace

    * at ()
    in SF_ROOT_DIR/apps/orangehrm/lib/model/performance/service/PerformanceReviewService.php line 316 …
    313. return false;
    314. }
    315. } catch (Exception $e) {
    316. throw new PerformanceServiceException($e->getMessage());
    317. }
    318.
    319. }
    * at PerformanceReviewService->isReviewer(null)
    in SF_ROOT_DIR/apps/orangehrm/modules/performance/actions/actions.class.php line 503 …
    500.
    501. $performanceReviewService = $this->getPerformanceReviewService();
    502.
    503. return $performanceReviewService->isReviewer($empId);
    504.
    505. }
    506.
    * at performanceActions->isLoggedReviewer(null)
    in SF_ROOT_DIR/apps/orangehrm/modules/performance/actions/actions.class.php line 120 …
    117. $this->loggedAdmin = false;
    118. }
    119.
    120. $this->loggedReviewer = $this->isLoggedReviewer($_SESSION);
    121.
    122. if (isset($_SESSION)) {
    123. $this->loggedUserId = $_SESSION;
    * at performanceActions->preExecute()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 89 …
    86. protected function executeAction($actionInstance)
    87. {
    88. // execute the action
    89. $actionInstance->preExecute();
    90. $viewName = $actionInstance->execute($this->context->getRequest());
    91. $actionInstance->postExecute();
    92.
    * at sfExecutionFilter->executeAction(object('performanceActions'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 76 …
    73. return sfView::SUCCESS;
    74. }
    75.
    76. return $this->executeAction($actionInstance);
    77. }
    78.
    79. /**
    * at sfExecutionFilter->handleAction(object('sfFilterChain'), object('performanceActions'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 53 …
    50. }
    51. else
    52. {
    53. $viewName = $this->handleAction($filterChain, $actionInstance);
    54. $this->handleView($filterChain, $actionInstance, $viewName);
    55. }
    56. }
    * at sfExecutionFilter->execute(object('sfFilterChain'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 …
    50. }
    51.
    52. // execute the next filter
    53. $this->chain->execute($this);
    54. }
    55. }
    56.
    * at sfFilterChain->execute()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfCommonFilter.class.php line 29 …
    26. public function execute($filterChain)
    27. {
    28. // execute next filter
    29. $filterChain->execute();
    30.
    31. // execute this filter only once
    32. $response = $this->context->getResponse();
    * at sfCommonFilter->execute(object('sfFilterChain'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 …
    50. }
    51.
    52. // execute the next filter
    53. $this->chain->execute($this);
    54. }
    55. }
    56.
    * at sfFilterChain->execute()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfBasicSecurityFilter.class.php line 62 …
    59. }
    60.
    61. // the user has access, continue
    62. $filterChain->execute();
    63. }
    64.
    65. /**
    * at sfBasicSecurityFilter->execute(object('sfFilterChain'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 …
    50. }
    51.
    52. // execute the next filter
    53. $this->chain->execute($this);
    54. }
    55. }
    56.
    * at sfFilterChain->execute()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 …
    30. public function execute($filterChain)
    31. {
    32. // execute next filter
    33. $filterChain->execute();
    34.
    35. // get response object
    36. $response = $this->context->getResponse();
    * at sfRenderingFilter->execute(object('sfFilterChain'))
    in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 …
    50. }
    51.
    52. // execute the next filter
    53. $this->chain->execute($this);
    54. }
    55. }
    56.
    * at sfFilterChain->execute()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfController.class.php line 245 …
    242. }
    243.
    244. // process the filter chain
    245. $filterChain->execute();
    246. }
    247. else
    248. {
    * at sfController->forward('performance', 'saveReview')
    in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 …
    45. }
    46.
    47. // make the first request
    48. $this->forward($moduleName, $actionName);
    49. }
    50. catch (sfException $e)
    51. {
    * at sfFrontWebController->dispatch()
    in SF_ROOT_DIR/lib/vendor/symfony/lib/util/sfContext.class.php line 159 …
    156. */
    157. public function dispatch()
    158. {
    159. $this->getController()->dispatch();
    160. }
    161.
    162. /**
    * at sfContext->dispatch()
    in SF_ROOT_DIR/web/index.php line 13 …
    10. require_once(dirname(__FILE__).'/../config/ProjectConfiguration.class.php');
    11.
    12. $configuration = ProjectConfiguration::getApplicationConfiguration('orangehrm', 'prod', true);
    13. sfContext::createInstance($configuration)->dispatch();
    14.

    symfony settings …

    app_items_per_page: 50
    app_sort_asc_class: ASC
    app_sort_default_class: null
    app_sort_desc_class: DESC
    mod_performance_enabled: true
    mod_performance_is_internal: false
    mod_performance_view_class: sfPHP
    sf_admin_module_web_dir: /sfDoctrinePlugin
    sf_admin_web_dir: /sf/sf_admin
    sf_app: orangehrm
    sf_app_base_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm
    sf_app_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod
    sf_app_config_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm/config
    sf_app_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm
    sf_app_i18n_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm/i18n
    sf_app_lib_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm/lib
    sf_app_module_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm/modules
    sf_app_template_dir: /opt/lampp/htdocs/orangehrm/symfony/apps/orangehrm/templates
    sf_apps_dir: /opt/lampp/htdocs/orangehrm/symfony/apps
    sf_cache: false
    sf_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache
    sf_calendar_web_dir: /sf/calendar
    sf_charset: utf-8
    sf_check_lock: false
    sf_check_symfony_version: false
    sf_compressed: false
    sf_config_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod/config
    sf_config_dir: /opt/lampp/htdocs/orangehrm/symfony/config
    sf_csrf_secret: 'kafkasipi3#iadfsakf'
    sf_data_dir: /opt/lampp/htdocs/orangehrm/symfony/data
    sf_debug: true
    sf_default_culture: en
    sf_doc_dir: /opt/lampp/htdocs/orangehrm/symfony/doc
    sf_enabled_modules:
    - default
    sf_environment: prod
    sf_error_404_action: error404
    sf_error_404_module: default
    sf_error_reporting: 341
    sf_escaping_method: ESC_SPECIALCHARS
    sf_escaping_strategy: true
    sf_etag: true
    sf_i18n: true
    sf_i18n_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod/i18n
    sf_lazy_cache_key: true
    sf_lib_dir: /opt/lampp/htdocs/orangehrm/symfony/lib
    sf_log_dir: /opt/lampp/htdocs/orangehrm/symfony/log
    sf_logging_enabled: false
    sf_login_action: login
    sf_login_module: auth
    sf_max_forwards: 5
    sf_module_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod/modules
    sf_module_disabled_action: disabled
    sf_module_disabled_module: default
    sf_no_script_name: false
    sf_orm: doctrine
    sf_plugins_dir: /opt/lampp/htdocs/orangehrm/symfony/plugins
    sf_rich_text_js_dir: js/tiny_mce
    sf_root_dir: /opt/lampp/htdocs/orangehrm/symfony
    sf_secure_action: secure
    sf_secure_module: default
    sf_standard_helpers:
    - Partial
    - Cache
    - Form
    - Orange
    - Url
    - I18N
    sf_strip_comments: true
    sf_symfony_lib_dir: /opt/lampp/htdocs/orangehrm/symfony/lib/vendor/symfony/lib
    sf_template_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod/template
    sf_test_cache_dir: /opt/lampp/htdocs/orangehrm/symfony/cache/orangehrm/prod/test
    sf_test_dir: /opt/lampp/htdocs/orangehrm/symfony/test
    sf_upload_dir: /opt/lampp/htdocs/orangehrm/symfony/web/uploads
    sf_use_database: true
    sf_validation_error_class: form_error
    sf_validation_error_id_prefix: error_for_
    sf_validation_error_prefix: ' ↓ '
    sf_validation_error_suffix: '  ↓'
    sf_web_debug: false
    sf_web_debug_web_dir: /sf/sf_web_debug
    sf_web_dir: /opt/lampp/htdocs/orangehrm/symfony/web

    request …

    parameterHolder:
    action: saveReview
    module: performance
    attributeHolder:
    sf_route: 'sfRoute Object()'

    response …

    options:
    http_protocol: HTTP/1.1
    logging: ''
    charset: utf-8
    send_http_headers: true
    content_type: 'text/html; charset=utf-8'
    cookies: { }
    httpHeaders:
    Content-Type: 'text/html; charset=utf-8'
    javascripts: { }
    stylesheets: { }
    metas: { }
    httpMetas: { }

    user …

    options:
    auto_shutdown: false
    culture: null
    default_culture: en
    use_flash: true
    logging: ''
    timeout: 1800
    attributeHolder: { }
    culture: en

    global vars …

    cookie:
    Loggedin: 'True'
    PHPSESSID: tjcp1duuop4cadf71vdp5p1ia0
    env: { }
    files: { }
    get: { }
    post: { }
    server:
    DOCUMENT_ROOT: /opt/lampp/htdocs
    GATEWAY_INTERFACE: CGI/1.1
    HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
    HTTP_ACCEPT_CHARSET: 'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
    HTTP_ACCEPT_ENCODING: 'gzip,deflate'
    HTTP_ACCEPT_LANGUAGE: 'en-us,en;q=0.5'
    HTTP_CONNECTION: keep-alive
    HTTP_COOKIE: 'PHPSESSID=tjcp1duuop4cadf71vdp5p1ia0; Loggedin=True'
    HTTP_HOST: 192.203.240.238
    HTTP_KEEP_ALIVE: '300'
    HTTP_REFERER: 'http://192.203.240.238/orangehrm/index.php?uniqcode=KPI&menu_no_top=performance&uri=performance/saveReview'
    HTTP_USER_AGENT: 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 ( .NET CLR 3.5.30729; .NET4.0C)'
    PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
    PATH_INFO: /performance/saveReview
    PATH_TRANSLATED: /opt/lampp/htdocs/performance/saveReview
    PHP_SELF: /orangehrm/symfony/web/index.php/performance/saveReview
    QUERY_STRING: ''
    REMOTE_ADDR: 192.168.192.190
    REMOTE_PORT: '55582'
    REQUEST_METHOD: GET
    REQUEST_TIME: 1292893074
    REQUEST_URI: /orangehrm/symfony/web/index.php/performance/saveReview
    SCRIPT_FILENAME: /opt/lampp/htdocs/orangehrm/symfony/web/index.php
    SCRIPT_NAME: /orangehrm/symfony/web/index.php
    SERVER_ADDR: 192.203.240.238
    SERVER_ADMIN: you@example.com
    SERVER_NAME: 192.203.240.238
    SERVER_PORT: '80'
    SERVER_PROTOCOL: HTTP/1.1
    SERVER_SIGNATURE: "<address>Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 Server at 192.203.240.238 Port 80</address>\n"
    SERVER_SOFTWARE: 'Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1'
    UNIQUE_ID: TQ-7ksDL8O4AAA5qXo4AAAAE
    session:
    PIM_MENU_TYPE: left
    WPATH: /orangehrm
    empID: null
    empNumber: null
    fname: Admin
    hp-action: GEN
    hp-module: Admin
    hp-role: Admin
    hp-userType: ESS
    isAcceptor: false
    isAdmin: 'Yes'
    isDirector: false
    isManager: false
    isOfferer: false
    isProjectAdmin: false
    isSupervisor: false
    ldap: disabled
    ldapStatus: disabled
    localRights: { add: false, edit: false, delete: false, view: false, repDef: true }
    path: /opt/lampp/htdocs/orangehrm
    posted: false
    printBenefits: enabled
    styleSheet: orange
    symfony/user/sfUser/attributes: { }
    symfony/user/sfUser/culture: en
    timePeriodSet: 'Yes'
    user: USR001
    userGroup: USG001
    userTimeZoneOffset: '-8'

    symfony v.1.2.8 - php 5.3.1