Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It sounds very much like your php was compiled with <a href="http://www.hardened-php.net/suhosin/" rel="nofollow">Suhosin</a>. The <a href="http://www.hardened-php.net/suhosin/configuration.html" rel="nofollow">default limit</a> of length for any post variable with Suhosin is 65000 bytes which is quite close to what you are estimating as your limit.</p> <p>In fact, your server is sending the <code>X-Powered-By</code> header with a value of <code>PHP/5.2.6-1+lenny9</code>. I googled this package version and on the Debian website they mention it was <a href="http://packages.debian.org/lenny/php5-common" rel="nofollow">built with Suhosin</a>.</p> <p>Since you do not have control over your server configuration, the solution would be to split up the canvas data into multiple variables below the post length limit of your server and then reassemble in PHP. If you check your <code>phpinfo()</code> it should show all these limits.</p> <p><strong>Edit</strong> - Added example code</p> <p><strong>Javascript:</strong></p> <pre><code>var canvasData = canvasP.toDataURL(); var length = canvasData.length; var content = ''; var index = 0; var limit = 64999; var l; while (length &gt; 0) { if (length &lt;= limit) l = length; else l = limit; content += '&amp;content[]=' + canvasData.substr(index * limit, l); length -= l; index++; } xhr.send(content); </code></pre> <p>I don't believe you need the <code>encodeURIComponent()</code> you have because <code>toDataURL()</code> encodes as base64 which is url safe.</p> <p><strong>PHP:</strong></p> <pre><code>if (!empty($_POST['content']) &amp;&amp; is_array($_POST['content'])) { $content = ''; foreach ($_POST['content'] as $part) { $content .= $part; } $content = base64_decode($content); } </code></pre> <p>Not the most efficient method to do this, but it may help you.</p> <p>This will still have it's limits with Suhosin, but you will be able to send much more data this way. Looks like you will be limited to 64 parts of 65000 bytes in an array before you will also have to use multiple arrays. However, at that point it will already getting way too large for most people to be uploading often and it would probably be better to send the changes to the image somehow instead of the whole image.</p>
    singulars
    1. This table or related slice is empty.
    1. POCan't POST large html5 canvas to server?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMike
    1. USMike
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCan't POST large html5 canvas to server?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you sir for figuring it out. Not very experienced with server-side stuff myself. So now I have to divide the string into <65kB pieces and do multiple POST-s... It seems like a lot of trouble to try to piece them all together on the php side. I'd have to add "headers" to each post so the script will know what to do with the pieces. Is there no other way to save your stuff on a server? Like some sort of reverse streaming?
      singulars
      1. PO
      1. USSpectraljump
    2. COInteresting... never thought, there may be limit from php build.
      singulars
      1. PO
      1. USkirilloid
    3. COI'm not sure of any easier way you could send the data besides POSTing it, but you don't necessarily have to do multiple POSTs. You just have to send multiple variables with the single POST having each variable being under 65000 bytes. And as long as the total of all values is below your limit of `post_max_size`, you should be fine. I've updated my answer for a possible method you could use to do this, it is untested however so I'm not sure if it will work. And of course, it would be a lot better if you could just get some hosting without Suhosin installed, but that's not always possible.
      singulars
      1. PO
      1. USMike
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload