View Single Post
Old 02-11-2005, 10:05 PM   #1
zac
Green Mole
 
Join Date: Feb 2005
Posts: 3
Cannot re-connect to db

Great script - thanks for all your efforts.

I got version version 1.8.7 going fine, except for lots of amp-raquo and amp-hash-1234 stuff.

I then decided I had to go for the UTF-8 version (1.8.8.-RC1) but could not install it becaue my mySQL is not the right version. So I wanted to go back to my working 1.8.7.

But now I cannot re-connect to the db - having quadruple checked the names of user, db, etc. and checked the connect.php settings which are (with the correct resplacement for &&& and ***, of course):
define('PHPDIG_DB_PREFIX','<php_search>');
define('PHPDIG_DB_HOST','<localhost>');
define('PHPDIG_DB_USER','<&&&&_dbname>');
define('PHPDIG_DB_PASS','<*******>');
define('PHPDIG_DB_NAME','<&&&&_DBNAME>');

When going to search.php, I get "Unable to connect to database : Check the connection script.". I then went to admin/install.php to try to get it to "find" the db again (using either "update db" or "write only connection parameters" options).

I know that the script is working its way through install.php (which indicates that it is finding the db okay, right?? - otherwise it would give an error earlier in the script) and all makes sense until the line...
Code:
 if ($cerror > 0) {
 //clean partial installation
    if (!$dbopt) {
       // @mysql_drop_db($dbname,$id_connect);
    $error .= phpdigMsg('error4');
    }
        $step = 1;
    }
     else {
     header("location:$relative_script_path/admin/");
}
It does enter the "if" section but does not kick error4 - and of course it does not go to /admin/, it just stays on the page install.php.

The parameters to be entered in install.php shoudl be exactly the same as those in connect.php, right? I had trouble first round getting these right and cannot quite remember what got me past this page.

Help please.
zac is offline   Reply With Quote