OBBLM league structure question

[Daikaiju]

Ah, I think its not linked to upgrades, but you needed to update before the initial install.

You'll need to either run it by hand or reinstall I'm afraid (if you put the new install in a new DB you could copy any content over).

Code: Select all

	return array(
        # Table name => column definitions
        'conferences' => array(
            # Column name => column definition
				'conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL PRIMARY KEY AUTO_INCREMENT',
				'f_tour_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
				'name'          => $CT_cols['name'],
				'type'          => 'TINYINT UNSIGNED',
				'date_created'  => 'DATETIME',
        ),
        'conference_teams' => array(
			'f_conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
	        'f_team_id'      => $CT_cols[T_OBJ_TEAM].' NOT NULL ',
			'PRIMARY KEY'  => '(f_conf_id,f_team_id)',
        ),
    );

Arg... So close! How do I "Run it by hand?" I am not sure how to do that.

I have just turned on the Conf module turned on and it's showing up in the list, but it isn't in the database.

Thanks,

Daikaiju

[dsavillian]

Ah, I think its not linked to upgrades, but you needed to update before the initial install.

You'll need to either run it by hand or reinstall I'm afraid (if you put the new install in a new DB you could copy any content over).

Code: Select all

	return array(
        # Table name => column definitions
        'conferences' => array(
            # Column name => column definition
				'conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL PRIMARY KEY AUTO_INCREMENT',
				'f_tour_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
				'name'          => $CT_cols['name'],
				'type'          => 'TINYINT UNSIGNED',
				'date_created'  => 'DATETIME',
        ),
        'conference_teams' => array(
			'f_conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
	        'f_team_id'      => $CT_cols[T_OBJ_TEAM].' NOT NULL ',
			'PRIMARY KEY'  => '(f_conf_id,f_team_id)',
        ),
    );

Arg... So close! How do I "Run it by hand?" I am not sure how to do that.

I have just turned on the Conf module turned on and it's showing up in the list, but it isn't in the database.

Thanks,

Daikaiju

Well, with some remote debugging and my slugging through PHP and MySql (I'm a C# and MS SQL guy!) we were able to get this working.

If anyone needs help with it in the future I can probably write up a little guide

[nicholasmr]

Ah, I think its not linked to upgrades, but you needed to update before the initial install.

You'll need to either run it by hand or reinstall I'm afraid (if you put the new install in a new DB you could copy any content over).

Code: Select all

	return array(
        # Table name => column definitions
        'conferences' => array(
            # Column name => column definition
				'conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL PRIMARY KEY AUTO_INCREMENT',
				'f_tour_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
				'name'          => $CT_cols['name'],
				'type'          => 'TINYINT UNSIGNED',
				'date_created'  => 'DATETIME',
        ),
        'conference_teams' => array(
			'f_conf_id'       => $CT_cols[T_NODE_TOURNAMENT].' NOT NULL ',
	        'f_team_id'      => $CT_cols[T_OBJ_TEAM].' NOT NULL ',
			'PRIMARY KEY'  => '(f_conf_id,f_team_id)',
        ),
    );

Arg... So close! How do I "Run it by hand?" I am not sure how to do that.

I have just turned on the Conf module turned on and it's showing up in the list, but it isn't in the database.

Thanks,

Daikaiju

Well, with some remote debugging and my slugging through PHP and MySql (I'm a C# and MS SQL guy!) we were able to get this working.

If anyone needs help with it in the future I can probably write up a little guide

Please do and add you solution in your first (original) post, this might be of use to people.

Nicholas.