[TsirhCitna]

Originally Posted by J98680B2423E

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.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'ALTER TABLE `vb3_blog` ADD `nominate_topic_amount` INT( 10 ) UNSIGNED DEFAULT '0' at line 2