[ Solved ] Small issue with Web Interface (any ideas?)

[konextu]

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

[konextu]

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

[mflorell]

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

[konextu]

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.

[konextu]

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

[mflorell]

Did you read the UPGRADE document before upgrading?

[konextu]

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!

[okli]

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

[konextu]

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