|
Posted by John Nichel on 12/07/05 18:37
Paul Hickey wrote:
> Can someone help me overcome this recurring problem? I am using the
> Joomla content management system and I keep coming across the following
> errors.
>
> Fatal error: Call to undefined function mysql_real_escape_string() in
> /usr/local/apache2/htdocs/common.php on line 24
>
> Fatal error: Call to undefined function mysql_real_escape_string() in
> /usr/local/apache2/htdocs/class.inputfilter.php on line 344
>
> I notice in my Dynamic Extensions section of php.ini there are no
> extensions called for; if that helps. Joomla works fine, but when adding
> components or modules the problems start. One component author made a
> test for the mysql_real_escape_string and I think avoided using it then
> the component worked. I think that's probably not the best solution.
>
> Fedora Core 3
>
> Apache 2.0.55
>
> PHP 5.0.5 (compiled with mysqli vice mysql)
> './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--enable-ftp'
> '--enable-inline-optimization' '--enable-magic-quotes'
> '--enable-mbstring' '--enable-track-vars' '--enable-trans-sid'
> '--enable-wddx=shared' '--enable-xml' '--with-dom' '--with-gd'
> '--with-gettext' '--with-mysqli=/usr/local/mysql/bin/mysql_config'
> '--with-regex=system' '--with-xml' '--with-zlib-dir=/usr/lib'
>
> MySQL 4.1.15
mysql_real_escape_string() is a MySQL function, and you're server is
compiled with the 'improved' MySQL functions. You want
mysqli_real_escape_string()
http://us3.php.net/manual/en/function.mysqli-real-escape-string.php
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
jnichel@dotcomholdingsofbuffalo.com
Navigation:
[Reply to this message]
|