Project

General

Profile

PHP and HTTPD Errors after update to 3.0

Added by Thomas Davis almost 11 years ago

GoAutodial 3.0 | Vicidial 2.4 | asterisk 1.4 | Centos 5.9 |Kernel 2.6.18-348.6.1.el5.1.goPAE |

I upgraded my system to 3.0 and now, there is an error and the system will not display any php pages that are connecting to mysql
I turned errors on and got "Fatal error: Call to undefined function mysql_connect() in /var/www/html/agent/dbconnect.php on line 44"

phpinfo() displays fine...mysql.so is installed and enabled...can't get it to work.

but..also, service httpd restart wont restart apache, I have to killall httpd to get it to restart...no error logs either...


Replies (7)

RE: PHP and HTTPD Errors after update to 3.0 - Added by Demian Biscocho almost 11 years ago

How exactly did you upgrade your system and from what version?

RE: PHP and HTTPD Errors after update to 3.0 - Added by Thomas Davis almost 11 years ago

I figured it out, there was an old httpd.conf file in place for some reason. now, I am on to other errors.

1. When selecting either the Phones, Carrier, or Server menu options, I get"
Error Number: 1054

Unknown column 'user_group' in 'field list'

SELECT extension,protocol,server_ip,dialplan_number,voicemail_id,status,active,fullname,messages,old_messages,user_group FROM phones ORDER BY extension;
"
and ofcourse, the table is missing "user_group" as a column. To work around, I simply tried adding a user_group column to my table, but with no luck.

2nd issue, is when I attempt to log into any campaign, I get and error stating "Sorry, you are not allowed to login to this campaign: "Campaign Name""
and that is for every user and campaign.

Any advice on those?

RE: PHP and HTTPD Errors after update to 3.0 - Added by Thomas Davis almost 11 years ago

I upgraded from GoAutodial CE 2.1 running the upgrade instructions on this web site.

RE: PHP and HTTPD Errors after update to 3.0 - Added by Demian Biscocho almost 11 years ago

You might have missed a step or two during the upgrade. Or you might be running a lower version than 2.1.

What's the build number of your GOadmin? It's located on the bottom of the admin login page box.

RE: PHP and HTTPD Errors after update to 3.0 - Added by Chad Fraser over 10 years ago

I am having the same issue

Error Number: 1054

Unknown column 'user_group' in 'field list'

SELECT extension,protocol,server_ip,dialplan_number,voicemail_id,status,active,fullname,messages,old_messages,user_group FROM phones ORDER BY extension;
"
and ofcourse, the table is missing "user_group" as a column. To work around, I simply tried adding a user_group column to my table, but with no luck.

i am also upgrading from CE 2.1. is there an update sql script that i can run manually to rectify the issue?

Please help

RE: PHP and HTTPD Errors after update to 3.0 - Added by Demian Biscocho over 10 years ago

The needed SQL files are in:

/usr/src/goautodial/sql

You can manually update the MySQL tables by running:

mysql -p filename.sql

The user_group column belongs to goautodial.sql. Let us know how it goes.

    (1-7/7)
    Go to top