WYbSar21

1Perl :
2
3 $Query = "INSERT INTO UserLog (Key, StartTime, SourceNet, PacketType, RepeaterID, DmrID, DestinationID, Sequence, TimeSlot, GroupCall, PrivateCall, DataCall, Raw) VALUES CRC32('$SourceID$RepeaterID$Sequence$SourceNet'),'$DateTime','$SourceNet', '$PacketType', '$RepeaterID', '$DmrID', '$DestinationID', '$Sequence', '$TimeSlot', '$GroupCall','$PrivateCall','$DataCall','$Raw') ON DUPLICATE KEY UPDATE EndTime='$DateTime';";
4
5Excuted as 
6
7INSERT INTO UserLog (Key, StartTime, SourceNet, PacketType, RepeaterID, DmrID, DestinationID, Sequence, TimeSlot, GroupCall, PrivateCall, DataCall, Raw) VALUES CRC32('3126018350201'),'2012-09-12 01:33:12','50201', '128', '312601', '3126002', '16776415', '83', '1', '','','','') ON DUPLICATE KEY UPDATE EndTime='2012-09-12 01:33:12';
8
9yields
10
11DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key, StartTime, SourceNet, PacketType, RepeaterID, DmrID, DestinationID, Sequenc' at line 1 at ./dmr-server.pl line 42, <GEN0> line 3.
12
13structure is as follows
14
15SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
16SET time_zone = "+00:00";
17
18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
19/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
20/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
21/*!40101 SET NAMES utf8 */;
22
23
24CREATE TABLE IF NOT EXISTS `UserLog` (
25  `Key` bigint(20) NOT NULL,
26  `StartTime` datetime NOT NULL,
27  `EndTime` datetime NOT NULL,
28  `SourceNet` int(11) NOT NULL,
29  `PacketType` int(2) NOT NULL,
30  `RepeaterID` int(11) NOT NULL,
31  `DmrID` int(11) NOT NULL,
32  `DestinationID` int(11) NOT NULL,
33  `Sequence` int(11) NOT NULL,
34  `TimeSlot` int(11) NOT NULL,
35  `GroupCall` int(11) NOT NULL,
36  `PrivateCall` int(11) NOT NULL,
37  `DataCall` int(11) NOT NULL,
38  `Raw` int(11) NOT NULL,
39  `Duration` int(11) NOT NULL,
40  PRIMARY KEY  (`Key`)
41) ENGINE=MyISAM DEFAULT CHARSET=latin1;
42
43/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
44/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
45/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;