I just upgraded the quotes from 5.x to 6.x-dev. During the upgrade, I received errors (listed below) but the quotes seem to be working. Except that only about half of the quote shows up in the blocks. The block is set to unlimited length, and I checked the actual content of the quote and it is all there. Is there anything else that might limit the size of a block? I also noticed that in the teaser page of quotes, about the same amount of text is displayed. I checked the contemplates settings, but other than a "print $teaser" field that is NOT activated, there is nothing to indicate what the teaser is or isn't. And, b/c I have TinyMCE on my site, the 'summary' field is not visible (whole different issue).
Here are the errors:
Duplicate column name 'count' query: ALTER TABLE quotes_blocks ADD `count` INT DEFAULT 1 in /home/.../public_html/dev/drupal6/includes/database.mysql-common.inc on line 298.
Duplicate column name 'show_titles' query: ALTER TABLE quotes_blocks ADD `show_titles` INT DEFAULT 0 in /home/mgwynm/public_html/dev/drupal6/includes/database.mysql-common.inc on line 298.
Table 'quotes_authors' already exists query: CREATE TABLE quotes_authors ( `aid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL, `bio` TEXT DEFAULT NULL, PRIMARY KEY (aid), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/.../public_html/dev/drupal6/includes/database.inc on line 514.
Duplicate column name 'aid' query: ALTER TABLE quotes ADD aid INT UNSIGNED NOT NULL AFTER vid in /home/.../public_html/dev/drupal6/update.php on line 69.
and, last but not least, here is the table structure:
--
-- Table structure for table `quotes`
--
CREATE TABLE `quotes` (
`nid` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`aid` int(10) unsigned NOT NULL,
`promote` int(11) NOT NULL,
`citation` varchar(255) default NULL,
PRIMARY KEY (`vid`),
KEY `quotes_nid` (`nid`),
KEY `quotes_promote` (`promote`),
KEY `quotes_aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `quotes_authors`
--
CREATE TABLE `quotes_authors` (
`aid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`bio` text,
PRIMARY KEY (`aid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Table structure for table `quotes_blocks`
--
CREATE TABLE `quotes_blocks` (
`bid` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`block_type` int(11) NOT NULL,
`nid_filter` text NOT NULL,
`rid_filter` text NOT NULL,
`uid_filter` text NOT NULL,
`tid_filter` text NOT NULL,
`cron_interval` int(11) NOT NULL,
`cron_step` int(11) NOT NULL,
`cron_last` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`count` int(11) NOT NULL default '1',
`show_titles` int(11) NOT NULL default '0',
PRIMARY KEY (`bid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Comments
Comment #1
nancydruOkay, I committed a change to bypass those updates if they are already present from a 5.x -> 6.x upgrade.
Comment #2
nancydruYou are correct, the block was using the teaser rather than the body. Fix committed.
Comment #3
mariagwyn commentedIt appears to be working just fine, no work necessary other than upgrading Quotes. Thanks!!!
m
Comment #4
nancydru