Announcement

Collapse
No announcement yet.

Database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error

    I don't quite exactly know why this error occurred

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT postid AS itemid, post.visible AS post_visible, thread.visible AS thread_visible, thread.forumid, thread.threadid,
    IF(postuserid = 24595, 'self', 'other') AS starter
    FROM post AS post
    INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
    WHERE postid IN(394890, 394871, 394854, 394846, 394843, 394840, 394839, 394838, 394836, 394811, 394810, 394808, 394801, 394757, 394756, 394755, 394754, 394753, 394752, 394751, 394750, 394749, 394748, 394747, 394746, 394745, 394743, 394742, 394741, 394740, 394728, 394711, 394707, 394706, 394705, 394704, 394693, 394691, 394687, 394686, 394685, 394683, 394682, 394679, 394678, 394677, 394676, 394675, 394674, 394673, 394672, 394671, 394669, 394667, 394664, 394660, 394659, 394658, 394657, 394656, 394655, 394654, 394651, 394650, 394649, 394646, 394645, 394639, 394635, 394632, 394631, 394630, 394627, 394622, 394621, 394620, 394619, 394618, 394617, 394615, 394614, 394613, 394612, 394605, 394604, 394603, 394602, 394600, 394598, 394597, 394595, 394594, 394593, 394592, 394590, 394582, 394577, 394575, 394574, 394573, 394569, 394539, 394537, 394529, 394528, 394527, 394525, 394524, 394523, 394521, 394520, 394519, 394518, 394517, 394516, 394515, 394514, 394512, 394472, 394468, 394467, 394466, 394454, 394445, 394438, 394436, 394433, 394427, 394426, 394425, 394424, 394423, 394410, 394391, 394382, 394374, 394371, 394369, 394366, 394358, 394354, 394347, 394309, 394303, 394285, 394245, 394244, 394243, 394241, 394239, 394238, 394235, 394224, 394223, 394222, 394221, 394220, 394214, 394213, 394212, 394211, 394210, 394209, 394206, 394205, 394204, 394203,...
    I knew about it only when I checked my email account, I was surprised to see it Any possible solution to this problem, if it is

  • #2
    continuation
    Invalid SQL:

    SELECT postid AS itemid, post.visible AS post_visible, thread.visible AS thread_visible, thread.forumid, thread.threadid,
    IF(postuserid = 24595, 'self', 'other') AS starter
    FROM post AS post
    INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
    WHERE postid IN(394890, 394871, 394854, 394846, 394843, 394840, 394839, 394838, 394836, 394811, 394810, 394808, 394801, 394757, 394756, 394755, 394754, 394753, 394752, 394751, 394750, 394749, 394748, 394747, 394746, 394745, 394743, 394742, 394741, 394740, 394728, 394711, 394707, 394706, 394705, 394704, 394693, 394691, 394687, 394686, 394685, 394683, 394682, 394679, 394678, 394677, 394676, 394675, 394674, 394673, 394672, 394671, 394669, 394667, 394664, 394660, 394659, 394658, 394657, ....
    this was second db error email

    Comment


    • #3
      To be able to help you, we will need to see the full error (you can cut out the large part of postid's).
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

      Comment


      • #4
        oh! sorry didn't notice it

        This is the below part
        AND thread.open <> 10
        ###AND thread.visible = 1###
        ###AND post.visible = 1###;

        MySQL Error : Got a packet bigger than 'max_allowed_packet'
        Error Number : 1153
        Date : Monday, December 11th 2006 @ 04:41:58 PM
        Script : http://www.forum.com/forum/search.php?searchid=101353 Referrer :
        IP Address :
        202.171.31.202
        Username : djxxx
        Classname : vb_database
        when I just followed up with script link I got this msg in my forum:

        Sorry - no matches. Please try some different terms.
        Last edited by riderbook; Sun 17 Dec '06, 9:51pm.

        Comment


        • #5
          MySQL Error : Got a packet bigger than 'max_allowed_packet'

          MySQL Error: Max packet size
          It means that someone has tried to post something larger than your host allows for.

          MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

          You need to ask your host to increase the 'max_allowed_packet' variable in the my.cnf file and restart MySQL. The default is 1Mb, but most hosts run 8-16 Mb without problems.
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X