Plesk Question posted in
The official documentation for Plesk Obsidian can be found here.

Php site won't run, stops at the Pear DB connect, but no error – Plesk

I’ve migrated a site to our hosting, standard ubuntu Plesk 11 server…

The site will not run, it stops at this line, with no error logged, or returned to the screen.

    $db=&DB::connect("mysql://$config[db_username]:$config[db_password]@$config[db_host]/$config[db_name]" );

The config array is populated with the correct info for the database. The next few lines of code are 

if (PEAR::isError($db)) {
    print nl2br(var_export($db));
    die("Failed connecting to database");
}

Which the program never gets to? So I’m really stuck. It has the correct info, the database is there, but it does not appear to be able to get any further than the DB::connect line, but isn’t showing any error?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Well the above didn't return anything either, but I did find that DB has been superceeded by MDB2, so I updated with

    require_once('/usr/share/php/MDB2.php');

    and

    $db =&  MDB2::factory("mysql://$config[db_username]:$config[db_password]@$config[db_host]/$config[db_name]" );

    Which did get me an error, saying PHP Fatal error: Call to undefined function: MDB2_Driver_mysql::getAll(). in /usr/share/php/MDB2.php on line 1936

    So I added this 

    $db->loadModule('Extended');

    From this question Fatal error: Call to undefined function: MDB2_Driver_MYSQL::getAll()

    and it seems to have connected. Still not quite there but now I have something on the screen ! Thanks all.


  2. 0

    Try to add these lines inside your “if block” to find out the error reason:

    echo 'Standard Message: ' . $db->getMessage() . "n";
echo 'Standard Code: ' . $db->getCode() . "n";

    Print additional info:

    echo 'DBMS/User Message: ' . $db->getUserInfo() . "n";
echo 'DBMS/Debug Message: ' . $db->getDebugInfo() . "n";

    Look at this link: http://pear.php.net/manual/en/package.database.db.db-error.php

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search