It seems that MySQL only accepts queries that are 470 characters or smaller
when I use PHP. Is this a known thing? Can I change it somehow? I printed
the query:

Query: REPLACE INTO foto (ID, titel, fotograaf, origineel_formaat_x,
origineel_formaat_y, datum_invoering, datum_wijziging, plaats_opname,
datum_opname, file_thumb, file_large, url_thumb, url_large, thumb_hoogte,
thumb_breedte, large_hoogte, large_breedte, fine_art_print,
digitaal_formaat) VALUES (00000001, "Eva", "Jasper", 1024, 768, now(),
now(), "Brunssum", , "/ var/www/html/foto/0/0/0/0/0001.thumb.jpg",
"/var/www/html/foto/0/0/0/0/0001.jpg", "/foto/0/0/0/0/0001.thumb.jpg", "/
foto/0/0/0/0/0001.jpg", 200, 150, 500, 375, "FALSE", "Array")

Database error: You have an error in your SQL syntax near '
"/var/www/html/foto/0/0/0/0/0001.thumb.jpg", "/var/www/html/
foto/0/0/0/0/0001.j' at line 1

I believe the error is a space prior to 'var'

"Brunssum", , "/ var/


"Brunssum", , "/var/

I consistantly use queries in PHP that are far longer than 470 characters
(not to mention that 470 would be an odd choice for a limit of this type.).



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

Reply via email to