vicidial.org

at the agent screen I get this above the login window:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/htdocs/agc/vicidial.php on line 300

Warning: Cannot modify header information - headers already sent by (output started at /var/www/htdocs/agc/vicidial.php:300) in /var/www/htdocs/agc/vicidial.php on line 405

Warning: Cannot modify header information - headers already sent by (output started at /var/www/htdocs/agc/vicidial.php:300) in /var/www/htdocs/agc/vicidial.php on line 406

Warning: Cannot modify header information - headers already sent by (output started at /var/www/htdocs/agc/vicidial.php:300) in /var/www/htdocs/agc/vicidial.php on line 407

When Modifying a campaign i get these above the campaign, but I can modify everything just fine:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/htdocs/vicidial/admin.php on line 11709

PHP4, mysql5.

KG

Figured I'd put up some fillers in case someone is thinking of replying:

-Asterisk/VICIDIAL/Web are on one server
-SQL is on the other

Everything is functional on the ADMIN side i can do anything without cause but i do get those result occurrence error's and cannot even log-in to the agent site.

Any suggestions or comments are welcomed

Thanks guys.

KG

you might have an incorrect SQL engine version as compared to your vicidial code. Did you do an upgrade?

Yes i was running 2.0.4 then rolled to the latest in the svn trunk, thoughts on where to go from here? I was hoping to do some testing tomorrow.

Thanks matt.

This the version of SQL i'm running: Server version: 5.0.51

Did you read the UPGRADE document before upgrading?

Yes, the biggest issue was I was forcing PHP4 to run and did not realize that. From there all the card's feel into place. Now i'm left with just a time sync issue so i'm going to reinstall ntp to see if that helps.

Thanks for all the help guys!

konextu wrote:Now i'm left with just a time sync issue so i'm going to reinstall ntp to see if that helps.

Maybe check for another NTP server as well. The one mentioned in scratch_install 18.145.0.30 tends to fail too often lately.
http://www.eflo.net/VICIDIALforum/viewt ... hlight=ntp

I figured out the time issue. I'm just an idiot. I had the server setup in the admin console for the wrong GMT code. How i missed that, who knows.

I've posted a new question in the general forums if anyone care's to take a peek.

KG