Not a bug vBulletin 3.8 "Key 'threadid' doesn't exist in table 'post'"

[Jake B.]

Affected version

Latest

In AbstractStatement.php line 228:

  MySQL statement prepare error [1176]: Key 'threadid' doesn't exist in table 'post'

xf:import [--processes PROCESSES] [--finalize]

Exception query:
                        SELECT post.*,
                                IF(user.username IS NULL, post.username, user.username) AS username,
                                thread.title AS threadtitle,
                                editlog.dateline AS editdate,
                                editlog.userid AS edituserid
                        FROM post AS
                                post USE INDEX (threadid)
                        LEFT JOIN thread AS
                                thread ON (post.threadid = thread.threadid)
                        LEFT JOIN user AS
                                user ON (user.userid = post.userid)
                        LEFT JOIN editlog AS
                                editlog ON (editlog.postid = post.postid)
                        WHERE post.threadid = ?
                        AND post.dateline > ?
                        ORDER BY post.dateline, post.postid
                        LIMIT ?

I've checked and threadid definitely does exist in both the post and thread tables:

mysql> describe thread;
+--------------------+----------------------+------+-----+---------+----------------+
| Field              | Type                 | Null | Key | Default | Extra          |
+--------------------+----------------------+------+-----+---------+----------------+
| threadid           | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
[...]

mysql> describe post;
+--------------------+----------------------+------+-----+---------+----------------+
| Field              | Type                 | Null | Key | Default | Extra          |
+--------------------+----------------------+------+-----+---------+----------------+
| postid             | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| threadid           | int(10) unsigned     | NO   | MUL | 0       |                |
[..]

Currently trying to sort out exactly why this is happening

 

[Liam W]

It's this: post USE INDEX (threadid). The field might exist, but the query is asking it to use the KEY/INDEX named threadid which probably doesn't exist.

 

[Jake B.]

Hm, yeah it does look like that is the case.. I'll check with them to see if the index was removed intentionally for some reason. Good catch, thanks

 

[Chris D]

For the avoidance of doubt all versions of VB I've got databases for from 3 up to 5 do have that index so it would seem that it being missing is unexpected.

 

[Jake B.]

Yeah, they confirmed that they had removed it intentionally. Got it working regardless though