Skip to:

Opened 9 years ago

Closed 9 years ago

Last modified 8 years ago

#930 closed defect (fixed)

tags import/upgrade not working

Reported by: zappoman Owned by:
Milestone: 1.0 Priority: high
Severity: major Version: 1.0-rc-2
Component: API - Installation/Upgrade Keywords: tags upgrade taxonomy


When upgrading to 1.0-alpha the system attempts to convert old style tags into the new term_taxonomy structure.

This appears to fail due to a required "description" column, that is not set in the import process.

This appears to be an issue in both alpha and the current trunk.

Details: The function function bb_upgrade_1080() around line 881 of upgrade-functions.php has the following code...

$bbdb->insert( $bbdb->term_taxonomy, array(
		'term_id' => $term_id,
		'taxonomy' => 'bb_topic_tag'
) );

This insert will fail be cause bb_term_taxonomy is created with a description field that is NOT NULL. As indicated by the code around line 101 of upgrade-schema.php

// term_taxonomy
$bb_queries['term_taxonomy'] = "CREATE TABLE IF NOT EXISTS `$bbdb->term_taxonomy` (
	`term_taxonomy_id` bigint(20) NOT NULL auto_increment,
	`term_id` bigint(20) NOT NULL default 0,
	`taxonomy` varchar(32) NOT NULL default '',
	`description` longtext NOT NULL,
	`parent` bigint(20) NOT NULL default 0,
	`count` bigint(20) NOT NULL default 0,
	PRIMARY KEY (`term_taxonomy_id`),
	UNIQUE KEY `term_id_taxonomy` (`term_id`, `taxonomy`)

Change History (3)

#1 @zappoman
9 years ago

  • Component changed from Administration to Installation/Upgrade

#2 @sambauers
9 years ago

  • Resolution set to fixed
  • Status changed from new to closed

(In [1688]) Add an empty description when upgrading tags to taxonomy system. Fixes #930

#3 @sambauers
8 years ago

  • Milestone set to 1.0
Note: See TracTickets for help on using tickets.