[Nico]

I guess this is a server configuration issue, so I'm posting this here.

I was using XAMPP before, but I wanted to set up PHP/MySQL/Apache by myself, so I uninstalled XAMPP and did so.

I installed PHP 5.3 (Alpha 1), MySQL 6.0 Alpha, and Apache 2.2. (Perhaps I shouldn't work with these beta/alpha releases?)

Now everything seems to be working fine, as long as I don't call mysql_real_escape_string().

MySQL is installed correctly and it's working, just except this one function. (I've established a database connection, using the right username and password).

PHP Code:

echo is_callable('mysql_real_escape_string')
    ? 'Is callable'
    : 'Isnt callable'; 

... this gives me "Is callable". But as soon as I actually call it, Apache crashes.

This is the MySQL section of my PHP Info:

Code:

Active Persistent Links 	0
Active Links 	0
Client API version 	mysqlnd 5.0.4-dev - 080501 - $Revision: 1.3.2.16 $
Persistent cache	enabled
put_hits 	0
put_misses 	0
get_hits 	0
get_misses 	0
size 	2000
free_items 	2000
references 	2 

mysql.allow_local_infile	On	On
mysql.allow_persistent	On	On
mysql.cache_size	2000	2000
mysql.connect_timeout	60	60
mysql.default_host	localhost	localhost
mysql.default_password	******	******
mysql.default_port	3306	3306
mysql.default_socket	no value	no value
mysql.default_user	root	root
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

I have no idea where to even start searching for the error, so any ideas would be appreciated.

[Nico]

Never mind... I needed the server and switched back to XAMPP.

[End User]

Originally Posted by Nico

Now everything seems to be working fine, as long as I don't call mysql_real_escape_string().

I did some searching on this and found a few things, but I don't know if they're relevant to the specific issue you were experiencing:

http://bugs.mysql.com/bug.php?id=3145

http://forums.mysql.com/read.php?45,151245,151245

There wasn't a whole lot more that seemed to bear on this, so my guess is that this is somehow related to the Alpha releases. Try setting up PHP 4.x or 5.0, mySQL 4.1x (very stable for the most part) and any earlier version of Apache...my bet is that everything would work just fine. I know Apache 2.x still has lost of unresolved problems with all sort of open bug issues right now.