vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Display Enhancements - Thread Thumbnail (https://vborg.vbsupport.ru/showthread.php?t=158396)

siliconfinance 01-25-2008 01:00 AM

Get this error for new posts:


Quote:

Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 17508 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(74160, 74080, 68654, 74097, 64105, 57850, 74166, 74172, 74171, 74162, 74170, 74169, 49164, 74072, 74141, 74163, 74092, 14029, 74168, 74167);
MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Date : Thursday, January 24th 2008 @ 06:58:04 PM
Script : http://www.mydomain.com/forums/searc...earchid=506222
Referrer : http://www.mydomain.com/forums/showthread.phpp=1282479#post1282479
IP Address :
Username : sfguy
Classname : vb_database

viper007 01-25-2008 02:25 AM

can give ..breif expaltion .. where can i upload php file in to ftp server ....plzzz urgent am waiting to u r reply..

viper007 01-25-2008 02:37 AM

Quote:

Be sure to change the forum ids in the $thumbsforums array to the forum ids you want to enable thumbnails in.

wheer can i change the forum ids . thumbnails enabled .. plzzzz tell me dudes.. am waiting ur reply

theOZer 01-26-2008 10:05 PM

Quote:

Originally Posted by Adam21 (Post 1404584)
Note: If you are using 3.7 Beta2 and have a quick search template edit in a custom template,you must disable the "search_results_query_threads" hook in your plug-ins manager

Without the thread thumbnail showing up in, say, New Posts, I've got to ask, "when will this search feature work in 3.7.0 Beta4?"

Love this mod/hack. Without it an art forum's impact is greatly reduced when viewing just the forum post listing and/or 'New Posts.'
Regards,
theOZer

SpreadingLight 02-06-2008 12:51 AM

How can this be changed so it's enabled for only specified forums,
and so it will auto-sort by the number of thread replies/comments (sorted in reverse; least comments first) ?

Thank You

siliconfinance 02-11-2008 03:29 AM

Does anybody know why my safari and firefox members can't see the thumbs?

sp0okz 02-14-2008 06:15 PM

can we get this for 3.70

MrGoodbyte 02-17-2008 12:32 PM

@ siliconfinance: How did You get the database-error fixxed? I have the same problem! :eek:

https://vborg.vbsupport.ru/

superthang 02-17-2008 09:29 PM

update for 3.7 please
thanks!

MrGoodbyte 02-18-2008 06:51 AM

Sorry, but I think there are several mistakes in the description of this hack!
  1. Nowhere is mentioned that one hast to upload the search.php to the forum-path, too, that's the reason for the database errors mentioned in my last post.
  2. The explanation of the forum-array is unclear:
    [CDATA[$tt_thumbsforums = array(76 80 81); causes this error-message: Parse error: syntax error, unexpected T_LNUMBER, expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
    [CDATA[$tt_thumbsforums = array(76,80,81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 27
    [CDATA[$tt_thumbsforums = array(76, 80, 81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
    [CDATA[$tt_thumbsforums = array(76; 80; 81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
    [CDATA[$tt_thumbsforums = array(76;80;81); causes this error-message: Parse error: syntax error, unexpected ';', expecting ')' in /forumpath/forumdisplay.php(812) : eval()'d code on line 9
    [CDATA[$tt_thumbsforums = array(76) (80) (81); causes this error-message: Parse error: syntax error, unexpected '(' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
    [CDATA[$tt_thumbsforums = array(76)(80)(81); causes this error-message: Parse error: syntax error, unexpected '(' in /forumpath/forumdisplay.php(812) : eval()'d code on line 36
    So, how shall it be possible to create thumbs for more than one forum? :eek:

Really nice is, that with all the testing now the thread-overview doesn't work even if I only wanna add thumbs to one forum and that I don't find any possibility to deactivate or deinstall the whole hack! So: What can I do now? My hole board doesn't work correctly!


https://vborg.vbsupport.ru/


All times are GMT. The time now is 08:19 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.01558 seconds
  • Memory Usage 1,747KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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