View Single Post
Old 08 Sep 2008, 13:10
TsirhCitna TsirhCitna is offline
Join Date: Jul 2005
Real name: Bob
Originally Posted by J98680B2423E View Post
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):

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

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
Tenstones Gaming Community
Reply With Quote