[J98680Bxxxxx]

Originally Posted by 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...

Check using phpMyAdmin if the "pollvote" table is defined in vB 3.6.8 as such:

vBulletin Table: pollvote
pollvoteid int(10) UNSIGNED No auto_increment
pollid int(10) UNSIGNED No 0
userid int(10) UNSIGNED Yes NULL
votedate int(10) UNSIGNED No 0
voteoption int(10) UNSIGNED No 0
votetype int(10) UNSIGNED No 0

Let me know if the pollvote table is defined with these fields in vB 3.6.8.

Originally Posted by 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?

Have you done the installation properly?

After a proper installation, the following columns must be present in the user table:

nominate_topic_user_amount, nominate_topic_nominated_posts, nominate_topic_nominated_times, nominate_topic_nominated_awards

An Unknown column 'nominate_topic_nominated_awards' in 'field list' indicates that the installation was not done properly.

Originally Posted by TsirhCitna

I did do a clean install. I fixed the link issue, now where do I enter the timestamp? I tried nominate_topic, but it still says 1969

You can use the submission time as timestamp when a nomination is submitted:

$timestamp = TIMENOW;

Or

$timestamp = time();

Originally Posted by smirkley

The problem I have with the member group permission masks is basically with the totm poll topic created by the modification, not with cmps.

A scenario if you will,...

1 - totm topic created by cron for the month, as expected by proper operation.

2 - someone nominates a topic that lets say is just spam. (dont ask me why, just assume it happens)

3 - staffer sends nominated topic to trash bin or staff forums for some reason, but basically nominated topic gets taken out of public or normal member view.

4 - guest/member views totm topic with poll results, and "hidden" topic that is now normally unavailable (yes vb will block access of course by permission masks), but the topic title still shows for all to see.

Basically I was wondering if the modification that generates the poll and displays, can be made to utilize the vb member group permission masks to filter topic titles (as well as links) to the nominatedpolls links. I know I am asking for coverage of a fairly rare condition, but there are occasions where the title ought not be publically displayed for the community benefit. I just am looking for an automated functionality to member group permission mask topic title filtering, to prevent from having to adjust the poll choices manually in the event it is necessary.

Was thinking that the permission masks for vb ought to be utilized whilst generating the view of the totm topic poll, or at least the topic list in the poll may be refreshed using permission masks on the next cron job.

Hope that helps.


(but this is unrelated to my cmps integration efforts fyi)

Thanks again

Understood. Will update the modules that generate the poll results accordingly. Thanks for the feedback. :up:

Originally Posted by tekguru

I have redownloaded v1.22 and I have instide the file:

PHP Code:

                //$vote_option = array_search($post_id, $arrayPostID);
                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')");
                    }
                } 


Is this correct or not? If not then the archive needs updating?

Yes it is the correct file.

Originally Posted by tekguru

The other problem I'm seeing is that originally I limited poll answers to 5 in the vote, I later increased this to 9, but I still get:

'Remanining nominations cummulated... ' and if any more nomionations are made the number of lines in the poll does not increase, as per the attached.

Will check this, as it is supposed to handle it automatically. Thanks for the feedback. :up:

Originally Posted by MissKalunji

There are so many posts that i bet you didn't see mine

Thanks for all of your help

Hi MissKalunji, it was answered here.

Originally Posted by Cybertims

Still no nominate button ever shows up for me.....

Send me a link to your site by PM, if possible.