Maximum in SQL query?

From: Date: Mon, 12 Aug 2002 14:28:39 +0000
Subject: Maximum in SQL query?
Groups: php.general 
Request: Send a blank email to php-general+get-112135@lists.php.net to get a copy of this message
Hi people, 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 -- Kind regards, Tim

« previous php.general (#112135) next »