Admin Voting mod

Posted: Mon Mar 22, 2010 9:34 am

Anyone have this mod working in the latest RN? Recieving error message after install of this:

Could not query vote results.

DEBUG MODE

SQL Error : 1054 Unknown column 'vote_cast' in 'field list'

SELECT vote_id, vote_user_id, vote_cast FROM nuke_bbvote_voters ORDER BY vote_id

Line : 209
File : admin_voting.php

The following is from the admin_voting.php file in that area:

// Assign individual vote results
$sql = "SELECT vote_id, vote_user_id, vote_cast" .
" FROM ". VOTE_USERS_TABLE .
" ORDER BY vote_id";

if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query vote results.', '', __LINE__, __FILE__, $sql);
}

Am attempting to add this to a test site before adding it to the main site for someone who wants to track the voting process to make sure all are actually voting. Yes it will be added to the legal area that this mod is being used. Any help would be appreciated..... Smile

Posted: Mon Mar 22, 2010 10:12 am

Disregard this post. Got it to work. Had to manually add the table for it. The mod I downloaded for phpnuke did not come with anything stating that you had to create this table for it to work. The regular phpbb hack has a php file you run to create this table. I just took the table information and created the table manually. Seems to work at the moment..... Smile