Announcement

Collapse
No announcement yet.

Invalid SQL

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

  • [Forum] Invalid SQL

    Database error in vBulletin 4.1.1:

    Invalid SQL:

    SELECT tagsearch.tagid, tag.tagtext, COUNT(*) AS searchcount
    FROM blog_tagsearch AS tagsearch
    INNER JOIN tag AS tag ON (tagsearch.tagid = tag.tagid)
    WHERE tagsearch.dateline > 1295046981
    GROUP BY tagsearch.tagid, tag.tagtext
    ORDER BY searchcount DESC
    LIMIT 70;

    MySQL Error : Table 'indianaa_forumdb.blog_tagsearch' doesn't exist
    Error Number : 1146
    Request Date : Sunday, February 13th 2011 @ 06:16:21 PM
    Error Date : Sunday, February 13th 2011 @ 06:16:21 PM
    Script : http://www.indianaauditions.com/foru....php?do=search
    Referrer :
    IP Address : 68.100.149.20
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

  • #2
    Just had a look at my own database and I have no table called "blog_tagsearch" despite running the blog. blog_tagsearch is an old vB3 table.

    That suggests that this is being caused by a modification.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.2 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Floydian, did you ever find the culprit. Getting the same error.

      Mike

      Comment

      Related Topics

      Collapse

      Working...
      X