[Lon]

Originally Posted by Irishnotsane

I've installed this many times on different forums, and I can't figure out why I get a DB error on this one.. I run 3.8.4 Patch 10 I believe. Some help would be great as I really need this modification! Thanks

Database error in vBulletin 3.8.4:

Invalid SQL:

				SELECT a.*, au.*
				FROM award a, award_user au
				WHERE (au.userid = 25) AND (a.award_id=au.award_id) AND (a.award_active=1)
				ORDER BY issue_time desc;

MySQL Error   : Table 'forum.award' doesn't exist
Error Number  : 1146
Request Date  : Monday, June 11th 2012 @ 04:02:46 AM
Error Date    : Monday, June 11th 2012 @ 04:02:46 AM
Script        : http://forum.mysite.com/showthread.php?t=29
Referrer      : 
IP Address    : 173.245.53.65
Username      : Myusername
Classname     : vB_Database
MySQL Version : 5.5.20-log

It seems in the new PhPMyAdmin version/MySQL, changes were made that affected the way queries were ran and now isn't compatible with the newest version.

You either have to alter the query within the XML or create the tables and columns manually until a fix is made.