Strange Database Error

Hi,

I have 2 Dolphins running right now. Installed Avhow first, solved all my problems and then set up my second one (Album Design Forum) exactly the same - same hosting company etc.(HostForWeb)

The first one runs fine and comes up with no errors. The second one runs fine with no apparent errors but I just had a look at the email I set up for the cron jobs and its showing a daily database error. I'm guessing its when the cron jobs are run.

All the Cron Daemon and Peridoic emails show no errors, however mixed in with them is an email with teh following subject "Database error in Album Design Forum"

This is the content of the email (note I removed the password at the very end for this post)

Database error in Album Design Forum
Mysql error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] =>
/home/albumdes/public_html/templates/base/scripts/BxBaseConfig.php
            [line] => 23
            [args] => Array
                (
                    [0] => /home/albumdes/public_html/inc/db.inc.php
                )

            [function] => require_once
        )

    [2] => Array
        (
            [file] =>
/home/albumdes/public_html/templates/tmpl_uni/scripts/BxTemplConfig.php
            [line] => 21
            [args] => Array
                (
                    [0] =>
/home/albumdes/public_html/templates/base/scripts/BxBaseConfig.php
                )

            [function] => require_once
        )

    [3] => Array
        (
            [file] => /home/albumdes/public_html/inc/params.inc.php
            [line] => 90
            [args] => Array
                (
                    [0] =>
/home/albumdes/public_html/templates/tmpl_uni/scripts/BxTemplConfig.php
                )

            [function] => require_once
        )

    [4] => Array
        (
            [file] => /home/albumdes/public_html/orca/xml/design.php
            [line] => 16
            [args] => Array
                (
                    [0] => /home/albumdes/public_html/inc/params.inc.php
                )

            [function] => require_once
        )

    [5] => Array
        (
            [file] => /home/albumdes/public_html/orca/index.php
            [line] => 62
            [args] => Array
                (
                    [0] => /home/albumdes/public_html/orca/xml/design.php
                )

            [function] => require_once
        )

)


Called script: /orca/index.php

Request parameters:
Array
(
    [action] => is_new_post
    [ts] => undefined
    [now] => Wed Jun 25 2008 11:02:49 GMT-0400 (Eastern Daylight Time)
    [lang] => en
    [track_topics] => a:1:{i:2;i:1214058991;}
    [strSec] => d4ddecd955e5dd76c4b719dab1c516b7
    [adminPassword] => 
    [adminID] => admin
)


--
Auto-report system

The bit at the beginning

/var/lib/mysql/mysql.sock

is the same for both this installation of dolphin and my avhow one - I checked,  so I'm pretty sure that part is correct.

Can anyone let me know what might be the problem?

Thanks

Max

I occasionally get a weird db error too, it happens when someone joins (only like 1% of the time) and it says duplicate entry for key 2, nickname.

It still create the profile though...?

-micliz-

singlesaints.com

@avhow

Send a copy of that error to your host. If it's not the same server there may be a difference. The site runs, so it obviously can connect to the database, but on some servers cron uses a different version of php than the web server. It seems that one can't find the mysql.sock file. Also check the inc/header.in.php file for the site returning the error and make sure $db['sock'] and $db['port'] do not have a value set.


@micliz

This would occure if a signup is attempted by someone using a nick name that already exists. A error would be generated and they would need to choose a new name. This may also occur if you have facebook connect installed and members used that for signup. fb connect would automatically generate a alternate name when the error ocures.

Thanks for responding Deano.  My nickname field is a unique field so it doesn't allow the form to submit when a nickname is a duplicate, it just shows the error that the name is already in use.

I don't have FB connect, I'm on 6.1.6.

I don't get how the form is even getting submitted if another nickname is in use.  Also, I'm led to believe there isn't really another same name because the new user is able to join and create a new profile without a problem...

-micliz-

LDS Singles

Solteros SUD Mormon