Aaron
Posts: 145
|
Posted: 06/23/2004, 6:38 AM |
|
Odd thing, but here goes...
Have mysql 4.0.18 on live server. Runs great. Had same on test machine, but upgraded to 4.0.20. Now getting this error on any page I try to run:
Fatal error: Call to undefined function: mysql_connect() in
/var/www/aaron/db_mysql.php on line 99
I've tried re-publishing the project, looked at the code, etc. I haven't changed a thing in the project but now I get that error.
The changes in .18 and .20 are not very great. Mainly bug fixes. I am thinking I should strip out mysql and reload .18, but am trying to avoid going through all that work if I can make some simple changes somewhere. Everything else works on this box (am running some other php and cgi scripts (including phpmyadmin) and they all work fine).
Any thoughts?
Aaron
|
|
|
Daniel Gaudreault
|
Posted: 06/23/2004, 6:52 AM |
|
Is your version of php pre-compiled or one you rolled (compiled) out
yourself? If you rolled it yourself, the php libs and bins may be
linked against the wrong version of MySQL.
Dan
Aaron wrote:
> Odd thing, but here goes...
>
> Have mysql 4.0.18 on live server. Runs great. Had same on test machine, but
> upgraded to 4.0.20. Now getting this error on any page I try to run:
>
> Fatal error: Call to undefined function: mysql_connect() in
> /var/www/aaron/db_mysql.php on line 99
>
> I've tried re-publishing the project, looked at the code, etc. I haven't
> changed a thing in the project but now I get that error.
>
> The changes in .18 and .20 are not very great. Mainly bug fixes. I am thinking
> I should strip out mysql and reload .18, but am trying to avoid going through
> all that work if I can make some simple changes somewhere. Everything else
> works on this box (am running some other php and cgi scripts (including
> phpmyadmin) and they all work fine).
>
> Any thoughts?
>
> Aaron
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Aaron
Posts: 145
|
Posted: 06/23/2004, 7:52 AM |
|
You know, I'll be that is it. Php was something I compiled, but mysql was updated through apt. (Am running Debian).
I'm a bit of a Linux n00b... suggestions on a fix?
A
|
|
|
Aaron
Posts: 145
|
Posted: 06/23/2004, 10:22 AM |
|
I have a feeling this may be part of it, but please, if I'm wrong let me know.
From the Upgrade manual from 2.5.3 to 4.0--
The old C API functions mysql_drop_db(), mysql_create_db(), and mysql_connect() are no longer supported unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. However, it is preferable to change client programs to use the new 4.0 API instead.
-- So, I'm thinking, if it works in .18 but not .2, what's going on here....
|
|
|
|
|
|
|
|