Database Error

AdamD

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."

AdamD

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.

andy

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....

AdamD

Glad it worked for you andy :-)

mojtaba

so thanks!

Neca

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?

aric

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';

Neca

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....

aric

@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?

Neca

This is my first installation, I'm running 0.9.0

aric

@Neca on second glance I think its that mail is not working. try making an account with no email address.

Neca

Thanks @aric, making an account with no email address worked! However I'd like users can enter their email.... what can I do?

happy

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.

aric

@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.

happy

@aric new post here:
http://forum.status.net/discussion/346/

nishant

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

lnxwalt

@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.