This is so weird! I'm getting a: ERROR 1172 (42000): Result consisted of more than one row
I've setup 2 machines. Same table (dbsetup.sql) , same insert statement (foo.sql), same version (5.0.24a). Only difference is: One is my laptop on FC5-i386, the other is a server on RHEL4u4-i386 Any clues? Help! p.s. I've attached the table definition and the insert statement.
INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg, event_id, username, computer_name) VALUES ( REPLACE(TRIM('SGBSPR01.isddc.men.maxis.com.my'),' ',''), REPLACE(TRIM('user'),' ',''), REPLACE(TRIM('notice'),' ',''), REPLACE(TRIM('notice'),' ',''), REPLACE(TRIM('0d'),' ',''), REPLACE(TRIM('2006-09-26 22:06:49'),' ',''), REPLACE(TRIM('MSWinEventLog;0;Security;6077;Tue Sep 26 22'),' ',''), REPLACE(TRIM('MSWinEventLog;0;Security;6077;Tue Sep 26 22:06:41 2006;593;Security;SYSTEM;User;Success Audit;SGBSPR01;Detailed Tracking;;A process has exited: Process ID: 5708 Image File NameC:\\WINDOWS\\system32\\cmd.exe User Name: SGBSPR01$ Domain:ISDDC Logon ID: (0x0,0x3E7) ;6070'), ': ',':'), SUBSTRING_INDEX(SUBSTRING_INDEX('MSWinEventLog;0;Security;6077;Tue Sep 26 22:06:41 2006;593;Security;SYSTEM;User;Success Audit;SGBSPR01;Detailed Tracking;;A process has exited: Process ID: 5708 Image File Name: C:\\WINDOWS\\system32\\cmd.exe User Name: SGBSPR01$ Domain: ISDDC Logon ID: (0x0,0x3E7) ;6070', ';', 6), ';', -1), SUBSTRING_INDEX(SUBSTRING_INDEX('MSWinEventLog;0;Security;6077;Tue Sep 26 22:06:41 2006;593;Security;SYSTEM;User;Success Audit;SGBSPR01;Detailed Tracking;;A process has exited: Process ID: 5708 Image File Name: C:\\WINDOWS\\system32\\cmd.exe User Name: SGBSPR01$ Domain: ISDDC Logon ID: (0x0,0x3E7) ;6070', ';', 8), ';', -1), SUBSTRING_INDEX(SUBSTRING_INDEX('MSWinEventLog;0;Security;6077;Tue Sep 26 22:06:41 2006;593;Security;SYSTEM;User;Success Audit;SGBSPR01;Detailed Tracking;;A process has exited: Process ID: 5708 Image File Name: C:\\WINDOWS\\system32\\cmd.exe User Name: SGBSPR01$ Domain: ISDDC Logon ID: (0x0,0x3E7) ;6070', ';', 11), ';', -1) );
CREATE TABLE IF NOT EXISTS logs ( seq bigint(12) unsigned NOT NULL primary key auto_increment, host char(35), facility char(8), priority char(7), level char(7), tag char(2), datetime datetime, program char(15), msg text, event_id integer, username char(25), computer_name char(25), index msg_idx (msg(255)), index host_idx (host), index program_idx (program), index datetime_idx (datetime), index priority_idx (priority), index facility_idx (facility), index event_id_idx (event_id), index username_idx (username), index computer_name_idx (computer_name) ) TYPE=MyISAM row_format=fixed;
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]