just installed on vb3.6.8

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 , attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , post.pagetext AS previewbbcode
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 = 1 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')) 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
(24907) GROUP BY thread.threadid GROUP BY thread.threadid;

MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066

i got that error by selecting `get new posts`

I fixed the above error - well sort of by going to plugin manager and disabling he 2 search boxes for it.Aint found no more errors at moment and the hack is working in the forum i selected.
Does anyone have a fix so i can have pics showing on search as well ?

On my 3.6.8 show just the image "nothumb.jpg" no way to show any other image.
What's wrong? I've installed the xml plugin, modified the template, add the id number of tread and disabilited the "Thread Thumbnail - Search" because I don't like.

Any could help me please???

Thank's P.

im amazed search.php worked for u - gave me a sql error

are u sure the forums u have it set for have a valid attachment pic

Now work. In my forum wasn't abilitated the Thambs

Thank's to all.
P.

Wondering if this mod works with any other free hosting image such as imageshack?

Err, no. It parses the attachments in each thread and produces uses the first attachments thumbnail as the thread thumbnail.

What's the line you've added to search.php ? I have already modified my search.php so I would need to modify the file for this hack myself.

any pics i upload i like to show inside the post but if i do then the thumbnail does not show unless i switch create thumbnail back on = then if i do that then pics are shown in threads/posts as small images which need to be clicked on to get full view.

Is there anyway i can have the thumbnail on forumdisplay while still viewing the full pic inside thread/posts without having to click on the image in the post.

Try so:
in option vbulletin switch yes (pic 001 rif pic 002 in english the help of pic 1)
then attachment switch yes pic 003.

Sorry but my forum is in italian!!!

P.

it all set same as yours m8 but pics in posts still need to be clicked on.
Thanks for your time is appreciated.

If i turn off the show thumbnail in attachments option it just displays a link instead of the pic

Watch here if is like U want: http://www.forumocchisullanatura.it

P.

that is weird cause its deffo working on your board.Yet my options in admincp are same as yours yet dont work

will pm u an account so u can take a look m8

send here: info@massimopisettaphotography.com

P.

sent m8

Hi there

I did all needed changes twice but no thumb is displaying. My other administrator got the sql error too when clicking on "new posts" but not me :/

edit: never mind. Don't forget: Always do the modifications on the right style, lol

@Principe10

big thanks for sorting out my problem.

You'r welcome!

M.

@lasto and @principe10: Can you guys please share how you accomplished this? I've been trying to do it myself, following principe10's instructions and screenshots but I haven't been able to get it to work.

Can you please assist?

Is it possible to take a thumbnail from the first youtube video posted in a thread?

Does anyone have this running where VBSEO is installed, works fine on my little forum, but when my colleague installed it on our bigger forum with VBSEO installed, it didn't work and I would like to install VBSEO in the near future.

Not sure whether it just didn't work, or it created errors, but will try and find out. :)

Hello, how did you intergrate the highslide JS into the attachment thumbnail?

I want to be able to have the image thumbnail as the thread prefix, but the full size image inside the topic. I understand you guys managed that.

It's a mod from here

vBulletin Search Engine Optimisation, a paid package which helps to lift your search engine optimisation.

Thank you ! nice work. Installed :)

Yes, I have been looking to get this working as well. Can you explain what you did to fix it? I want to view the full size images within the threads but still use this mod (which requires the thumbnail function enabled in admincp).

Thanks!

Sorry, I dont' have it.

See U.

M.

Have U installed the Plug-in correctly? What do U see now in your forum? Give me the addess so I can see it.

My forum is here and U can see an example: http://www.forumocchisullanatura.it/...splay.php?f=40

M.

did anyone find out a correct way to eliminate the thumbnail if the thread doens't have thumbnail in it?

Yes, easy.


Here:
<if condition="$show['threadicons']">
<td class="alt2" align="center" valign="middle">
<if condition="$tt_displaythumbs">
<if condition="($thread['attachmentid']) AND ($thread['thumbsize'])">
<a href="showthread.php?$session[sessionurl]t=$thread[threadid]">
<img src="attachment.php?attachmentid=$thread[attachmentid]&stc=1&thumb=1" alt="" border="0" />
</a>
<else />
<img src="$stylevar[imgdir_misc]/nothumb.jpg" alt="" border="0" />
</if>
<else />
<if condition="$show['threadicon']">
<img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />
</if>
</if>
Put:
<img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" />

so U have the normal icon.

M.

Is it at all possible this would work on 3.6.5?

Is it possible to take a thumbnail from the first youtube video posted in a thread?
As youtube has the thumbnails from the videos.
http://img.youtube.com/vi/videoid/default.jpg

Hi guys,
instelled on 3.6.7
VBSEO installed as well.

A few issues:

1- this features:
* If there are attachments that are not images, it will skip them and go to the first image attachment.
* Optional - you can now display thumbnails on search results.
Are not working.

2- the search doesn't show any thumbnail. I mean when the search result it's a thread with thumbnail.

3- a thumbnail created from other images as [IMG] links or Youtube videos, could be very very very very great!

4- Doesn't show the No Thumbs Available picture, even if correctly uploaded in the server.

Thanks in advance.

Steve

This is working fine for me in 3.6.8. :)

Does anyone have any idea how to get the thumbnail to appear in the news module in vbadvanced as well?

Working fine for me to in 3.6.8 but I have a problem.

I want to disable the download attachments for unregistered users, but they get this:



Its possible to show icons only for unregistered user?

Ok, I found the solution here and works:

https://vborg.vbsupport.ru/showpost....&postcount=113

Where do I find the "threadbit template"??

Works perfectly on a 3.68 testforum, I am very glad about this plugin, thank you!

Style & Templates, search in Templates and then just search for "threadbit" and click customize.