Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Size Limits On Uploaded Photos

forums forums SQLyog Using SQLyog Size Limits On Uploaded Photos

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #22655
      peterlaursen
      Participant

      There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

      But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

      Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

      PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

      SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

      If you create a ticket I can arrange access to a database on another server (tomorrow!).

      Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

      Tickets: http://www.webyog.com/support/ttx.cgi

    • #22656
      Tarheel
      Member

      I upgraded to the 5.2 beta5 and as you predicted, it did not solve the problem.

      I then changed the field from BLOB to LONGBLOB and that solved it. I just uploaded a ~600KB image file successfully. Thanks for your prompt response. I am very pleased the SQLyog program.

      peterlaursen wrote on Oct 2 2006, 01:54 PM:
      There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

      But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

      Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

      PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

      SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

      If you create a ticket I can arrange access to a database on another server (tomorrow!).

      Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

      Tickets: http://www.webyog.com/support/ttx.cgi

    • #22657
      peterlaursen
      Participant

      OK …

      you can read about the max. storage size of different variable types here:

      http://dev.mysql.com/doc/refman/5.0/en/sto…quirements.html

      BLOB: 2^16 byte ~64 KB

      MEDIUBLOB: 2^24 byte ~ 1.6 MB

      LONGBLOB: 2^32 byte ~ 4 GB

      Data are truncated if they are too big. However I did not notice because my image was a Interlaced TIFF image and with that resolution it displayed OK actually (there were lots of 'holes' in it but they were not visible). A .JPG on the opposite will simply be cut off!

Viewing 2 reply threads
  • You must be logged in to reply to this topic.