Hi Mark,
Thanks for replying so quickly. I hope I have what you need:
--
-- Table structure for table `jos_bib`
--
DROP TABLE IF EXISTS `jos_bib`;
CREATE TABLE `jos_bib` (
`type` varchar(255) default NULL,
`address` varchar(255) default NULL,
`annote` text,
`authorid` int(11) NOT NULL auto_increment,
`booktitle` varchar(255) default NULL,
`chapter` varchar(255) default NULL,
`edition` varchar(255) default NULL,
`editor` varchar(255) default NULL,
`eprint` varchar(255) default NULL,
`howpublished` varchar(255) default NULL,
`institution` varchar(255) default NULL,
`journal` varchar(255) default NULL,
`key` varchar(255) default NULL,
`month` varchar(255) default NULL,
`note` varchar(255) default NULL,
`number` varchar(255) default NULL,
`organization` varchar(255) default NULL,
`pages` varchar(255) default NULL,
`publisher` varchar(255) default NULL,
`school` varchar(255) default NULL,
`series` varchar(255) default NULL,
`title` text,
`volume` varchar(255) default NULL,
`year` varchar(255) default NULL,
`cite` varchar(255) default NULL,
`url` text,
`keywords` text,
`abstract` text,
`authorsnames` text,
`shortauthnames` varchar(255) default NULL,
`checkedout` int(11) default '0',
PRIMARY KEY (`authorid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_bib`
--
LOCK TABLES `jos_bib` WRITE;
/*!40000 ALTER TABLE `jos_bib` DISABLE KEYS */;
INSERT INTO `jos_bib` (`type`, `address`, `annote`, `authorid`, `booktitle`, `chapter`, `edition`, `editor`, `eprint`, `howpublished`, `institution`, `journal`, `key`, `month`, `note`, `number`, `organization`, `pages`, `publisher`, `school`, `series`, `title`, `volume`, `year`, `cite`, `url`, `keywords`, `abstract`, `authorsnames`, `shortauthnames`, `checkedout`) VALUES (NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'George Ronald',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'An introduction to Shii Islam',NULL,'1985',NULL,'http://www.amazon.com/dp/0300035314?tag=httpbahainet-20',NULL,'The history and doctrines of Twelver Islam.',' Moojan Momen',' Moojan Momen',0);
/*!40000 ALTER TABLE `jos_bib` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_bib_auth`
--
DROP TABLE IF EXISTS `jos_bib_auth`;
CREATE TABLE `jos_bib_auth` (
`id` int(11) default NULL,
`num` int(11) default NULL,
`first` varchar(255) default NULL,
`von` varchar(255) default NULL,
`last` varchar(255) default NULL,
`jr` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_bib_auth`
--
LOCK TABLES `jos_bib_auth` WRITE;
/*!40000 ALTER TABLE `jos_bib_auth` DISABLE KEYS */;
INSERT INTO `jos_bib_auth` (`id`, `num`, `first`, `von`, `last`, `jr`) VALUES (2,1,'Moojan','','Momen','');
/*!40000 ALTER TABLE `jos_bib_auth` ENABLE KEYS */;
UNLOCK TABLES;
We had about 4 entries in the bibliography and tried removing them one at a time to find the one that might be causing the problem. We're using the bibliography to list books rather than journal articles, as you can probably tell. The problem existed before I modified the PHP to change the column heading from "Journal" to "Publisher" and to get rid of the italics in the entries.
cheers
Steve
