Bug Database error when enabling Hash tags sidebar

[IcEWoLF]

Here is the error I currently get:

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT hash, userid
			FROM dbtech_usertag_hash AS hash
			LEFT JOIN blog_text AS blog_text ON (blog_text.blogtextid = hash.postid)
			WHERE hash.type = 'post'
				AND hash.dateline > '1338612304';

MySQL Error   : Table 'rsquadco_lunar.blog_text' doesn't exist
Error Number  : 1146
Request Date  : Sunday, June 3rd 2012 @ 12:45:04 AM
Error Date    : Sunday, June 3rd 2012 @ 12:45:04 AM
Script        : http://www.47r-squad.com/forum.php
Referrer      : http://www.47r-squad.com/forum.php
IP Address    : xxxxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version : 5.1.62-cll

 

[Fillip H.]

I totally did not put the blog query where the post query should have been and vice versa.

Nosir, not me.

>.>

<.<



Fixed, re-download and re-upload /includes/block/dbtech_usertag_hash.php