[bashy]

Hi

It appears that i am now getting this DB error whilst using your hack

Database error in vBulletin 3.5.3:

Invalid SQL:

                        SELECT post.pagetext AS preview,
                                thread.threadid, thread.title AS threadtitle, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter,
                                thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible
                                

                        FROM thread AS thread
                        
                        LEFT JOIN recentlyviewed AS recentlyviewed ON(recentlyviewed.threadid = thread.threadid)
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                        WHERE thread.threadid IN(132,1550,1584,1580,1585,1573,1586,1587,1588,1381,1589,1559,1590,1591,1579,92,1594,1595,1597,1562,1596,1599,1600,1565,1602,1603,1577,1605,1608,1623,1625,1624,1627,1628,1629,1622,1630,1643,1645,1644,1641,1647,942,362,509,1581,1606,1648,1345,1620,1089,1649,130,1651,1650,1505,1658,1668,1666,1413,1667,1660,1663,1669,554,993,1384,1670,1672,1673,1390,1635,1677,1675,1676)
                        ORDER BY recentlyviewed.dateline DESC
                        LIMIT 5;

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay Error Number : 1104
Date         : Thursday, February 16th 2006 @ 02:11:15 PM
Script       : http://www.bashys-place.com/forums/
Referrer     :

Please advise?