PHP and HTTPD Errors after update to 3.0
Added by Thomas Davis almost 12 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 12 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 12 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 Demian Biscocho almost 12 years ago
Please see my post above.
RE: PHP and HTTPD Errors after update to 3.0
-
Added by Thomas Davis almost 12 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 12 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 11 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 11 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.