vb.org Archive - vBulletin Forum Sideblocks - Show Poll In Forum Sideblock

Page 5 of 18

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - vBulletin Forum Sideblocks - Show Poll In Forum Sideblock (https://vborg.vbsupport.ru/showthread.php?t=266481)

wildheart

07-13-2011 04:16 PM

No, we are working to get it right, I really appreciate your help especially because I am still so much in the dark. Do you suggest I undo everything and try again?

cherylferraro

07-16-2011 05:32 PM

Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:

Code:

Database error in vBulletin 4.1.4:



Invalid SQL:

SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum 

LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;



MySQL Error   : Unknown column 'forum.forumid' in 'field list'

Error Number  : 1054

Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM

Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM

Script        : http://www.mysite.com/forum/

Referrer      : http://www.mysite.com/forum/

IP Address    : *

Username      : me

Classname     : vB_Database

MySQL Version : 5.1.56

Badshah93

07-17-2011 04:19 AM

1 Attachment(s)

Quote:

Originally Posted by cherylferraro (Post 2221261)

Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:

Code:

Database error in vBulletin 4.1.4:



Invalid SQL:

SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum 

LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;



MySQL Error   : Unknown column 'forum.forumid' in 'field list'

Error Number  : 1054

Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM

Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM

Script        : http://www.mysite.com/forum/

Referrer      : http://www.mysite.com/forum/

IP Address    : 98.164.244.76

Username      : me

Classname     : vB_Database

MySQL Version : 5.1.56

try this xml

AttalaEA

07-18-2011 05:51 PM

Thank you so much :)

AttalaEA

07-18-2011 06:03 PM

How can I change poll title to anything else in the sideblock same vbulletin.

Badshah93

07-18-2011 06:26 PM

Quote:

Originally Posted by AttalaEA (Post 2222071)

How can I change poll title to anything else in the sideblock same vbulletin.

Edit this phrase

Code:

sideblock_poll_title

AttalaEA

07-18-2011 06:31 PM

Quote:

Originally Posted by Sherif (Post 2222077)

Edit this phrase

Code:

sideblock_poll_title

Thank You Sherif. This works great. :)

Trek	07-18-2011 09:00 PM

I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

Badshah93

07-19-2011 05:46 AM

1 Attachment(s)

Quote:

Originally Posted by Trek (Post 2222123)

I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

uninstall the product and delete all poll sideblock forum block manager. then install this new xml.

i tested this mod on a forum with table prefix, its working fine there hopefully it will be for u also.

mjp1111

07-19-2011 06:16 AM

Can I show a poll from multiple or all forums if I separate with a comma or do something else?

All times are GMT. The time now is 08:02 AM.

Page 5 of 18

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01271 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 (4)bbcode_code_printable (4)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
Messages: