php+mysql woes when installing script....

Hi Folks,

I am running php, MySQL with IIS5.

The problem is that I am trying to install a php script called
phpNewsletter
(http://gregory.kokanosky.free.fr/v4/phpmynewsletter/index.en.html).

I have iis, php and mysql installed. The trouble starts when I extract
the php scripts and point my browser at
http://localhost/pmnl/install.php.

I get an error in the browser (IE6) :

Fatal error: Call to undefined function MYSQL_ERROR() in
c:\Inetpub\wwwroot\pmnl\include\lang\english.php on line 199

Now if I go to lines 196-201 the following code is present:

"ERROR_DBCONNECT_CORE" => "Unable to connect to the Database.<br
/>".
"<ul><li>Check that <b>password</b> used to connect to the database is
<b>correct</b>.</li>".
"<li>Check that your <b>database server is up and
running</b>.</li></ul>".
(MYSQL_ERROR() ? "The following error message can help you :
".MYSQL_ERROR() : "")
."<br /><br /><a
href=\"http://gregory.kokanosky.free.fr/v4/phpmynewsletter/docs/\">Documentation</a>
section on /phpMyNewsletter /website.",

with the line that starts with (MYSQL_ERROR() being the one that is
causing the problem.

I think its to do with my MySQL installation, but not sure what.

My friend has installed the same script on a Linux box with no
problems, so the script is OK.

Anybody have any ideas?

Thanks

-Al

Kristofer
Sat May 28 04:44:50 CDT 2005

Hi Al,

First of all, i am not a PHP expert. But in PHP 5+, the MySQL extension is
not enabled by default, and i have a feeling that this method
(MYSQL_ERROR() ) will be undefined if the extension is not loaded.

The problem you are seeing does not seem to be a problem with IIS however,
but more of a configuration of PHP.

This page may help you further:
http://se.php.net/mysql

The PHP newsgroups may also give you more help:
news://news.php.net/

Good Luck!


--
Regards,
Kristofer Gafvert (IIS MVP)
www.gafvert.info - My Articles and help
www.ilopia.com


Al wrote:

> Hi Folks,
>
> I am running php, MySQL with IIS5.
>
> The problem is that I am trying to install a php script called
> phpNewsletter
> (http://gregory.kokanosky.free.fr/v4/phpmynewsletter/index.en.html).
>
> I have iis, php and mysql installed. The trouble starts when I extract
> the php scripts and point my browser at
> http://localhost/pmnl/install.php.
>
> I get an error in the browser (IE6) :
>
> Fatal error: Call to undefined function MYSQL_ERROR() in
> c:\Inetpub\wwwroot\pmnl\include\lang\english.php on line 199
>
> Now if I go to lines 196-201 the following code is present:
>
> "ERROR_DBCONNECT_CORE" => "Unable to connect to the Database.<br
> />".
> "<ul><li>Check that <b>password</b> used to connect to the database is
> <b>correct</b>.</li>".
> "<li>Check that your <b>database server is up and
> running</b>.</li></ul>".
> (MYSQL_ERROR() ? "The following error message can help you :
> ".MYSQL_ERROR() : "")
> ."<br /><br /><a
>
href=\"http://gregory.kokanosky.free.fr/v4/phpmynewsletter/docs/\">Documentation</a>
> section on /phpMyNewsletter /website.",
>
> with the line that starts with (MYSQL_ERROR() being the one that is
> causing the problem.
>
> I think its to do with my MySQL installation, but not sure what.
>
> My friend has installed the same script on a Linux box with no
> problems, so the script is OK.
>
> Anybody have any ideas?
>
> Thanks
>
> -Al