CVS OpenEMR-2.8.2-dev bug

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

drbowen wrote on Friday, November 24, 2006:

Also at:

ERROR 1136 (21S01) at line 27193: Column count doesn’t match value count at row 1

Sam Bowen, MD

markleeds wrote on Friday, November 24, 2006:

I read someone hear mention that they added a fax field recently.  Could that be it?

markleeds wrote on Friday, November 24, 2006:

Sorry, I meant ‘here’ not ‘hear’.  Must be too much turkey :slight_smile:

drbowen wrote on Friday, November 24, 2006:

It appears to be the fax field.  I just added ‘’,  and got past the problem but this needs to be fixed in CVS.

The second error is where the calendar events are being added: In_Office, Lunch, Out-OF-OFFICE.

It is not as clear what is missing.

Except for these two hiccoughs I have successfully installed on FreeBSD 6.2 using PHP 5 and MySQl 4.1.21.

I haven’t tried the PHP5 and MySQL5 yet.

Rod, any idea what field needs to added to these insert statements?

Sam Bowen, MD

sunsetsystems wrote on Friday, November 24, 2006:

Looks like a couple of fields were added without changing the corresponding inserts for default rows.  I updated database.sql to fix this.

Rod
www.sunsetsystems.com

tekknogenius wrote on Tuesday, November 28, 2006:

My fault on the fax field. Perhaps another field too. I neglected to update the insert statements (forgot about the seeded data).

Thanx for fixing it.