Announcement

Collapse
No announcement yet.

SQL - database error

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

  • [Forum] SQL - database error

    Hi,
    if anyone can hint me what kind of question is sql?

    Code:
    SELECT thread.threadid, thread.title, thread.prefixid, post.attach, thread.postusername, thread.dateline, podcastitem.*, forum.forumid, post.pagetext AS message, post.allowsmilie, post.postid FROM forum_thread AS thread INNER JOIN forum_forum AS forum ON(forum.forumid = thread.forumid) LEFT JOIN forum_post AS post ON (post.postid = thread.firstpostid) LEFT JOIN forum_podcastitem AS podcastitem ON (podcastitem.postid = thread.firstpostid) WHERE 1=1 AND thread.forumid IN(1,2,18,68,70,69,74,72,73,24,71,23,27,38,42,31,62,78,52,63,53,54,55,61,79,60,65,58,59,64,50,56,57,43,4,29,5,30,6,21,22,26,28,39,51,7,47,48,8,9,11,3,35,36,37,32,33,40,19,75,34,76,25,44,41,45) AND thread.visible = 1 AND post.visible = 1 AND open <> 10 AND thread.dateline > -24646346544 ORDER BY thread.dateline DESC LIMIT 15:
    Such queries to the database are hundreds and they cause overloading the database - which leads to a Database error message. I do not know where to find the cause - unfortunately I do not know why/where this query is generated? Scheduled tasks? search? - Any tips please ...

  • #2
    That looks like the query in the external.php file - so it's from your rss feed.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment


    • #3
      Thank you for your reply. This will definitely help me solve the problem.

      Comment


      • #4
        Actually, I don't even see an error in there.

        Comment

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