video issue

I have been all over this forum the past few weeks trying everything i could find with no luck. installed 7.1.3 and all seemed ok until the video upload. all i can get is pending processing. i contacted my host for help today and they played with it. now i have a new cron email:

<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/cattitoo/public_html/inc/classes/BxDolDb.php
            [line] => 68
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => cattitoo_dolphin
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                )

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

        )

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

            [type] => ->
            [args] => Array
                (
                )

        )

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

            [type] => ->
            [args] => Array
                (
                )

        )

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

            [function] => require_once
        )

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

            [function] => require_once
        )

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

            [function] => require_once
        )

)
</pre><b>Called script:</b> /home/cattitoo/public_html/periodic/cron.php<br /><b>Request parameters:</b><br /><pre>Array
(
)
</pre>
</div>                </div>
            
Fatal error: Call to a member function getRow() on a non-object in /home/cattitoo/public_html/inc/utils.inc.php on line 437

it got longer since earlier but still the line 437 deal. my host then sent me this email:

Hello David,

Thanks for the mail.
I was unable to fins any valid video conversion for linux in your script.
The only binary I was I able to find was
/home/cattitoo/public_html/flash/modules/global/app/ffmpeg.exe
Which is a windows binary.

Please contact the script vendor and get back to us regarding the exact configuration for linux.

oh my host is pacific host. i was running clipbucket before this and it worked fine.

any tips?

Thanks!

nobody knows?

I see this in your mail: "<div style="text-align:center;">Database connect failed</div>" - try checking to make sure the database, database username and database password are correct in your inc/header.inc.php file

that seems to be ok

the database works fine everywhere else...

It maybe different php configuration files are used in cron and for displaying pages. 

It maybe that some settings can affect on database connection.

You could try to get location of php.ini file for displaying web pages (admin panel > tools > host tools > php info ) and explicity specify path to php configuration file for cron command, -c command line option:

-c <path>|<file> Look for php.ini file in this directory 

how would i do this? mentioned that to my host and they said to try changing the path and gave me the new path and try doing it on my end...not sure where i would do that...im starting to feel stupid now

still not getting anywhere

I did not understand this part:

I was unable to fins any valid video conversion for linux in your script.
The only binary I was I able to find was
/home/cattitoo/public_html/flash/modules/global/app/ffmpeg.exe
Which is a windows binary.

Please contact the script vendor and get back to us regarding the exact configuration for linux.

The ffmpeg.exe that ships with Dolphin is the Linux version. Did you try changing the ffmpeg.exe file? Are you on Linux or Windows server?  And by the way, on most configurations the ffmpeg.exe file needs 777 permission.

As for the cron job, go to your admin -> Tools -> Host Tools.  You will find a listing of your current cron job.  Also in Host Tools at the top you will see a link to PHP INFO, click on that and you can find out the configurations for PHP.

@GG - the FFMPEG is a windows file - hence the .exe at the end - linux doesnt use .exe files. But that still would not affect him - unless it is an outdated version of the ffmpeg file. Or the cron is incorrect as was already stated.

 Yes, I understand that Linux does not use extensions on files but you can certainly name a file XXXX.XXX in Linux.  If you go to ffmpeg.org you will see there are builds for Linux, Windows, and OSX.  You can not look at a file on Linux such as ffmpeg.exe and say, "Hey, that is a windows binary".  If his hosting company did so, they they are not so bright.  You have to examine the file itself to say it is a windows binary.  Now if he installed Dolphin on a Windows server, he will need to have the windows binary.  However, the statement would indicate that he is on a Linux host.  Therefore, why would he have installed a windows version of ffmpeg?  Dolphin ships with a version of ffmpeg suited to use on a Linux server.  It is when you are on a Windows server that you need to use a windows binary of ffmpeg.  My question to dltimko was to see if he had mistakenly installed a windows binary of ffmpeg to try and solve his issue.

@GG - not to be rude or anything of that nature - but if you look at the Additional Downloads (where you would download Dolphin) - it specifically says ffmpeg.exe (Windows). So is this a different version than what is within the Dolphin download - or a standalone download in case the one originally with dolphin is somehow messed up?

I am running on a Linux server, CentOS to be exact.  I installed Dolphin from the download and did not change my ffmpeg file.  On my server it is ffmpeg.exe and I know it is not a Windows binary.

I am not trying to be rude either.

For those wanting to install Dolphin on a Windows server, Boonex offers a windows binary of ffmpeg.  That is what I was trying to ask the topic owner, if they had replaced their ffmpeg and perhaps replaced it with the windows binary version by mistake.

so the ffmpeg that is shipped with dolphin is not the one that is in the additional downloads?

i am on a linux server and the ffmpeg i installed was the one that came with the 7.1.3 download. so i do have to agree that was a lack of knowledge on their part. and it is set at 777. my cron job match with everything i have found on other posts. i have an extra one that shows up tho but when i go into my cpanel its not in there. everything in the php settings say ok. path looks good. 

OK - I am gonna try my luck and see if i cant shed some light on this.

First thing I notice is the Error "Database Connect Failed". Then the section referring to BxDolDb line 68. This is the function that includes that line (line 68 for me is in blue):

    function connect()
    {
        $full_host = $this->host;
        $full_host .= $this->port ? ':'.$this->port : '';
        $full_host .= $this->socket ? ':'.$this->socket : '';

        $this->link = @mysql_pconnect($full_host, $this->user, $this->password);
        if (!$this->link)
            $this->error('Database connect failed', true);

        if (!$this->select_db())
            $this->error('Database select failed', true);

        mysql_query("SET NAMES 'utf8'", $this->link);
        mysql_query("SET sql_mode = ''", $this->link);

        $GLOBALS['bx_db_link'] = $this->link;
    }

