Hi all the dump actually is different...& you don't need the care_test_group anymore... at the end pf this mail is the dump of the table...
hi to your vacation place :) gjergji --------------- CREATE TABLE `care_test_param` ( `nr` smallint(5) unsigned NOT NULL auto_increment, `group_id` varchar(35) collate latin1_general_ci NOT NULL, `name` varchar(35) collate latin1_general_ci NOT NULL, `id` varchar(50) collate latin1_general_ci NOT NULL, `sort_nr` tinyint(4) NOT NULL default '0', `msr_unit` varchar(15) collate latin1_general_ci NOT NULL, `status` varchar(25) collate latin1_general_ci NOT NULL, `median` varchar(20) collate latin1_general_ci default NULL COMMENT 'for males', `hi_bound` varchar(20) collate latin1_general_ci default NULL, `lo_bound` varchar(20) collate latin1_general_ci default NULL, `hi_critical` varchar(20) collate latin1_general_ci default NULL, `lo_critical` varchar(20) collate latin1_general_ci default NULL, `hi_toxic` varchar(20) collate latin1_general_ci default NULL, `lo_toxic` varchar(20) collate latin1_general_ci default NULL, `median_f` varchar(20) collate latin1_general_ci default NULL COMMENT '_ f for females', `hi_bound_f` varchar(20) collate latin1_general_ci default NULL, `lo_bound_f` varchar(20) collate latin1_general_ci default NULL, `hi_critical_f` varchar(20) collate latin1_general_ci default NULL, `lo_critical_f` varchar(20) collate latin1_general_ci default NULL, `hi_toxic_f` varchar(20) collate latin1_general_ci default NULL, `lo_toxic_f` varchar(20) collate latin1_general_ci default NULL, `median_n` varchar(20) collate latin1_general_ci default NULL COMMENT '_n for neonatal from 0 to 1 month', `hi_bound_n` varchar(20) collate latin1_general_ci default NULL, `lo_bound_n` varchar(20) collate latin1_general_ci default NULL, `hi_critical_n` varchar(20) collate latin1_general_ci default NULL, `lo_critical_n` varchar(20) collate latin1_general_ci default NULL, `hi_toxic_n` varchar(20) collate latin1_general_ci default NULL, `lo_toxic_n` varchar(20) collate latin1_general_ci default NULL, `median_y` varchar(20) collate latin1_general_ci default NULL COMMENT '_y for children form 1 month to 12 months', `hi_bound_y` varchar(20) collate latin1_general_ci default NULL, `lo_bound_y` varchar(20) collate latin1_general_ci default NULL, `hi_critical_y` varchar(20) collate latin1_general_ci default NULL, `lo_critical_y` varchar(20) collate latin1_general_ci default NULL, `hi_toxic_y` varchar(20) collate latin1_general_ci default NULL, `lo_toxic_y` varchar(20) collate latin1_general_ci default NULL, `median_c` varchar(20) collate latin1_general_ci default NULL COMMENT '_c for children form 1 to 14 years', `hi_bound_c` varchar(20) collate latin1_general_ci default NULL, `lo_bound_c` varchar(20) collate latin1_general_ci default NULL, `hi_critical_c` varchar(20) collate latin1_general_ci default NULL, `lo_critical_c` varchar(20) collate latin1_general_ci default NULL, `hi_toxic_c` varchar(20) collate latin1_general_ci default NULL, `lo_toxic_c` varchar(20) collate latin1_general_ci default NULL, `method` varchar(255) collate latin1_general_ci default NULL, `history` text collate latin1_general_ci NOT NULL, `modify_id` varchar(35) collate latin1_general_ci NOT NULL, `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `create_id` varchar(35) collate latin1_general_ci NOT NULL, `create_time` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`nr`,`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=665 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -------------- Claudio Giulio Torbinio - Personale wrote: > Hi all > > I seems po be all ok > Only the dumping of the care_test_param > <http://localhost/phpmyadmin/tbl_structure.php?db=care2x&table=care_test_param&token=5e7c9b9da5b2b7e39ecb292a29e69031> > > tab give this error: > ----------------------------- > > # Dumping data for table care_test_param > # > INSERT INTO care_test_param > VALUES ( 1, 'priority', 'Quick', '00q', 'mm/s', '', '', '', '', '', '', > '', '', '', 'Elpidio Latorilla', 20030806033227, '', 00000000000000 ) ; > > | #1136 - Column count doesn't match value count at row 1 > ----------------------- > Think is nothink, but query must be revisited. > Hi by my vacation place > > BB on 06/27 > > Claudio > | > Robert Meggle ha scritto: > >> Hi developers, >> >> First of all, many thanks to the work of Gjergj Sheldija, a really active >> care2x developer from Albania! >> >> Now there is a request of comment for developers. >> >> Actually the dump of mysql has been changed on two tables. It reflects >> care_test_groups and care_users. If you want to test quickly then just pick >> out these two tables out of the mysql_dump.sql of the path >> /installer/db/sql/ >> >> He sent it to me with just one description, short and precicely: >> "i'm sending the new lab module & the modifications on the sequrity ( user >> -> department ) & some patches on some care2x classes..." >> >> On my system it is running well, now as more eyes are looking to it as >> better. >> >> >> Robert >> >> >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2005. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Care2002-developers mailing list >> Care2002-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/care2002-developers >> >> >> >> > > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
