vBulletin Product SQL Import

[browneyadz]

Whilst trying to import several plugins into my vBulletin 3.8.7, it has come to my attention that regardless of the success of installation message it seems the tables are not created / altered within the database. It seems all the configuration file is correct? Could anyone provide a solution for this issue as I'm not sure if its global. I've tried searching around but I can't find an answer.

Take Yet Another Award System for example;
I get a database error:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT award.*, award_cat.award_cat_title
FROM award AS award
LEFT JOIN award_cat AS award_cat USING (award_cat_id)

ORDER BY award_cat.award_cat_displayorder,award.award_displ ayorder;

Any support would be excellent.

Thanks