Hi, I've been using the quotes module for a while... and when updating to v6 I noticed that a lot if not all of my old quotes don't display in the block. thx

Comments

nancydru’s picture

Are they marked to show in the block? Are you using any other filters? Are you getting any error messages?

czarphanguye’s picture

@NancyDru, Thanks for the reply. Answers: They are marked as "show in block" (as they were working before the v6 update). Any filters? the box filters are set to show my quotes and these issue quotes are authored by me. Errors? Watchdog reports no errors of any sort.

The only thing that displays in the box when this happens is a link to the quotes author's page. See czarism.com and I'll leave the quote box (called Random Quote) running (bottom right) if you want to see first hand.

nancydru’s picture

I can't see a whole lot. All of the correct HTML stuff is there, but not the body. Yet the body displays when I click on view.

czarphanguye’s picture

@NancyDru, exactly... I'm not sure what is needed to report in order to close this bug.

nancydru’s picture

Do you have any theme overrides in place?

czarphanguye’s picture

@NancyDru, None as it's a new upgrade of v6 and the Pixture theme. These issues of missing quotes arouse the same update that author hyperlink (auto find same authors) was added. Then all the past quotes, mainly the ones I mass imported a year ago, quit working and all the newly added ones worked.

Did one of my past updates miss a mysql update? Here's an export...

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-7
-- Generation Time: Jun 27, 2008 at 02:31 AM
-- Server version: 5.0.32
-- PHP Version: 5.2.0-8+etch11
-- --------------------------------------------------------

-- 
-- Table structure for table `quotes`
-- 

CREATE TABLE `quotes` (
  `nid` int(11) NOT NULL default '0',
  `promote` int(11) NOT NULL default '0',
  `vid` int(11) NOT NULL default '0',
  `aid` int(10) unsigned 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=latin1;

-- --------------------------------------------------------

-- 
-- 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=79 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `quotes_blocks`
-- 

CREATE TABLE `quotes_blocks` (
  `bid` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `block_type` int(11) NOT NULL default '0',
  `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 default '0',
  `cron_step` int(11) NOT NULL default '0',
  `cron_last` int(11) NOT NULL default '0',
  `vid` int(11) NOT NULL default '0',
  `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=latin1;

nancydru’s picture

Status: Active » Postponed (maintainer needs more info)

Well, the quotes table is not in the same order as I create it, but MySql should take care of that. However, I do see that "promote" is still "int(11)" in yours, and it is "tinyint(3)" in my database. I don't know how much effect that would have. You might try taking a back up and then changing that field size.

nancydru’s picture

Status: Postponed (maintainer needs more info) » Closed (works as designed)

no response in a long time.