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!
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...
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...
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
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....