[J98680Bxxxxx]

My apologies for the late reply in supporting you Guys/Gals. My Internet land connection went off last Saturday and I was in the dark ages until now. I have managed to get back online via a satelite connection.

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.

Originally Posted by TsirhCitna

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb3_nominate_topic WHERE postid = '408696' AND userid = '4' AND is_blog = '0';

MySQL Error : Unknown column 'is_blog' in 'where clause'
Error Number : 1054
Request Date : Saturday, September 6th 2008 @ 05:43:50 PM
Error Date : Saturday, September 6th 2008 @ 05:43:51 PM
Script : http://www.tenstones.net/forums/nominate_topic.php

Also, refreshing the poll no longer makes the urls parse with vBSEO. Before I was refreshing them after any votes because this format doesn't work:

http://www.tenstones.net/forums/showthread.php?t=408696

Similar issue fixed with Magz.

Ensure that the column is_blog has been created in the table nominate_topic when you imported the product. If it has not been created, you will have to do it manually either via phpmyadmin or via ACP -> Maintenance -> Execute SQL Query. Here are the instructions (same as specified in the product file):

ALTER TABLE `TABLE_PREFIX_nominate_topic` ADD `is_blog` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `TABLE_PREFIX_blog` ADD `nominate_topic_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `TABLE_PREFIX_blog` ADD `nominate_topic_award` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `TABLE_PREFIX_blog` ADD `nominate_topic_award_rank` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL

Of course, you must replace the TABLE_PREFIX by your actual table prefix. If your table prefix is magician for example, then you must use the instructions:

ALTER TABLE `magician_nominate_topic` ADD `is_blog` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL
etc...

I don?t understand why vbulletin is not executing those instructions directly via the product file on some servers.

Originally Posted by TsirhCitna

Another error:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT postid, threadid FROM vb3_post WHERE visible = '1' AND nominated_topic_amount > 0 AND nominate_topic_award = '0';

MySQL Error : Unknown column 'nominated_topic_amount' in 'where clause'
Error Number : 1054
Request Date : Saturday, September 6th 2008 @ 05:52:10 PM
Error Date : Saturday, September 6th 2008 @ 05:52:10 PM
Script : http://www.tenstones.net/forums/admi...atedpostsicons

Typing error fixed in the nominate_topic_admin.php
nominate_topic_amount instead of nominated_topic_amount

Get v1.61

Originally Posted by pnosko31

HOW DO WE FIX
Could not find phrase 'This is an automatic message to inform you that your post on [post={1}]{2}[/post] is amongst the winners of this cycle time topic nomination contest.'.

Phrases on "nominate_topic_awardwinner_pm" moved from "Email Body Text" to GLOBAL phrase type in v1.61. This fix this "Could not find phrase" issue.