Maximum in SQL query?
| From: | Tim Stoop | 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