drbowen wrote on Friday, November 24, 2006:
I think there is a bug in the current database.sql. I got the error message on installing a new server:
ERROR 1136 (21S01) at line 26487: Column count doesn’t match value count at row 1
In fact there are 16 fields in table ‘facility’:
DROP TABLE IF EXISTS `facility`;
CREATE TABLE `facility` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`phone` varchar(30) default NULL,
`fax` varchar(30) default NULL,
`street` varchar(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(50) default NULL,
`postal_code` varchar(11) default NULL,
`country_code` varchar(10) default NULL,
`federal_ein` varchar(15) default NULL,
`billing_location` tinyint(1) NOT NULL default ‘0’,
`accepts_assignment` tinyint(1) NOT NULL default ‘0’,
`pos_code` tinyint(4) default NULL,
`x12_sender_id` varchar(25) default NULL,
`attn` varchar(65) default NULL,
`domain_identifier` varchar(60) default NULL,
PRIMARY KEY (`id`)
) ;
But the dump data statement only has 15 fields:
–
– Dumping data for table `facility`
–
/*!40000 ALTER TABLE `facility` DISABLE KEYS */;
INSERT INTO `facility` VALUES (3,‘Your Clinic Name Here’,‘000-000-0000’,’’,’’,’’,’’,’’,’’,0,0,NULL,’’,’’,’’);
/*!40000 ALTER TABLE `facility` ENABLE KEYS */;
Sam Bowen, MD