blank page when using PostgreSQL database in CodeIgniter

Question

I'm developing a PHP application using CodeIgniter as the framework, and PostgreSQL as the database. In \application\config\database.php I have the following configuration:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '<myusername>';
$db['default']['password'] = '<mypassword>';
$db['default']['database'] = 'heatmap';
$db['default']['dbdriver'] = 'postgre';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

When I try to load my http://localhost/heatmap/ page I only get a blank page. Nothing is displayed, and the page source is empty as well. No error thrown. I'm only trying to load the default page that comes with CodeIgniter. I did googled this problem, and none of the related problems I found solved my problem. My Postgres version is 9.1, PHP is 5.3.8.

karthikr · Accepted Answer · 2012-12-19 21:34:51Z

5

I can only say what helped me. I just realized that i don't have php-postgre drivers in my system (Debian) Installing php5-pgsql worked for me. After this i had to set the

$db['default']['db_debug'] = FALSE;

And now everything works just fine.

edited Dec 19, 2012 at 21:34

karthikr

100k26 gold badges208 silver badges191 bronze badges

answered Dec 19, 2012 at 21:17

I2i

511 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Clark So · Accepted Answer · 2014-05-05 16:12:22Z

1

Check php.ini: extension=php_pgsql.dll

Check httpd.conf: LoadFile "C:/Program Files/PostgreSQL/9.3/bin/libpq.dll"

Reboot the apache.

answered May 5, 2014 at 16:12

Clark So

113 bronze badges

Comments

Robert · Accepted Answer · 2012-06-29 12:46:31Z

0

Are you sure that the problem is caused by your database(configuration)? The default controller does not interact with the database and the database class is not loaded by default.

If you did load the database class yourself using $this->load->database(); then remove it and see if the default page is being displayed.

I would also recommend turning error_reporting() on so you can look through the logs and see what happens. More info on that topic can be found here.

answered Jun 29, 2012 at 12:46

Robert

1,9051 gold badge17 silver badges24 bronze badges

3 Comments

cybertextron Over a year ago

I did so: removed database from autoload, the page loaded correctly. I'm not even using $this->load->database();, and the controller I'm using is the default controller that come with the framework.

Robert Over a year ago

Ok, so now we know that the problem is indeed caused by the database(connection). As suggested, take a look at the log.

vandershraaf Over a year ago

If you do find the log, add it to your question. That would be helpful

Collectives™ on Stack Overflow

blank page when using PostgreSQL database in CodeIgniter

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related