Database Error

I have set up my database ran the install and now I am getting the following error:

"The database for MySite isn't responding correctly, so the site won't work properly. The site admins probably know about the problem, but you can contact them at to make sure. Otherwise, wait a few minutes and try again."

Comments

  • Never mind, this worked: http://forum.status.net/discussion/60/problem-after-installation

    Had to change mysqli in the config.php file to mysql (took off the "i" and now it works). Sorry for a duplicate post. I didn't see that discussion earlier.
  • thanks very much....i got the same problem before. i thought it is a problem of upgrade, but now it looks like a error of configure which is created in the installing....
  • Glad it worked for you andy :-)
  • so thanks!
  • When I try to register an account I am getting the following error:

    "The database for MYSITE isn't responding correctly, so the site won't work properly. The site admins probably know about the problem, but you can contact them at *** to make sure. Otherwise, wait a few minutes and try again"

    I've deleted the character "i" of mysqli in the sintax:
    $config['db']['database'] = 'mysql://dbuser:dbpassword@localhost/dbname';

    But it doesn't work yet, any ideas?
  • you really do need the "i" in 9x or greater.

    turn up the logging, and see why its not connecting. its possible that your php doesn't have mysqli support. tho, ive never actually seen that irl.

    $config['db']['debug'] = create_function('$class, $message, $logtype, $level','common_log(LOG_DEBUG,"DBDO: $class / $message / $logtype");');

    $config['site']['logdebug'] = true;

    $config['site']['logfile'] = '/tmp/statusnettmp.log';
  • Here is part of the log:
    PEAR error: DB Error: unknown error : INSERT INTO confirm_address (code , user_id , address , address_type )
    VALUES ('BQJW9MGNN8UHETTG28SYY77QE3' , 11 , 'myemail@myemail.com' , 'email' ) [nativecode=1364 **
    Field 'address_extra' doesn't have a default value]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]

    #0 PEAR_Error->PEAR_Error(string,integer,integer,string,string) called at
    [C:\Apache\htdocs\weno\extlib\DB.php:966]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    #1 DB_Error->DB_Error(integer,integer,string,string) called at
    [C:\Apache\htdocs\weno\extlib\PEAR.php:574]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    #2 PEAR->raiseError(NULL,integer,NULL,NULL,string,string,boolean) called at
    [C:\Apache\htdocs\weno\extlib\DB\common.php:1908]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    #3 DB_common->raiseError(integer,NULL,NULL,NULL,string) called at
    [C:\Apache\htdocs\weno\extlib\DB\mysqli.php:928]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    #4 DB_mysqli->mysqliRaiseError() called at
    [C:\Apache\htdocs\weno\extlib\DB\mysqli.php:402]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    #5 DB_mysqli->simpleQuery(string) called at
    [C:\Apache\htdocs\weno\extlib\DB\common.php:1216]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]...
    ...............
    ....#14 main() called at [C:\Apache\htdocs\weno\index.php:336]
    2010-03-16 01:07:59
    LOG_WARNING: [localhost:656.8765ec2f POST /weno/index.php/main/register]
    ServerErrorAction: 500 The database for weno isn't responding correctly....
  • @neca [Field 'address_extra' doesn't have a default value] --it looks like it was a problem with the upgrade. What version were you running, amd what are the steps you took to upgrade?
  • This is my first installation, I'm running 0.9.0
  • @Neca on second glance I think its that mail is not working. try making an account with no email address.
  • Thanks @aric, making an account with no email address worked! However I'd like users can enter their email.... what can I do?
  • Same problem happens on my windows server2003 installation, new 0.9.0.
    And another thing, after registration , check MySQL Database, only the table 'profile' was written, "user" has nothing in it.
  • @neca you have to install the correct php mail packages. php-mail php-mail-mime php-mail-mimedecode
    and have a working postfix setup.

    @happy windows server2003? can you start a new thread about windows installations. I've never done one, and im interested in having a discussion about it.
  • Warning: Cannot modify header information - headers already sent by (output started at H:\xampp\htdocs\statusnet-0.9.6\lib\xmloutputter.php:165) in H:\xampp\htdocs\statusnet-0.9.6\lib\htmloutputter.php on line 109

    Warning: Cannot modify header information - headers already sent by (output started at H:\xampp\htdocs\statusnet-0.9.6\lib\xmloutputter.php:165) in H:\xampp\htdocs\statusnet-0.9.6\lib\servererroraction.php on line 108

    The database for Status Net isn't responding correctly, so the site won't work properly. The site admins probably know about the problem....


    I am getting this warning message. how could i resolve it
  • @nishant Unfortunately, I don't use XAMP (or Windows), so I don't know what could be causing your problem. In the future, instead or using a year-old thread, you should start a new one. Software versions and environments may have changed since then.

    In a new thread, you can emphasize your use of XAMP and the version of the software you're installing. It may attract the attention of someone who does know how to fix this.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID