1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL Tables Error

Discussion in 'Databases' started by 7up407, Jul 27, 2006.

  1. #1
    I added a mod that adds more colored ranks to groups, Index.php, and Viewonline.php. All went well untill i had to add the SQL tables to my data base. This is the erros i got, can anyone tell me what i'm doing wrong or what i need to do.

    "Duplicate column name 'user_whosonline_color' "

    I'm not exsactly sure what that means.


    These are the SQL codes i am suppose to run.


    Code:
    #-----[ SQL ]------------------------------------------
    #
    CREATE TABLE `phpbb_whosonline_ranks` (
    `whosonline_rank_id` tinyint(4) NOT NULL auto_increment,
    `whosonline_rank_name` varchar(50) NOT NULL default '',
    `whosonline_rank_color` varchar(9) NOT NULL default '',
    `whosonline_lang_key` smallint(1) unsigned NOT NULL default '0',
    `whosonline_rank_order` int(11) NOT NULL default '0',
    PRIMARY KEY (`whosonline_rank_id`)
    ) TYPE=MyISAM AUTO_INCREMENT=20 ;

    #
    #-----[ SQL ]------------------------------------------
    #
    INSERT INTO `phpbb_whosonline_ranks` VALUES (1, 'Test', 'red', 0, 10);

    #
    #-----[ SQL ]------------------------------------------
    #

    ALTER TABLE phpbb_users ADD user_whosonline_color int(11) DEFAULT '0' NOT NULL;

    #
    #-----[ SQL ]------------------------------------------
    #

    ALTER TABLE `phpbb_groups` ADD `group_color` smallint(8) DEFAULT '0' NOT NULL ;

    #
    #-----[ SQL ]------------------------------------------
    #

    INSERT INTO `phpbb_config` VALUES ('allow_group_index', '0');

    #
     
    7up407, Jul 27, 2006 IP