Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You may be violating the <code>max_allowed_packet</code> setting. See <a href="http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html" rel="nofollow">here</a> for more data.</p> <p>Quote,</p> <blockquote> <p>If you are using the mysql client program, its default max_allowed_packet variable is 16MB.</p> </blockquote> <p>If you are uploading uncompressed images, this value is fairly easy to reach.</p> <p>Also, it would be great if you could name the specific database interface class that you use (PDO? mysql_? mysqli_?), as different classes handle errors differently. It could just as well not handle an oversized packet situation at all.</p> <p>P.S.: You should really be checking your logs for the specific error you encounter. The first place to look for would be <code>/var/log/mysql/error.log</code> (could vary depending on your env)</p> <p><strong>Update:</strong> <code>mysql_error()</code> returned <code>"MySQL server has gone away"</code></p> <blockquote> <p>From the manual pages for the error: "You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end..."</p> </blockquote> <p>(quote courtesy of @Colin Morelli)</p>
    singulars
    1. This table or related slice is empty.
    1. POMySQL insert query failing when data gets large
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMaxim Kumpan
    1. USMaxim Kumpan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMySQL insert query failing when data gets large
      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. COI am using phpmyadmin and images that I am uploading as BLOB are in KB's(not more than 50). In mysql.log I am not getting anthing related to this and I am not able to find error.log anywhere in mysql.
      singulars
      1. PO
      1. USAman Chhabra
    2. CO@AmanChhabra, Try eyeballing your /var/log folder for mysql* files or directories in case you missed something. Also try checking your webserver log files for errors. Another point: are you certain the query correctly reaches your database? Could there be a data transition problem before your mysql call?
      singulars
      1. PO
      1. USMaxim Kumpan
    3. COI have changed every field to longtext and longblob. Also $result=mysql_query($sql) is returning null and there are no log entries. I am a noob sorry if I didnt get what you meant. Also I even searched for every log files... there is no path as you mentioned.
      singulars
      1. PO
      1. USAman Chhabra
 

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