Bug DB Error

[FDinolfo]

Trying to use vbArcade Lite to see whether I want to purchase it. It installed okay, at least I thought it did, but I keep getting this error.

Database error in vBulletin 5.1.1:

                        Invalid SQL:

                                SELECT
                                         COUNT(*) AS total,
                                         AVG(rating) AS average
                                FROM ttruck_dbtech_vbarcade_session
                                WHERE gameid = 'bigmoneyGC'

/**getVoteStats- vbarcade**/;

                        MySQL Error   : Unknown column 'rating' in 'field list'
                        Error Number  : 1054
                        Request Date  : Saturday, May 10th 2014 @ 05:24:55 PM
                        Error Date    : Saturday, May 10th 2014 @ 05:24:55 PM
                        Script        : http:///admincp/arcade_admin.php?do=import
                        Referrer      : http://www.tiredofittrucking.org/admincp/arcade_admin.php?do=import
                        IP Address    : x.x.x.x
                        Username      : AdminUser
                        Classname     : vB_Database_MySQLi
                        MySQL Version : 10.0.10-MariaDB-1~wheezy-log

The game does appear in the list on the portal page, but clicking play now or scores, or whatever just goes back to the homepage, making it completely unusable.

 

[Fillip H.]

I've added a hotfix to /core/packages/dbtechvbarcade/db/mysql/querydefs.php that should fix this