vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Recently Viewed Threads (https://vborg.vbsupport.ru/showthread.php?t=107739)

bashy 02-16-2006 05:11 PM

All seems ok again :)
Cheers for the quick response an all that :)

bashy 02-19-2006 06:44 PM

Just had this error

Code:

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(1701,1699,1698,1697,1693,1692,1691,1687,1703,1704,1705,1706,1708,1707,1712,1714,194,1732,1103,1729,1718,1725,1717,1736,1051,1741,1647,1625,1346,1579,1688,1742,1743,1744,184,1670,1754,1753,1758,1759,1577,1757,1546,1391,1760,1761,1762,1764,1766,1765,1749,1747,1748,1755,1767,1768,1769,1770,1771,1773,1774,1775,1776,1751,1678,1657,1640,1611,1607,1561,1540,1528,1777,1778,1779,132,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1685,1715,1772,1816,1621)
                        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        : Sunday, February 19th 2006 @ 08:35:01 PM
Script      : http://www.bashys-place.com/forums/
Referrer    : http://www.bashys-place.com/forums/

I tried to run that sql ya gave me but didnt work this time...
Please advise as i have to keep this turned off now :(

Wongod 03-15-2006 08:25 AM

Is this hack working?

thanh 03-30-2006 06:52 PM

me too

I had the errrors

Database error in vBulletin 3.5.4:

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(4,5,1,2,3,15,19,8,22,23,28,29,11,34,18,24,25,20 ,40,42,57,59,60,62,31,64,65,35 ,66,6,7,67,41,73,63,72,74,75,76,77,78,79,80,81,82, 83,84,85,86,87,88,89,90,91,92, 93,94,95,96,97,98,99,100,101,102,103,104,105,106,1 07,71,111,115,117,127,157,134, 181,156,120,186,141,159,197,234,217,216,187,237,19 6,192,243,211,244,215,133,212, 246,158,268,270,272,274,276,277,278,279,280,281,28 2,283,284,285,286,287,289,290, 291,292,294,295,296,298,299,300,301,302,303,68,304 ,307,308,309,310,312,313,314,3 15,316,317,318,320,321,322,323,324,325,326,327,328 ,180,330,152,331,333,221,335,3 36,337,188,338,341,342,347,340,359,384,379,386,155 ,385,362,344,390,391,358,396,4 15,441,458,463,436,474,476,429,269,461,484,487,493 ,488,491,502,509,511,512,513,5 14,515,516,517,519,521,522,523,524,504,424,496,492 ,154,421,537,531,470,420,560,5 58,564,477,466,426,542,430,494,475,561,566,520,568 ,604,596,574,600,618,615,614,6 23,624,585,619,622,598,563,577,261,645,423,706,670 ,757,756,866,937,802,808,841,6 92,960,904,829,1030,1014,1029,1034,1046,377,1036,1 044,1033,1018,375,1022,1051,20 6,401,409,367,378,387,13,453,951,1143,1217,1219,11 49,1195,1042,1272,1275,1305,63 2,275,241,675,1658,373,1303)
ORDER BY recentlyviewed.dateline DESC
LIMIT 5;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Thursday, March 30th 2006 @ 03:30:52 PM
Script : http://xxxxxxxxxxxxxx/forums/index.php
Referrer : http://xxxxxxxxxx/forums/showthread.php?t=1679
IP Address : xxxxxxxxxxxxxx
Username : admin
Classname : vb_database

thanh 03-30-2006 07:00 PM

@LiveWire

When run
DELETE FROM recentlyviewed
WHERE dateline < (1140115611 - 3600)

The member access forum OK w/o any error but when iam, the administrator loggin in the error still apear :(

thanh 03-30-2006 07:02 PM

AHA, when i'm trying TRUNCATE TABLE `recentlyviewed`
all become the normal now:)

xspazx 04-03-2006 09:10 PM

The hook for this plugin made my forums stats say threads: 5. Maybe you should update that?. I wont click uninstall in hopes that you do fix the slight bug. But it's going to be disabled on my site for now. Thanks.

Logikos 04-04-2006 02:33 AM

I'll be updating this in the next day or so, as I need to fix it for my site. ;)

Wongod 04-24-2006 05:00 PM

Hi LiveWire, any progress? This seems like a great feature.

FleaBag 05-23-2006 05:17 AM

I get the issue where it says I have 5 threads too. Also, recently this seems to slow down my forumhome loading. Normally <1 second to over a minute. I had to disable even with it only showing 3 threads updating every 30 minutes. Hope you know about this issue and how to fix. :D


All times are GMT. The time now is 03:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02339 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete