Add-On Releases - Topic (incl. Blog) of the Week/Fortnight/Month Nomination v1.636

On my board (USS Enterprise, NCC-1701-D), we get many comments daily or weekly on many different topics and there are so many topics in the community that to be honest, we had a tough time remembering the topic being reviewed to offer a timely comment or response. Obviously, we needed a weekly/monthly topic nomination system with which we could get our community to commit to one topic as a group and then comment on it during the course of the week/month.

Cruising vB.org at warp speed, I failed to find a nomination system readily available. Hence, I quickly wrote this mod (on my way to the bridge).

Acknowledgement:
This release would not have been quickly possible without the existence of most hacks released at vB.org, especially the "Thank You" hack by Abe1, which provided this mod basis structure. Our thanks and all the merit goes to Abe1.

A nice set of button and awards images have also been kindly provided by PrinceEdward to whom we also extend our thanks.

Many constructive feedbacks have been given by those members at the vB.org community who downloaded the first releases of this Mod, the implementation of which has led to an improved version of the Mod. We extend our thanks to those members.

What this mod does

It adds a "Topic Of The Week/Month" nomination system to your community.

What is Topic Of The Week/Month?

Topic of the Week/Month is a contest that select posts on which your community can commit to as a group and then comment/discuss on them during the course of the selected week/month. Any listed topic (post, thread) is eligible for the Topic of the Week/Month selection.

What determines a Topic Of The Week/Month?

Topic Of The Week/Month is based on a simple nomination system. Throughout the selected forums, members with adequate permissions can nominate their favorite topic by clicking on the award nomination button below the post.

The five topics with the most votes during the course of the week/month are automatically displayed on a nomination thread including a poll feature. At the end of the week/month, the first three topics with the most votes are the award winners of the contest.

Features:

1. Uses AJAX technology.
2. Uses one query per show thread page
3. Fully phrased to allow (language translation) (addition v 1.3)
4. Places an easy to use "Nominate Post" button next to the edit button
5. Automatically create a nomination thread for discussions on nominees
6. Displays a varying nomination stamps on posts that have been nominated for the contest. The color of the nomination stamps varies depending on how many users have nominated the post. (addition v 1.2)
7. Displays an award winner stamp op award winner posts at the end of the Topic Of The Week/Month contest. (addition v 1.2)
8. Via postbit pop-up, displays link to find all nominations or nominees made by a user (addition v 1.35)
9. Via postbit pop-up, allows selected usergroups (e.g. Moderators or SuperModerators) can withdraw all user?s nominees from all posts (addition v 1.2) or to remove all current nominations on a given user (addition v 1.35)
10. Option to select the maximum number of topics that must be displayed in the poll (addition v 1.2)
11. Option to take or not into account for nomination only posts made during the month preceding the nomination cycle time (addition v 1.2)
12. Option to consider the maximum number of posts a user can nominate per cycle time (addition v 1.2)
13. Nominated posts titles hot linked in the poll to actual thread/post of the forum. Links displaying on the same page (No. popups) (addition v 1.3)
14. Automatically closes the nomination thread at end of the contest cycle time (weekly/monthly)
15. Quick link to nomination thread via the "Quick Navigation" menu
16. Quick link to award winners page via the "Quick Navigation" menu (addition v.1.1)
17. Automatically update the nomination poll whenever a post is nominated or withdraw from the contest.
18. Separate looks for postbit and postbit_legacy
19. Places all post nominees in one small box
20. Displays award winners in one small box
21. Quick link to nomination thread via the "small box" on the thread page
22. Option to allow award winners to re-enter the contest after X days
23. Users cannot nominate the same post twice
24. Option to not allow users to nominate their own post
25. Counts nominees submitted by a user
26. Counts how many times a nominee is submitted
27. Shows how many nominees a user submitted in every post of his
28. Shows info in member's profile
29. Option to search for posts nominated by a user
30. Option to search for all nominated posts
31. Administrator can withdraw all nominees of a single post
32. Selected usergroups (e.g. Moderators or SuperModerators) can withdraw all nominees of a single post (addition v 1.10)
33. Users can withdraw their own nominee
34. Option to disable the mod on selected forums
35. Option to disable the mod on all but the first post of a thread
36. Option to disable the mod on all but the first post of a thread in specific forums
37. Option to enable/disable view of nomination date on specific or all forums
38. Option to add to post count when someone nominate a post.
39. Option to give reputation points to the user whose post is nominated.
40. Option to ban selected usergroups from using the mod
41. Option to ban selected users from using the mod
42. Option to display user?s nomination statistics on postbit (addition v 1.10)
43. Option not to display nomination statistics on postbit for selected users (addition v 1.10)
44. Option not to display nomination statistics on postbit for selected usergroups (addition v 1.50)
45. Option to display or not the hall of fame link in Quick-Links (addition v 1.3)
46. Option to select forums on which nominations must be considered (addition v 1.35)
47. Hall of fame re-designed to handle a Top 10 award winners, all time cumulated (addition v 1.3)
48. Option to refresh the poll thread if for some reason a post referenced in the poll came to be deleted (addition v 1.3)
49. Option to use the current week number or month, or the next week number or month, in the contest title (addition v 1.3)
50. Option for archiving nominations in the "Nomination Thread" automatically whenever a user nominate a post. (addition v 1.35)
51. Option to automatically send a PM to award winners at the end of the contest (addition v 1.4)
52. Option to automatically add points to award winners? reputation at the end of the contest (addition v 1.4)
53. If the current ?Nomination Thread? is deleted for whatever reason, a single manual run of the cron file will suffice to create a new thread, avoiding a clean install of the product.
54. Option to nominate blog entries (addition v 1.6)
55. Option to have award winners or nominated posts icons displayed on posts, so that nominated posts can be easily identified when listing posts.
56. Option to close current nomination thread and create a new one directly from the ACP

Installation instructions

Version 1.63

1. Uncompress the archive
2. Upload the content of the "upload" folder into your forum root directory
3. Import the "product_nominate_topic.xml" product via your ACP:
   ACP -> Plugins & Products -> Manage Product -> Add/Import Product (Allow Overwrite if you are upgrading)
4. Adjust the mod settings as you see fit.
   Specify the Forum ID that will receive nomination threads. Also specify the User ID of the nomination thread owner.
   ACP -> vBulletin Options -> vBulletin Options -> Nominate Topic Mod
5. Save the specified settings
6. ACP -> Scheduled Tasks -> Scheduled Task Manager
   Nominate Weekly Or Monthly Topic Mod -> Run Now

Enjoy

Update in version 1.01
Nominated posts titles hot linked in the poll to actual thread/post of the forum

Update in version 1.1

1. Postbit_legacy fixed
2. Quick link to award winners page via the "Quick Navigation" menu
3. Selected usergroups (e.g. Moderators or SuperModerators) can withdraw all nominees of a single post
4. Option to display user?s nomination statistics on postbit
5. Option not to display nomination statistics on postbit for selected users
6. Small bugs fixed
7. Tested on vB 3.7.0 and vB 3.7.2
8. Working on vB 3.6.8 and above

Update in version 1.2

1. Displays a varying nomination stamps on posts that have been nominated for the contest. The color of the nomination stamps varies depending on how many users have nominated the post. (addition v 1.2)
2. Displays an award winner stamp op award winner posts at the end of the Topic Of The Week/Month contest. (addition v 1.2)
3. Via postbit pop-up, displays link to find all nominations made by a user (addition v 1.2)
4. Via postbit pop-up, allows selected usergroups (e.g. Moderators or SuperModerators) can withdraw all user?s nominees from all posts (addition v 1.2)
5. Option to select the maximum number of topics that must be displayed in the poll (addition v 1.2)
6. Option to take or not into account for nomination only posts made during the month preceding the nomination cycle time (addition v 1.2)
7. Option to consider the maximum number of posts a user can nominate per cycle time (addition v 1.2)

Update in version 1.21

1. Fix for transition to Week 28 on cron file
2. Fix Unknown column error when adding a nomination.
3. Few bugs on withdraw nomination

Feedback are welcome and implementation of constructive suggestions will likely be carried out during weekends only, as I am kept busy with other matters during working days.

Update in version 1.22

1. Fix Duplicate entry issue.
2. Clean cron file
3. Full phrasing for those who wish to translate it.

Update in version 1.3

1. Nominated posts titles hot linked in the poll to actual thread/post of the forum. Links displaying on the same page (No. popups) (addition v 1.3)
2. Option to display or not the hall of fame link in Quick-Links (addition v 1.3)
3. Option to select only one forum on which nominations must be considered (addition v 1.3)
4. Hall of fame re-designed to handle a Top 10 award winners, all time cumulated (addition v 1.3)
5. Option to refresh the poll thread if for some reason a post referenced in the poll came to be deleted (addition v 1.3)
6. Option to use the current week number or month, or the next week number or month, in the contest title (addition v 1.3)
7. Fully phrased to allow language translation (addition v 1.3)
8. Cron file up-to-date

Update in version 1.35

1. Option to select forums on which nominations must be considered
2. Option for archiving nominations in the ?Nomination Thread? automatically.
3. Fortnightly cycle time added
4. Fully phrased to allow language translation (addition v 1.35)
5. Few reported bugs fixed

Update 14/07/2008 in cron file
I noticed that some code instructions fail to work properly depending on the PhP version been used.

If you are running the v 1.35 and TOTW on a weekly basis and if for some reason, your cron file failed to work and create a new nomination thread on Sunday 13, July 2008, please use the attachment "updated-cron-14-07-2008.zip". The instructions are given in there.

Update in version 1.40

1. Option to automatically send a PM to award winners at the end of the contest (addition v 1.4)
2. Option to automatically add points to award winners? reputation at the end of the contest (addition v 1.4)
3. If the current ?Nomination Thread? is deleted for whatever reason, a single manual run of the cron file will suffice to create a new thread, avoiding a clean install of the product.

Update in version 1.50

1. Option not to display nomination statistics on postbit for selected usergroups (addition v 1.50)
2. Few display titles fixed
3. Additions made for users who had problems displaying the nomination button and stamp on their styles. Checkout the "Readme and installation" file.
4. Cron file completely rewritten. Why?
   The previous cron file worked fine only when they were activated manually from the Run button in the Admin CP, but they were failing to run on their own as a scheduled task. I noticed that vbulletin global variables were no longer been passed to the cron file. Why??? I have actually getting the values of vbulletin global variables needed for the cron directly from the database.
   If you noticed that the "Nomination Thread" of the past week did not closed properly, proceed as follow:
   1. Open the cron file (upload/included/cron/
   2. Search for "// $createNewThread = 1;"
   3. Replace it by: "$createNewThread = 1;"
   4. Upload the cron file and run it manually (only once), just to close the previous thread and open a new one.
   5. Upload the original cron file back (the one with "// $createNewThread = 1;")

Update in version 1.51

1. For weekly nominations, Cron file set to create a new "Nomination Thread" every MONDAY's (00:10AM) as the week numbering starts on Monday's and not on Sunday's (as set in v 1.50)

If you are running v 1.50 with weekly cycle time and noticed that a new nomination thread has been created but the display title is still that of the previous thread (week 30), then this is for you. Do not delete the newly created nomination thread (with title week 30). On Monday 21st July, 2008, after 00:10AM, proceed as follow:

1. Refresh your poll from the ACP -> Nominate Topic -> Refresh Poll (This will update the display title of both the poll and the nomination thread)
2. Upload the content of the attachment v 1.51 to your root directory. (DO NOT MANUALLY RUN THE CRON FILE)

Topic of the Week-Month Nomination v1.51 Updated Prod and Cron

1. Automatic PM subject phrase moved from "<phrasetype name="Email Subject Text" fieldname="emailsubject">" to "<phrasetype name="GLOBAL" fieldname="global">"
2. For monthly nominations, Cron file set to create a new "Nomination Thread" every 1st day of the month (00:10AM) and not on the last day of the month.

Topic of the Week-Month Nomination v1.51 Updated function

1. Function updated (see attachment) as a result of exchanges with Kevil via TeamViewer.

Update in version 1.60

1. Option to nominate blog entries (addition v 1.6)
2. Option to have award winners or nominated posts icons displayed on posts, so that nominated posts can be easily identified when listing posts.
3. Option to close current nomination thread and create a new one directly from the ACP (NOT VIA THE CRON)

Update in version 1.61

1. Typing mistake fixed in the "nominate_topic_admin.php". nominate_topic_amount instead of nominated_topic_amount.
2. Fix for "Could not find phrase 'This is an automatic message to inform you that your post ..." message.

Update in version 1.62

1. Typing mistake fixed in the "nominate_topic_admin.php". nominate_topic_amount instead of nominated_topic_amount.
2. Fix for http:"//... occurring in the poll while listing blog entries.
3. Display of nomination stamps while listing blog entries from the blog.
4. Fix for displaying of blog entries in poll when a post is nominated from the non blog board.

Update in version 1.621

1. Fixed "Parse error: syntax error, unexpected '}' in /includes/cron/nominate_topic_cron.php on line 584"
2. Fixed ": syntax error, unexpected T_STRING in /home/nascartr/public_html/community/admincp/nominate_topic_admin.php on line 435"

Update in version 1.63

1. Fixed link call, requested by TsirhCitna
2. Fixed "Hall of fame" display.

Update in version 1.635

1. Bug Fix by vbboarder implemented ? ?can?t find phrase? error in PM subject

Update in version 1.636

1. Default value for "cycle time header" set to use the current cycle time (current week/fortnight/month instead of next week/fortnight)
2. Option to nominate own post activated by default.

Feedback are welcome and implementation of constructive suggestions will likely be carried out during weekends only, as I am kept busy with other matters during working days. Also, feel free to add improvements in those files and post them.

To other coders: feel free to add improvements to the Mod (files) and post them. I will directly use your updated files for the next version of the mod.

[Hannan]

The error is still there!

Warning: implode() [function.implode]: Invalid arguments passed in [path]\includes\functions_nominate_topic.php on line 567

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET nominate_topic_user_amount = nominate_topic_user_amount - 1 WHERE userid IN ();

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 ')' at line 1
Error Number : 1064
Request Date : Tuesday, July 8th 2008 @ 01:37:56 AM
Error Date : Tuesday, July 8th 2008 @ 01:37:56 AM
Script : http://forum.persiandown.com/nominat...e_all&p=172461
Referrer : http://forum.persiandown.com/showthread.php?p=172461
IP Address : xxxxx
Username : Hannan
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt

Thanks for responding fast

[soletrader]

Originally Posted by soletrader

Can you please explain where I can find this and what line I need to fix? Love the hack btw... thanks!

Originally Posted by J98680B2423E

$vbulletin->templatecache['your_template_hook'] = str_replace("your_location", "your_location".$vbulletin->templatecache['nominate_topic_button'], $vbulletin->templatecache['your_template_hook']);

Any help with this is appreciated. Thank you.

[Artes_Marciales]

Uninstalled
When the version be improved I will install it,
But right now there are too many errors... : (

[tekguru]

This was working well but now that my team / users are starting to use the Mod we are gettign errors like:

PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('32','10','1215502754','4','0');

MySQL Error   : Duplicate entry '32-10-0' for key 2
Error Number  : 1062
Request Date  : Tuesday, July 8th 2008 @ 08:39:14 AM
Error Date    : Tuesday, July 8th 2008 @ 08:39:14 AM
Script        : http://www.4winmobile.com/forums/nominate_topic.php?do=nominate_topic_add&p=188812&securitytoken=1215501110-9dc08c878ed8d2682274ca2ad0f152cd85314268
Referrer      : http://www.4winmobile.com/forums/4wm-news/16710-winterface-cool-fresh-breeze-world-windows-mobile-interface.html
IP Address    : 86.139.133.53
Username      : neilm
Classname     : vB_Database 


The poll seems to be updated okay but if these continue I'm tempted to turn it off for the moment as uses get scared by such errors.

Any ideas?

[J98680Bxxxxx]

Originally Posted by TimberFloorAu

Okies.

Followed full instructions, and upgraded to v 1.22

Week 29 looks ok at the moment.

In the process of uninstall and reinstall etc and the hiccups, all data and votes for week 28 are dead and gone.

Shame as our members will feel slightly concerned f their votes are pissing in th wind.

For testing purposes may I please make a suggestion !

Allow a 1 hr test version for this.

Whereby we can condense a totw to a toth , for testing purposes, to see if everything is propogating properly.

Then reset to totw afterwards, and delete any corresponding threads. This would mean that new totw would have to overwrite the week field, as this would have already been crunched by test week.

Do you know what I mean?

1. duplicate entry into week 28/29 now seems to be fixed.
2. all previous weeks entries and voting has disappeared. ( hence a test acct ) as 150 votes, on varying threads etc, over the course of a week, only to be lost in upgrade etc, is gonna piss so many ppl off, and lose the board credibility.

Regards Ozzy

Have tested it a daily cron and the transition seems to work well.

Good suggestion TimberFloorAu. Will proceed as suggested with the cron hourly test later today.

The previous week entries were damaged during the transition Sunday/Monday.

Originally Posted by StonePilot

I would like to see a feature that allows for only one forum's posts be able to be nominated, it's a bit of work to have to disable every single forum except for the one that I want. Plus I have to remember to disable all new forums that are created.

Will add it in the next version. :up:

Originally Posted by smirkley

Just an update, I am close to having a completed poll module created for use with CMPS.

Still a little testing needed, but so far it works.

I think it will just take a new module upload, and maybe a couple of the cmps poll template tweaks for esthetic purposes.

(and voted this hack here, as mod of the month )

Well done there on the CMPS. Keep us posted.

Originally Posted by TsirhCitna

I fixed my week 28 with a few simple MySQL edits.

I'm not sure where I fix the link to the week 29 poll though or this: Award Winner, Topic Of The Week 01, December, 1969

To fix the link to the week 29 poll, edit the table "nominate_topic_thread". It contains one entry with values (postid, threadid, pollid) for the current nomination thread. But, it's better to do a clean install.

Originally Posted by smirkley

Followup, and bug report I think,..

It seems in testing that nominated posts displayed do not necessarily follow forum permissions by member group.

IE,...

If a nominated forum for some reason ends up in the trash bin or moved to a private or staff forum, the forum title as well as the votes still display publically on the totm poll topic.

Can "follow forum/member group permissions" be a feature added in the future for topics moved later to forums where member groups have no permissions? (I know you can specify which forums to allow/deny in the acp, but it would make sense to filter by member group permission masks also)

Have tested it and saw that vBulletin automatically handles forum permissions. The user following a link through the poll will receive a message telling him/her that "...he/she do not have permission to access this page. This could be due to one of several reasons:..."

Don't know how it's done on the CMPS side. Keep us posted

Originally Posted by Hannan

The error is still there!


Thanks for responding fast

Please describe the steps that you are following so that I can replicate them on my side.

(All steps of the installation done? Cron file manually run at the first installation?)

Originally Posted by soletrader

Does anyone know how to move the nominate button from next to the edit button to somewhere else? Thanks

Originally Posted by soletrader

Any help with this is appreciated. Thank you.

1. First, you must locate the "template hook" that you wish to use for the "nominate button". Let's call it "yourtemplatehook".
2. Secondly, find the location within that template, where you wish to have the "nominate button" displayed. This location will be in between pieces of existing html code. Let's say preceeded by "prevHTMLLocationCode". Ensure that this piece of html code is unique (appears only once) in that template.
3. Thirdly, open the product file "product-nominate_topic.xml" using WordPad for example and do the following:

1. Scroll down until you reach the plugins section
2. In the "global_setup_complete" plugin, add this line just after the "<![CDATA[":
$vbulletin->templatecache['yourtemplatehook'] = str_replace("prevHTMLLocationCode", "prevHTMLLocationCode".$vbulletin->templatecache['nominate_topic_button'], $vbulletin->templatecache['yourtemplatehook']);

3. In the "postbit_display_complete" plugin, change this line:

eval('$template_hook[postbit_controls] .= " ' . fetch_template('nominate_topic_button') . '";');

with:

eval('$template_hook[yourtemplatehook] .= " ' . fetch_template('nominate_topic_button') . '";');

--

That should do it.

Originally Posted by tekguru

This was working well but now that my team / users are starting to use the Mod we are gettign errors like:

PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('32','10','1215502754','4','0');

MySQL Error   : Duplicate entry '32-10-0' for key 2
Error Number  : 1062
Request Date  : Tuesday, July 8th 2008 @ 08:39:14 AM
Error Date    : Tuesday, July 8th 2008 @ 08:39:14 AM
Script        : http://www.4winmobile.com/forums/nominate_topic.php?do=nominate_topic_add&p=188812&securitytoken=1215501110-9dc08c878ed8d2682274ca2ad0f152cd85314268
Referrer      : http://www.4winmobile.com/forums/4wm-news/16710-winterface-cool-fresh-breeze-world-windows-mobile-interface.html
IP Address    : 86.139.133.53
Username      : neilm
Classname     : vB_Database 


The poll seems to be updated okay but if these continue I'm tempted to turn it off for the moment as uses get scared by such errors.

Any ideas?

Fixed yesterday with version 1.22.

Open the v 1.22 attachment and upload the file located in "upload/includes/functions_nominate_topic.php" to the corresponding location on your site.

[tekguru]

Weird I had thought I was already running 1.22......

Have also imported the product again. Do I need to uplaod the rest of the files again as well?

[tekguru]

Still getting:

PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('32','2','1215514729','6','0');

MySQL Error   : Duplicate entry '32-2-0' for key 2
Error Number  : 1062
Request Date  : Tuesday, July 8th 2008 @ 11:58:49 AM
Error Date    : Tuesday, July 8th 2008 @ 11:58:50 AM
Script        : http://www.4winmobile.com/forums/nominate_topic.php?do=nominate_topic_add&p=188842&securitytoken=1215514535-f4d5b334a5e5b51c957c2bc04eba1ddc7990ca2c
Referrer      : http://www.4winmobile.com/forums/windows-chat-xp-mce2004-2005-vista/16712-rocketdock.html
IP Address    : 78.86.46.67
Username      : windows
Classname     : vB_Database
MySQL Version : 5.0.51a-community 


Looks like I will have to disable it, this is with running v1.22....

[J98680Bxxxxx]

Originally Posted by tekguru

Still getting:

PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('32','2','1215514729','6','0');

MySQL Error   : Duplicate entry '32-2-0' for key 2
Error Number  : 1062
Request Date  : Tuesday, July 8th 2008 @ 11:58:49 AM
Error Date    : Tuesday, July 8th 2008 @ 11:58:50 AM
Script        : http://www.4winmobile.com/forums/nominate_topic.php?do=nominate_topic_add&p=188842&securitytoken=1215514535-f4d5b334a5e5b51c957c2bc04eba1ddc7990ca2c
Referrer      : http://www.4winmobile.com/forums/windows-chat-xp-mce2004-2005-vista/16712-rocketdock.html
IP Address    : 78.86.46.67
Username      : windows
Classname     : vB_Database
MySQL Version : 5.0.51a-community 


Looks like I will have to disable it, this is with running v1.22....

The following edit was made in "functions_nominate_topic.php" on v 1.22 to prevent that error:

if ($vote_option > 0){
	$get_pollvote = $vbulletin->db->query_read("SELECT * FROM ". TABLE_PREFIX ."pollvote WHERE userid = '$user_id' AND pollid = '$poll_id' AND voteoption = '$vote_option' AND votetype ='$vote_option'");
	$nb_pollvote = $vbulletin->db->num_rows($get_pollvote);
	if ($nb_pollvote == 0){
		$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('$poll_id','$user_id','$now','$vote_option','$vote_option')");
	}
}

From your report:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_pollvote (pollid,userid,votedate,voteoption,votetype) VALUES ('32','2','1215514729','6','0');

$vote_option = 6, the same value is assigned to 'votetype' in the "functions_nominate_topic.php" up-to-date file, see code above, and not '0' as shown on your feedback above, hence this error will not occur if you have the file "functions_nominate_topic.php" not up-to-date.

Redownload the attachment and upload the "functions_nominate_topic.php".

[princeedward]

Bro...need help too...on this...
after update got also this error when i click nominate button at my postbit_legacy setting

note: Tried also Clean Install (delete thread and upload all new files same as product...) but still no luck!

new functions_nominate_topic.php 3X test to upload


Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM pollvote WHERE userid = '1' AND pollid = '30' AND voteoption = '1' AND votetype ='1';

MySQL Error  : Unknown column 'votetype' in 'where clause'
Error Number : 1054
Date         : Tuesday, July 8th 2008 @ 12:44:13 PM
Script       : http://mysite.com/nominate_topic.php...securitytoken=
Referrer     : http://mysite.com/showthread.php?p=6782
IP Address   : XX.XXX.XXX
Username     : princeedward
Classname    : vB_Database

but you can see the nominated topic to poll thread

+++++++++++++++++++++

got (3) of this also:


Withdraw All Nominations < not working to poll
Withdraw All Nominations < not working to poll
Withdraw Your Nomination < working good

thanks and best regards...

[esperone]

i keep getting this database error when trying to withdraw nominations as wee as trying to view all nominations:

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT userid, username, usertitle, nominate_topic_user_amount, nominate_topic_nominated_posts, nominate_topic_nominated_times, nominate_topic_nominated_awards FROM user WHERE nominate_topic_nominated_awards > 0 ORDER BY nominate_topic_nominated_awards DESC LIMIT 0,2;

MySQL Error   : Unknown column 'nominate_topic_nominated_awards' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, July 8th 2008 @ 09:15:18 AM
Error Date    : Tuesday, July 8th 2008 @ 09:15:18 AM
Script        : http://mydomain.net/forums/nominate_topic.php?do=shownominationawardswinners
Referrer      : http://mydomain.net/forums/passwords/491-biggest-list-more-than-10000-passes.html
IP Address    : removed
Username      : admin
Classname     : vB_Database
MySQL Version : 4.1.22-standard

anyone else having this problem and know how to fix this?