#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    4
    Rep Power
    0
    I have a mySQL database (version 3.22.32) that holds news articles. I've built a browser-based admin interface to add, edit and delete articles in this database. I've used the database and admin on multiple sites with no problems, until now. In my latest implementation of this "app," I can insert, update and delete articles of any size via telnet. Through my admin tool, I can insert, update and delete very short articles. However, I cannot insert or update (yet, I can delete) long articles via the admin tool. (When I say long, I only mean a couple-few paragraphs, not pages and pages of text.) The field is mediumtext, so that isn't the problem. On a different staging server, the admin tool works fine on any size article, so it's not my code. Originally, I thought that my ISP's firewall was blocking a certain size http send, but they've instructed me that the server my database is on is not behind a firewall. So, my question is, does mySQL have some way to limit an http send above a certain size? Basically, is it mySQL that could be causing this problem, or is it more likely something else? What else could be going on here? I'm really at a loss, and am desperately seeking advice from anyone that has even the smallest bit of input they can offer. Thanks in advance.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Location
    Montreal, Canada
    Posts
    72
    Rep Power
    14
    I had a similar problem but I found out it was more of a HTML problem. I was using a form to input my data and HTML requires that you specify how large an input type should be or else it defaults to a certain value(browser dependent). I then had to specify that I was using a textbox area specifying the column width and height.

    In your situation, I am not too sure if this is the problem but MySQL has to allocate maximum area for any type of data(logically) in some form of vector form. The only other reason is you have exceeded these vector capacity(I doubt this).
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    61
    Rep Power
    14
    if you are using a form here, make sure you're using method="post" and not "get".

Similar Threads

  1. video capture file size limit
    By scooby74 in forum Windows Help
    Replies: 1
    Last Post: February 5th, 2004, 10:52 AM
  2. send info to open socket
    By chgifts in forum PHP Development
    Replies: 0
    Last Post: January 23rd, 2004, 02:51 PM
  3. mailto size limit: Need Alternate
    By mrortner in forum PHP Development
    Replies: 0
    Last Post: January 5th, 2004, 12:37 PM
  4. Socket recv and send help
    By Soul12 in forum C Programming
    Replies: 0
    Last Post: December 14th, 2003, 04:53 PM
  5. Does _msize() always return EXACT size of malloc'ed block?
    By Jason Doucette in forum C Programming
    Replies: 10
    Last Post: November 29th, 2003, 12:24 AM

IMN logo majestic logo threadwatch logo seochat tools logo