vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Poll Survey (https://vborg.vbsupport.ru/showthread.php?t=135223)

taxick 01-01-2007 05:05 PM
I get this SQL error.

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(p.pollid) AS scount
FROM forum_poll AS p
INNER JOIN thread AS t ON (p.pollid = t.pollid)
WHERE t.forumid IN(3, 11, 14, 154, 15, 119, 4, 157, 158, 159, 16, 17, 116, 118, 153, 105, 5, 138, 19, 18, 25, 22, 21, 9, 34, 52, 91, 93, 92, 122, 132, 126, 140, 139, 141, 146, 142, 155, 147, 145, 144, 100, 102, 104, 101, 113, 136, 137, 156, 160, 134, 120, 6, 48, 50, 49, 75, 76, 65, 89, 135, 90, 121, 44, 45, 36, 95, 39, 96, 111)
AND t.visible IN (1);

MySQL Error : Table 'forum.thread' doesn't exist
Error Number : 1146
Date : Monday, January 1st 2007 @ 08:03:58 PM
Script : http://www.*************/misc.php?do=survey
Referrer :
IP Address : *****************
Username : Taxick
Classname : vB_Database

Renee 01-01-2007 06:50 PM
Quote:
Originally Posted by taxick (Post 1148596)
I get this SQL error.
Oh, thank you, I forget two table_prefixes. They're now in :)

taxick 01-01-2007 08:11 PM
Hey :)

I still get the same sql error :( Hope you can fix it :)

FleaBag 01-01-2007 09:31 PM
Great hack thank you!

taxick 01-02-2007 12:30 AM
Now it works..

installed

thank you!

ubblite 01-03-2007 07:38 AM
Does this mod auto-update? For some reason I'm showing polls that have been closed saying "active".

Renee 01-03-2007 10:16 AM
Umpf sorry, I have forget that polls could close by hand :confused:

I will update it later, have to work now :)

ResaleBroker 02-11-2007 03:29 PM
I get this error when trying to view the list as an "Unregistered Guest" without viewing permission:

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(p.pollid) AS scount
FROM poll AS p
INNER JOIN thread AS t ON (p.pollid = t.pollid)
WHERE t.forumid IN()
AND t.visible IN (1);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND t.visible IN (1)' at line 4
Error Number : 1064

WhyDoesItMatter 04-10-2007 05:52 PM
Quote:
Originally Posted by ResaleBroker (Post 1179956)
I get this error when trying to view the list as an "Unregistered Guest" without viewing permission:

Ditto, I came here to check it out. Glad I'm not the only one getting this error.

skorzguy 04-12-2007 05:45 PM
Here is what I did since I needed to make a link so anyone can see what polls are available.

Instead of adding this:

<!-- Poll Survey begin -->
<tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=survey">$vbphrase[survey_all_polls]</a></td></tr>
<!-- Poll Survey end -->

I made a link and pointed to this url:

http://www.allstarchat.com/forum/misc.php?do=survey

** You just need to put your website in the url instead of mine.

** You can still see the page as a guest


All times are GMT. The time now is 02:50 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

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.01381 seconds
  • Memory Usage 1,738KB
  • 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_quote_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