Quote:
Originally Posted by MarkFL
Can you provide the information about the steps you are taking to reorder the list and the exact error you get?
|
Thank you, and from the main page (forumhome) which is where I display the Featured Threads box, I either select all or select the Featured Threads I want to reorder and then alter the value in the display order box to be what I want it to (while editing the display order of any other threads which had that original value to the value of the threads being moved up or down). I then click re-order.
My exact error is this on the standard vBulletin Database Error page:
Page URL:
https://www.alexandria-ns.com/featur...p?action=array
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT thread.*, featuredthreads.id
FROM estate_thread
INNER JOIN estate_featuredthreads
ON thread.threadid = featuredthreads.threadid
ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;
MySQL Error : Unknown table 'thread'
Error Number : 1051
Request Date : Monday, April 18th 2016 @ 02:43:08 PM
Error Date : Monday, April 18th 2016 @ 02:43:08 PM
Script : http://www.alexandria-ns.com/featuredthread.php?action=array
Referrer : https://www.alexandria-ns.com/forum.php
IP Address : xx.xx.xx.xx
Username : Joshua Ravenclaw
Classname : vB_Database_MySQLi
MySQL Version : 5.5.47-0ubuntu0.14.04.1