RE: Why does this work on one server, but not another?

[tedd <tedd@xxxxxxxxxxxx>]

Hi gang:

Update:

Both servers state: enable-magic_quotes

One sever states (this is the one that fails):

magic_quotes_gpc ON
magic_quotes_runtime ON

The other sever states (this is the one that works):

magic_quotes_gpc ON
magic_quotes_runtime OFF

However, I am using addslashes() -- should I not 
use them when magic_quotes_runtime is ON? Is that 
the problem? I guess that I could check, but it's 
easier for me to ask at the moment.

tedd


> -----Original Message-----
> From: tedd [mailto:tedd@xxxxxxxxxxxx]
> Sent: Thursday, March 23, 2006 7:48 PM
> To: php-general@xxxxxxxxxxxxx
> Subject:  Why does this work on one server, but not another?
>
> Hi gang:
>
> I posted this question to a MySQL list, but apparently it stumped them. So,
> I'll ask here:
>
> On one server, the following code works without any problems whatsoever:
>
> --- quote ---
>
> $sqlString = "INSERT INTO $dbtable (id, image_type, image_large,
> image_small, image_width, image_height, image_name, image_size, date_time,
> date_created ) VALUES ('', '{$type}', '{$image_large}', '{$image_small}',
> '{$width}', '{$height}','{$name}', '{$size}', '{$date_time}',
> '{$date_created}')"; $result = mysql_query($sqlString)  or die("2.
> Error in query $sqlString " . mysql_error());
>
> --- un-quote ---
>
> However, on another server, it doesn't (remember the code is identical for
> both).
>
> I have looked at the PHP Info on both servers, the php versions are
> different (4.3.10 v 4.4.2) but the mysql specifics are identical except the
> version differs slightly (v 4.1.15 v 4.1.14).
>
> A clue, on the server it chokes on, if I reduce the image size to 100 x 67
> pixels, it will work.
> However, if the image is 150 x 100 pixels, or greater, it will crater.
>
> The error message is:
>
> 2. Error in query INSERT INTO as_table2 (id, image_type, image_large,
> image_small, image_width, image_height, image_name, image_size, date_time,
> date_created ) VALUES ('', 'image/jpeg', 'ÿØÿà\0JFIF\
> -snip- (the entire text file for the image) 'v_small.jpg', '320000',
> '2006-03-22 14:10:55',
> '2006-03-22 14:10:55') You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near
> 'ö~?L-?æÏôÏjâ?(xÏJ?÷Ý>Ô?s?íHñåE(?êÏØÊ?Ü"ÁíÎk????iË3¬4A''ÿ\0?Mm¿ä÷´?ÿ\0m
> ÿ\0&¿'
> at line 2
>
> Any ideas?
>
> Many thanks in advance.
>
> tedd
> --
> ----------------------------------------------------------------------------
> ----
> http://sperling.com
>
> --
> PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
> http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


--
--------------------------------------------------------------------------------
http://sperling.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php