Menu

Error message while opening -Date function

Help
C P
2010-02-05
2013-05-30
  • C P

    C P - 2010-02-05

    I get the following error and am clue less on what to do.

    I am beginner in this field and will appreciate your patience in understanding my problem.

    ERROR 2: PDO::__construct() :  A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:0)
    0 Error occurred on in function __construct
    1 called from line 115 of file class_pgv_db.php in function createInstance
    2 called from line 276 of file session.php in function require_once
    3 called from line 75 of file config.php in function require_once
    4 called from line 42 of file install.php

    Warning: PDO::__construct() :  A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:0) in G:\WebPages\PhpGedView\includes\classes\class_pgv_db.php on line 115

    ERROR 2: date() : It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead
    0 Error occurred on in function date
    1 called from line 310 of file session.php in function require_once
    2 called from line 75 of file config.php in function require_once
    3 called from line 42 of file install.php

    Warning: date() : It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead in G:\WebPages\PhpGedView\includes\authentication.php on line 294

    Warning: date() : It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead in G:\WebPages\PhpGedView\includes\authentication.php on line 299

    Warning: date() : It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead in G:\WebPages\PhpGedView\includes\session.php on line 310

     
  • Greg Roach

    Greg Roach - 2010-02-05

    There are two separate issues.

    1) You don't have a working database connection.  Did you create a database?  PGV uses an existing database - it doesn't create one.

    2) You have configured your webserver to show all minor warnings/information as if they were errors.  This is normal on a development server, but wrong on a production server.  You should set error reporting in your php.ini to ignore these.
    It is warning you that you haven't set a time-zone in your php.ini.  You probably want to do this.

     
  • C P

    C P - 2010-02-05

    Thanks for the quick reply.

    Request you to kindly help me how to set the time-zone in php.ini.

    I know the location of the file, but I want to know exactly in which line I need to make the change and what that change would be.

    Thanks

     
  • Greg Roach

    Greg Roach - 2010-02-05
    [Date]
    date.timezone = "Europe/London"
    
     
  • C P

    C P - 2010-02-06

    Thanks fisharebest,

    I have set the date to "Asia/Calcutta"

    and incoporated php.ini from php.ini-production file

    As regards to database creation… I have installed MySQL and is configured correctly with Apache2.2 and PHP. I do not know how to create a database.

    Please help

     
  • Greg Roach

    Greg Roach - 2010-02-06

    You don't say whether you have and database client software, so I assume you know how to get to a command line.

    Assuming your database's "master" account is called "root" and the password is "secret", type this to connect to the database

    mysql -user=root -password=secret

    At the prompt, type this to create the database

    create database phpgedview;

    Type this to get out of the database

    exit;

    When you configure PhpGedView, you will need to give it the root/secret account details, and the database name phpgedview.

     
  • C P

    C P - 2010-02-06

    Thanks…

    I have done all you had suggested. This time I am getting a message "Your current database configuration is bad. Please check your database connection parameters and configure again." while i am configuring PhpGedView

     

Log in to post a comment.