Cron jobs errors

Hi everyones, I installed dolphin 7.0.7 and I'm getting emails about cron jobs errors. I never had these problems with 7.0.6. and I use the same cron job command like:

/usr/local/bin/php -q /home/*/public_html/periodic/cron.php

This is a fresh install, I tried both with and without Softaculous autoinstall, I followed the steps here carefully on a manual install:

http://www.boonex.com/trac/dolphin/wiki/DetailedInstall

The only part I did'nt done is bellow because there is no such directories in the installation (I wonder why these steps are there?!?):

SITE CHMOD 777 ./groups/gallery
SITE CHMOD 777 ./groups/orca/cachejs
SITE CHMOD 777 ./groups/orca/classes
SITE CHMOD 666 ./ray/modules/board/xml/config.xml

The emails I get contain these errors:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description:

Is anyone got errors like that with the new 7.0.7?

If, yes that would be great if you tell me how to fix this

Thanks and sorry for my english

Regards

Martin

Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71

where this says Database access error, that means its not connecting to the database. can you enable mysql debug and get a full error report? 

I'm sorry for being a noob but where do I enable this please?

 no need to be sorry!!!!

 first thing you do is attempt to use the search feature of the forum. 

so searching something like --> enable database debug mode 

would be a really good start. so i am going to go search for that, since my gogo gadget reversed imagery anticipatory filtering mechanism just lost 2.7 giggyhirtz~ and currently unable to decipher.

/inc/classes/BxDolDb.php

and change

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

and you will got full error description

Thanks for that but unfortunately it's seems there is no longer these lines in the file inc\db.inc.php

It's /inc/classes/BxDolDb.php.

Thanks for your help guys, now I'm trying to find how to get this full error report and I'll get back to you.

Do I need to wait for the next email?

Thanks

Yep.

Hi again, I've enabled the DB_FULL_DEBUG_MODE but the emails I get from cron jobs show nothing more than before, is there another way to see the full error report? in a file maybe?:

Here is the content of the emails I get, thanks for helping:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: 
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description: Database access error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
 Description:

Here what I got in error_log:

[18-Aug-2011 01:18:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 01:18:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 01:18:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 01:18:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 01:18:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 01:18:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 01:18:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 01:18:02] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 02:58:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 02:58:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 02:58:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 02:58:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 02:58:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 02:58:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 02:58:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 02:58:02] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 08:14:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 08:14:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 08:14:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 08:14:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 08:14:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:14:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:14:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:14:03] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 08:50:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 08:50:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 08:50:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 08:50:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 08:50:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:50:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:50:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:50:03] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 08:50:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 08:50:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 09:55:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 09:55:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 09:55:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 09:55:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 09:55:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 09:55:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 09:55:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 09:55:02] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 09:55:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 09:55:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 10:10:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 10:10:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 10:10:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 10:10:03] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 10:10:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 10:10:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 10:10:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 10:10:03] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67
[18-Aug-2011 10:10:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 10:10:03] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 11:28:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 48
[18-Aug-2011 11:28:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 49
[18-Aug-2011 11:28:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 50
[18-Aug-2011 11:28:02] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 51
[18-Aug-2011 11:28:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 11:28:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 11:28:02] PHP Warning:  mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/choixduq/public_html/flash/modules/global/inc/db.inc.php on line 71
[18-Aug-2011 11:28:02] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/choixduq/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php on line 67

any idea?

thanks for helping!

Finally I got a email with the full error report, can anybody tell me what is wrong in this please?

Thanks

 <div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
                    <div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
                    <div style="text-align:center;">Database connect failed</div>
            <div style="overflow:scroll;height:300px;border:1px solid gray;"><b>Debug backtrace:</b><br /><pre>Array
(
    [1] => Array
        (
            [file] => /home/choixduq/public_html/inc/classes/BxDolDb.php
            [line] => 82
            [function] => error
            [class] => BxDolDb
            [type] => ->
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => choixduq_dolph99
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [args] => Array
                (
                    [0] => Database connect failed
                    [1] => 1
                )

        )

    [2] => Array
        (
            [file] => /home/choixduq/public_html/inc/classes/BxDolDb.php
            [line] => 58
            [function] => connect
            [class] => BxDolDb
            [type] => ->
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => choixduq_dolph99
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [args] => Array
                (
                )

        )

    [3] => Array
        (
            [file] => /home/choixduq/public_html/inc/db.inc.php
            [line] => 25
            [function] => BxDolDb
            [class] => BxDolDb
            [type] => ->
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => choixduq_dolph99
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [args] => Array
                (
                )

        )

    [4] => Array
        (
            [file] => /home/choixduq/public_html/inc/classes/BxDolAlerts.php
            [line] => 20
            [args] => Array
                (
                    [0] => /home/choixduq/public_html/inc/db.inc.php
                )

            [function] => require_once
        )

    [5] => Array
        (
            [file] => /home/choixduq/public_html/inc/header.inc.php
            [line] => 176
            [args] => Array
                (
                    [0] => /home/choixduq/public_html/inc/classes/BxDolAlerts.php
                )

            [function] => require_once
        )

    [6] => Array
        (
            [file] => /home/choixduq/public_html/periodic/cron.php
            [line] => 24
            [args] => Array
                (
                    [0] => /home/choixduq/public_html/inc/header.inc.php
                )

            [function] => require_once
        )

)
</pre><b>Called script:</b> /home/choixduq/www/periodic/cron.php<br /><b>Request parameters:</b><br /><pre>Array
(
)
</pre>
</div>                </div>
            
Fatal error: Call to a member function getParam() on a non-object in /home/choixduq/public_html/inc/db.inc.php on line 83

your title has had me thinking, cron-job-errors would when this is an email that is a cron report. the errors are with the file that is attempting to connect to the database, and or the database itself. 

so you have database connections errors, not cron job errors. 

Thanks, now I know what is the problem but it's not resolving it thought.

So, do I start a new topic "Database connection error"...?

 if it was a connection error would your site still work at all?....

 prolaznik, the and marthymart, 

the reason i say its a database connection issue, if you look at the errors that are being reported from the cron email, you will see that specifically it says its related to the /flash config modules. so yes, if its a connection error parts of the site would still work, since the different functions albeit flash and orca, have config integrations that would dictate the same behavior that i am seeing in this report.

So what should I do DosDawg?

Thanks for helping

well hopefully you have a backup from your 7.0.6 that can be restored and you can start over. i think something went wrong with the upgrade. as this is not standard behavior. 

 so my suggestion is to restore to a backup, and start over with the upgrade. 

If anyone have these problems in the future, this is the .htaccess file in the flash folder that is related to it.

 What did you do to fix this? I'm getting cron job errors of the same type.

 Have you had any luck getting an answer for this? I'm having this issue as well.

Thanks