so with that - it seems that the variable "$this->link" is acting up for some reason. The rest of the issues are all related to connecting to the database.

If it were me, I would try uninstalling the videos module, deleting the original videos module folder and flash folder, reuploading a fresh copy of the videos module and flash folder, then reinstalling the videos module. (Then cross my fingers and hope it works) I am not 100% sure, but if everything else is working in regards to your database, it may be a corrupted file or something in your videos module or flash folder. I am guessing here, but a lot of times starting over can resolve a problem.

Just a few questions though - is this a new install? was the install done manually or with an autoinstaller?

this is a new install. i stopped using dolphin a few years ago and tried something else and decided to come back. it is a manual install. however i also did a autoinstaller in a subdirectory and it has the same issues. back before i contacted my host, my cron email was much shorter so im thinking about doing another fresh install cause i have no idea what they did. the email i got before them and also the one i currently get from my subfolder just says this:

<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>
            <br />
<b>Fatal error</b>:  Call to a member function getRow() on a non-object in <b>/home/cattitoo/public_html/demo/inc/utils.inc.php</b> on line <b>437</b><br />

ok just completed a fresh install of 7.1.4 and now i only get this message. 

Fatal error: Call to a member function getRow() on a non-object in /home/cattitoo/public_html/inc/utils.inc.php on line 437

also in my host tools i now have this problem that i did not have before:

• disable_functions = show_source, system, passthrunfo, proc_open - FAIL (must be = )

other than that im still at the same place. pending processing :( im about to give up

i take it everyone else gave up too?  

A error like Call to a member function getRow() on a non-object in on line 437

Is usually database related. Mysql is down, not configured right, wrong mysql user, wrong mysql password, or a combination.

But if your database can't connect you shouldn't be able to get to the Dolphin Admin Host Tools section either.

For example:

If you find on Host Tools page that path to php.ini is:

/etc/php5/php.ini

And your cron is looking like this:

* * * * * cd /home/someuserhere/public_html/periodic; /usr/bin/php -q cron.php

Then you can try to modify it like this:

* * * * * cd /home/someuserhere/public_html/periodic; /usr/bin/php -q -c /etc/php5/php.ini cron.php

Please keep in mind that your paths can be completely different!

changed my cron and it made no difference at all

 PM site, and server info. I will check all your settings for free.

well obviously this script is never gonna work and theres not much of a tech support so is it possible to sell my 2 licenses?

No, Boonex won't allow one to sell their linceses.

However, first if this is a new site go ahead and move to 7.1.4, as some bug fixes were done and included in 7.1.4.

Did you allow Newton into your site to take a look-see?  There is only so much we can do with such errors outside of access to the server.

The other thing is to list who you are hosting with.  Some hosts are not that great to put Dolphin on.  For example, I have a test site on a recommended share hosting and one day the site started reporting errors.  The shared host provider was no help.  I thought about redoing it so let it sit for a while and then one day went to it without any errors reported.  The shared hosting provider had screwed around with the servers but of course when I reported the errors, it had nothing to do with them.

The script works just fine.  It's your server setup that is not working.  If you want a hand with this let me know and i will do my best to walk you through it. 

One more thing to check is MySQL settings.

It maybe that connection to MySQL server timeout during video processing, since it can take some considerable time.

Check the following settings:

wait_timeout

interactive_timeout

They should be at least 9000, so the conversion can last up to 2.5 hours.

 yes, I did. The problem is the cron setup is not activating.

He did two installs,

1. Softaculous
2. and manual..

each cron job was different, the latter one has the normal command.

Neither install works or fires the cron, I checked most file permissions. There is no access to SSH, shared..

 the server never starts..

normal install > cd /home/****/public_html/periodic; /usr/local/bin/php -q -c/usr/local/lib/php.ini cron.php

soft install > php -q /home/cattitoo/public_html/demo/periodic/cron.php

 scratch all the above, still is the database...

i am on 7.1.4 now. did a manual install step by step. everything went great but problems never changed. i am using pacific host. i used dolphin on it a couple years back and it worked fine except it was too much work to customize so i switched to clip bucket. now im trying to go back to dolphin with no luck. would really hate to leave the host i have had for so long since i still have probably another 10 months paid up

D, am on your server now..

if you give us some time we will get is going, I have been a bit busy past few days.

Ok the puzzle is, the site will run and pull data for memberships, as login and the site is up and running.

The problem is when the cron tries to run, that is where the database error triggers, just got the most recent message and it is a general one...

 <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>
            
Fatal error: Call to a member function getRow() on a non-object in /home/cattitoo/public_html/inc/utils.inc.php on line 437

Server log shows last error.

[Tue Aug 27 19:37:48 2013] [error] [client *.*.192.37] File does not exist: /home/*/public_html/user, referer: http://*.*/

UPDATE

The problem has to be with your server.

Not only Dolphin site crons, but all jobs fail.

Looking further into your problem I experimented and installed "Clip Bucket" as well, under *.*/clip/

This install also created a database, which I was able to setup the cron job to fire manual via the command area.

Guess what, I also got a mailbox full of database connect errors. So your server is not running any cron job at all... contact your hosting company and inform them you have installed a couple of scripts and the cron jobs are not connecting to the database created.

PS, when setting clip bucket to work without a cron job, the video processes via your ffmpeg (server side)

check the site I set you via PM

 I was just about to say I think this is something Pacific host is going to have to fix on their end.

I think maybe the cron tab on this server is running under an account that doesn't have the rights to access Mysql... or maybe just not the users individual Mysql accounts.

 I'm sure your correct here.