0
Welcome Guest! Login
0 items Join Now

[solved - won't fix] PDO Connection Error

    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Hello !

      I am trying to copy my Joomla 1.7.1 sites to my local environment (Joomlas2Go!). So far the moving to the local environment was not an issue.

      But now, I am complely stuck with an "Uncaught exception: PDO Connection Error: SQLSTATE[HY000] [2002]" - error.

      The original site I am trying to copy locally is hosted on Hostgator.
      Apache 2.2.20
      MySQL 5.1.56
      PHP 5.2.17
      Using: MySQLi
      Template is Crystalline and also tried another site with Template Campher.

      I tried several ways to copy the sites to the local environment, to make sure nothing done wrong here. (Using Akeeba Backup, as well as doing everything manually. Export/Import of DB and copy/replace files.) Gabriel from Joomlas2Go was so kind and looked into the matter, but found no solution so far. But he confirmed that the local environment is working and OK.

      I get this PDO error after I move the site to my local environment and then try to open the front-page of this local installation. Tried on Win 7 and also Win XP. Same result.

      When I only import the DB and keep everything else untouched of my local environment of Joomlas2G (So I keep the all files of the default local installation) - I do see the front page of my site. But of course just a mere display as text, as the right Joomla-Template etc is missing. But I can connect to the imported DB.
      When I then replace the folders under root with the files from my original site, I loose the DB connection and get this PDO connection error.

      Also played around with the configuration.php file. .htacess files… but can’t get it to work.

      Also tried Server2Go. No success.

      Any ideas anyone? What do I have to look for, or could test?
      Help would be greatly appreciated!

      Thanks,
      Jörg
    • Last Edit: 8 years 1 month ago by Joerg D..
    • Ben Simon's Avatar
    • Ben Simon
    • Elite Rocketeer
    • Posts: 4301
    • Thanks: 8
    • Full-time web developer

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Do your sites use any PDO dependent modules/components?

      Although SQLSTATE[HY000] [2002] is a connection error make sure you have PHP support for MySQL PDO and SQLite PDO on your local build.
    • B e courteous to staff and members that volunteer their time helping you
      E ssential Tool - FireBug
      N ever assume I know what version you're talking about

      S earch the forum for a solution first
      I nclude a link to the problem
      M ark your resolved issues as [SOLVED]
      O nly PM moderators if they request it first
      N o...
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Thanks for your reply!

      Well, I have only installed
      > RokGallery
      > Ohanah Events
      > Akeeba Backup (never caused a problem, so far)
      > JCE Editor

      and switched to mysqli.

      That's all.

      How can I install a PHP support for MySQL PDO and SQLite PDO on my local build?
    • Ben Simon's Avatar
    • Ben Simon
    • Elite Rocketeer
    • Posts: 4301
    • Thanks: 8
    • Full-time web developer

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • RokGallery requires both. See System Requirements here: www.rockettheme.com/extensions-joomla/rokgallery

      I don't use Joomlas2Go so it's difficult to say exactly were you php.ini file is. Searching the forum I found this: http://www.rockettheme.com/forum/index.php?f=528&t=138794&rb_v=viewtopic .

      Look for these lines and remove the ';' in front or create them if necessary:
      extension=php_pdo_mysql.dll
      extension=php_pdo_SQlite.dll


      "Joomlas2Go" type solutions are good for simple testing but I recommend finding a good host that can take care of these issues for you or install a simple WAMP/LAMP config on your machine yourself.
    • B e courteous to staff and members that volunteer their time helping you
      E ssential Tool - FireBug
      N ever assume I know what version you're talking about

      S earch the forum for a solution first
      I nclude a link to the problem
      M ark your resolved issues as [SOLVED]
      O nly PM moderators if they request it first
      N o...
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Thanks for your update!

      It was all active already:
      php.ini settings:
      ...
      extension=php_pdo.dll
      extension=php_sqlite.dll
      extension=php_mysql_libmysql.dll
      extension=php_mysqli_libmysql.dll
      extension=php_pdo_sqlite.dll
      extension=php_pdo_pgsql.dll
      extension=php_pdo_mysql.dll
      ...

      I switched back to mysql on my server-installation and deactivated the Koowa plugin which is used by ohanah. Exported and Imported everything again into local build:
      ==> Same error-message on my local enviroment :cry:

      If I set up a fresh & empty Joomla 1.7.1 install with mysqli it does work in my local build. At least I get to see the frontpage! But I get another strange effect: When I log in to the admin-area I only get a blank white page - but this might be another issue....
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • The issue is indeed with RokGallery.

      When I disable RokGallery the import to my local Joomlas2Go! environment works fine.

      I will send an email to Gabriel from Joomlas2Go! and ask if the Joomlas2Go! package can be modified so that it will run even with RokGallery.
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Gabriel will try to fix this, so that the RokGallery extension will also work in the local Joomlas2Go! environment. I will post an update.

      Looks like the needed InnoDB support is causing the problem.

      So far the workaround is: Disable RokGallery on your server-installation. Then export from the server and import in the local environment.
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago
    • Does anyone know, where RokGallery allocates the innoDBs?.
      Where are they located (absolute path) ??
      (Joomlas2Go! needs this info)

      Thanks!!!

      Jörg
    • Joerg D.'s Avatar
    • Joerg D.
    • Rocketeer
    • Posts: 73
    • Thanks: 0

    Re: [solved - won't fix] PDO Connection Error

    Posted 8 years 1 month ago

Time to create page: 0.085 seconds