RE: [PHP] Maximum in SQL query?
Hi Jay, Jay Blanchard wrote: > I believe the error is a space prior to 'var' > > "Brunssum", , "/ var/ > > try > > "Brunssum", , "/var/ Nope, that wasn't the error, but the error was in there... it's the ", ," in there :) An empty value... Thanks for the quick reply! -- Kind regards, Tim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Maximum in SQL query?
[snip] 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 (0001, "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 [/snip] I believe the error is a space prior to 'var' "Brunssum", , "/ var/ try "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.). HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Maximum in SQL query?
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 (0001, "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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
