[mtha]

Originally Posted by ChrisBaktis

I got a message 'effected rows: 0'

I used the vbulletin admin cp to run it. would I have gotten an error or message if it didnt take?

It seems that you was able to create the database. Check database structure in phpMyAdmin to see if you have that table created?

Is there any different from the query you ran and the one in the installation file?

Or if you are the only one who get this error, I just have you to create the tables manually.

Execute the following queries: (if you run in AdminCP, you need to run each of them individually)

[sql]
DROP TABLE IF EXISTS `award`;
[/sql]
[sql]
CREATE TABLE `award` (
`award_id` smallint(5) unsigned NOT NULL auto_increment,
`award_cat_id` smallint(5) NOT NULL default '1',
`award_name` varchar(50) NOT NULL default '',
`award_desc` varchar(250) NOT NULL default '',
`award_icon_url` varchar(250) NOT NULL default '',
`award_img_url` varchar(225) NOT NULL default '',
`award_displayorder` smallint(5) NOT NULL default '0',
PRIMARY KEY (`award_id`)
) TYPE=MyISAM;
[/sql]
[sql]DROP TABLE IF EXISTS `award_user`;[/sql]
[sql]CREATE TABLE `award_user` (
`issue_id` smallint(5) NOT NULL auto_increment,
`award_id` smallint(5) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(10) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;
[/sql]

and then go to the next step:
/admincp/awards_install.php?step=dofileedits


You may also create the award_cat table, for future development:
[sql]
REMOVED
[/sql]