Tags help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • morrow
    Senior Member
    • Mar 2002
    • 137

    [Forum] Tags help

    In a previous version of vBulletin, I had the Zoints tags installed and working. Since I upgraded to vb4.0.6, I no longer use Zoints. The problem is that when I click on "Tag Cloud", I'm recieving a mySQL message:

    Code:
    <!--
    Database error in vBulletin 4.0.6:
     
    Invalid SQL:
     
            SELECT zoints_tag.tag, COUNT(*) count FROM zoints_tag zoints_tag
            LEFT JOIN thread thread ON(zoints_tag.threadid = thread.threadid)
            WHERE thread.forumid IN(168,169,170,12,122,22,5,20,64,85,89,121,73,21,72,148,147,106,7,113,114,94,139,4,108,50,51,52,53,55,120,104,105,115,135,14,11,90,95,129,131,16,74,96,86,69,8,137,138,107,111,67,28,57,87,88,70,15,29,58,134,110,17,18,19,117,116,118,13,23,153,154,156,157,158,159,155)
     
                AND autogen != 1
            GROUP BY zoints_tag.tag 
            ORDER BY count DESC
            LIMIT 30;
     
    MySQL Error   : Table 'njfly_vBulletin.zoints_tag' doesn't exist
    Error Number  : 1146
    Request Date  : Tuesday, September 7th 2010 @ 01:14:56 PM
    Error Date    : Tuesday, September 7th 2010 @ 01:14:56 PM
    Script        : http://www.njflyfishing.com/vBulletin/tags/
    Referrer      : 
    IP Address    : ***
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version : 
    -->
    Now of course the table doesn't exist, it was deleted when I uninstalled Zoints. Something was obviously not uninstalled completely and is still looking for this reference.

    Now I don't expect anyone here to support Zoints or any other modification that I may have installed but I am hoping that someone might be able to put me in the right direction to troubleshoot my issue here.

    I've removed all files related to Zoints and uninstalled the product.

    Then I went and ran a query on my DB. The following tables have references to Zoints:

    adminlog
    cronlog
    datastore

    Your input would be greatly appreciated!

    Thank You.
    -=morrow=-
  • morrow
    Senior Member
    • Mar 2002
    • 137

    #2
    Anyone have any ideas?
    -=morrow=-

    Comment

    • Acido
      Member
      • Sep 2003
      • 45

      #3
      Just as a reference: After uninstall zoint tags, you must to delete the folder /tags on your server, or use another word in vbseo to rewrite the tags url.
      Regards

      Comment

      Related Topics

      Collapse

      Working...