[Mornagest]

Hello Mark,

And thank you for your quick answer

I made a try and got a database error. This comes up because we put a prefix to all our vBulletin tables (we have several other databases so we chose to prefix their tables). I tried to add the prefix to the query but it still doesn't work ; I don't know where to add it.

As you can see, the prefix is vb_ ; where should I add it ?

Again, thank you !

Database error in vBulletin 4.2.2:

Invalid SQL:

    SELECT attachment.*, user.*, post.postid, post.threadid, thread.title, filedata.filesize
    FROM vb_attachment
    INNER JOIN vb_user
    ON user.userid = attachment.userid
    INNER JOIN vb_post
    ON post.postid = attachment.contentid
    INNER JOIN vb_thread
    ON thread.threadid = post.threadid
    INNER JOIN vb_filedata
    ON filedata.filedataid = attachment.filedataid
    ORDER BY attachment.dateline DESC
    LIMIT 5;

MySQL Error   : Unknown table 'attachment'
Error Number  : 1051
Request Date  : Tuesday, December 22nd 2015 @ 01:31:53 PM
Error Date    : Tuesday, December 22nd 2015 @ 01:31:54 PM
Script        : http://www.myforum.fr/forum.php
Referrer      : http://www.myforum.fr/forum.php
IP Address    : 80.67.176.207
Username      : Mornagest
Classname     : vB_Database
MySQL Version : 5.5.46-0ubuntu0.12.04.2