By cybe on

So I have a lot of big articles I wanto add but the max size seems to be 64kb, what do I tweak? Php, apache or mysql? Can

Comments

marco’s picture

marco commented

In MySQL run

ALTER TABLE node CHANGE body body MEDIUMTEXT;

this should be enough, your new max will be 2^24 chars

--
Marco

allitbooks’s picture

allitbooks commented

I am trying to paste a table from dreamweaver into a drupal page node. The code itself is about 15k. I have applied the tweak above to no avail. I keep getting a page not found error. If I paste part of the code in and enclose it in

It will show it but when ever I try to do the whole thing it gives me the page not found error. I have tried removing everything except the

and html(i.e. no font, align, colspan tags) and it will still do it if I try to submit or preview the whole table.
drnonsense’s picture

drnonsense commented

I am having the same problem as allitbooks: trying to enter the following html table into a page node in drupal 4.7.0 I get the error page that follows the code.

<strong>Photography:</strong>
<table width="75%" border="0" align="center">
  <tr> 
    <td width="30%"> 
<a href="http://www.ephotozine.com/" target="_blank">ephotozine</a></td>
    <td width="70%"> 
      good site with news, a great forum that 
        allows posting of photos with various awards and a &quot;Photo of the 
        Week&quot;</td>
  </tr>
  <tr> 
<td> 
<a href="http://www.photo.net/" target="_blank">photo.net</a></td>
    <td> 
      good photo posting forum with &quot;Photograph of 
        the Week&quot; but articles are not updated frequently</td>
  </tr>
  <tr> 
<td> 
<a href="http://www.radiantvista.com/index.php" target="_blank">The 
        Radiant Vista</a></td>
    <td> 
      excellent and very polished site with some fantastic 
        free tutorials on Photoshop</td>
  </tr>
  <tr> 
<td> 
<a href="http://theonlinephotographer.blogspot.com/" target="_blank">The 
        Online Photographer</a></td>
    <td> 
      blog with interesting articles on photography</td>
  </tr>
  <tr> 
<td> 
<a href="http://luminous-landscape.com/" target="_blank">The 
        Luminous Landscape</a></td>
    <td> 
      site with interesting articles, reviews and tutorials</td>
  </tr>
  <tr> 
<td> 
<a href="http://www.dpreview.com/" target="_blank">dpreview</a></td>
    <td> 
      good site for camera news and reviews</td>
  </tr>
  <tr>
<td><a href="http://www.photoshopguys.com/">Photoshop TV</a></td>
    <td>Photoshop tutorials,tips etc in the form of a TV show</td>
  </tr>
</table>
<strong>Computers:</strong>
<table width="75%" border="0" align="center">
  <tr> 
    <td width="30%"><a href="http://www.computershopper.co.uk/" target="_blank">Computer 
        Shopper</a></td>
    <td width="70%">News and reviews</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.dabs.com/" target="_blank">Dabs</a></td>
    <td width="70%">Online retailer of all things computer related</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.novatech.co.uk/novatech/" target="_blank">Novatech</a></td>
    <td width="70%">ditto</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.savastore.com/" target="_blank">Savastore.com</a></td>
    <td width="70%">ditto</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.misco.co.uk/" target="_blank">Misco</a></td>
    <td width="70%">ditto</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.overclockers.co.uk/" target="_blank">Overlclockers UK</a></td>
    <td width="70%">ditto (with emphasis on high quality components)</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.morgancomputers.co.uk/" target="_blank">Morgan Computers</a></td>
    <td width="70%">Retailer of computers and components specialising in end of line and refurbished stock</td>
  </tr>
</table>
<strong>Whisky:</strong>
<table width="75%" border="0" align="center">
  <tr> 
    <td width="30%"><a href="http://www.royalmilewhiskies.com/" target="_blank">Royal Mile Whiskies</a></td>
    <td width="70%">Whisky heaven</td>
  </tr>
  <tr> 
    <td width="30%"><a href="http://www.justminiatures.co.uk/" target="_blank">Just Miniatures</a></td>
    <td width="70%">Great selection of whisky miniatures</td>
  </tr>

</table>

Error Page...

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@simon.naisbitt.me.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I checked the MySQL entry under nodes/body as suggested by marco but it was set to

longtext

which I would assume is longer than

mediumtext

and it certainly looks that way from MySQL documentation.

One funny thing: I find I can succesfully post up to the table row for dpreview successfully and can copy and paste the earlier entries into the same table after this thus giving me duplicate entries. So I assume there is something with the way the HTML is written after this that is wrong but I can't detect it.

Anyone got any ideas??

webmeister123’s picture

webmeister123 commented

I am having the same issue here. Drupal refuses to render the page if the textarea is larger then 64kb.

Any solutions or tweaks?

ludo.r’s picture

ludo.r
Location Brussels
commented

I have the same issue here D 6.15.

My text in english is 62000 bytes, and it displays well.
The russian version is 52000 and the text does not appear. I myust cut half the text to get the text displayed.