Re: [PHP] Issues with long SQL inserts

2002-04-01 Thread Chris Snyder
Jason Wong wrote: > On Monday 01 April 2002 07:22, Chris Snyder wrote: > > > >>I altered the add.php script to print the query to screen instead of >>sending it to MySQL to try this. It still acted the same, regardless of >>whether it was sending it to the My

Re: [PHP] Issues with long SQL inserts

2002-04-01 Thread Chris Snyder
Jason Wong wrote: > On Monday 01 April 2002 07:22, Chris Snyder wrote: > > > >>I altered the add.php script to print the query to screen instead of >>sending it to MySQL to try this. It still acted the same, regardless of >>whether it was sending it to the My

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Cal Evans wrote: >Sorry, I've reached the end of my tech-support flow-chart. You might want >to try 2 things: > >1: Fire up the MySQL client of choice and do the insert manually. If it >works there. If it does then at least you've isolated the problem to PHP or >your script. If not then you'v

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Cal Evans wrote: >I'm not up on the exact spec on MySQL but if it has an 'unlimited' text type >then it is a rarity among SQL engines. M$SQL's limit is (used to be?) 8MB >in a single text field. > >FoxPro/dBase had an unlimited text field but that's not so must a SQL engine >as a file format. >

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
y give a hint. > I tried shaving off the article to the size that it truncated it to on its own, and the add worked fine. It seems to be a concrete limit of about 8-9K. >-Original Message- >From: Chris Snyder [mailto:[EMAIL PROTECTED]] >Sent: Sunday, March 31, 2002 3:43 PM &

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
ith 40 meg free, and around 450 meg of swap - shouldn't be a problem. >-Original Message- >From: Chris Snyder [mailto:[EMAIL PROTECTED]] >Sent: Sunday, March 31, 2002 3:43 PM >To: [EMAIL PROTECTED] >Subject: [PHP] Issues with long SQL inserts > > >Server is r

[PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Server is running PHP 4.1.2, APC 1.1.0pl1, MySQL 3.23.47, Apache 1.3.23 on a built-from-scratch Linux system with kernel 2.4.17, glibc 2.2.5, and gcc 3.0.4. I'm using a fairly simple script to take input from a form, and add it to a database. The database has the following structure: ID - med