
CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerNumber` int(11) NOT NULL,
  `checkNumber` varchar(50) NOT NULL,
  `paymentDate` date NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`,`customerNumber`,`checkNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=latin1;

/*Data for the table `payments` */

insert  into `payments`(`id`,`customerNumber`,`checkNumber`,`paymentDate`,`amount`) values 
(1,103,'HQ336336','2004-10-19',6066.78),
(2,103,'JM555205','2003-06-05',14571.44),
(3,103,'OM314933','2004-12-18',1676.14),
(4,112,'BO864823','2004-12-17',14191.12),
(5,112,'HQ55022','2003-06-06',32641.98),
(6,112,'ND748579','2004-08-20',33347.88),
(7,114,'GG31455','2003-05-20',45864.03),
(8,114,'MA765515','2004-12-15',82261.22),
(9,114,'NP603840','2003-05-31',7565.08),
(10,114,'NR27552','2004-03-10',44894.74),
(11,119,'DB933704','2004-11-14',19501.82),
(12,119,'LN373447','2004-08-08',47924.19),
(13,119,'NG94694','2005-02-22',49523.67),
(14,121,'DB889831','2003-02-16',50218.95),
(15,121,'FD317790','2003-10-28',1491.38),
(16,121,'KI831359','2004-11-04',17876.32),
(17,121,'MA302151','2004-11-28',34638.14),
(18,124,'AE215433','2005-03-05',101244.59),
(19,124,'BG255406','2004-08-28',85410.87),
(20,124,'CQ287967','2003-04-11',11044.30),
(21,124,'ET64396','2005-04-16',83598.04),
(22,124,'HI366474','2004-12-27',47142.70),
(23,124,'HR86578','2004-11-02',55639.66),
(24,124,'KI131716','2003-08-15',111654.40),
(25,124,'LF217299','2004-03-26',43369.30),
(26,124,'NT141748','2003-11-25',45084.38),
(27,128,'DI925118','2003-01-28',10549.01),
(28,128,'FA465482','2003-10-18',24101.81),
(29,128,'FH668230','2004-03-24',33820.62),
(30,128,'IP383901','2004-11-18',7466.32),
(31,129,'DM826140','2004-12-08',26248.78),
(32,129,'ID449593','2003-12-11',23923.93),
(33,129,'PI42991','2003-04-09',16537.85),
(34,131,'CL442705','2003-03-12',22292.62),
(35,131,'MA724562','2004-12-02',50025.35),
(36,131,'NB445135','2004-09-11',35321.97),
(37,141,'AU364101','2003-07-19',36251.03),
(38,141,'DB583216','2004-11-01',36140.38),
(39,141,'DL460618','2005-05-19',46895.48),
(40,141,'HJ32686','2004-01-30',59830.55),
(41,141,'ID10962','2004-12-31',116208.40),
(42,141,'IN446258','2005-03-25',65071.26),
(43,141,'JE105477','2005-03-18',120166.58),
(44,141,'JN355280','2003-10-26',49539.37),
(45,141,'JN722010','2003-02-25',40206.20),
(46,141,'KT52578','2003-12-09',63843.55),
(47,141,'MC46946','2004-07-09',35420.74),
(48,141,'MF629602','2004-08-16',20009.53),
(49,141,'NU627706','2004-05-17',26155.91),
(50,144,'IR846303','2004-12-12',36005.71),
(51,144,'LA685678','2003-04-09',7674.94),
(52,145,'CN328545','2004-07-03',4710.73),
(53,145,'ED39322','2004-04-26',28211.70),
(54,145,'HR182688','2004-12-01',20564.86),
(55,145,'JJ246391','2003-02-20',53959.21),
(56,146,'FP549817','2004-03-18',40978.53),
(57,146,'FU793410','2004-01-16',49614.72),
(58,146,'LJ160635','2003-12-10',39712.10),
(59,148,'BI507030','2003-04-22',44380.15),
(60,148,'DD635282','2004-08-11',2611.84),
(61,148,'KM172879','2003-12-26',105743.00),
(62,148,'ME497970','2005-03-27',3516.04),
(63,151,'BF686658','2003-12-22',58793.53),
(64,151,'GB852215','2004-07-26',20314.44),
(65,151,'IP568906','2003-06-18',58841.35),
(66,151,'KI884577','2004-12-14',39964.63),
(67,157,'HI618861','2004-11-19',35152.12),
(68,157,'NN711988','2004-09-07',63357.13),
(69,161,'BR352384','2004-11-14',2434.25),
(70,161,'BR478494','2003-11-18',50743.65),
(71,161,'KG644125','2005-02-02',12692.19),
(72,161,'NI908214','2003-08-05',38675.13),
(73,166,'BQ327613','2004-09-16',38785.48),
(74,166,'DC979307','2004-07-07',44160.92),
(75,166,'LA318629','2004-02-28',22474.17),
(76,167,'ED743615','2004-09-19',12538.01),
(77,167,'GN228846','2003-12-03',85024.46),
(78,171,'GB878038','2004-03-15',18997.89),
(79,171,'IL104425','2003-11-22',42783.81),
(80,172,'AD832091','2004-09-09',1960.80),
(81,172,'CE51751','2004-12-04',51209.58),
(82,172,'EH208589','2003-04-20',33383.14),
(83,173,'GP545698','2004-05-13',11843.45),
(84,173,'IG462397','2004-03-29',20355.24),
(85,175,'CITI3434344','2005-05-19',28500.78),
(86,175,'IO448913','2003-11-19',24879.08),
(87,175,'PI15215','2004-07-10',42044.77),
(88,177,'AU750837','2004-04-17',15183.63),
(89,177,'CI381435','2004-01-19',47177.59),
(90,181,'CM564612','2004-04-25',22602.36),
(91,181,'GQ132144','2003-01-30',5494.78),
(92,181,'OH367219','2004-11-16',44400.50),
(93,186,'AE192287','2005-03-10',23602.90),
(94,186,'AK412714','2003-10-27',37602.48),
(95,186,'KA602407','2004-10-21',34341.08),
(96,187,'AM968797','2004-11-03',52825.29),
(97,187,'BQ39062','2004-12-08',47159.11),
(98,187,'KL124726','2003-03-27',48425.69),
(99,189,'BO711618','2004-10-03',17359.53),
(100,189,'NM916675','2004-03-01',32538.74),
(101,198,'FI192930','2004-12-06',9658.74),
(102,198,'HQ920205','2003-07-06',6036.96),
(103,198,'IS946883','2004-09-21',5858.56),
(104,201,'DP677013','2003-10-20',23908.24),
(105,201,'OO846801','2004-06-15',37258.94),
(106,202,'HI358554','2003-12-18',36527.61),
(107,202,'IQ627690','2004-11-08',33594.58),
(108,204,'GC697638','2004-08-13',51152.86),
(109,204,'IS150005','2004-09-24',4424.40),
(110,205,'GL756480','2003-12-04',3879.96),
(111,205,'LL562733','2003-09-05',50342.74),
(112,205,'NM739638','2005-02-06',39580.60),
(113,209,'BOAF82044','2005-05-03',35157.75),
(114,209,'ED520529','2004-06-21',4632.31),
(115,209,'PH785937','2004-05-04',36069.26),
(116,211,'BJ535230','2003-12-09',45480.79),
(117,216,'BG407567','2003-05-09',3101.40),
(118,216,'ML780814','2004-12-06',24945.21),
(119,216,'MM342086','2003-12-14',40473.86),
(120,219,'BN17870','2005-03-02',3452.75),
(121,219,'BR941480','2003-10-18',4465.85),
(122,227,'MQ413968','2003-10-31',36164.46),
(123,227,'NU21326','2004-11-02',53745.34),
(124,233,'BOFA23232','2005-05-20',29070.38),
(125,233,'II180006','2004-07-01',22997.45),
(126,233,'JG981190','2003-11-18',16909.84),
(127,239,'NQ865547','2004-03-15',80375.24),
(128,240,'IF245157','2004-11-16',46788.14),
(129,240,'JO719695','2004-03-28',24995.61),
(130,242,'AF40894','2003-11-22',33818.34),
(131,242,'HR224331','2005-06-03',12432.32),
(132,242,'KI744716','2003-07-21',14232.70),
(133,249,'IJ399820','2004-09-19',33924.24),
(134,249,'NE404084','2004-09-04',48298.99),
(135,250,'EQ12267','2005-05-17',17928.09),
(136,250,'HD284647','2004-12-30',26311.63),
(137,250,'HN114306','2003-07-18',23419.47),
(138,256,'EP227123','2004-02-10',5759.42),
(139,256,'HE84936','2004-10-22',53116.99),
(140,259,'EU280955','2004-11-06',61234.67),
(141,259,'GB361972','2003-12-07',27988.47),
(142,260,'IO164641','2004-08-30',37527.58),
(143,260,'NH776924','2004-04-24',29284.42),
(144,276,'EM979878','2005-02-09',27083.78),
(145,276,'KM841847','2003-11-13',38547.19),
(146,276,'LE432182','2003-09-28',41554.73),
(147,276,'OJ819725','2005-04-30',29848.52),
(148,278,'BJ483870','2004-12-05',37654.09),
(149,278,'GP636783','2003-03-02',52151.81),
(150,278,'NI983021','2003-11-24',37723.79),
(151,282,'IA793562','2003-08-03',24013.52),
(152,282,'JT819493','2004-08-02',35806.73),
(153,282,'OD327378','2005-01-03',31835.36),
(154,286,'DR578578','2004-10-28',47411.33),
(155,286,'KH910279','2004-09-05',43134.04),
(156,298,'AJ574927','2004-03-13',47375.92),
(157,298,'LF501133','2004-09-18',61402.00),
(158,299,'AD304085','2003-10-24',36798.88),
(159,299,'NR157385','2004-09-05',32260.16),
(160,311,'DG336041','2005-02-15',46770.52),
(161,311,'FA728475','2003-10-06',32723.04),
(162,311,'NQ966143','2004-04-25',16212.59),
(163,314,'LQ244073','2004-08-09',45352.47),
(164,314,'MD809704','2004-03-03',16901.38),
(165,319,'HL685576','2004-11-06',42339.76),
(166,319,'OM548174','2003-12-07',36092.40),
(167,320,'GJ597719','2005-01-18',8307.28),
(168,320,'HO576374','2003-08-20',41016.75),
(169,320,'MU817160','2003-11-24',52548.49),
(170,321,'DJ15149','2003-11-03',85559.12),
(171,321,'LA556321','2005-03-15',46781.66),
(172,323,'AL493079','2005-05-23',75020.13),
(173,323,'ES347491','2004-06-24',37281.36),
(174,323,'HG738664','2003-07-05',2880.00),
(175,323,'PQ803830','2004-12-24',39440.59),
(176,324,'DQ409197','2004-12-13',13671.82),
(177,324,'FP443161','2003-07-07',29429.14),
(178,324,'HB150714','2003-11-23',37455.77),
(179,328,'EN930356','2004-04-16',7178.66),
(180,328,'NR631421','2004-05-30',31102.85),
(181,333,'HL209210','2003-11-15',23936.53),
(182,333,'JK479662','2003-10-17',9821.32),
(183,333,'NF959653','2005-03-01',21432.31),
(184,334,'CS435306','2005-01-27',45785.34),
(185,334,'HH517378','2003-08-16',29716.86),
(186,334,'LF737277','2004-05-22',28394.54),
(187,339,'AP286625','2004-10-24',23333.06),
(188,339,'DA98827','2003-11-28',34606.28),
(189,344,'AF246722','2003-11-24',31428.21),
(190,344,'NJ906924','2004-04-02',15322.93),
(191,347,'DG700707','2004-01-18',21053.69),
(192,347,'LG808674','2003-10-24',20452.50),
(193,350,'BQ602907','2004-12-11',18888.31),
(194,350,'CI471510','2003-05-25',50824.66),
(195,350,'OB648482','2005-01-29',1834.56),
(196,353,'CO351193','2005-01-10',49705.52),
(197,353,'ED878227','2003-07-21',13920.26),
(198,353,'GT878649','2003-05-21',16700.47),
(199,353,'HJ618252','2005-06-09',46656.94),
(200,357,'AG240323','2003-12-16',20220.04),
(201,357,'NB291497','2004-05-15',36442.34),
(202,362,'FP170292','2004-07-11',18473.71),
(203,362,'OG208861','2004-09-21',15059.76),
(204,363,'HL575273','2004-11-17',50799.69),
(205,363,'IS232033','2003-01-16',10223.83),
(206,363,'PN238558','2003-12-05',55425.77),
(207,379,'CA762595','2005-02-12',28322.83),
(208,379,'FR499138','2003-09-16',32680.31),
(209,379,'GB890854','2004-08-02',12530.51),
(210,381,'BC726082','2004-12-03',12081.52),
(211,381,'CC475233','2003-04-19',1627.56),
(212,381,'GB117430','2005-02-03',14379.90),
(213,381,'MS154481','2003-08-22',1128.20),
(214,382,'CC871084','2003-05-12',35826.33),
(215,382,'CT821147','2004-08-01',6419.84),
(216,382,'PH29054','2004-11-27',42813.83),
(217,385,'BN347084','2003-12-02',20644.24),
(218,385,'CP804873','2004-11-19',15822.84),
(219,385,'EK785462','2003-03-09',51001.22),
(220,386,'DO106109','2003-11-18',38524.29),
(221,386,'HG438769','2004-07-18',51619.02),
(222,398,'AJ478695','2005-02-14',33967.73),
(223,398,'DO787644','2004-06-21',22037.91),
(224,398,'JPMR4544','2005-05-18',615.45),
(225,398,'KB54275','2004-11-29',48927.64),
(226,406,'BJMPR4545','2005-04-23',12190.85),
(227,406,'HJ217687','2004-01-28',49165.16),
(228,406,'NA197101','2004-06-17',25080.96),
(229,412,'GH197075','2004-07-25',35034.57),
(230,412,'PJ434867','2004-04-14',31670.37),
(231,415,'ER54537','2004-09-28',31310.09),
(232,424,'KF480160','2004-12-07',25505.98),
(233,424,'LM271923','2003-04-16',21665.98),
(234,424,'OA595449','2003-10-31',22042.37),
(235,447,'AO757239','2003-09-15',6631.36),
(236,447,'ER615123','2003-06-25',17032.29),
(237,447,'OU516561','2004-12-17',26304.13),
(238,448,'FS299615','2005-04-18',27966.54),
(239,448,'KR822727','2004-09-30',48809.90),
(240,450,'EF485824','2004-06-21',59551.38),
(241,452,'ED473873','2003-11-15',27121.90),
(242,452,'FN640986','2003-11-20',15130.97),
(243,452,'HG635467','2005-05-03',8807.12),
(244,455,'HA777606','2003-12-05',38139.18),
(245,455,'IR662429','2004-05-12',32239.47),
(246,456,'GJ715659','2004-11-13',27550.51),
(247,456,'MO743231','2004-04-30',1679.92),
(248,458,'DD995006','2004-11-15',33145.56),
(249,458,'NA377824','2004-02-06',22162.61),
(250,458,'OO606861','2003-06-13',57131.92),
(251,462,'ED203908','2005-04-15',30293.77),
(252,462,'GC60330','2003-11-08',9977.85),
(253,462,'PE176846','2004-11-27',48355.87),
(254,471,'AB661578','2004-07-28',9415.13),
(255,471,'CO645196','2003-12-10',35505.63),
(256,473,'LL427009','2004-02-17',7612.06),
(257,473,'PC688499','2003-10-27',17746.26),
(258,475,'JP113227','2003-12-09',7678.25),
(259,475,'PB951268','2004-02-13',36070.47),
(260,484,'GK294076','2004-10-26',3474.66),
(261,484,'JH546765','2003-11-29',47513.19),
(262,486,'BL66528','2004-04-14',5899.38),
(263,486,'HS86661','2004-11-23',45994.07),
(264,486,'JB117768','2003-03-20',25833.14),
(265,487,'AH612904','2003-09-28',29997.09),
(266,487,'PT550181','2004-02-29',12573.28),
(267,489,'OC773849','2003-12-04',22275.73),
(268,489,'PO860906','2004-01-31',7310.42),
(269,495,'BH167026','2003-12-26',59265.14),
(270,495,'FN155234','2004-05-14',6276.60),
(271,496,'EU531600','2005-05-25',30253.75),
(272,496,'MB342426','2003-07-16',32077.44),
(273,496,'MN89921','2004-12-30',52166.00);

/*Table structure for table `productlines` */


CREATE TABLE `productlines` (
  `productLine` varchar(50) NOT NULL,
  `textDescription` varchar(4000) DEFAULT NULL,
  `htmlDescription` mediumtext DEFAULT NULL,
  `image` mediumblob DEFAULT NULL,
  PRIMARY KEY (`productLine`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `productlines` */

insert  into `productlines`(`productLine`,`textDescription`,`htmlDescription`,`image`) values 
('Classic Cars','Attention car enthusiasts: Make your wildest car ownership dreams come true. Whether you are looking for classic muscle cars, dream sports cars or movie-inspired miniatures, you will find great choices in this category. These replicas feature superb attention to detail and craftsmanship and offer features such as working steering system, opening forward compartment, opening rear trunk with removable spare wheel, 4-wheel independent spring suspension, and so on. The models range in size from 1:10 to 1:24 scale and include numerous limited edition and several out-of-production vehicles. All models include a certificate of authenticity from their manufacturers and come fully assembled and ready for display in the home or office.',NULL,NULL),
('Motorcycles','Our motorcycles are state of the art replicas of classic as well as contemporary motorcycle legends such as Harley Davidson, Ducati and Vespa. Models contain stunning details such as official logos, rotating wheels, working kickstand, front suspension, gear-shift lever, footbrake lever, and drive chain. Materials used include diecast and plastic. The models range in size from 1:10 to 1:50 scale and include numerous limited edition and several out-of-production vehicles. All models come fully assembled and ready for display in the home or office. Most include a certificate of authenticity.',NULL,NULL),
('Planes','Unique, diecast airplane and helicopter replicas suitable for collections, as well as home, office or classroom decorations. Models contain stunning details such as official logos and insignias, rotating jet engines and propellers, retractable wheels, and so on. Most come fully assembled and with a certificate of authenticity from their manufacturers.',NULL,NULL),
('Ships','The perfect holiday or anniversary gift for executives, clients, friends, and family. These handcrafted model ships are unique, stunning works of art that will be treasured for generations! They come fully assembled and ready for display in the home or office. We guarantee the highest quality, and best value.',NULL,NULL),
('Trains','Model trains are a rewarding hobby for enthusiasts of all ages. Whether you\'re looking for collectible wooden trains, electric streetcars or locomotives, you\'ll find a number of great choices for any budget within this category. The interactive aspect of trains makes toy trains perfect for young children. The wooden train sets are ideal for children under the age of 5.',NULL,NULL),
('Trucks and Buses','The Truck and Bus models are realistic replicas of buses and specialized trucks produced from the early 1920s to present. The models range in size from 1:12 to 1:50 scale and include numerous limited edition and several out-of-production vehicles. Materials used include tin, diecast and plastic. All models include a certificate of authenticity from their manufacturers and are a perfect ornament for the home and office.',NULL,NULL),
('Vintage Cars','Our Vintage Car models realistically portray automobiles produced from the early 1900s through the 1940s. Materials used include Bakelite, diecast, plastic and wood. Most of the replicas are in the 1:18 and 1:24 scale sizes, which provide the optimum in detail and accuracy. Prices range from $30.00 up to $180.00 for some special limited edition replicas. All models include a certificate of authenticity from their manufacturers and come fully assembled and ready for display in the home or office.',NULL,NULL);

/*Table structure for table `products` */


CREATE TABLE `products` (
  `productId` int(11) NOT NULL AUTO_INCREMENT,
  `productCode` varchar(15) NOT NULL,
  `productName` varchar(70) NOT NULL,
  `productLine` varchar(50) NOT NULL,
  `productScale` varchar(10) NOT NULL,
  `productVendor` varchar(50) NOT NULL,
  `productDescription` text NOT NULL,
  `quantityInStock` smallint(6) NOT NULL,
  `buyPrice` decimal(10,2) NOT NULL,
  `MSRP` decimal(10,2) NOT NULL,
  PRIMARY KEY (`productId`,`productCode`),
  KEY `productLine` (`productLine`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

/*Data for the table `products` */

insert  into `products`(`productId`,`productCode`,`productName`,`productLine`,`productScale`,`productVendor`,`productDescription`,`quantityInStock`,`buyPrice`,`MSRP`) values 
(1,'S10_1678','1969 Harley Davidson Ultimate Chopper','Motorcycles','1:10','Min Lin Diecast','This replica features working kickstand, front suspension, gear-shift lever, footbrake lever, drive chain, wheels and steering. All parts are particularly delicate due to their precise scale and require special care and attention.',7933,48.81,95.70),
(2,'S10_1949','1952 Alpine Renault 1300','Classic Cars','1:10','Classic Metal Creations','Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',7305,98.58,214.30),
(3,'S10_2016','1996 Moto Guzzi 1100i','Motorcycles','1:10','Highway 66 Mini Classics','Official Moto Guzzi logos and insignias, saddle bags located on side of motorcycle, detailed engine, working steering, working suspension, two leather seats, luggage rack, dual exhaust pipes, small saddle bag located on handle bars, two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand, diecast metal with plastic parts and baked enamel finish.',6625,68.99,118.94),
(4,'S10_4698','2003 Harley-Davidson Eagle Drag Bike','Motorcycles','1:10','Red Start Diecast','Model features, official Harley Davidson logos and insignias, detachable rear wheelie bar, heavy diecast metal with resin parts, authentic multi-color tampo-printed graphics, separate engine drive belts, free-turning front fork, rotating tires and rear racing slick, certificate of authenticity, detailed engine, display stand\r\n, precision diecast replica, baked enamel finish, 1:10 scale model, removable fender, seat and tank cover piece for displaying the superior detail of the v-twin engine',5582,91.02,193.66),
(5,'S10_4757','1972 Alfa Romeo GTA','Classic Cars','1:10','Motor City Art Classics','Features include: Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',3252,85.68,136.00),
(6,'S10_4962','1962 LanciaA Delta 16V','Classic Cars','1:10','Second Gear Diecast','Features include: Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',6791,103.42,147.74),
(7,'S12_1099','1968 Ford Mustang','Classic Cars','1:12','Autoart Studio Design','Hood, doors and trunk all open to reveal highly detailed interior features. Steering wheel actually turns the front wheels. Color dark green.',68,95.34,194.57),
(8,'S12_1108','2001 Ferrari Enzo','Classic Cars','1:12','Second Gear Diecast','Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',3619,95.59,207.80),
(9,'S12_1666','1958 Setra Bus','Trucks and Buses','1:12','Welly Diecast Productions','Model features 30 windows, skylights & glare resistant glass, working steering system, original logos',1579,77.90,136.67),
(10,'S12_2823','2002 Suzuki XREO','Motorcycles','1:12','Unimax Art Galleries','Official logos and insignias, saddle bags located on side of motorcycle, detailed engine, working steering, working suspension, two leather seats, luggage rack, dual exhaust pipes, small saddle bag located on handle bars, two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand, diecast metal with plastic parts and baked enamel finish.',9997,66.27,150.62),
(11,'S12_3148','1969 Corvair Monza','Classic Cars','1:18','Welly Diecast Productions','1:18 scale die-cast about 10\" long doors open, hood opens, trunk opens and wheels roll',6906,89.14,151.08),
(12,'S12_3380','1968 Dodge Charger','Classic Cars','1:12','Welly Diecast Productions','1:12 scale model of a 1968 Dodge Charger. Hood, doors and trunk all open to reveal highly detailed interior features. Steering wheel actually turns the front wheels. Color black',9123,75.16,117.44),
(13,'S12_3891','1969 Ford Falcon','Classic Cars','1:12','Second Gear Diecast','Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',1049,83.05,173.02),
(14,'S12_3990','1970 Plymouth Hemi Cuda','Classic Cars','1:12','Studio M Art Models','Very detailed 1970 Plymouth Cuda model in 1:12 scale. The Cuda is generally accepted as one of the fastest original muscle cars from the 1970s. This model is a reproduction of one of the orginal 652 cars built in 1970. Red color.',5663,31.92,79.80),
(15,'S12_4473','1957 Chevy Pickup','Trucks and Buses','1:12','Exoto Designs','1:12 scale die-cast about 20\" long Hood opens, Rubber wheels',6125,55.70,118.50),
(16,'S12_4675','1969 Dodge Charger','Classic Cars','1:12','Welly Diecast Productions','Detailed model of the 1969 Dodge Charger. This model includes finely detailed interior and exterior features. Painted in red and white.',7323,58.73,115.16),
(17,'S18_1097','1940 Ford Pickup Truck','Trucks and Buses','1:18','Studio M Art Models','This model features soft rubber tires, working steering, rubber mud guards, authentic Ford logos, detailed undercarriage, opening doors and hood,  removable split rear gate, full size spare mounted in bed, detailed interior with opening glove box',2613,58.33,116.67),
(18,'S18_1129','1993 Mazda RX-7','Classic Cars','1:18','Highway 66 Mini Classics','This model features, opening hood, opening doors, detailed engine, rear spoiler, opening trunk, working steering, tinted windows, baked enamel finish. Color red.',3975,83.51,141.54),
(19,'S18_1342','1937 Lincoln Berline','Vintage Cars','1:18','Motor City Art Classics','Features opening engine cover, doors, trunk, and fuel filler cap. Color black',8693,60.62,102.74),
(20,'S18_1367','1936 Mercedes-Benz 500K Special Roadster','Vintage Cars','1:18','Studio M Art Models','This 1:18 scale replica is constructed of heavy die-cast metal and has all the features of the original: working doors and rumble seat, independent spring suspension, detailed interior, working steering system, and a bifold hood that reveals an engine so accurate that it even includes the wiring. All this is topped off with a baked enamel finish. Color white.',8635,24.26,53.91),
(21,'S18_1589','1965 Aston Martin DB5','Classic Cars','1:18','Classic Metal Creations','Die-cast model of the silver 1965 Aston Martin DB5 in silver. This model includes full wire wheels and doors that open with fully detailed passenger compartment. In 1:18 scale, this model measures approximately 10 inches/20 cm long.',9042,65.96,124.44),
(22,'S18_1662','1980s Black Hawk Helicopter','Planes','1:18','Red Start Diecast','1:18 scale replica of actual Army\'s UH-60L BLACK HAWK Helicopter. 100% hand-assembled. Features rotating rotor blades, propeller blades and rubber wheels.',5330,77.27,157.69),
(23,'S18_1749','1917 Grand Touring Sedan','Vintage Cars','1:18','Welly Diecast Productions','This 1:18 scale replica of the 1917 Grand Touring car has all the features you would expect from museum quality reproductions: all four doors and bi-fold hood opening, detailed engine and instrument panel, chrome-look trim, and tufted upholstery, all topped off with a factory baked-enamel finish.',2724,86.70,171.00),
(24,'S18_1889','1948 Porsche 356-A Roadster','Classic Cars','1:18','Gearbox Collectibles','This precision die-cast replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',8826,53.90,77.00),
(25,'S18_1984','1995 Honda Civic','Classic Cars','1:18','Min Lin Diecast','This model features, opening hood, opening doors, detailed engine, rear spoiler, opening trunk, working steering, tinted windows, baked enamel finish. Color yellow.',9772,93.89,142.25),
(26,'S18_2238','1998 Chrysler Plymouth Prowler','Classic Cars','1:18','Gearbox Collectibles','Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',4724,101.51,163.73),
(27,'S18_2248','1911 Ford Town Car','Vintage Cars','1:18','Motor City Art Classics','Features opening hood, opening doors, opening trunk, wide white wall tires, front door arm rests, working steering system.',540,33.30,60.54),
(28,'S18_2319','1964 Mercedes Tour Bus','Trucks and Buses','1:18','Unimax Art Galleries','Exact replica. 100+ parts. working steering system, original logos',8258,74.86,122.73),
(29,'S18_2325','1932 Model A Ford J-Coupe','Vintage Cars','1:18','Autoart Studio Design','This model features grille-mounted chrome horn, lift-up louvered hood, fold-down rumble seat, working steering system, chrome-covered spare, opening doors, detailed and wired engine',9354,58.48,127.13),
(30,'S18_2432','1926 Ford Fire Engine','Trucks and Buses','1:18','Carousel DieCast Legends','Gleaming red handsome appearance. Everything is here the fire hoses, ladder, axes, bells, lanterns, ready to fight any inferno.',2018,24.92,60.77),
(31,'S18_2581','P-51-D Mustang','Planes','1:72','Gearbox Collectibles','Has retractable wheels and comes with a stand',992,49.00,84.48),
(32,'S18_2625','1936 Harley Davidson El Knucklehead','Motorcycles','1:18','Welly Diecast Productions','Intricately detailed with chrome accents and trim, official die-struck logos and baked enamel finish.',4357,24.23,60.57),
(33,'S18_2795','1928 Mercedes-Benz SSK','Vintage Cars','1:18','Gearbox Collectibles','This 1:18 replica features grille-mounted chrome horn, lift-up louvered hood, fold-down rumble seat, working steering system, chrome-covered spare, opening doors, detailed and wired engine. Color black.',548,72.56,168.75),
(34,'S18_2870','1999 Indy 500 Monte Carlo SS','Classic Cars','1:18','Red Start Diecast','Features include opening and closing doors. Color: Red',8164,56.76,132.00),
(35,'S18_2949','1913 Ford Model T Speedster','Vintage Cars','1:18','Carousel DieCast Legends','This 250 part reproduction includes moving handbrakes, clutch, throttle and foot pedals, squeezable horn, detailed wired engine, removable water, gas, and oil cans, pivoting monocle windshield, all topped with a baked enamel red finish. Each replica comes with an Owners Title and Certificate of Authenticity. Color red.',4189,60.78,101.31),
(36,'S18_2957','1934 Ford V8 Coupe','Vintage Cars','1:18','Min Lin Diecast','Chrome Trim, Chrome Grille, Opening Hood, Opening Doors, Opening Trunk, Detailed Engine, Working Steering System',5649,34.35,62.46),
(37,'S18_3029','1999 Yamaha Speed Boat','Ships','1:18','Min Lin Diecast','Exact replica. Wood and Metal. Many extras including rigging, long boats, pilot house, anchors, etc. Comes with three masts, all square-rigged.',4259,51.61,86.02),
(38,'S18_3136','18th Century Vintage Horse Carriage','Vintage Cars','1:18','Red Start Diecast','Hand crafted diecast-like metal horse carriage is re-created in about 1:18 scale of antique horse carriage. This antique style metal Stagecoach is all hand-assembled with many different parts.\r\n\r\nThis collectible metal horse carriage is painted in classic Red, and features turning steering wheel and is entirely hand-finished.',5992,60.74,104.72),
(39,'S18_3140','1903 Ford Model A','Vintage Cars','1:18','Unimax Art Galleries','Features opening trunk,  working steering system',3913,68.30,136.59),
(40,'S18_3232','1992 Ferrari 360 Spider red','Classic Cars','1:18','Unimax Art Galleries','his replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',8347,77.90,169.34),
(41,'S18_3233','1985 Toyota Supra','Classic Cars','1:18','Highway 66 Mini Classics','This model features soft rubber tires, working steering, rubber mud guards, authentic Ford logos, detailed undercarriage, opening doors and hood, removable split rear gate, full size spare mounted in bed, detailed interior with opening glove box',7733,57.01,107.57),
(42,'S18_3259','Collectable Wooden Train','Trains','1:18','Carousel DieCast Legends','Hand crafted wooden toy train set is in about 1:18 scale, 25 inches in total length including 2 additional carts, of actual vintage train. This antique style wooden toy train model set is all hand-assembled with 100% wood.',6450,67.56,100.84),
(43,'S18_3278','1969 Dodge Super Bee','Classic Cars','1:18','Min Lin Diecast','This replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',1917,49.05,80.41),
(44,'S18_3320','1917 Maxwell Touring Car','Vintage Cars','1:18','Exoto Designs','Features Gold Trim, Full Size Spare Tire, Chrome Trim, Chrome Grille, Opening Hood, Opening Doors, Opening Trunk, Detailed Engine, Working Steering System',7913,57.54,99.21),
(45,'S18_3482','1976 Ford Gran Torino','Classic Cars','1:18','Gearbox Collectibles','Highly detailed 1976 Ford Gran Torino \"Starsky and Hutch\" diecast model. Very well constructed and painted in red and white patterns.',9127,73.49,146.99),
(46,'S18_3685','1948 Porsche Type 356 Roadster','Classic Cars','1:18','Gearbox Collectibles','This model features working front and rear suspension on accurately replicated and actuating shock absorbers as well as opening engine cover, rear stabilizer flap,  and 4 opening doors.',8990,62.16,141.28),
(47,'S18_3782','1957 Vespa GS150','Motorcycles','1:18','Studio M Art Models','Features rotating wheels , working kick stand. Comes with stand.',7689,32.95,62.17),
(48,'S18_3856','1941 Chevrolet Special Deluxe Cabriolet','Vintage Cars','1:18','Exoto Designs','Features opening hood, opening doors, opening trunk, wide white wall tires, front door arm rests, working steering system, leather upholstery. Color black.',2378,64.58,105.87),
(49,'S18_4027','1970 Triumph Spitfire','Classic Cars','1:18','Min Lin Diecast','Features include opening and closing doors. Color: White.',5545,91.92,143.62),
(50,'S18_4409','1932 Alfa Romeo 8C2300 Spider Sport','Vintage Cars','1:18','Exoto Designs','This 1:18 scale precision die cast replica features the 6 front headlights of the original, plus a detailed version of the 142 horsepower straight 8 engine, dual spares and their famous comprehensive dashboard. Color black.',6553,43.26,92.03),
(51,'S18_4522','1904 Buick Runabout','Vintage Cars','1:18','Exoto Designs','Features opening trunk,  working steering system',8290,52.66,87.77),
(52,'S18_4600','1940s Ford truck','Trucks and Buses','1:18','Motor City Art Classics','This 1940s Ford Pick-Up truck is re-created in 1:18 scale of original 1940s Ford truck. This antique style metal 1940s Ford Flatbed truck is all hand-assembled. This collectible 1940\'s Pick-Up truck is painted in classic dark green color, and features rotating wheels.',3128,84.76,121.08),
(53,'S18_4668','1939 Cadillac Limousine','Vintage Cars','1:18','Studio M Art Models','Features completely detailed interior including Velvet flocked drapes,deluxe wood grain floor, and a wood grain casket with seperate chrome handles',6645,23.14,50.31),
(54,'S18_4721','1957 Corvette Convertible','Classic Cars','1:18','Classic Metal Creations','1957 die cast Corvette Convertible in Roman Red with white sides and whitewall tires. 1:18 scale quality die-cast with detailed engine and underbvody. Now you can own The Classic Corvette.',1249,69.93,148.80),
(55,'S18_4933','1957 Ford Thunderbird','Classic Cars','1:18','Studio M Art Models','This 1:18 scale precision die-cast replica, with its optional porthole hardtop and factory baked-enamel Thunderbird Bronze finish, is a 100% accurate rendition of this American classic.',3209,34.21,71.27),
(56,'S24_1046','1970 Chevy Chevelle SS 454','Classic Cars','1:24','Unimax Art Galleries','This model features rotating wheels, working streering system and opening doors. All parts are particularly delicate due to their precise scale and require special care and attention. It should not be picked up by the doors, roof, hood or trunk.',1005,49.24,73.49),
(57,'S24_1444','1970 Dodge Coronet','Classic Cars','1:24','Highway 66 Mini Classics','1:24 scale die-cast about 18\" long doors open, hood opens and rubber wheels',4074,32.37,57.80),
(58,'S24_1578','1997 BMW R 1100 S','Motorcycles','1:24','Autoart Studio Design','Detailed scale replica with working suspension and constructed from over 70 parts',7003,60.86,112.70),
(59,'S24_1628','1966 Shelby Cobra 427 S/C','Classic Cars','1:24','Carousel DieCast Legends','This diecast model of the 1966 Shelby Cobra 427 S/C includes many authentic details and operating parts. The 1:24 scale model of this iconic lighweight sports car from the 1960s comes in silver and it\'s own display case.',8197,29.18,50.31),
(60,'S24_1785','1928 British Royal Navy Airplane','Planes','1:24','Classic Metal Creations','Official logos and insignias',3627,66.74,109.42),
(61,'S24_1937','1939 Chevrolet Deluxe Coupe','Vintage Cars','1:24','Motor City Art Classics','This 1:24 scale die-cast replica of the 1939 Chevrolet Deluxe Coupe has the same classy look as the original. Features opening trunk, hood and doors and a showroom quality baked enamel finish.',7332,22.57,33.19),
(62,'S24_2000','1960 BSA Gold Star DBD34','Motorcycles','1:24','Highway 66 Mini Classics','Detailed scale replica with working suspension and constructed from over 70 parts',15,37.32,76.17),
(63,'S24_2011','18th century schooner','Ships','1:24','Carousel DieCast Legends','All wood with canvas sails. Many extras including rigging, long boats, pilot house, anchors, etc. Comes with 4 masts, all square-rigged.',1898,82.34,122.89),
(64,'S24_2022','1938 Cadillac V-16 Presidential Limousine','Vintage Cars','1:24','Classic Metal Creations','This 1:24 scale precision die cast replica of the 1938 Cadillac V-16 Presidential Limousine has all the details of the original, from the flags on the front to an opening back seat compartment complete with telephone and rifle. Features factory baked-enamel black finish, hood goddess ornament, working jump seats.',2847,20.61,44.80),
(65,'S24_2300','1962 Volkswagen Microbus','Trucks and Buses','1:24','Autoart Studio Design','This 1:18 scale die cast replica of the 1962 Microbus is loaded with features: A working steering system, opening front doors and tailgate, and famous two-tone factory baked enamel finish, are all topped of by the sliding, real fabric, sunroof.',2327,61.34,127.79),
(66,'S24_2360','1982 Ducati 900 Monster','Motorcycles','1:24','Highway 66 Mini Classics','Features two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand',6840,47.10,69.26),
(67,'S24_2766','1949 Jaguar XK 120','Classic Cars','1:24','Classic Metal Creations','Precision-engineered from original Jaguar specification in perfect scale ratio. Features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',2350,47.25,90.87),
(68,'S24_2840','1958 Chevy Corvette Limited Edition','Classic Cars','1:24','Carousel DieCast Legends','The operating parts of this 1958 Chevy Corvette Limited Edition are particularly delicate due to their precise scale and require special care and attention. Features rotating wheels, working streering, opening doors and trunk. Color dark green.',2542,15.91,35.36),
(69,'S24_2841','1900s Vintage Bi-Plane','Planes','1:24','Autoart Studio Design','Hand crafted diecast-like metal bi-plane is re-created in about 1:24 scale of antique pioneer airplane. All hand-assembled with many different parts. Hand-painted in classic yellow and features correct markings of original airplane.',5942,34.25,68.51),
(70,'S24_2887','1952 Citroen-15CV','Classic Cars','1:24','Exoto Designs','Precision crafted hand-assembled 1:18 scale reproduction of the 1952 15CV, with its independent spring suspension, working steering system, opening doors and hood, detailed engine and instrument panel, all topped of with a factory fresh baked enamel finish.',1452,72.82,117.44),
(71,'S24_2972','1982 Lamborghini Diablo','Classic Cars','1:24','Second Gear Diecast','This replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',7723,16.24,37.76),
(72,'S24_3151','1912 Ford Model T Delivery Wagon','Vintage Cars','1:24','Min Lin Diecast','This model features chrome trim and grille, opening hood, opening doors, opening trunk, detailed engine, working steering system. Color white.',9173,46.91,88.51),
(73,'S24_3191','1969 Chevrolet Camaro Z28','Classic Cars','1:24','Exoto Designs','1969 Z/28 Chevy Camaro 1:24 scale replica. The operating parts of this limited edition 1:24 scale diecast model car 1969 Chevy Camaro Z28- hood, trunk, wheels, streering, suspension and doors- are particularly delicate due to their precise scale and require special care and attention.',4695,50.51,85.61),
(74,'S24_3371','1971 Alpine Renault 1600s','Classic Cars','1:24','Welly Diecast Productions','This 1971 Alpine Renault 1600s replica Features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',7995,38.58,61.23),
(75,'S24_3420','1937 Horch 930V Limousine','Vintage Cars','1:24','Autoart Studio Design','Features opening hood, opening doors, opening trunk, wide white wall tires, front door arm rests, working steering system',2902,26.30,65.75),
(76,'S24_3432','2002 Chevy Corvette','Classic Cars','1:24','Gearbox Collectibles','The operating parts of this limited edition Diecast 2002 Chevy Corvette 50th Anniversary Pace car Limited Edition are particularly delicate due to their precise scale and require special care and attention. Features rotating wheels, poseable streering, opening doors and trunk.',9446,62.11,107.08),
(77,'S24_3816','1940 Ford Delivery Sedan','Vintage Cars','1:24','Carousel DieCast Legends','Chrome Trim, Chrome Grille, Opening Hood, Opening Doors, Opening Trunk, Detailed Engine, Working Steering System. Color black.',6621,48.64,83.86),
(78,'S24_3856','1956 Porsche 356A Coupe','Classic Cars','1:18','Classic Metal Creations','Features include: Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis.',6600,98.30,140.43),
(79,'S24_3949','Corsair F4U ( Bird Cage)','Planes','1:24','Second Gear Diecast','Has retractable wheels and comes with a stand. Official logos and insignias.',6812,29.34,68.24),
(80,'S24_3969','1936 Mercedes Benz 500k Roadster','Vintage Cars','1:24','Red Start Diecast','This model features grille-mounted chrome horn, lift-up louvered hood, fold-down rumble seat, working steering system and rubber wheels. Color black.',2081,21.75,41.03),
(81,'S24_4048','1992 Porsche Cayenne Turbo Silver','Classic Cars','1:24','Exoto Designs','This replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish.',6582,69.78,118.28),
(82,'S24_4258','1936 Chrysler Airflow','Vintage Cars','1:24','Second Gear Diecast','Features opening trunk,  working steering system. Color dark green.',4710,57.46,97.39),
(83,'S24_4278','1900s Vintage Tri-Plane','Planes','1:24','Unimax Art Galleries','Hand crafted diecast-like metal Triplane is Re-created in about 1:24 scale of antique pioneer airplane. This antique style metal triplane is all hand-assembled with many different parts.',2756,36.23,72.45),
(84,'S24_4620','1961 Chevrolet Impala','Classic Cars','1:18','Classic Metal Creations','This 1:18 scale precision die-cast reproduction of the 1961 Chevrolet Impala has all the features-doors, hood and trunk that open; detailed 409 cubic-inch engine; chrome dashboard and stick shift, two-tone interior; working steering system; all topped of with a factory baked-enamel finish.',7869,32.33,80.84),
(85,'S32_1268','1980’s GM Manhattan Express','Trucks and Buses','1:32','Motor City Art Classics','This 1980’s era new look Manhattan express is still active, running from the Bronx to mid-town Manhattan. Has 35 opeining windows and working lights. Needs a battery.',5099,53.93,96.31),
(86,'S32_1374','1997 BMW F650 ST','Motorcycles','1:32','Exoto Designs','Features official die-struck logos and baked enamel finish. Comes with stand.',178,66.92,99.89),
(87,'S32_2206','1982 Ducati 996 R','Motorcycles','1:32','Gearbox Collectibles','Features rotating wheels , working kick stand. Comes with stand.',9241,24.14,40.23),
(88,'S32_2509','1954 Greyhound Scenicruiser','Trucks and Buses','1:32','Classic Metal Creations','Model features bi-level seating, 50 windows, skylights & glare resistant glass, working steering system, original logos',2874,25.98,54.11),
(89,'S32_3207','1950\'s Chicago Surface Lines Streetcar','Trains','1:32','Gearbox Collectibles','This streetcar is a joy to see. It has 80 separate windows, electric wire guides, detailed interiors with seats, poles and drivers controls, rolling and turning wheel assemblies, plus authentic factory baked-enamel finishes (Green Hornet for Chicago and Cream and Crimson for Boston).',8601,26.72,62.14),
(90,'S32_3522','1996 Peterbilt 379 Stake Bed with Outrigger','Trucks and Buses','1:32','Red Start Diecast','This model features, opening doors, detailed engine, working steering, tinted windows, detailed interior, die-struck logos, removable stakes operating outriggers, detachable second trailer, functioning 360-degree self loader, precision molded resin trailer and trim, baked enamel finish on cab',814,33.61,64.64),
(91,'S32_4289','1928 Ford Phaeton Deluxe','Vintage Cars','1:32','Highway 66 Mini Classics','This model features grille-mounted chrome horn, lift-up louvered hood, fold-down rumble seat, working steering system',136,33.02,68.79),
(92,'S32_4485','1974 Ducati 350 Mk3 Desmo','Motorcycles','1:32','Second Gear Diecast','This model features two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand',3341,56.13,102.05),
(93,'S50_1341','1930 Buick Marquette Phaeton','Vintage Cars','1:50','Studio M Art Models','Features opening trunk,  working steering system',7062,27.06,43.64),
(94,'S50_1392','Diamond T620 Semi-Skirted Tanker','Trucks and Buses','1:50','Highway 66 Mini Classics','This limited edition model is licensed and perfectly scaled for Lionel Trains. The Diamond T620 has been produced in solid precision diecast and painted with a fire baked enamel finish. It comes with a removable tanker and is a perfect model to add authenticity to your static train or car layout or to just have on display.',1016,68.29,115.75),
(95,'S50_1514','1962 City of Detroit Streetcar','Trains','1:50','Classic Metal Creations','This streetcar is a joy to see. It has 99 separate windows, electric wire guides, detailed interiors with seats, poles and drivers controls, rolling and turning wheel assemblies, plus authentic factory baked-enamel finishes (Green Hornet for Chicago and Cream and Crimson for Boston).',1645,37.49,58.58),
(96,'S50_4713','2002 Yamaha YZR M1','Motorcycles','1:50','Autoart Studio Design','Features rotating wheels , working kick stand. Comes with stand.',600,34.17,81.36),
(97,'S700_1138','The Schooner Bluenose','Ships','1:700','Autoart Studio Design','All wood with canvas sails. Measures 31 1/2 inches in Length, 22 inches High and 4 3/4 inches Wide. Many extras.\r\nThe schooner Bluenose was built in Nova Scotia in 1921 to fish the rough waters off the coast of Newfoundland. Because of the Bluenose racing prowess she became the pride of all Canadians. Still featured on stamps and the Canadian dime, the Bluenose was lost off Haiti in 1946.',1897,34.00,66.67),
(98,'S700_1691','American Airlines: B767-300','Planes','1:700','Min Lin Diecast','Exact replia with official logos and insignias and retractable wheels',5841,51.15,91.34),
(99,'S700_1938','The Mayflower','Ships','1:700','Studio M Art Models','Measures 31 1/2 inches Long x 25 1/2 inches High x 10 5/8 inches Wide\r\nAll wood with canvas sail. Extras include long boats, rigging, ladders, railing, anchors, side cannons, hand painted, etc.',737,43.30,86.61),
(100,'S700_2047','HMS Bounty','Ships','1:700','Unimax Art Galleries','Measures 30 inches Long x 27 1/2 inches High x 4 3/4 inches Wide. \r\nMany extras including rigging, long boats, pilot house, anchors, etc. Comes with three masts, all square-rigged.',3501,39.83,90.52),
(101,'S700_2466','America West Airlines B757-200','Planes','1:700','Motor City Art Classics','Official logos and insignias. Working steering system. Rotating jet engines',9653,68.80,99.72),
(102,'S700_2610','The USS Constitution Ship','Ships','1:700','Red Start Diecast','All wood with canvas sails. Measures 31 1/2\" Length x 22 3/8\" High x 8 1/4\" Width. Extras include 4 boats on deck, sea sprite on bow, anchors, copper railing, pilot houses, etc.',7083,33.97,72.28),
(103,'S700_2824','1982 Camaro Z28','Classic Cars','1:18','Carousel DieCast Legends','Features include opening and closing doors. Color: White. \r\nMeasures approximately 9 1/2\" Long.',6934,46.53,101.15),
(104,'S700_2834','ATA: B757-300','Planes','1:700','Highway 66 Mini Classics','Exact replia with official logos and insignias and retractable wheels',7106,59.33,118.65),
(105,'S700_3167','F/A 18 Hornet 1/72','Planes','1:72','Motor City Art Classics','10\" Wingspan with retractable landing gears.Comes with pilot',551,54.40,80.00),
(106,'S700_3505','The Titanic','Ships','1:700','Carousel DieCast Legends','Completed model measures 19 1/2 inches long, 9 inches high, 3inches wide and is in barn red/black. All wood and metal.',1956,51.09,100.17),
(107,'S700_3962','The Queen Mary','Ships','1:700','Welly Diecast Productions','Exact replica. Wood and Metal. Many extras including rigging, long boats, pilot house, anchors, etc. Comes with three masts, all square-rigged.',5088,53.63,99.31),
(108,'S700_4002','American Airlines: MD-11S','Planes','1:700','Second Gear Diecast','Polished finish. Exact replia with official logos and insignias and retractable wheels',8820,36.27,74.03),
(109,'S72_1253','Boeing X-32A JSF','Planes','1:72','Motor City Art Classics','10\" Wingspan with retractable landing gears.Comes with pilot',4857,32.77,49.66),
(110,'S72_3212','Pont Yacht','Ships','1:72','Unimax Art Galleries','Measures 38 inches Long x 33 3/4 inches High. Includes a stand.\r\nMany extras including rigging, long boats, pilot house, anchors, etc. Comes with 2 masts, all square-rigged',414,33.30,54.60);

/*Table structure for table `projects` */


CREATE TABLE `projects` (
  `project_id` int(11) NOT NULL AUTO_INCREMENT,
  `comp_id` int(6) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `progress` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `budjet` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `projects` */

insert  into `projects`(`project_id`,`comp_id`,`project_name`,`description`,`progress`,`start_date`,`end_date`,`budjet`) values 
(1,1,'Company Profile Web','Alice. \'Stand up and leave the court; but on the same thing as \"I eat what I eat\" is the use of a water-well,\' said the Queen, who was a general clapping of hands at this:',0,'2019-11-14','2019-11-29',200),
(2,2,'Redesign',NULL,30,'2019-11-18','2019-11-23',1500),
(3,3,'Mobile android / Ios Dev',NULL,37,'2019-11-04','2019-11-25',3200),
(4,4,'Module Extension',NULL,25,'2019-11-05','2019-11-25',150),
(5,5,'Attendance Module',NULL,90,'2019-11-11','2019-11-22',300);

/*Table structure for table `sample` */


CREATE TABLE `sample` (
  `employeeNumber` int(11) NOT NULL AUTO_INCREMENT,
  `lastName` varchar(50) NOT NULL,
  `firstName` varchar(50) NOT NULL,
  `extension` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `officeCode` varchar(10) NOT NULL,
  `reportsTo` int(11) DEFAULT NULL,
  `jobTitle` varchar(50) NOT NULL,
  `photo` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`employeeNumber`),
  KEY `reportsTo` (`reportsTo`),
  KEY `officeCode` (`officeCode`)
) ENGINE=InnoDB AUTO_INCREMENT=1703 DEFAULT CHARSET=latin1;

/*Data for the table `sample` */

insert  into `sample`(`employeeNumber`,`lastName`,`firstName`,`extension`,`email`,`officeCode`,`reportsTo`,`jobTitle`,`photo`) values 
(1002,'Murphy','Diane','x5800','dmurphy@classicmodelcars.com','1',0,'President','1573637014-85559715.jpg'),
(1056,'Patterson','Mary','x4611','mpatterso@classicmodelcars.com','1',1002,'VP Sales','1573636998-98460984.jpg'),
(1076,'Firrelli','Jeff','x9273','jfirrelli@classicmodelcars.com','1',1002,'VP Marketing','1573636647-92130539.jpg'),
(1088,'Patterson','William','x4871','wpatterson@classicmodelcars.com','6',1056,'Sales Manager (APAC)','1573636804-84407544.jpg'),
(1102,'Bondur','Gerard','x5408','gbondur@classicmodelcars.com','4',1056,'Sale Manager (EMEA)','1573636817-59008340.jpg'),
(1143,'Bow','Anthony','x5428','abow@classicmodelcars.com','1',1056,'Sales Manager (NA)','1573636829-96098230.jpg'),
(1165,'Jennings','Leslie','x3291','ljennings@classicmodelcars.com','1',1143,'Sales Rep','1573636842-61150314.jpg'),
(1166,'Thompson','Leslie','x4065','lthompson@classicmodelcars.com','1',1143,'Sales Rep','1573636906-75748756.jpg'),
(1188,'Firrelli','Julie','x2173','jfirrelli@classicmodelcars.com','2',1143,'Sales Rep','1573636969-66025880.jpg'),
(1216,'Patterson','Steve','x4334','spatterson@classicmodelcars.com','2',1143,'Sales Rep','1573637647-17713148.jpg'),
(1286,'Tseng','Foon Yue','x2248','ftseng@classicmodelcars.com','3',1143,'Sales Rep','1573637663-15449628.jpg'),
(1323,'Vanauf','George','x4102','gvanauf@classicmodelcars.com','3',1143,'Sales Rep',NULL),
(1337,'Bondur','Loui','x6493','lbondur@classicmodelcars.com','4',1102,'Sales Rep',NULL),
(1370,'Hernandez','Gerard','x2028','ghernande@classicmodelcars.com','4',1102,'Sales Rep',NULL),
(1401,'Castillo','Pamela','x2759','pcastillo@classicmodelcars.com','4',1102,'Sales Rep',NULL),
(1501,'Bott','Larry','x2311','lbott@classicmodelcars.com','7',1102,'Sales Rep',NULL),
(1504,'Jones','Barry','x102','bjones@classicmodelcars.com','7',1102,'Sales Rep','1543652639.jpeg'),
(1611,'Fixter','Andy','x101','afixter@classicmodelcars.com','6',1088,'Sales Rep','1543652571.jpeg'),
(1612,'Marsh','Peter','x102','pmarsh@classicmodelcars.com','6',1088,'Sales Rep',NULL),
(1619,'King','Tom','x103','tking@classicmodelcars.com','6',1088,'Sales Rep',NULL),
(1621,'Nishi','Mami','x101','mnishi@classicmodelcars.com','5',1056,'Sales Rep',NULL),
(1625,'Kato','Yoshimi','x102','ykato@classicmodelcars.com','5',1621,'Sales Rep',NULL),
(1702,'Gerards','Martin','x2312','mgerard@classicmodelcars.com','4',1102,'Sales Rep',NULL);

/*Table structure for table `sb_tasks` */


CREATE TABLE `sb_tasks` (
  `TaskID` int(11) NOT NULL AUTO_INCREMENT,
  `UserIDs` varchar(20) DEFAULT NULL,
  `TaskName` varchar(255) DEFAULT NULL,
  `TaskNote` text DEFAULT NULL,
  `TaskStatus` char(30) DEFAULT NULL,
  `Created` date DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `ProjectID` int(6) DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `sb_tasks` */

insert  into `sb_tasks`(`TaskID`,`UserIDs`,`TaskName`,`TaskNote`,`TaskStatus`,`Created`,`StartDate`,`EndDate`,`ProjectID`) values 
(1,'4','Create Design Concept','Please crate new design concept for this clients , should be done on next 3 days','open',NULL,'2012-05-21','2016-05-19',1),
(2,'1','Create Blue Print','Create Blue Print','active',NULL,'2016-05-24','2016-05-28',1),
(3,'4','Create Design Concept','Please crate new design concept for this clients , should be done on next 3 days','open',NULL,'2012-05-21','2016-05-19',1);

/*Table structure for table `states` */


CREATE TABLE `states` (
  `state_id` int(3) NOT NULL AUTO_INCREMENT,
  `state_name` varchar(30) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

/*Data for the table `states` */

insert  into `states`(`state_id`,`state_name`,`country_id`) values 
(1,'Nanggroe Aceh Darussalam',107),
(2,'Sumatera Utara',107),
(3,'Sumatera Barat',107),
(4,'Riau',107),
(5,'Kepulauan Riau',107),
(6,'Kepulauan Bangka-Belitung',107),
(7,'Jambi',107),
(8,'Bengkulu',107),
(9,'Sumatera Selatan',107),
(10,'Lampung',107),
(11,'Banten',107),
(12,'DKI Jakarta',107),
(13,'Jawa Barat',107),
(14,'Jawa Tengah',107),
(15,'Daerah Istimewa Yogyakarta  ',107),
(16,'Jawa Timur',107),
(17,'Bali',107),
(18,'Nusa Tenggara Barat',107),
(19,'Nusa Tenggara Timur',107),
(20,'Kalimantan Barat',107),
(21,'Kalimantan Tengah',107),
(22,'Kalimantan Selatan',107),
(23,'Kalimantan Timur',107),
(24,'Gorontalo',107),
(25,'Sulawesi Selatan',107),
(26,'Sulawesi Tenggara',107),
(27,'Sulawesi Tengah',107),
(28,'Sulawesi Utara',107),
(29,'Sulawesi Barat',107),
(30,'Maluku',107),
(31,'Maluku Utara',107),
(32,'Papua Barat',107),
(33,'Papua',107);

/*Table structure for table `sx_customers` */


CREATE TABLE `sx_customers` (
  `customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) NOT NULL,
  `address1` varchar(50) NOT NULL,
  `address2` varchar(50) DEFAULT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) DEFAULT NULL,
  `zipcode` varchar(15) DEFAULT NULL,
  `country` varchar(50) NOT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=496 DEFAULT CHARSET=latin1;

/*Data for the table `sx_customers` */

insert  into `sx_customers`(`customer_id`,`name`,`contact`,`email`,`phone`,`address1`,`address2`,`city`,`state`,`zipcode`,`country`,`logo`,`user_id`) values 
(1,'Atelier graphique','Schmitts','admin@mail.com','40.32.2555','54, rue Royale',NULL,'Nantes',NULL,'44000','France','1575603300-71143124.jpg',1),
(2,'Signal Gift Stores','King','same@mail.com','7025551838','8489 Strong St.',NULL,'Las Vegas','NV','83030','USA','1575603400-35105121.png',4),
(3,'Australian Collectors, Co.','Ferguson','acc@austria.com','03 9520 4555','636 St Kilda Road','Level 3','Melbourne','Victoria','3004','Australia','1575603423-90406014.png',1),
(4,'La Rochelle Gifts','Labrune',NULL,'40.67.8555','67, rue des Cinquante Otages',NULL,'Nantes',NULL,'44000','France',NULL,NULL),
(121,'Baane Mini Imports','Bergulfsen',NULL,'07-98 9555','Erling Skakkes gate 78',NULL,'Stavern',NULL,'4110','Norway',NULL,NULL),
(124,'Mini Gifts Distributors Ltd.','Nelson',NULL,'4155551450','5677 Strong St.',NULL,'San Rafael','CA','97562','USA',NULL,NULL),
(125,'Havel & Zbyszek Co','Piestrzeniewicz',NULL,'(26) 642-7555','ul. Filtrowa 68',NULL,'Warszawa',NULL,'01-012','Poland',NULL,NULL),
(128,'Blauer See Auto, Co.','Keitel',NULL,'+49 69 66 90 2555','Lyonerstr. 34',NULL,'Frankfurt',NULL,'60528','Germany',NULL,NULL),
(129,'Mini Wheels Co.','Murphy',NULL,'6505555787','5557 North Pendale Street',NULL,'San Francisco','CA','94217','USA',NULL,NULL),
(131,'Land of Toys Inc.','Lee',NULL,'2125557818','897 Long Airport Avenue',NULL,'NYC','NY','10022','USA',NULL,NULL),
(141,'Euro+ Shopping Channel','Freyre',NULL,'(91) 555 94 44','C/ Moralzarzal, 86',NULL,'Madrid',NULL,'28034','Spain',NULL,NULL),
(144,'Volvo Model Replicas, Co','Berglund',NULL,'0921-12 3555','Berguvsvägen  8',NULL,'Luleå',NULL,'S-958 22','Sweden',NULL,NULL),
(145,'Danish Wholesale Imports','Petersen',NULL,'31 12 3555','Vinbæltet 34',NULL,'Kobenhavn',NULL,'1734','Denmark',NULL,NULL),
(146,'Saveley & Henriot, Co.','Saveley',NULL,'78.32.5555','2, rue du Commerce',NULL,'Lyon',NULL,'69004','France',NULL,NULL),
(148,'Dragon Souveniers, Ltd.','Natividad',NULL,'+65 221 7555','Bronz Sok.','Bronz Apt. 3/6 Tesvikiye','Singapore',NULL,'079903','Singapore',NULL,NULL),
(151,'Muscle Machine Inc','Young',NULL,'2125557413','4092 Furth Circle','Suite 400','NYC','NY','10022','USA',NULL,NULL),
(157,'Diecast Classics Inc.','Leong',NULL,'2155551555','7586 Pompton St.',NULL,'Allentown','PA','70267','USA',NULL,NULL),
(161,'Technics Stores Inc.','Hashimoto',NULL,'6505556809','9408 Furth Circle',NULL,'Burlingame','CA','94217','USA',NULL,NULL),
(166,'Handji Gifts& Co','Victorino',NULL,'+65 224 1555','106 Linden Road Sandown','2nd Floor','Singapore',NULL,'069045','Singapore',NULL,NULL),
(167,'Herkku Gifts','Oeztan',NULL,'+47 2267 3215','Brehmen St. 121','PR 334 Sentrum','Bergen',NULL,'N 5804','Norway  ',NULL,NULL),
(168,'American Souvenirs Inc','Franco',NULL,'2035557845','149 Spinnaker Dr.','Suite 101','New Haven','CT','97823','USA',NULL,NULL),
(169,'Porto Imports Co.','de Castro',NULL,'(1) 356-5555','Estrada da saúde n. 58',NULL,'Lisboa',NULL,'1756','Portugal',NULL,NULL),
(171,'Daedalus Designs Imports','Rancé',NULL,'20.16.1555','184, chaussée de Tournai',NULL,'Lille',NULL,'59000','France',NULL,NULL),
(172,'La Corne D\'abondance, Co.','Bertrand',NULL,'(1) 42.34.2555','265, boulevard Charonne',NULL,'Paris',NULL,'75012','France',NULL,NULL),
(173,'Cambridge Collectables Co.','Tseng',NULL,'6175555555','4658 Baden Av.',NULL,'Cambridge','MA','51247','USA',NULL,NULL),
(175,'Gift Depot Inc.','King',NULL,'2035552570','25593 South Bay Ln.',NULL,'Bridgewater','CT','97562','USA',NULL,NULL),
(177,'Osaka Souveniers Co.','Kentary',NULL,'+81 06 6342 5555','1-6-20 Dojima',NULL,'Kita-ku','Osaka',' 530-0003','Japan',NULL,NULL),
(181,'Vitachrome Inc.','Frick',NULL,'2125551500','2678 Kingston Rd.','Suite 101','NYC','NY','10022','USA',NULL,NULL),
(186,'Toys of Finland, Co.','Karttunen',NULL,'90-224 8555','Keskuskatu 45',NULL,'Helsinki',NULL,'21240','Finland',NULL,NULL),
(187,'AV Stores, Co.','Ashworth',NULL,'(171) 555-1555','Fauntleroy Circus',NULL,'Manchester',NULL,'EC2 5NT','UK',NULL,NULL),
(189,'Clover Collections, Co.','Cassidy',NULL,'+353 1862 1555','25 Maiden Lane','Floor No. 4','Dublin',NULL,'2','Ireland',NULL,NULL),
(198,'Auto-Moto Classics Inc.','Taylor',NULL,'6175558428','16780 Pompton St.',NULL,'Brickhaven','MA','58339','USA',NULL,NULL),
(201,'UK Collectables, Ltd.','Devon',NULL,'(171) 555-2282','12, Berkeley Gardens Blvd',NULL,'Liverpool',NULL,'WX1 6LT','UK',NULL,NULL),
(202,'Canadian Gift Exchange Network','Tamuri',NULL,'(604) 555-3392','1900 Oak St.',NULL,'Vancouver','BC','V3F 2K1','Canada',NULL,NULL),
(204,'Online Mini Collectables','Barajas',NULL,'6175557555','7635 Spinnaker Dr.',NULL,'Brickhaven','MA','58339','USA',NULL,NULL),
(205,'Toys4GrownUps.com','Young',NULL,'6265557265','78934 Hillside Dr.',NULL,'Pasadena','CA','90003','USA',NULL,NULL),
(206,'Asian Shopping Network, Co','Walker',NULL,'+612 9411 1555','Suntec Tower Three','8 Temasek','Singapore',NULL,'038988','Singapore',NULL,NULL),
(209,'Mini Caravy','Citeaux',NULL,'88.60.1555','24, place Kléber',NULL,'Strasbourg',NULL,'67000','France',NULL,NULL),
(211,'King Kong Collectables, Co.','Gao',NULL,'+852 2251 1555','Bank of China Tower','1 Garden Road','Central Hong Kong',NULL,NULL,'Hong Kong',NULL,NULL),
(216,'Enaco Distributors','Saavedra',NULL,'(93) 203 4555','Rambla de Cataluña, 23',NULL,'Barcelona',NULL,'08022','Spain',NULL,NULL),
(219,'Boards & Toys Co.','Young',NULL,'3105552373','4097 Douglas Av.',NULL,'Glendale','CA','92561','USA',NULL,NULL),
(223,'Natürlich Autos','Kloss',NULL,'0372-555188','Taucherstraße 10',NULL,'Cunewalde',NULL,'01307','Germany',NULL,NULL),
(227,'Heintze Collectables','Ibsen',NULL,'86 21 3555','Smagsloget 45',NULL,'Århus',NULL,'8200','Denmark',NULL,NULL),
(233,'Québec Home Shopping Network','Fresnière',NULL,'(514) 555-8054','43 rue St. Laurent',NULL,'Montréal','Québec','H1J 1C3','Canada',NULL,NULL),
(237,'ANG Resellers','Camino',NULL,'(91) 745 6555','Gran Vía, 1',NULL,'Madrid',NULL,'28001','Spain',NULL,NULL),
(239,'Collectable Mini Designs Co.','Thompson',NULL,'7605558146','361 Furth Circle',NULL,'San Diego','CA','91217','USA',NULL,NULL),
(240,'giftsbymail.co.uk','Bennett',NULL,'(198) 555-8888','Garden House','Crowther Way 23','Cowes','Isle of Wight','PO31 7PJ','UK',NULL,NULL),
(242,'Alpha Cognac','Roulet',NULL,'61.77.6555','1 rue Alsace-Lorraine',NULL,'Toulouse',NULL,'31000','France',NULL,NULL),
(247,'Messner Shopping Network','Messner',NULL,'069-0555984','Magazinweg 7',NULL,'Frankfurt',NULL,'60528','Germany',NULL,NULL),
(249,'Amica Models & Co.','Accorti',NULL,'011-4988555','Via Monte Bianco 34',NULL,'Torino',NULL,'10100','Italy',NULL,NULL),
(250,'Lyon Souveniers','Da Silva',NULL,'+33 1 46 62 7555','27 rue du Colonel Pierre Avia',NULL,'Paris',NULL,'75508','France',NULL,NULL),
(256,'Auto Associés & Cie.','Tonini',NULL,'30.59.8555','67, avenue de l\'Europe',NULL,'Versailles',NULL,'78000','France',NULL,NULL),
(259,'Toms Spezialitäten, Ltd','Pfalzheim',NULL,'0221-5554327','Mehrheimerstr. 369',NULL,'Köln',NULL,'50739','Germany',NULL,NULL),
(260,'Royal Canadian Collectables, Ltd.','Lincoln',NULL,'(604) 555-4555','23 Tsawassen Blvd.',NULL,'Tsawassen','BC','T2F 8M4','Canada',NULL,NULL),
(273,'Franken Gifts, Co','Franken',NULL,'089-0877555','Berliner Platz 43',NULL,'München',NULL,'80805','Germany',NULL,NULL),
(276,'Anna\'s Decorations, Ltd','O\'Hara',NULL,'02 9936 8555','201 Miller Street','Level 15','North Sydney','NSW','2060','Australia',NULL,NULL),
(278,'Rovelli Gifts','Rovelli',NULL,'035-640555','Via Ludovico il Moro 22',NULL,'Bergamo',NULL,'24100','Italy',NULL,NULL),
(282,'Souveniers And Things Co.','Huxley',NULL,'+61 2 9495 8555','Monitor Money Building','815 Pacific Hwy','Chatswood','NSW','2067','Australia',NULL,NULL),
(286,'Marta\'s Replicas Co.','Hernandez',NULL,'6175558555','39323 Spinnaker Dr.',NULL,'Cambridge','MA','51247','USA',NULL,NULL),
(293,'BG&E Collectables','Harrison',NULL,'+41 26 425 50 01','Rte des Arsenaux 41 ',NULL,'Fribourg',NULL,'1700','Switzerland',NULL,NULL),
(298,'Vida Sport, Ltd','Holz',NULL,'0897-034555','Grenzacherweg 237',NULL,'Genève',NULL,'1203','Switzerland',NULL,NULL),
(299,'Norway Gifts By Mail, Co.','Klaeboe',NULL,'+47 2212 1555','Drammensveien 126A','PB 211 Sentrum','Oslo',NULL,'N 0106','Norway  ',NULL,NULL),
(303,'Schuyler Imports','Schuyler',NULL,'+31 20 491 9555','Kingsfordweg 151',NULL,'Amsterdam',NULL,'1043 GR','Netherlands',NULL,NULL),
(307,'Der Hund Imports','Andersen',NULL,'030-0074555','Obere Str. 57',NULL,'Berlin',NULL,'12209','Germany',NULL,NULL),
(311,'Oulu Toy Supplies, Inc.','Koskitalo',NULL,'981-443655','Torikatu 38',NULL,'Oulu',NULL,'90110','Finland',NULL,NULL),
(314,'Petit Auto','Dewey',NULL,'(02) 5554 67','Rue Joseph-Bens 532',NULL,'Bruxelles',NULL,'B-1180','Belgium',NULL,NULL),
(319,'Mini Classics','Frick',NULL,'9145554562','3758 North Pendale Street',NULL,'White Plains','NY','24067','USA',NULL,NULL),
(320,'Mini Creations Ltd.','Huang',NULL,'5085559555','4575 Hillside Dr.',NULL,'New Bedford','MA','50553','USA',NULL,NULL),
(321,'Corporate Gift Ideas Co.','Brown',NULL,'6505551386','7734 Strong St.',NULL,'San Francisco','CA','94217','USA',NULL,NULL),
(323,'Down Under Souveniers, Inc','Graham',NULL,'+64 9 312 5555','162-164 Grafton Road','Level 2','Auckland  ',NULL,NULL,'New Zealand',NULL,NULL),
(324,'Stylish Desk Decors, Co.','Brown',NULL,'(171) 555-0297','35 King George',NULL,'London',NULL,'WX3 6FW','UK',NULL,NULL),
(328,'Tekni Collectables Inc.','Brown',NULL,'2015559350','7476 Moss Rd.',NULL,'Newark','NJ','94019','USA',NULL,NULL),
(333,'Australian Gift Network, Co','Calaghan',NULL,'61-7-3844-6555','31 Duncan St. West End',NULL,'South Brisbane','Queensland','4101','Australia',NULL,NULL),
(334,'Suominen Souveniers','Suominen',NULL,'+358 9 8045 555','Software Engineering Center','SEC Oy','Espoo',NULL,'FIN-02271','Finland',NULL,NULL),
(335,'Cramer Spezialitäten, Ltd','Cramer',NULL,'0555-09555','Maubelstr. 90',NULL,'Brandenburg',NULL,'14776','Germany',NULL,NULL),
(339,'Classic Gift Ideas, Inc','Cervantes',NULL,'2155554695','782 First Street',NULL,'Philadelphia','PA','71270','USA',NULL,NULL),
(344,'CAF Imports','Fernandez',NULL,'+34 913 728 555','Merchants House','27-30 Merchant\'s Quay','Madrid',NULL,'28023','Spain',NULL,NULL),
(347,'Men \'R\' US Retailers, Ltd.','Chandler',NULL,'2155554369','6047 Douglas Av.',NULL,'Los Angeles','CA','91003','USA',NULL,NULL),
(348,'Asian Treasures, Inc.','McKenna',NULL,'2967 555','8 Johnstown Road',NULL,'Cork','Co. Cork',NULL,'Ireland',NULL,NULL),
(350,'Marseille Mini Autos','Lebihan',NULL,'91.24.4555','12, rue des Bouchers',NULL,'Marseille',NULL,'13008','France',NULL,NULL),
(353,'Reims Collectables','Henriot',NULL,'26.47.1555','59 rue de l\'Abbaye',NULL,'Reims',NULL,'51100','France',NULL,NULL),
(356,'SAR Distributors, Co','Kuger',NULL,'+27 21 550 3555','1250 Pretorius Street',NULL,'Hatfield','Pretoria','0028','South Africa',NULL,NULL),
(357,'GiftsForHim.com','MacKinlay',NULL,'64-9-3763555','199 Great North Road',NULL,'Auckland',NULL,NULL,'New Zealand',NULL,NULL),
(361,'Kommission Auto','Josephs',NULL,'0251-555259','Luisenstr. 48',NULL,'Münster',NULL,'44087','Germany',NULL,NULL),
(362,'Gifts4AllAges.com','Yoshido',NULL,'6175559555','8616 Spinnaker Dr.',NULL,'Boston','MA','51003','USA',NULL,NULL),
(363,'Online Diecast Creations Co.','Young',NULL,'6035558647','2304 Long Airport Avenue',NULL,'Nashua','NH','62005','USA',NULL,NULL),
(369,'Lisboa Souveniers, Inc','Rodriguez',NULL,'(1) 354-2555','Jardim das rosas n. 32',NULL,'Lisboa',NULL,'1675','Portugal',NULL,NULL),
(376,'Precious Collectables','Urs',NULL,'0452-076555','Hauptstr. 29',NULL,'Bern',NULL,'3012','Switzerland',NULL,NULL),
(379,'Collectables For Less Inc.','Nelson',NULL,'6175558555','7825 Douglas Av.',NULL,'Brickhaven','MA','58339','USA',NULL,NULL),
(381,'Royale Belge','Cartrain',NULL,'(071) 23 67 2555','Boulevard Tirou, 255',NULL,'Charleroi',NULL,'B-6000','Belgium',NULL,NULL),
(382,'Salzburg Collectables','Pipps',NULL,'6562-9555','Geislweg 14',NULL,'Salzburg',NULL,'5020','Austria',NULL,NULL),
(385,'Cruz & Sons Co.','Cruz',NULL,'+63 2 555 3587','15 McCallum Street','NatWest Center #13-03','Makati City',NULL,'1227 MM','Philippines',NULL,NULL),
(386,'L\'ordine Souveniers','Moroni',NULL,'0522-556555','Strada Provinciale 124',NULL,'Reggio Emilia',NULL,'42100','Italy',NULL,NULL),
(398,'Tokyo Collectables, Ltd','Shimamura',NULL,'+81 3 3584 0555','2-2-8 Roppongi',NULL,'Minato-ku','Tokyo','106-0032','Japan',NULL,NULL),
(406,'Auto Canal+ Petit','Perrier',NULL,'(1) 47.55.6555','25, rue Lauriston',NULL,'Paris',NULL,'75016','France',NULL,NULL),
(409,'Stuttgart Collectable Exchange','Müller',NULL,'0711-555361','Adenauerallee 900',NULL,'Stuttgart',NULL,'70563','Germany',NULL,NULL),
(412,'Extreme Desk Decorations, Ltd','McRoy',NULL,'04 499 9555','101 Lambton Quay','Level 11','Wellington',NULL,NULL,'New Zealand',NULL,NULL),
(415,'Bavarian Collectables Imports, Co.','Donnermeyer',NULL,' +49 89 61 08 9555','Hansastr. 15',NULL,'Munich',NULL,'80686','Germany',NULL,NULL),
(424,'Classic Legends Inc.','Hernandez',NULL,'2125558493','5905 Pompton St.','Suite 750','NYC','NY','10022','USA',NULL,NULL),
(443,'Feuer Online Stores, Inc','Feuer',NULL,'0342-555176','Heerstr. 22',NULL,'Leipzig',NULL,'04179','Germany',NULL,NULL),
(447,'Gift Ideas Corp.','Lewis',NULL,'2035554407','2440 Pompton St.',NULL,'Glendale','CT','97561','USA',NULL,NULL),
(448,'Scandinavian Gift Ideas','Larsson',NULL,'0695-34 6555','Åkergatan 24',NULL,'Bräcke',NULL,'S-844 67','Sweden',NULL,NULL),
(450,'The Sharp Gifts Warehouse','Frick',NULL,'4085553659','3086 Ingle Ln.',NULL,'San Jose','CA','94217','USA',NULL,NULL),
(452,'Mini Auto Werke','Mendel',NULL,'7675-3555','Kirchgasse 6',NULL,'Graz',NULL,'8010','Austria',NULL,NULL),
(455,'Super Scale Inc.','Murphy',NULL,'2035559545','567 North Pendale Street',NULL,'New Haven','CT','97823','USA',NULL,NULL),
(456,'Microscale Inc.','Choi',NULL,'2125551957','5290 North Pendale Street','Suite 200','NYC','NY','10022','USA',NULL,NULL),
(458,'Corrida Auto Replicas, Ltd','Sommer',NULL,'(91) 555 22 82','C/ Araquil, 67',NULL,'Madrid',NULL,'28023','Spain',NULL,NULL),
(459,'Warburg Exchange','Ottlieb',NULL,'0241-039123','Walserweg 21',NULL,'Aachen',NULL,'52066','Germany',NULL,NULL),
(462,'FunGiftIdeas.com','Benitez',NULL,'5085552555','1785 First Street',NULL,'New Bedford','MA','50553','USA',NULL,NULL),
(465,'Anton Designs, Ltd.','Anton',NULL,'+34 913 728555','c/ Gobelas, 19-1 Urb. La Florida',NULL,'Madrid',NULL,'28023','Spain',NULL,NULL),
(471,'Australian Collectables, Ltd','Clenahan',NULL,'61-9-3844-6555','7 Allen Street',NULL,'Glen Waverly','Victoria','3150','Australia',NULL,NULL),
(473,'Frau da Collezione','Ricotti',NULL,'+39 022515555','20093 Cologno Monzese','Alessandro Volta 16','Milan',NULL,NULL,'Italy',NULL,NULL),
(475,'West Coast Collectables Co.','Thompson',NULL,'3105553722','3675 Furth Circle',NULL,'Burbank','CA','94019','USA',NULL,NULL),
(477,'Mit Vergnügen & Co.','Moos',NULL,'0621-08555','Forsterstr. 57',NULL,'Mannheim',NULL,'68306','Germany',NULL,NULL),
(480,'Kremlin Collectables, Co.','Semenov',NULL,'+7 812 293 0521','2 Pobedy Square',NULL,'Saint Petersburg',NULL,'196143','Russia',NULL,NULL),
(481,'Raanan Stores, Inc','Altagar,G M',NULL,'+ 972 9 959 8555','3 Hagalim Blv.',NULL,'Herzlia',NULL,'47625','Israel',NULL,NULL),
(484,'Iberia Gift Imports, Corp.','Roel',NULL,'(95) 555 82 82','C/ Romero, 33',NULL,'Sevilla',NULL,'41101','Spain',NULL,NULL),
(486,'Motor Mint Distributors Inc.','Salazar',NULL,'2155559857','11328 Douglas Av.',NULL,'Philadelphia','PA','71270','USA',NULL,NULL),
(487,'Signal Collectibles Ltd.','Taylor',NULL,'4155554312','2793 Furth Circle',NULL,'Brisbane','CA','94217','USA',NULL,NULL),
(489,'Double Decker Gift Stores, Ltd','Smith',NULL,'(171) 555-7555','120 Hanover Sq.',NULL,'London',NULL,'WA1 1DP','UK',NULL,NULL),
(495,'Diecast Collectables','Franco',NULL,'6175552555','6251 Ingle Ln.',NULL,'Boston','MA','51003','USA',NULL,NULL);

/*Table structure for table `sx_invoice_items` */


CREATE TABLE `sx_invoice_items` (
  `item_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `amount` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

/*Data for the table `sx_invoice_items` */

insert  into `sx_invoice_items`(`item_id`,`invoice_id`,`item_name`,`qty`,`amount`) values 
(14,5,'TV Baru',1,400),
(15,5,'TV Baru I',1,356),
(16,5,'TV Baru II',3,546);

/*Table structure for table `sx_invoices` */


CREATE TABLE `sx_invoices` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `number` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `shipt_to` varchar(100) DEFAULT NULL,
  `ship_address` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `terms` varchar(255) DEFAULT NULL,
  `discount` decimal(10,0) DEFAULT NULL,
  `tax` decimal(10,0) DEFAULT NULL,
  `shipp` decimal(10,0) DEFAULT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `status` enum('unpaid','paid') DEFAULT 'unpaid',
  `created_at` datetime DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `sx_invoices` */

insert  into `sx_invoices`(`invoice_id`,`title`,`number`,`date`,`duedate`,`project_id`,`customer_id`,`address`,`shipt_to`,`ship_address`,`note`,`terms`,`discount`,`tax`,`shipp`,`total`,`status`,`created_at`,`sent_at`) values 
(5,'Invoice','10001','2017-02-09','2017-02-09',1,1,'51 Sandy Ave, Suite 200\r\nSan Jose, CA 91503\r\nP: (123) 456-7890        ','Mangopik LTD','51 Sandy Ave, Suite 200\r\nSan Jose, CA 91503\r\nP: (123) 456-7890 ','Thanks For Buying at ower store','Accusamus qui ratione cumque minima. Iste tempore ut sint dolorum id. Id blanditiis esse magni voluptatibus. Qui est velit aperiam consequatur.',100,25,NULL,2269,'unpaid','2019-12-13 09:43:25','2019-12-13 09:43:30'),
(7,NULL,'1002','2019-12-05','2019-12-23',2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1400,'unpaid','2019-12-13 15:58:22','2019-12-13 15:58:26');

/*Table structure for table `sx_issues` */


CREATE TABLE `sx_issues` (
  `issue_id` int(20) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `checklist_id` int(20) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `comments` longtext DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `status` enum('open','closed') DEFAULT 'open',
  `user_id` int(11) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  PRIMARY KEY (`issue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `sx_issues` */

insert  into `sx_issues`(`issue_id`,`parent_id`,`task_id`,`checklist_id`,`title`,`comments`,`label`,`status`,`user_id`,`createdOn`) values 
(1,NULL,NULL,NULL,'Error Validations',NULL,'bug','open',1,'2019-12-02 18:49:37'),
(2,NULL,NULL,NULL,'Miss spelling',NULL,NULL,'open',1,'2019-12-02 18:49:37'),
(3,NULL,NULL,NULL,'DataBase unNamed',NULL,NULL,'open',1,'2019-12-02 18:49:37'),
(4,NULL,NULL,NULL,'Alice. \'Stand up and leave the court; but on the same thing as \"I eat what I eat\" is the use of a water-well',NULL,NULL,'open',4,'2019-12-02 19:04:15');

/*Table structure for table `sx_payments` */


CREATE TABLE `sx_payments` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `payment_mode` varchar(100) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `amount` decimal(10,0) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `sx_payments` */

insert  into `sx_payments`(`payment_id`,`invoice_id`,`payment_method`,`payment_mode`,`payment_date`,`transaction_id`,`amount`,`note`,`created_at`) values 
(1,5,'Manual Transfer','Bank','2019-12-16','34252',1000,'Good Clients',NULL);

/*Table structure for table `sx_projects` */


CREATE TABLE `sx_projects` (
  `project_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(6) DEFAULT NULL,
  `team_id` int(6) DEFAULT NULL,
  `project_name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `progress` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `budjet` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `sx_projects` */

insert  into `sx_projects`(`project_id`,`customer_id`,`team_id`,`project_name`,`description`,`progress`,`start_date`,`end_date`,`budjet`) values 
(1,2,1,'Company Profile Web','<p>Alice. \'Stand up and leave the court; but on the same thing as \"I eat what I eat\" is the use of a water-well,\' said the Queen, who was a general clapping of hands at this:</p>\r\n<p>Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.</p>',0,'2019-11-14','2019-11-29',200),
(2,2,3,'Redesign','Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.',30,'2019-11-18','2019-11-23',1500),
(3,3,1,'Mobile android / Ios Dev','Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.',37,'2019-11-04','2019-11-25',3200),
(4,4,2,'Module Extension','<p><span style=\"color: rgb(33, 37, 41); display: inline !important;\">Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.</span></p><p style=\"color: rgb(33, 37, 41);\">Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.</p>',75,'2019-11-05','2019-11-25',150),
(5,1,2,'Attendance Module','<p>Alice. \'Stand up and leave the court; but on the same thing as \"I eat what I eat\" is the use of a water-well,\' said the Queen, who was a general clapping of hands at this:<br></p>',90,'2019-11-11','2019-11-22',300);

/*Table structure for table `sx_task_comments` */


CREATE TABLE `sx_task_comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `sx_task_comments` */

insert  into `sx_task_comments`(`comment_id`,`task_id`,`user_id`,`content`,`createdOn`) values 
(1,1,1,'Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.','2019-12-04 10:29:41'),
(4,1,4,'<p>Saya sangat suka sekali</p>','2019-12-04 03:46:02'),
(5,4,4,'<p>Please create greate applications for this aps</p>','2019-12-04 04:28:42'),
(7,14,1,'<p>im done with this tasks</p>','2019-12-08 08:53:18');

/*Table structure for table `sx_task_sections` */


CREATE TABLE `sx_task_sections` (
  `section_id` int(6) NOT NULL AUTO_INCREMENT,
  `project_id` int(6) DEFAULT NULL,
  `section_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

/*Data for the table `sx_task_sections` */

insert  into `sx_task_sections`(`section_id`,`project_id`,`section_name`) values 
(1,1,'Planning'),
(2,1,'Redesign'),
(3,1,'Development'),
(4,1,'Testing Unit'),
(6,2,'Another Section'),
(9,3,'Mockup creation'),
(10,3,'More Sectiona'),
(13,3,'Mobile Development'),
(14,NULL,'Dashboard Developments');

/*Table structure for table `sx_task_todo` */


CREATE TABLE `sx_task_todo` (
  `todo_id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `todo_name` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`todo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

/*Data for the table `sx_task_todo` */

insert  into `sx_task_todo`(`todo_id`,`project_id`,`task_id`,`todo_name`,`status`,`user_id`) values 
(2,1,1,'Create new MockUp','1',1),
(4,NULL,1,'new commers','1',1),
(7,NULL,4,'Please create doc UAT','1',1),
(8,NULL,4,'Please create greate applications for this aps','',4),
(9,NULL,4,'Please create greate applications for this aps','1',1),
(11,NULL,1,'Adding new API interface','',4),
(12,NULL,5,'Breakfast entry','1',1),
(13,NULL,5,'Manajemen lists','1',1),
(17,NULL,14,'good tools','',1),
(18,NULL,2,'Task 1','1',1),
(19,NULL,2,'Taski 2','1',1),
(20,NULL,2,'Task 3','1',1);

/*Table structure for table `sx_tasks` */


CREATE TABLE `sx_tasks` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(6) DEFAULT NULL,
  `section_id` int(6) DEFAULT NULL,
  `milestone_id` int(11) DEFAULT NULL,
  `task_name` varchar(255) DEFAULT NULL,
  `task_desc` text DEFAULT NULL,
  `task_status` enum('not_started','in_progress','review','completed') DEFAULT 'not_started',
  `task_priority` varchar(20) DEFAULT NULL,
  `assigned_to` varchar(100) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `followers` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

/*Data for the table `sx_tasks` */

insert  into `sx_tasks`(`task_id`,`project_id`,`section_id`,`milestone_id`,`task_name`,`task_desc`,`task_status`,`task_priority`,`assigned_to`,`start_date`,`end_date`,`created_by`,`followers`) values 
(1,1,1,NULL,'Research for design stuff','Facilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et.\r\n<p>\r\nFacilis molestiae debitis tempore vel in. Voluptas quis qui repellendus iure ut.Blanditiis labore tempore ex deserunt ut est non provident. Quia voluptas autem id libero laboriosam qui eius. Quibusdam officiis non enim voluptatem consequatur aut et. </p>\r\n\r\n','not_started','high','4','2019-11-30','2019-11-30',NULL,NULL),
(2,1,2,NULL,'Mockup New Website','Lorem ipsum dolor sit amet, consectetur adipisicing elit. Doloribus perferendis magnam fugit veritatis numquam perspiciatis. Mollitia optio vero eum velit, recusandae! Amet in consectetur expedita repellat, obcaecati non deserunt molestias.','not_started',NULL,'1','2019-12-04','2019-11-30',NULL,NULL),
(3,1,3,NULL,'Frontend Development',NULL,'not_started',NULL,'1','2019-12-01','2019-11-30',NULL,NULL),
(4,1,1,NULL,'Database Design','Lorem ipsum dolor sit amet, consectetur adipisicing elit. Doloribus perferendis magnam fugit veritatis numquam perspiciatis. Mollitia optio vero eum velit, recusandae! Amet in consectetur expedita repellat, obcaecati non deserunt molestias.','not_started',NULL,'1','2019-12-02','2019-11-30',NULL,NULL),
(5,1,1,NULL,'Setup Team',NULL,'in_progress',NULL,'4','2019-12-01','2019-11-30',NULL,NULL),
(6,1,4,NULL,'Validation Checklists',NULL,'in_progress',NULL,'4','2019-11-05','2019-11-30',NULL,NULL),
(7,1,4,NULL,'Server Checklists',NULL,'not_started',NULL,'4','2019-11-13','2019-11-30',NULL,NULL),
(8,1,4,NULL,'FlowChart Check List',NULL,'completed',NULL,'4','2019-11-27','2019-11-30',NULL,NULL),
(10,3,10,NULL,'Another great applciation','another gerat applications','in_progress',NULL,'1','2019-12-06','2019-12-16',NULL,NULL),
(11,3,10,NULL,'More Tasks','<p>More application task&nbsp; &nbsp; &nbsp;&nbsp;</p>','not_started',NULL,'4','2019-12-10','2019-12-10',NULL,NULL),
(12,3,9,NULL,'UI / UX design','<p>please create ui ux design&nbsp;&nbsp;&nbsp;&nbsp;</p>','completed',NULL,'4','2019-12-10','2019-12-14',NULL,NULL),
(13,3,9,NULL,'Dashboard Mockup','<p>please create a good one&nbsp;&nbsp;&nbsp;&nbsp;</p>','review',NULL,'1','2019-12-04','2019-11-17',NULL,NULL),
(14,3,14,NULL,'Another great applciation','Another great applciation','not_started',NULL,'1','2019-12-06','2019-12-24',NULL,NULL),
(15,3,13,NULL,'Lear React JS','Please','not_started',NULL,'1','2019-11-14','2019-12-16',NULL,NULL),
(16,3,10,NULL,'test new task inside list','test new task inside list','not_started',NULL,'4','2019-12-12','2019-11-23',NULL,NULL),
(18,1,2,NULL,'Icon Creation','<p>Icon Creation&nbsp;&nbsp;&nbsp;&nbsp;</p>','not_started',NULL,'1','2019-12-25','2019-11-26',NULL,NULL),
(19,2,6,NULL,'I Like Sximo 6 Version 6.2','Greate applicatios and im verry like its','not_started',NULL,'4','2019-12-07','2019-11-08',NULL,NULL),
(20,2,6,NULL,'Another great applciation','aassaa','not_started',NULL,'4','2019-11-18','2019-11-20',NULL,NULL),
(21,1,3,NULL,'Backlog Data','<p> Lorem ipsum dolor sit amet, consectetur adipisicing elit. Doloribus perferendis magnam fugit veritatis numquam perspiciatis. Mollitia optio vero eum velit, recusandae! Amet in consectetur expedita repellat, obcaecati non deserunt molestias.</p><p><span style=\"display: inline !important;\">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Doloribus perferendis magnam fugit veritatis numquam perspiciatis. Mollitia optio vero eum velit, recusandae! Amet in consectetur expedita repellat, obcaecati non deserunt molestias.</span><br></p>','not_started',NULL,'1','2019-12-07','2019-12-09',NULL,NULL);

/*Table structure for table `sx_teams` */


CREATE TABLE `sx_teams` (
  `team_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_ids` varchar(255) DEFAULT NULL,
  `team_leader` int(6) DEFAULT NULL,
  `team_name` varchar(255) DEFAULT NULL,
  `team_desc` text DEFAULT NULL,
  `createdOn` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedOn` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`team_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `sx_teams` */

insert  into `sx_teams`(`team_id`,`user_ids`,`team_leader`,`team_name`,`team_desc`,`createdOn`,`updatedOn`) values 
(1,'1,4',1,'Ninja CSS','<p><span style=\"display: inline !important;\">Minus fugit esse dolorem inventore. Id eveniet ipsa veniam officia culpa laudantium neque. Voluptatem nesciunt repellat itaque fugiat velit. Voluptatem aut quisquam voluptatem fugit deleniti provident. Porro</span><br></p>','2019-11-25 09:05:03','2019-11-25 09:16:02'),
(2,'4',1,'Backend Programmer','<p><span style=\"display: inline !important;\">Minus fugit esse dolorem inventore. Id eveniet ipsa veniam officia culpa laudantium neque. Voluptatem nesciunt repellat itaque fugiat velit. Voluptatem aut quisquam voluptatem fugit deleniti provident. Porro</span><br></p>','2019-11-25 09:10:44','2019-11-25 09:41:11'),
(3,'4',1,'Frontend Developer','<p><span style=\"display: inline !important;\">Minus fugit esse dolorem inventore. Id eveniet ipsa veniam officia culpa laudantium neque. Voluptatem nesciunt repellat itaque fugiat velit. Voluptatem aut quisquam voluptatem fugit deleniti provident. Porro</span><br></p>','2019-11-25 09:40:17','2019-11-25 09:40:17'),
(4,'1,4',1,'Mobile Developer','<p><span style=\"display: inline !important;\">Minus fugit esse dolorem inventore. Id eveniet ipsa veniam officia culpa laudantium neque. Voluptatem nesciunt repellat itaque fugiat velit. Voluptatem aut quisquam voluptatem fugit deleniti provident. Porro</span><br></p>','2019-11-25 09:40:17','2019-12-06 06:19:29');

/*Table structure for table `sx_tickets` */


CREATE TABLE `sx_tickets` (
  `ticke_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `assigned` varchar(20) DEFAULT NULL,
  `priority` enum('low','medium') DEFAULT 'low',
  `status` enum('Pending','Processed','Completed','New') DEFAULT 'New',
  `attachment` varchar(50) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `entry_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`ticke_id`)
) ENGINE=MyISAM AUTO_INCREMENT=371 DEFAULT CHARSET=latin1;

/*Data for the table `sx_tickets` */

insert  into `sx_tickets`(`ticke_id`,`parent_id`,`category`,`project_id`,`user_id`,`subject`,`content`,`assigned`,`priority`,`status`,`attachment`,`createdOn`,`entry_by`) values 
(30,363,NULL,NULL,2899,'teste','modulo de teste',NULL,'low','Completed',NULL,'2017-04-07 14:47:32',NULL),
(31,363,NULL,NULL,4,'Update ke Sximo 5.18','Pagi Gan,\r\n\r\nKalo mau update ke SXIMO 5.18 kemana ya? Soalnya yang saya undu di codecanyon versi 5.16. Trims',NULL,'low','Processed',NULL,'2017-04-08 02:34:18',NULL),
(32,363,NULL,NULL,583,'Next release','Do you have a date for the next release and the changes made?',NULL,'low','New',NULL,'2017-04-09 13:50:35',NULL),
(26,363,NULL,NULL,188,'Licenses','Hello,\r\nwhere are my licences?\r\n\r\nI have purchased sximo, sximo 5 LTX and the ajax plugins.\r\n\r\nPlease add to my account.\r\n\r\nJochen',NULL,'low','Completed',NULL,'2017-03-31 11:15:29',NULL),
(27,NULL,NULL,NULL,1296,'Deleted All Licences.','plz in this vercion no have any licence. plz check older bd and repair mys licences. need to work. plz',NULL,'low','Completed',NULL,'2017-04-04 05:29:55',NULL),
(28,NULL,NULL,NULL,3381,'Create New User from Dashboard','Hi,\r\n\r\nCreate new User from Dashboard is not working! We have problem with (Group / Level) Form Type Select Option Data Type Database not active! can you help me?',NULL,'low','Processed',NULL,'2017-04-05 18:53:37',NULL),
(29,NULL,NULL,NULL,386,'where can i download the free plugins','Hello dear\r\n\r\nI cannot find the plugins that used to be available to download .\r\n\r\nI am supposed to be an exclusive member sinsce i was in the old website but now i cannot find the download section any help would be apreciated\r\n\r\nThanks',NULL,'low','Processed',NULL,'2017-04-07 11:25:43',NULL),
(25,NULL,NULL,NULL,2575,'module_config','Hello,\r\nIs there a way to recreate the module_config without having to rebuild the module?\r\nI have added a couple of new fields in my table and even if I rebuild code it will give me errors.\r\nWhat exactly is the purpose of the module_config (it seems encrypted!). Can I decode it and add a couple of other properties?\r\n\r\nThanks much. This is giving me much pain because I don\'t want to reinvent the wheel since I have my module and works great.\r\nThanks much',NULL,'low','Completed',NULL,'2017-03-27 16:46:11',NULL),
(33,NULL,NULL,NULL,583,'Problems with subform','Do you have a manual from subform?\r\n\r\nI\'m trying to use this, but isn´t working.\r\n\r\nSee below\r\n\r\n![My SubForm](http://image.prntscr.com/image/2cda22cfcdbb48c48dd8dc985796ea9a.png)\r\n\r\nTable (parent table) TIPO_SEGURO\r\n![My parent table](http://image.prntscr.com/image/7de4383274bc440fa12627c08fbf05fc.png)\r\n\r\nTable (child table) TIPO_SEGURO_INFORMACAO_MODELO\r\n![My child table](http://image.prntscr.com/image/985ef15de6eb44d79a2f34585cf3e9e2.png)\r\n\r\nModule configuration\r\n![My SubForm configuration](http://image.prntscr.com/image/331bec1fc3ce4555ab259c68a894ed2c.png)\r\n\r\nWhat\'s wrong?\r\n\r\nIf you want to see, use the credentials below:\r\nURL: [https://desenvolvimento.voon.com.br/corretora/public](https://desenvolvimento.voon.com.br/corretora/public)\r\nUser: sximobuilder@sximo.com\r\nPass: sximovoon',NULL,'low','Processed',NULL,'2017-04-09 19:01:46',NULL),
(34,NULL,NULL,NULL,3395,'Purchased old version on Envato Market Web Site','I just purchased a full years support for your product \"Laravel CMS - CRUD Builder - Administrator\" on the Envato Market web site. \r\n\r\nI thought it works with the latest Laravel 5 but after downloading and reading the docs I now find out it’s based on Laravel 4 AND it’s no longer supported!\r\n\r\nI now found out that you have a separate product called \"Laravel CRUD - CMS - Sximo 5 LTS\" which uses Laravel 5.1 and is currently being supported. Is there any way I can convert my license to the Laravel 5 version of your product?\r\n\r\nThe reason I found the wrong version was because I received an email news letter (for the \"Learning Angular with Laravel 5\" book) which pointed to an article that discussed your product. It never occurred to me that the article was old (I see now that it\'s 2 years old) and was pointing to an old version of your product. This is the article:\r\n\r\nhttps://news.learninglaravel.net/l/nOT2s3e4xNHEaKn6htkiFA/7XpmQvVr4Ttu763NqCNRg41A/loYRWzLcK6FG7m763cnIblNQ\r\n\r\n\r\nthanks,\r\n\r\nPaul',NULL,'low','Processed',NULL,'2017-04-11 07:01:06',NULL),
(35,NULL,NULL,NULL,3385,'How to change size of letters in the list or make them bold as the titles','i have the DataTables GUI CRUD - Sximo 5 and  I have the necessity to more legible letters from the list either in size or converted to bold... where I can make these changes to greetings.\r\n\r\n\r\n![https://snag.gy/EGVFtp.jpg](http://)',NULL,'low','New',NULL,'2017-04-11 15:53:28',NULL),
(36,NULL,NULL,NULL,3385,'BUTTON PRINT NO DISPLAY THE IMAGES','TO THE PRECIONAS THE BUTTON PRINT GENERATED PRINT DOES NOT INCLUDE IMAGES... IS THERE ANY WAY THAT APPEAR?\r\n\r\nhttps://snag.gy/dSTrcy.jpg',NULL,'low','New',NULL,'2017-04-11 16:42:19',NULL),
(37,NULL,NULL,NULL,3399,'Query about hide ID in DataTables GUI CRUD - Sximo 5','Hello, I bought the script DataTables GUI CRUD - Sximo 5 but I can not hide the ID. Attached screen printing. Thank you very much for your help.\r\n\r\nhttps://drive.google.com/open?id=0B-EWbg-aGGlOV3V1SmNmZHU1b2s',NULL,'low','Completed',NULL,'2017-04-12 22:55:01',NULL),
(38,NULL,NULL,NULL,3399,'Get average in a table field','Hello again, I ask you if I can make a table with averages: 4 fields: 1 2 3 and in 4 show me the average (1 + 2 + 3/3) AVG(). \r\n\r\n------------------------------------\r\nfiled1 - field2 - field3 - fieldavg\r\n   1       2        3          2          \r\n\r\nIt’s possible?. Thank you very much.',NULL,'low','Processed',NULL,'2017-04-13 17:47:59',NULL),
(39,NULL,NULL,NULL,2575,'Ajax plugins bug','Hello,\r\nI have installed the latest 5.18 sximo and ajax plugins.\r\nI try to create an ajax CRUD everything works fine until I choose to view it. Then I see an empty screen (sidebards and everything else is displayed - i don\'t get any errors). what\'s wrong? Please help.',NULL,'low','Completed',NULL,'2017-04-14 14:46:39',NULL),
(40,NULL,NULL,NULL,2575,'rest api','Hello,\r\nHow can I use the rest api?\r\nWhen I edit the available ones, modules empty.. no matches found.',NULL,'low','New',NULL,'2017-04-14 15:31:30',NULL),
(41,NULL,NULL,NULL,3204,'Ajax plug-in installation','Hi Taufik,\r\nI’m trying to installa ajax plug-in following your instruction but on step 2 I can’t go.\r\nStep 2 : Composer dump-autoload\r\n\r\nNext, you need to make sure new function ajax are loaded into current sximo 5.1. \r\nif you dont have installed composer on your computer , please check this Download Composer \r\n\r\nAutoload New file.\r\n\r\nOpen your console/terminal then point to your sximo 5 installation . Next , type command as bellow.\r\n    composer dump-autoload\r\non terminal inside of sximo dir I receive this message:\r\n\r\n\r\nsh-3.2# composer dump-autoload\r\nsh: composer: command not found\r\n\r\nIf I use > php composer.phar \r\n ______\r\n  / ____/___  ____ ___  ____  ____  ________  _____\r\n / /   / __ \\/ __ `__ \\/ __ \\/ __ \\/ ___/ _ \\/ ___/\r\n/ /___/ /_/ / / / / / / /_/ / /_/ (__  )  __/ /\r\n\\____/\\____/_/ /_/ /_/ .___/\\____/____/\\___/_/\r\n                    /_/\r\nComposer version 1.4.1 2017-03-10 09:29:45\r\n\r\nUsage:\r\n  command [options] [arguments]\r\n\r\nOptions:\r\n  -h, --help                     Display this help message\r\n  -q, --quiet                    Do not output any message\r\n  -V, --version                  Display this application version\r\n      --ansi                     Force ANSI output\r\n      --no-ansi                  Disable ANSI output\r\n  -n, --no-interaction           Do not ask any interactive question\r\n      --profile                  Display timing and memory usage information\r\n      --no-plugins               Whether to disable plugins.\r\n  -d, --working-dir=WORKING-DIR  If specified, use the given directory as working directory.\r\n  -v|vv|vvv, --verbose           Increase the verbosity of messages: 1 for normal output, 2\r\n\r\ncomposer appare installed.\r\n\r\ncan you help me?',NULL,'low','Processed',NULL,'2017-04-14 18:38:30',NULL),
(42,NULL,NULL,NULL,3390,'Format  Uang Di Sximo Ajax','Siang Mang Opik.\r\n\r\nSaya coba bikin format rupiah tapi ggagal berikut screenshoot setingganya.\r\n1. Class Helpernya https://snag.gy/kUVoFn.jpg\r\n2. Setiing tablenya https://snag.gy/ECsQuP.jpg\r\n3. Hasilnya https://snag.gy/kPx5vE.jpg\r\nKira kira salah dimana sudah saya clear chace tapi tidak isa? Tolong dibantu. Terimakasih',NULL,'low','Processed',NULL,'2017-04-15 05:34:56',NULL),
(43,NULL,NULL,NULL,3406,'Can\'t install DataTables GUI CRUD - Sximo 5','Hi,\r\nI have try to insall this app but it give me 1000 error. the explain that in decumentation is not claer and I think there mistakes.\r\n\r\ncan I run it on wordpress ?\r\n\r\nand peale tell me how to install it.\r\n\r\n\r\nam tring to install it on local host using xmapp.\r\n\r\n\r\nA PHP Error was encountered\r\n\r\nSeverity: Warning\r\n\r\nMessage: mysqli::real_connect(): (HY000/1045): Access denied for user \'root\'@\'localhost\' (using password: YES)\r\n\r\nFilename: mysqli/mysqli_driver.php\r\n\r\nLine Number: 135\r\n\r\nBacktrace:\r\n\r\nFile: C:\\xampp\\htdocs\\test\\application\\core\\SB_Controller.php\r\n Line: 9\r\n Function: __construct \r\n\r\nFile: C:\\xampp\\htdocs\\test\\application\\controllers\\Page.php\r\n Line: 11\r\n Function: __construct \r\n\r\nFile: C:\\xampp\\htdocs\\test\\index.php\r\n Line: 298\r\n Function: require_once \r\n\r\n\r\nA Database Error Occurred\r\n\r\nUnable to connect to your database server using the provided settings.\r\n\r\nFilename: C:/xampp/htdocs/test/application/core/SB_Controller.php\r\n\r\nLine Number: 9\r\n\r\n\r\nRegards,',NULL,'low','Processed',NULL,'2017-04-16 11:24:46',NULL),
(44,NULL,NULL,NULL,3402,'Can not backup module','Hello - I can not backup a module. I get the following error: Illegal string offset \'name\' (View: /home/site/resources/views/sximo/module/package.blade.php). How can I fix this? I am using Sximo 5.1.8',NULL,'low','Processed',NULL,'2017-04-18 10:57:08',NULL),
(45,NULL,NULL,NULL,3402,'Ajax Plugin - not working','I installed the AJAX plugin. When I click add on a module with modal setting enable I get this error in console: Failed to load resource: the server responded with a status of 500 () - module/update?\r\nHow can I fix this?',NULL,'low','New',NULL,'2017-04-18 10:59:54',NULL),
(46,NULL,NULL,NULL,3381,'convert to pdf-files not working!!!','Whoops, looks like something went wrong. 1/1 ErrorException in style.cls.php line 1280: A non-numeric value encountered\r\n\r\nin style.cls.php line 1280\r\nat HandleExceptions->handleError(\'2\', \'A non-numeric value encountered\', \'/var/www/vhosts/xn--gdg-hckelhoven-ksb.de/vsystem/vendor/dompdf/dompdf/include/style.cls.php\', \'1280\', array(\'w\' => \'527.24850393701\', \'h\' => \'773.85850393701\', \'rTL\' => \'\', \'rTR\' => \'\', \'rBL\' => \'\', \'rBR\' => \'\')) in style.cls.php line 1280\r\nat Style->get_computed_border_radius(\'527.24850393701\', \'773.85850393701\') in block_renderer.cls.php line 42\r\nat Block_Renderer->render(object(Block_Frame_Decorator)) in renderer.cls.php line 287\r\nat Renderer->_render_frame(\'block\', object(Block_Frame_Decorator)) in renderer.cls.php line 96\r\nat Renderer->render(object(Block_Frame_Decorator)) in page_frame_reflower.cls.php line 130\r\nat Page_Frame_Reflower->reflow(null) in frame_decorator.cls.php line 711\r\nat Frame_Decorator->reflow() in dompdf.cls.php line 973\r\nat DOMPDF->render() in Dompdf.php line 70\r\nat Dompdf->render() in Dompdf.php line 88\r\nat Dompdf->show() in Controller.php line 775\r\nat Controller->getExport(object(Request), \'pdf\')\r\nat call_user_func_array(array(object(GemeindeController), \'getExport\'), array(object(Request), \'any\' => \'pdf\')) in Controller.php line 55\r\nat Controller->callAction(\'getExport\', array(object(Request), \'any\' => \'pdf\')) in ControllerDispatcher.php line 44\r\nat ControllerDispatcher->dispatch(object(Route), object(GemeindeController), \'getExport\') in Route.php line 189\r\nat Route->runController() in Route.php line 144\r\nat Route->run(object(Request)) in Router.php line 653\r\nat Router->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in IpblockedMiddleware.php line 68\r\nat IpblockedMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in SubstituteBindings.php line 41\r\nat SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in ShareErrorsFromSession.php line 49\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in StartSession.php line 64\r\nat StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in EncryptCookies.php line 59\r\nat EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Router.php line 655\r\nat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629\r\nat Router->dispatchToRoute(object(Request)) in Router.php line 607\r\nat Router->dispatch(object(Request)) in Kernel.php line 268\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Kernel.php line 150\r\nat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117\r\nat Kernel->handle(object(Request)) in index.php line 53',NULL,'low','Processed',NULL,'2017-04-18 11:37:02',NULL),
(47,NULL,NULL,NULL,3402,'Custom development','Hello - Do you do any freelance custom programming work on Sximo? What do you charge for this if you do? \r\n\r\nThank you, \r\n\r\nDrexel',NULL,'low','Processed',NULL,'2017-04-19 16:36:44',NULL),
(48,NULL,NULL,NULL,1457,'Follow-up on Refund','Dear sXimo/Sir Mangopik.\r\nI would like to follow-up the refund for my first purchase of the script. As what you have told me to choose from the options. You will tell envato to refund if I purchase the LTS.\r\nThank you!',NULL,'low','Processed',NULL,'2017-04-20 11:32:32',NULL),
(49,NULL,NULL,NULL,2642,'Postgres support','Hi,\r\n\r\nI try to use the app with postgres database, is it possible?\r\nDo you have database support for postgres?',NULL,'low','Processed',NULL,'2017-04-24 19:27:06',NULL),
(50,NULL,NULL,NULL,3403,'License register issue','Hello there\r\n\r\nI haven\'t received reply for my problem yet. \r\n\r\nProblem described below\r\n\r\nIt\'s just urgent situation now. \r\nPlease solve my issue. \r\nMy project getting delayed',NULL,'low','Completed',NULL,'2017-04-26 09:01:15',NULL),
(51,NULL,NULL,NULL,3403,'Installation on the host issue','Hey mate I got an another question about installation on web hosting. There\'s not so much described on Documentation.html Where should I find this kind of solution? I\'ve created database and uploaded all files to the bluehost server. Configured .env and other files that are mentioned on Documentation.html But I tried to via browser that says: \r\n\r\nIndex of / \r\nApache Server at www.uscarstransport.com Port 80\r\n\r\n[URL](http://www.uscarstransport.com)\r\n\r\nThank you for quick response\r\n\r\nbtw I installed successfully on local',NULL,'low','Completed',NULL,'2017-04-27 02:29:47',NULL),
(52,NULL,NULL,NULL,3414,'Problem with saving data into MySql','After filling up and submiting the form, data will not save or update into MySql database.',NULL,'low','Completed',NULL,'2017-04-27 05:17:46',NULL),
(53,NULL,NULL,NULL,3403,'Class SiteHelpers error on login page','FatalErrorException in c42c71e72155e81c07f6e659ac8bc6d5c0793fe4.php line 234:\r\n\r\n\r\n\r\n\r\nClass \'Sitehelpers\' not found\r\n\r\n\r\n\r\nhow can I fix it?',NULL,'low','Completed',NULL,'2017-04-28 02:17:04',NULL),
(54,NULL,NULL,NULL,3403,'Error on create user (tb_audits)','When I try to create user there\'s an error says \r\n\r\n\r\n\r\nSQLSTATE[42S02]: Base table or view not found: 1146 Table \'uscarsmn_uctdb.tb_audits\' doesn\'t exist (SQL: insert into `tb_audits` (`ModuleName`, `ModuleTitle`, `ModuleTable`, `ModuleKey`, `ModuleDataID`, `ModuleData`, `UserID`, `Created`, `AuditType`) values ..........\r\n\r\n\r\n\r\n\r\nEventhough user created in tb_users table\r\n\r\n\r\n\r\nI can\'t find this kind of error on discussion board.\r\n\r\n\r\n\r\n\r\nWhat is purpose of tb_audits table?\r\n\r\n\r\n\r\n\r\nCould you send me tb_audits sql?',NULL,'low','Completed',NULL,'2017-04-28 03:48:13',NULL),
(55,NULL,NULL,NULL,3399,'Not enter the home. Redirect to login.','Hello, I need you to not be able to enter the home. To be entered directly into the login.\r\n\r\nAttached sample photos: https://drive.google.com/open?id=0B0f5X_lcM2wwQTk1dzNjLXFEQ0k\r\n\r\nThank you very much.!',NULL,'low','Processed',NULL,'2017-04-29 01:58:45',NULL),
(56,NULL,NULL,NULL,737,'Sximo 5 licence','Hi,\r\n\r\n\r\nCan you add my licence code for Sximo5LTE to my account?\r\n\r\nThe Paypal Unique Transaction ID is #3UJ616112C388070D. \r\n\r\nItem Title:	Sximo 5.1 LTS Upgrade\r\nDate:	Jun 22, 2015\r\nTime:	10:13:13 PDT\r\nStatus:	Completed  \r\n\r\nThanks!\r\n\r\nBest Regards, \r\n\r\nZoltan',NULL,'low','Completed',NULL,'2017-04-29 11:04:24',NULL),
(57,NULL,NULL,NULL,214,'License Sximo 5 LTS Builder','Hello Mangopik,\r\n\r\nPlease give me download to Sximo 5 LTS Builder.\r\n\r\nThanks,\r\nJan Astary\r\n\r\nMy Licence for 5.1 LTS is: 6W403519424857020',NULL,'low','Completed',NULL,'2017-05-08 11:40:12',NULL),
(58,NULL,NULL,NULL,3431,'editable table in front end','Dear Support I installed sximo site in my developer enviroment.\r\nI add a page clienti where i see all the cusemers (see the link below)\r\nhttp://franrag.mynetgear.com:99/demo3/public/clienti\r\nis it possible in this front end page add button for add customers, edit customers, delete customers?\r\nif yes how  can i do it?\r\nThank you very much',NULL,'low','Processed',NULL,'2017-05-08 12:40:00',NULL),
(59,NULL,NULL,NULL,2655,'cannot download the newset version','unable to download the newest version of sximo builder :/',NULL,'low','Processed',NULL,'2017-05-10 04:15:34',NULL),
(60,NULL,NULL,NULL,3362,'AuditHelper','Why is the AuditHelper referencing a ‘tbaudits\' table while the db has \'tblogs‘? This causes logs to produce an error. Changing the ’tbaudits\' to \'tblogs’ also causes an error because of columns.',NULL,'low','Processed',NULL,'2017-05-10 10:21:58',NULL),
(61,NULL,NULL,NULL,2575,'5.1.9 When I resubmit the sql on any CRUD module','Hello I have the following error when I resubmit my sql code on any module.. for example \r\nhttp://dashboard.topcoupons.gr/sximo/module/sql/categorytr\r\nIt keeps spinning without anything to happen and in the console I get:\r\n\r\nFailed to load resource: the server responded with a status of 405 (Method Not Allowed)',NULL,'low','Processed',NULL,'2017-05-11 07:10:22',NULL),
(62,NULL,NULL,NULL,2575,'Bug fixed  - jqueryFIleTree fix','In 5.1.9 this is not included so you cannot edit module files on the dashboard.\r\n\r\nAdd the folder jquery.fileTree in asset->plugins->bower_components\r\nThen replace the following code in two files:\r\nviews/sximo/code/index.blade.php and \r\nviews/sximo/module/code/code.blade.php\r\n<pre>\r\n	<!-- N.R. jqueryFileTree fix -->\r\n	<script type=\"text/javascript\" src=\"{{ asset(\'assets/plugins/bower_components/jquery.fileTree/jqueryFileTree.js\') }}\"></script>\r\n	<link href=\"{{ asset(\'assets/plugins/bower_components/jquery.fileTree/jqueryFileTree.css\') }}\" rel=\"stylesheet\">\r\n	<!-- end -->\r\n</pre>',NULL,'low','Completed',NULL,'2017-05-12 09:41:53',NULL),
(63,NULL,NULL,NULL,2683,'ajax crud plugins','Hi. I was wondering if Ajax Plugins works in 5.1.9?',NULL,'low','Completed',NULL,'2017-05-13 01:07:58',NULL),
(64,NULL,NULL,NULL,2366,'Git Access for 5.9','Hi,\r\n\r\njust wondering if theres any chance of me having access to the latest build through GIT?\r\n\r\n\r\nThanks',NULL,'low','Processed',NULL,'2017-05-14 17:07:20',NULL),
(65,NULL,NULL,NULL,3447,'error upon install','Installed on Siteground server and am getting the following error upon installation. Please advise. Thanks!\r\n\r\n\r\nFatal error: Uncaught ReflectionException: Class log does not exist in /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php:741 Stack trace: #0 /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php(741): ReflectionClass->__construct(\'log\') #1 /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php(631): Illuminate\\Container\\Container->build(\'log\', Array) #2 /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(674): Illuminate\\Container\\Container->make(\'log\', Array) #3 /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php(842): Illuminate\\Foundation\\Application->make(\'log\') #4 /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php(805): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter)) #5 /home/webmaster/public_html/data/vendor/laravel/framewor in /home/webmaster/public_html/data/vendor/laravel/framework/src/Illuminate/Container/Container.php on line 741',NULL,'low','Completed',NULL,'2017-05-15 21:56:02',NULL),
(66,NULL,NULL,NULL,3445,'Multi Language Settings Bug','Hello,\r\n\r\nI just purchased your CRUD/CMS I really like it\'s potential.  I started playing around and after changing a few of the settings I logged out.  When I went to log back in I got an error on the login page:\r\n\r\nErrorException in a86ce361cd00552f0e90bdb394f237414709a053.php line 234:\r\nClass \'Sitehelpers\' not found (View: /Users/myusername/projects/tracker/resources/views/user/login.blade.php)\r\n\r\nI was able to trace this particular error down to the \'cnf_multilang\' 		=> \'0\', setting.  Setting this to \'0\' (disabled) causes the error. If I go back to the sximo.php file and change it back to \'1\' (enabled) I can log in again.\r\n\r\nI am using 5.1.8\r\n\r\nJust wanted to let you know.  Keep up the great work.  Look forward to what more you have in store for the next versions.\r\n\r\nThanks,\r\nEric',NULL,'low','Processed',NULL,'2017-05-16 00:59:50',NULL),
(67,NULL,NULL,NULL,3447,'Customize detail page','can detail Pages be customize pdatabase tablfor front end viewing?',NULL,'low','New',NULL,'2017-05-16 06:48:13',NULL),
(68,NULL,NULL,NULL,3447,'Customize detail page','can detail Pages be customize pdatabase tablfor front end viewing?',NULL,'low','New',NULL,'2017-05-16 06:48:13',NULL),
(69,NULL,NULL,NULL,737,'Download Sximo5LTE','Hello, \r\n\r\nthanks for the license. How / from where can I download the latest files? \r\n\r\nRegards, Zoltan',NULL,'low','Processed',NULL,'2017-05-16 16:56:53',NULL),
(70,NULL,NULL,NULL,3447,'Error upon logout. Can\';t log back in PLUS group select box empty for add/edit users','Please close the 2 tix open. Thanks. This is a new issue during day 2 of the product.\r\n\r\nAll I did was logout in order to try and log back in as a regular administrator instead of SUPERADMIN.\r\n\r\nI also cannot add/edit users because the group field is empty (nothing in the dropdowns).\r\n\r\nThanks for any help. Very hopeful of this product\'s utility!\r\n\r\nTim\r\n\r\nhttp://manage.downeastmaine.com/classifieds/public/user/login\r\n\r\nErrorException in ec916aa7f5e873078e683c5d1a43054442cbbb7f.php line 234:\r\nClass \'Sitehelpers\' not found (View: /home/webmaster/public_html/classifieds/resources/views/user/login.blade.php)\r\nin ec916aa7f5e873078e683c5d1a43054442cbbb7f.php line 234\r\nat CompilerEngine->handleViewException(object(FatalThrowableError), \'0\') in PhpEngine.php line 46\r\nat PhpEngine->evaluatePath(\'/home/webmaster/public_html/classifieds/storage/framework/views/ec916aa7f5e873078e683c5d1a43054442cbbb7f.php\', array(\'__env\' => object(Factory), \'app\' => object(Application), \'errors\' => object(ViewErrorBag), \'socialize\' => array(\'mailgun\' => array(\'domain\' => null, \'secret\' => null), \'ses\' => array(\'key\' => null, \'secret\' => null, \'region\' => \'us-east-1\'), \'sparkpost\' => array(\'secret\' => null), \'stripe\' => array(\'model\' => \'App\\User\', \'key\' => null, \'secret\' => null), \'google\' => array(\'client_id\' => \'1038196167526-euluve7af4mhfgde9vr79a8s1or4t8it\', \'client_secret\' => \'Z_Wq238T-bSWC5Azmyk2jSs6\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/google\'), \'twitter\' => array(\'client_id\' => \'q2NR24fPB2VtayTOMa6NDAG9s\', \'client_secret\' => \'deLBI0nVkllV1aAOrohk0X9nDJY1tognRQO2myJsGis9GnmBCY\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/twitter\'), \'facebook\' => array(\'client_id\' => \'725712687473196\', \'client_secret\' => \'97af69633d9f00e4d3d2e9929574d9e9\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/facebook\')))) in CompilerEngine.php line 59\r\nat CompilerEngine->get(\'/home/webmaster/public_html/classifieds/resources/views/user/login.blade.php\', array(\'__env\' => object(Factory), \'app\' => object(Application), \'errors\' => object(ViewErrorBag), \'socialize\' => array(\'mailgun\' => array(\'domain\' => null, \'secret\' => null), \'ses\' => array(\'key\' => null, \'secret\' => null, \'region\' => \'us-east-1\'), \'sparkpost\' => array(\'secret\' => null), \'stripe\' => array(\'model\' => \'App\\User\', \'key\' => null, \'secret\' => null), \'google\' => array(\'client_id\' => \'1038196167526-euluve7af4mhfgde9vr79a8s1or4t8it\', \'client_secret\' => \'Z_Wq238T-bSWC5Azmyk2jSs6\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/google\'), \'twitter\' => array(\'client_id\' => \'q2NR24fPB2VtayTOMa6NDAG9s\', \'client_secret\' => \'deLBI0nVkllV1aAOrohk0X9nDJY1tognRQO2myJsGis9GnmBCY\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/twitter\'), \'facebook\' => array(\'client_id\' => \'725712687473196\', \'client_secret\' => \'97af69633d9f00e4d3d2e9929574d9e9\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/facebook\')))) in View.php line 149\r\nat View->getContents() in View.php line 120\r\nat View->renderContents() in View.php line 85\r\nat View->render() in Response.php line 45\r\nat Response->setContent(object(View)) in Response.php line 201\r\nat Response->__construct(object(View)) in Router.php line 1028\r\nat Router->prepareResponse(object(Request), object(View)) in Router.php line 653\r\nat Router->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in IpblockedMiddleware.php line 68\r\nat IpblockedMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in SubstituteBindings.php line 41\r\nat SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in ShareErrorsFromSession.php line 49\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in StartSession.php line 64\r\nat StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in EncryptCookies.php line 59\r\nat EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Router.php line 655\r\nat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629\r\nat Router->dispatchToRoute(object(Request)) in Router.php line 607\r\nat Router->dispatch(object(Request)) in Kernel.php line 268\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Kernel.php line 150\r\nat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117\r\nat Kernel->handle(object(Request)) in index.php line 53\r\n1/2\r\nFatalThrowableError in ec916aa7f5e873078e683c5d1a43054442cbbb7f.php line 234:\r\nClass \'Sitehelpers\' not found\r\nin ec916aa7f5e873078e683c5d1a43054442cbbb7f.php line 234\r\nat include() in PhpEngine.php line 42\r\nat PhpEngine->evaluatePath(\'/home/webmaster/public_html/classifieds/storage/framework/views/ec916aa7f5e873078e683c5d1a43054442cbbb7f.php\', array(\'__env\' => object(Factory), \'app\' => object(Application), \'errors\' => object(ViewErrorBag), \'socialize\' => array(\'mailgun\' => array(\'domain\' => null, \'secret\' => null), \'ses\' => array(\'key\' => null, \'secret\' => null, \'region\' => \'us-east-1\'), \'sparkpost\' => array(\'secret\' => null), \'stripe\' => array(\'model\' => \'App\\User\', \'key\' => null, \'secret\' => null), \'google\' => array(\'client_id\' => \'1038196167526-euluve7af4mhfgde9vr79a8s1or4t8it\', \'client_secret\' => \'Z_Wq238T-bSWC5Azmyk2jSs6\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/google\'), \'twitter\' => array(\'client_id\' => \'q2NR24fPB2VtayTOMa6NDAG9s\', \'client_secret\' => \'deLBI0nVkllV1aAOrohk0X9nDJY1tognRQO2myJsGis9GnmBCY\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/twitter\'), \'facebook\' => array(\'client_id\' => \'725712687473196\', \'client_secret\' => \'97af69633d9f00e4d3d2e9929574d9e9\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/facebook\')))) in CompilerEngine.php line 59\r\nat CompilerEngine->get(\'/home/webmaster/public_html/classifieds/resources/views/user/login.blade.php\', array(\'__env\' => object(Factory), \'app\' => object(Application), \'errors\' => object(ViewErrorBag), \'socialize\' => array(\'mailgun\' => array(\'domain\' => null, \'secret\' => null), \'ses\' => array(\'key\' => null, \'secret\' => null, \'region\' => \'us-east-1\'), \'sparkpost\' => array(\'secret\' => null), \'stripe\' => array(\'model\' => \'App\\User\', \'key\' => null, \'secret\' => null), \'google\' => array(\'client_id\' => \'1038196167526-euluve7af4mhfgde9vr79a8s1or4t8it\', \'client_secret\' => \'Z_Wq238T-bSWC5Azmyk2jSs6\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/google\'), \'twitter\' => array(\'client_id\' => \'q2NR24fPB2VtayTOMa6NDAG9s\', \'client_secret\' => \'deLBI0nVkllV1aAOrohk0X9nDJY1tognRQO2myJsGis9GnmBCY\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/twitter\'), \'facebook\' => array(\'client_id\' => \'725712687473196\', \'client_secret\' => \'97af69633d9f00e4d3d2e9929574d9e9\', \'redirect\' => \'http://sximobuilder.com/sximodemo/sximo5/user/facebook\')))) in View.php line 149\r\nat View->getContents() in View.php line 120\r\nat View->renderContents() in View.php line 85\r\nat View->render() in Response.php line 45\r\nat Response->setContent(object(View)) in Response.php line 201\r\nat Response->__construct(object(View)) in Router.php line 1028\r\nat Router->prepareResponse(object(Request), object(View)) in Router.php line 653\r\nat Router->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in IpblockedMiddleware.php line 68\r\nat IpblockedMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in SubstituteBindings.php line 41\r\nat SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in ShareErrorsFromSession.php line 49\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in StartSession.php line 64\r\nat StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in EncryptCookies.php line 59\r\nat EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Router.php line 655\r\nat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629\r\nat Router->dispatchToRoute(object(Request)) in Router.php line 607\r\nat Router->dispatch(object(Request)) in Kernel.php line 268\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Kernel.php line 150\r\nat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117\r\nat Kernel->handle(object(Request)) in index.php line 53',NULL,'low','Processed',NULL,'2017-05-16 18:09:48',NULL),
(71,NULL,NULL,NULL,2575,'Dynamically change database','Hi,\r\nI\'d like to be able to change database dynamically from my backend. Do you think this is feasibly easily? Maybe from a dropdown in the general settings..',NULL,'low','New',NULL,'2017-05-16 18:41:08',NULL),
(72,NULL,NULL,NULL,3403,'On submitting form says class Input not found','Hello there\r\n\r\n\r\n\r\n\r\nI created a form by Form Generator and display it on frontend. Then press submit button, error occurs and it says FormHelpers.php line 156: Class \'Input\' not found.\r\n\r\n\r\nPlease help me hurry\r\n\r\nthank you',NULL,'low','Processed',NULL,'2017-05-18 06:30:27',NULL),
(73,NULL,NULL,NULL,3403,'Contact form issue','![text](http://i.imgur.com/tLjRMW0.png)',NULL,'low','Processed',NULL,'2017-05-18 06:42:55',NULL),
(74,NULL,NULL,NULL,3447,'Trying to Create a Module','Having lots of bugs. With different versions of the software I get different bugs. Very frustrating. So I\'ve started over with 5.1.9 and whenever I try to create a new CRUD module, I get the error below. It seems like perhaps the $mtype variable is awry but I really don\'t know. Note below:\r\n\'include(/home/webmaster/public_html/resources/views/sximo/module/template/*****this looks like a null value to me***/config/route.php): failed to open stream: No such file or directory\',\r\n\r\nI am near ready to give up on this software.\r\n\r\n\r\n\r\nWhoops, looks like something went wrong.\r\n\r\n1/1\r\nErrorException in ModuleController.php line 1753:\r\ninclude(/home/webmaster/public_html/resources/views/sximo/module/template//config/route.php): failed to open stream: No such file or directory\r\nin ModuleController.php line 1753\r\nat HandleExceptions->handleError(\'2\', \'include(/home/webmaster/public_html/resources/views/sximo/module/template//config/route.php): failed to open stream: No such file or directory\', \'/home/webmaster/public_html/app/Http/Controllers/Sximo/ModuleController.php\', \'1753\', array(\'rows\' => object(Collection), \'val\' => \'<?php \', \'row\' => object(stdClass), \'class\' => \'jobscontroller\', \'controller\' => \'JobscontrollerController\', \'mType\' => \'\')) in ModuleController.php line 1753\r\nat include() in ModuleController.php line 1753\r\nat ModuleController->createRouters() in ModuleController.php line 1691\r\nat ModuleController->getRebuild(object(Request), \'71\')\r\nat call_user_func_array(array(object(ModuleController), \'getRebuild\'), array(object(Request), \'any\' => \'71\')) in Controller.php line 55\r\nat Controller->callAction(\'getRebuild\', array(object(Request), \'any\' => \'71\')) in ControllerDispatcher.php line 44\r\nat ControllerDispatcher->dispatch(object(Route), object(ModuleController), \'getRebuild\') in Route.php line 189\r\nat Route->runController() in Route.php line 144\r\nat Route->run(object(Request)) in Router.php line 653\r\nat Router->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in ModuleController.php line 22\r\nat ModuleController->App\\Http\\Controllers\\Sximo\\{closure}(object(Request), object(Closure)) in Pipeline.php line 120\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in IpblockedMiddleware.php line 68\r\nat IpblockedMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in SubstituteBindings.php line 41\r\nat SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Authenticate.php line 43\r\nat Authenticate->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in ShareErrorsFromSession.php line 49\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in StartSession.php line 64\r\nat StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in EncryptCookies.php line 59\r\nat EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Router.php line 655\r\nat Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629\r\nat Router->dispatchToRoute(object(Request)) in Router.php line 607\r\nat Router->dispatch(object(Request)) in Kernel.php line 268\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request)) in Pipeline.php line 53\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request)) in Pipeline.php line 33\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request)) in Pipeline.php line 104\r\nat Pipeline->then(object(Closure)) in Kernel.php line 150\r\nat Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117\r\nat Kernel->handle(object(Request)) in index.php line 53',NULL,'low','Processed',NULL,'2017-05-19 18:07:43',NULL),
(75,NULL,NULL,NULL,3446,'Error','When I create a module and I’m going to edit records I press the apply chage button and create a new record and if I click the Save button it does the same',NULL,'low','Processed',NULL,'2017-05-19 19:18:51',NULL),
(76,NULL,NULL,NULL,3452,'Ajax Plugin','Is Ajax Plugin working with 5.1.9 ?\r\nI installed it and it messed up all files.\r\nItem purchase code: 5f7871fc-da28-45b9-9995-cb63a721527b\r\n\r\nPlease advise\r\nAhmed',NULL,'low','New',NULL,'2017-05-19 20:09:24',NULL),
(77,NULL,NULL,NULL,3452,'Native sort','Native sort not working on 5.1.9',NULL,'low','Completed',NULL,'2017-05-19 20:58:18',NULL),
(78,NULL,NULL,NULL,3403,'Date time picker','I created a form by form builder and use it on the frontend but datetimepicker isn\'t working.\r\n\r\nPlease help me',NULL,'low','New',NULL,'2017-05-22 03:55:44',NULL),
(79,NULL,NULL,NULL,3403,'iCheck javascript error','There\'s a javascript error says \"contact-us:310 Uncaught TypeError: $(...).icheck is not a function\"\r\n\r\n![text](http://imgur.com/j8V2bUB)',NULL,'low','New',NULL,'2017-05-22 10:07:53',NULL),
(80,NULL,NULL,NULL,3452,'File upload','Hi,\r\n\r\n1. The file upload allows you to upload, but there is not place where you can click to download the uploaded file.\r\n2. When you update the existing file, it creates a new record.\r\n3. When you edit, it does not show you the file you uploaded.',NULL,'low','Processed',NULL,'2017-05-22 21:22:19',NULL),
(81,NULL,NULL,NULL,3452,'TextArea with Editor','Ajax Plugin TextArea with Editor not working, just spins.',NULL,'low','New',NULL,'2017-05-22 21:30:35',NULL),
(82,NULL,NULL,NULL,2575,'Tryiing to build a site similar to sximobuilder.com','Hi,\r\nI\'m trying to build a site similar to what you have...\r\nAre you using sximo5 for it?\r\nHow do you have a dashboard that looks the same with the frontend?\r\nCan you please share some code?',NULL,'low','Processed',NULL,'2017-05-26 05:39:39',NULL),
(83,NULL,NULL,NULL,3472,'Just Purchased DataTable.NET Plugin','Hi there,\r\n\r\nJust purchased DataTable.NET Plugin but I\'m not able to download. Can you please help me to download? here is my purchase code : 6ezuwnlu-sd5a-go9e-r3rr-dazurtadmxoy \r\n\r\nThanks',NULL,'low','Processed',NULL,'2017-05-26 16:38:29',NULL),
(84,NULL,NULL,NULL,3491,'Cara Buat Module sama dengan Task (Project Modul)  Restricted Access Specific User atau ACL','Kang opik mohon bantuannya untuk case saya. ini saya kan coba yang module bonus yang project management. \r\n\r\nlalu disini bisa assign user lebih spesifik misal ke user A dan hanya user A yg bisa melihat task ini. namun ketika saya edit beberapa database,form, dan table ini tidak bisa lagi, user B bisa melihat task ini.\r\n\r\nnah yang saya butuhkan ini adalah sama dengan modul ini, namun ketika saya buat yang sama kenapa tidak bisa dilimit hanya user A yg bsa melihat data (task) yg admin buat?\r\n\r\nbagaimana caranya supaya di limit lebih spesifik ketika membuat task hanya user A yg bisa lihat (Case disini saya buat dari awal membuat tabel dan controller)\r\n\r\nNuhun kang sateacanna.\r\n\r\niman',NULL,'low','New',NULL,'2017-06-07 16:21:41',NULL),
(85,NULL,NULL,NULL,3490,'Drag and Drop Menu Not Working ??!!','i have install sximo 5.9 but have problem with menu management i can\'t make drag and drop i can\'t move menu item !!!!!!!??\r\n\r\nplease need your help',NULL,'low','Processed',NULL,'2017-06-08 13:14:13',NULL),
(86,NULL,NULL,NULL,3104,'AJAX Crud not shown','I have purchased AJAX Crud, and install as your instruction.\r\ndelete all cache and also inside storage/framework/view.\r\nbut AJAX Crud not shown there.\r\nplease help, thanks',NULL,'low','Completed',NULL,'2017-06-08 14:32:52',NULL),
(87,NULL,NULL,NULL,3502,'ajax plugin error','saya order ajax plugin, di pasang di v 5.16 ketika klik new di form gak mau, cuma muter muter saja. trus coba di pasang di v 5.1.8 dan di 5.1.9 ada error setLocale(CNF_LANG)\r\n\r\nmohon bantuannya',NULL,'low','Completed',NULL,'2017-06-13 06:33:40',NULL),
(88,NULL,NULL,NULL,3503,'Sub Form not adding items','Hello i created form with sub form but the sub form cannot add more than 1 item\r\n\r\nPlease help my url is http://tenictrading.co.za/app\r\nusername and password is still default ones\r\n\r\n![text](http://)',NULL,'low','New',NULL,'2017-06-14 03:10:06',NULL),
(89,NULL,NULL,NULL,3504,'Ajax installation','Dear sir/madam, i have purchased some of your products.\r\nI would like to ask assistance on how to install the Ajax plugin, i have tried several times and in different ways, either on version 516 that on 519 but still having white page after installation. I basically cannot access the app after updating the folders.\r\n\r\nI hav etried either completely replacing the folders, than changing or adding single files.\r\nResult is always the same.\r\nI am working locally on my computer.\r\nI will do an oline installation.\r\n\r\nPlease can you porvide assistance.\r\n\r\nOther info:\r\nCan you provide customization to realiza the tables i need, can you send a quote?\r\n\r\nBest Regards\r\nVincent',NULL,'low','New',NULL,'2017-06-14 14:31:04',NULL),
(90,NULL,NULL,NULL,3504,'Ajax installation','Dear sir/madam, i have purchased some of your products.\r\nI would like to ask assistance on how to install the Ajax plugin, i have tried several times and in different ways, either on version 516 that on 519 but still having white page after installation. I basically cannot access the app after updating the folders.\r\n\r\nI hav etried either completely replacing the folders, than changing or adding single files.\r\nResult is always the same.\r\nI am working locally on my computer.\r\nI will do an oline installation.\r\n\r\nPlease can you porvide assistance.\r\n\r\nOther info:\r\nCan you provide customization to realiza the tables i need, can you send a quote?\r\n\r\nBest Regards\r\nVincent',NULL,'low','New',NULL,'2017-06-14 14:31:07',NULL),
(91,NULL,NULL,NULL,3104,'Use of undefined constant CNF_APPNAME - assumed \'CNF_APPNAME\'','Pagi...\r\n\r\nada error ketika generate-> print invoice\r\n\r\nUse of undefined constant CNF_APPNAME - assumed \'CNF_APPNAME\' (View: D:\\htdocs\\sximo519\\resources\\views\\sinvoice\\pdf.blade.php)',NULL,'low','Processed',NULL,'2017-06-15 02:51:23',NULL),
(92,NULL,NULL,NULL,3431,'installation mac','i have problem with installation of sximo 5 on mac. Maybe it\'s a problem of permission. Can you help me?',NULL,'low','Processed',NULL,'2017-06-15 10:29:54',NULL),
(93,NULL,NULL,NULL,3507,'Installation Issue','Hi\r\n\r\nI am geting the following error immediately after installing the app in a webfolder and configuring the app.php and .env file and setting out the persmissions.\r\n\r\nI am using Lanpp on ubuntu.\r\n\r\nThis happens immediately on trying to open the app in the browser.\r\n\r\nError is get is :\r\n\r\n\r\nParse error: syntax error, unexpected \'.\', expecting \'&\' or variable (T_VARIABLE) in /opt/lampp/htdocs/app/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php on line 476\r\n\r\nThe app does not check and I do not know how to check whether the following requirements are there:\r\n\r\n? OpenSSL PHP Extension\r\n? Mbstring PHP Extension\r\n? Tokenizer PHP Extension\r\n? Module Re_write server\r\n? PHP_CURL Module Enable\r\n\r\nIs the error related to any of the above?\r\nIf yes, then how to check whether these are available or not.\r\n\r\nI have spent 8 hours trying to figure out this.\r\n\r\nThanks in advance.\r\n\r\nBest regards\r\n\r\nCJ Singh',NULL,'low','Processed',NULL,'2017-06-18 10:38:56',NULL),
(94,NULL,NULL,NULL,3104,'Differ between generated file and costumed file','Dear Tim Sximo,\r\n\r\nrequest different file between generated file and costumed file which has been changed.',NULL,'low','New',NULL,'2017-06-19 03:16:11',NULL),
(95,NULL,NULL,NULL,3502,'\"Required\" in form not work','Gan, mau nanya lagi di versi 5.1.9 , sudah di set di form requred only number tapi tetap bisa save input \"huruf\" knapa ya???',NULL,'low','New',NULL,'2017-06-20 03:11:21',NULL),
(96,NULL,NULL,NULL,1539,'Where can i download version 5.1.8','There was a seccion http://sximobuilder.com/download but now i can enter, could you help me, or if you could help me i want to use Simple To Do Management',NULL,'low','Processed',NULL,'2017-06-20 17:35:37',NULL),
(97,NULL,NULL,NULL,3206,'Form dont work','Good Morning,\r\n\r\nMy \"form layout\" dont work and i dont know why. (Attachment IMG1.JPG)![text](http://www.hd-rescue.com/images/IMG1.jpg)\r\n\r\nOther problem is my \"Form Configuration\", if i change \"type\" ou create a new field dont work the characteristics. \r\n**Example: if change \"type\" to \"text_date\" calendar does not appear, and I made the changes in Database tables to \"date\".**\r\n![text](http://www.hd-rescue.com/images/IMG2.jpg)\r\n\r\nPS: I clean cache and logs',NULL,'low','Completed',NULL,'2017-06-22 09:51:26',NULL),
(98,NULL,NULL,NULL,3510,'Project Manager Example','Can I have the ProjectManager module?\r\n\r\nThank you.',NULL,'low','Processed',NULL,'2017-06-22 10:03:11',NULL),
(99,NULL,NULL,NULL,3497,'multiple database','Hello,\r\nI\'ve purchased your script from codecanyon\r\nmy ticket id is a6713987-69b6-4add-acf7-c373bd7b3c88\r\nI would like to ask if it is possible to connect to two databases?\r\n\r\nThank you\r\n\r\nKind regards\r\n\r\nMilan',NULL,'low','Processed',NULL,'2017-06-23 14:19:02',NULL),
(100,NULL,NULL,NULL,3511,'Full Crud','I am not seeing an option to select \"Full CRUD\" when building a module. So I basically dont have the option to add/edit/delete entries in the form.',NULL,'low','Completed',NULL,'2017-06-23 23:52:27',NULL),
(101,NULL,NULL,NULL,3500,'Invoice Generator','I have bought the Sximo Builder and I have downloaded and installed the Invoice Generator module. I am not a coder but I am passionate about IT. Your software looks impressive. Keep it up !\r\n\r\n1) When you change the Qty for example and type Enter, it gives an error but does the calculation. Tab works well.\r\n\r\n2) When Print Invoice is clicked, the following error:\r\n\r\n\"FatalErrorException in SinvoiceController.php line 174:\r\nClass \'PDF\' not found\"\r\nis displayed.\r\n\r\nAlso, if that can help, I can provide corrections to some English errors.\r\n\r\nBest regards\r\nRobert',NULL,'low','Processed',NULL,'2017-06-25 13:27:07',NULL),
(102,NULL,NULL,NULL,2097,'public/core/users','im using 5.1.7 and i can create users in my admin backend with same usernames and email addresses. can you please help me fix the controller. thanks alot',NULL,'low','Processed',NULL,'2017-06-25 23:35:59',NULL),
(103,NULL,NULL,NULL,3511,'Import csv file','When I try to import a csv file, it only replaces the current records I have. It is not adding to the database.\r\n\r\nDo you know what I need to do to make the import from csv work?',NULL,'low','Completed',NULL,'2017-06-27 02:09:16',NULL),
(104,NULL,NULL,NULL,3511,'Ask for username during sign up','When I try to register / sign up for an account it is asking for the username, but there are no fields to inlcude username on the sign up page.\r\n\r\nhttps://snag.gy/tuxWhA.jpg\r\n\r\n[https://snag.gy/tuxWhA.jpg](http://)',NULL,'low','Processed',NULL,'2017-06-27 02:36:42',NULL),
(105,NULL,NULL,NULL,2760,'Error save module settings!','Hello,\r\n\r\nI would like help solving the problem below:\r\n\r\nAt some point when you save the module settings, the system redirects to the Dashboard and displays an error message. Re-run the same module configuration and save successfully.\r\n\r\nThis problem has occurred and it is disruptive to use the tool.\r\n\r\nI have already performed tests using PHP version 5.6.28 and 7.0.13 but the problem continues.\r\n\r\nCould you help me identify and solve this problem?\r\n\r\nGrateful.',NULL,'low','New',NULL,'2017-06-27 03:15:19',NULL),
(106,NULL,NULL,NULL,2760,'Erro save SUB FORM','Hello,\r\n\r\nI\'m having trouble setting up a Sub Form!\r\n\r\nI took the same steps as the video below and I did not succeed.\r\nHttps://www.youtube.com/watch?v=OUpQu1Rc5AU&index=8&list=PLnr0T4N8qJf6q2DvuzWlPEZeGTq32Eugv\r\n\r\nFollows details of the created module.\r\n\r\nM x N relationship between the Exercise and Muscular Groups tables\r\n\r\nExercise Table\r\nTable Name: Exercises\r\nFields:\r\nId (PK)\r\nTeam_id (FK team module)\r\nname\r\ndescription\r\ndifficulty\r\nimage\r\n\r\nExercise Groups\r\nName of the table: exercise_grupomuscular\r\nFields:\r\nId (PK)\r\nexercise_id (FK exercise module)\r\ngrupomuscular_id (FK muscle groups module)\r\norder\r\n\r\nMuscular Groups Table\r\nTable name: muscular_groups\r\nFields:\r\nId (PK)\r\nname\r\ndescription\r\norder\r\n\r\nSteps taken:\r\n1. Create CRUD Exercises\r\n2. Create CRUD Exercises Muscular Groups\r\n3. Edit the Exercise GRUD\r\n3.1. Add sub form with the configuration below\r\nTitle: Muscular Groups\r\nMaster Form Key: id (PK of the exercise table)\r\nTake FORM from Module: CRUD Exercises Muscular Groups\r\nSub Form Database: exercise_group\r\nSub Form Relation Key: exercicio_id (FK exercicio in the muscular-exercise table)\r\n3.2. Add Master Detail\r\nTitle: Muscular Groups\r\nMaster Key: id\r\nModule target: CRUD Exercises Muscular Groups\r\nDB Table Module Target: exercise_grupomuscular\r\nDetail Key: exerccicio_id\r\n3.3. Rebuild\r\n\r\nWhen I access the exercise registration form, the Muscle Groups Exercises form fields are displayed, I fill in the data and when saved displays the error below:\r\n\r\nhttps://drive.google.com/drive/folders/0B6F-PQeuceAXbXJ2U2xZeFFfcEU?usp=sharing\r\n\r\nCould you help me identify and solve this problem?\r\n\r\nGrateful.',NULL,'low','Processed',NULL,'2017-06-27 10:36:15',NULL),
(107,NULL,NULL,NULL,2760,'Create 2 or more subforms in the same module!','Hi, \r\n\r\nHow can I create 2 or more subforms in the same module?\r\n\r\nGrateful',NULL,'low','Completed',NULL,'2017-06-27 10:38:02',NULL),
(108,NULL,NULL,NULL,2097,'Blast Email','Hi\r\nwhat should we use in Blast Email instead of [fullname] [first_name] [last_name] [email].. Because they dont show anything..',NULL,'low','New',NULL,'2017-06-27 11:19:36',NULL),
(109,NULL,NULL,NULL,3206,'I can\'t upload multiple images','Hi,\r\n\r\nwhy i can\'t upload multiple images ?\r\ni select \"allow Multiple\", and i can\'t import multiple imagens. And i can import mutiple Files (.doc, etc) if e change to upload \"files\".\r\n\r\n\r\n![text](http://www.hd-rescue.com/images/upfiles.jpg)\r\n\r\nAnother question- Is it possible to open a page from another table in popup mode to view the data?',NULL,'low','New',NULL,'2017-06-28 09:05:41',NULL),
(110,NULL,NULL,NULL,3511,'Error when guest try to click on menu','I am getting the following error when I have a guest (no sign in) to click on a link in the front page:\r\nFatalThrowableError in HomeController.php line 76:\r\nClass \'App\\Http\\Controllers\\Lang\' not found\r\n\r\nWhen I am logged in everything works fine. BUt when I log off and try to click in the link it gives me the error.\r\n\r\nI created a table to show in the front page.',NULL,'low','Processed',NULL,'2017-06-28 12:40:55',NULL),
(111,NULL,NULL,NULL,2097,'URGENT HELP NEEDED','Hi\r\nafter completing everthing i uploaded my script to the server.. everything works fine except CLONE ( copy ) in index pages. when i try to clone a row or rows i get this error.. \r\nit still clones the row but it gives an error.i have searched everywhere and i guess it is an PDO issue with fetch all .. can u please help me.\r\nby the way it works fine on my localhost computer with no problem.\r\n\r\nscreen shot is here\r\n\r\nhttps://ibb.co/cBtmCk\r\n\r\n---\r\n\r\nmysql on localhost is 5.7.12\r\nmysql on server is 5.6.35\r\n\r\nPHP is 5.6\r\n\r\nplease help asap',NULL,'low','New',NULL,'2017-06-30 10:10:52',NULL),
(112,NULL,NULL,NULL,3511,'Logo (backend dashboard) not uploading','When I try to upload a logo (Control Panel -> General Settings -> Backend Logo) it doesnt upload with the image attached.\r\n\r\nDo you know how can i fix it?',NULL,'low','New',NULL,'2017-07-03 00:25:32',NULL),
(113,NULL,NULL,NULL,3511,'Table not reloading/refreshing after search table','After i use search option to look for a specific table/data I try to click in the \'X\' to close the search and refresh to see all data in the table but its not working. The \'x\' (close) doesnt do anything\r\n\r\n(https://snag.gy/IQB28s.jpg)',NULL,'low','New',NULL,'2017-07-03 01:13:26',NULL),
(114,NULL,NULL,NULL,3511,'Download file','I am currently able to upload a file to my form, and create a link to the file. The problem is that I can get to open the folder where the file is, but I want to have the ability to download the file instead.\r\n\r\nAlso, how can I upload PDF files?',NULL,'low','New',NULL,'2017-07-03 13:52:54',NULL),
(115,NULL,NULL,NULL,3526,'Change front end Template','Good day\r\n\r\nI have a custom eccommerce template that I would like to use on the front end of my website. I have tried following the docs for creating a custom template but I can not get this right.\r\n\r\nPlease assist and guide me as to the easiest way to achieve this',NULL,'low','New',NULL,'2017-07-03 20:14:52',NULL),
(116,NULL,NULL,NULL,3525,'Cannot find database file','According to installation instruction I will need a database file to import. However I cannot find it in the package that downloaded from codecanyon.',NULL,'low','Processed',NULL,'2017-07-05 02:37:03',NULL),
(117,NULL,NULL,NULL,3525,'Modules not working','After install the Sximo builder successfully I can access dash board and open core modules just fine.\r\n\r\nHowever I get page not found for other modules besides core and I also cannot generate a new module as I get this error\"\r\n\r\nFatalErrorException in ModuleController.php line 1677:\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'C:\\wamp64\\www\\soninsis7/resources/views/sximo/module/template//config/config.php\' (include_path=\'.;C:\\php\\pear\')',NULL,'low','Processed',NULL,'2017-07-05 04:58:15',NULL),
(118,NULL,NULL,NULL,3508,'When formatting Data Rows ( Ajax ) as function it doesn\'t load data.','I have installed version 5.1.9 with Ajax plugins. I am trying to format some rows as function like in your video https://www.youtube.com/watch?v=XjktWk1Q_OA.\r\nI have created MyHelpers.php file with MyHelpers class, added function: 	 \r\n\r\n/* Format Booking Status */\r\n	 static public function bookingStatus($b_status)\r\n	 {\r\n	 	if($b_status ==1):\r\n	 		return \'<span class=\"label label-danger\"> NEW ORDER </span>\';\r\n	 	\r\n	 	elseif($b_status ==5):\r\n	 		return \'<span class=\"label label-primary\"> CANCELLED </span>\';\r\n	 	\r\n	 	else($b_status ==3):\r\n	 		return  \'<span class=\"label label-success\"> ASSIGNED </span>\';\r\n	 	\r\n	 }\r\n	 \r\nI did run locally \'composer dump-autoload\' and uploaded files back to the server.Next I registered function in Sximo:\r\nMyHelpers|bookingStatus|booking_statuses_id\r\n\r\nAfter rebuilding I have a screen with spinning wheel, like it cannot load a table. Console shows:\r\nGET http: ... cp/public/bookings/data 500 (Internal Server Error)\r\n\r\nPlease help me on that.',NULL,'low','Processed',NULL,'2017-07-05 12:45:13',NULL),
(119,NULL,NULL,NULL,3530,'404 Errors  Ops , Page not found !','Hi\r\nI\'ve got \r\n404 Errors Ops , Page not found ! \r\nwhen i try to open any module in Sximo 5 LTS 5.1.9\r\nURL: http://localhost/sximo/public/basicform\r\nMod_rewrite is ON. I\'ve checked a permission also — it\'s OK (and i have superadmin rights)\r\nThank you very much in advance \r\nSerge',NULL,'low','Processed',NULL,'2017-07-06 11:25:51',NULL),
(120,NULL,NULL,NULL,3530,'Error when i try to add new module','Hi again\r\n\r\nI\'ve got the error when try to add new module\r\n\r\nWhoops, looks like something went wrong.\r\n\r\n1/1\r\nFatalErrorException in ModuleController.php line 1677:\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'/Applications/MAMP/htdocs/sximo/resources/views/sximo/module/template//config/config.php\' (include_path=\'.:/Applications/MAMP/bin/php/php7.1.1/lib/php\')\r\nin ModuleController.php line 1677\r\n\r\nURL: http://localhost/sximo/public/sximo/module/rebuild/62',NULL,'low','New',NULL,'2017-07-06 11:37:31',NULL),
(121,NULL,NULL,NULL,2719,'5.1.9 download','From where I can download latest version 5.1.9',NULL,'low','Processed',NULL,'2017-07-07 02:12:06',NULL),
(122,NULL,NULL,NULL,2719,'how to remove public from url?','how to remove public from url?',NULL,'low','Processed',NULL,'2017-07-07 04:00:31',NULL),
(123,NULL,NULL,NULL,3544,'Mohon Informasi Detail File Kenpa Berbeda dengan yang di Panduan  Instalasi','Mohon Informasi Detail File Kenpa Berbeda dengan yang di Panduan  Instalasi\r\n\r\nmisi mas opik, sy sudah coba download dari codecanyon setelah sy percase reguler licence. \r\ntetapi setelah sy unzip isi file tidak sama seperti yang ada di panduan instalasi. \r\napakah karena versi nya berbeda atau gimana ya....',NULL,'low','New',NULL,'2017-07-10 21:14:38',NULL),
(124,NULL,NULL,NULL,2719,'Forgot password is not working','Hi,\r\n my forgot password is not working. I am using the latest version. I got this type of link on my email http://domain.com/user/reset. \r\n \r\n Thanks',NULL,'low','Processed',NULL,'2017-07-11 14:40:19',NULL),
(125,NULL,NULL,NULL,3545,'Error 500 when i try login','Hello,\r\ni have a problem with login. When i try it with default login datas, i got 500 error.\r\nlink: http://hatasu.eu (user: tkphoto, pass: tkpass)\r\nmod_rewrite is enabled\r\n\r\nWhat is the problem, and how can i fix it?\r\n\r\nThanks!',NULL,'low','New',NULL,'2017-07-12 09:57:18',NULL),
(126,NULL,NULL,NULL,3546,'SXIMO 5 NOT WORKING','Hello, I bought Sximo 5 through envato and this is how it looks when installed?\r\n\r\nhttps://i.gyazo.com/17f592a1e0db2c449d539ac606eac5b5.png\r\n\r\nI followed all instructions',NULL,'low','New',NULL,'2017-07-12 14:14:08',NULL),
(127,NULL,NULL,NULL,3553,'Rest API For Datatable how to install','I purchased the Rest API For Datatable but I went to the repository and downloaded it. I am not sure how to install it. Please help.\r\n\r\nThank you,\r\n\r\n-Jason',NULL,'low','New',NULL,'2017-07-18 22:21:04',NULL),
(128,NULL,NULL,NULL,3559,'error line 1677','gan ini kenapa ko ketika create module baru .aku klik save jadi kluar error gini\r\n\r\nFatalErrorException in ModuleController.php line 1677:\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'D:\\xampp\\htdocs\\app/resources/views/sximo/module/template//config/config.php\' (include_path=\'D:\\xampp\\php\\PEAR\')\r\n\r\ncara benerinnya gmn ya',NULL,'low','New',NULL,'2017-07-22 08:56:46',NULL),
(129,NULL,NULL,NULL,583,'Calendar','Do you have a date for the next release and the changes made?',NULL,'low','New',NULL,'2017-07-30 16:37:56',NULL),
(130,NULL,NULL,NULL,3502,'bug validate di versi 5.1.9 ?','Gan, updatenya gimana?? masih perlu waktu kah???atau sudah ada update versinya??? yg fixed bug validate',NULL,'low','New',NULL,'2017-07-31 08:58:35',NULL),
(131,NULL,NULL,NULL,1521,'AJAX Plugin Doesn\'t Work with SXIMO 5 !','mango - trying to get 5.1.9 and ajax plugin to work togather but no joy. Per message on codecanyon page:\r\n\r\nI installed 519 and Ajax plugin (based on PHP 5.6 and 7) and get the below error:\r\n\r\nUse of undefined constant CNF_LANG – assumed ‘CNF_LANG’\r\n\r\nWhat is going on ?\r\n\r\nSteve\r\n\r\nPlease advise...',NULL,'low','New',NULL,'2017-08-01 12:15:29',NULL),
(132,NULL,NULL,NULL,3571,'Add/Update form not updating on rebuild','I did the following:\r\n1) Created table with id (primary key, INT) 2) added field for \"FirstName\" (varchar(128) 3) Created module in SXIMO, kept id as SHOW, but set to hidden 4) Rebuilt module 5) viewed module, saw that everything was working fine 6) added column in table for lastname 7) went to SXIM, on SQL tab, clicked Save SQL 8) saw that lastname was there for table and form 9) rebuilt 10) viewed module. no last name field in form, only in table.\r\nI am tearing my hair out here. I have verified permissions, everything. Table updates fine but the last name never shows on the add/update form.\r\nOne note: I looked at the source for the page and last name is there but when I do \"inspect\" it isn\'t. Assuming there is a JS script somewhere hiding it.\r\nHELP!\r\nThanks, Sean',NULL,'low','Processed',NULL,'2017-08-02 00:11:23',NULL),
(133,NULL,NULL,NULL,2760,'Erro save SUB FORM','Hello, I\'m having trouble setting up a Sub Form! I took the same steps as the video below and I did not succeed. Https://www.youtube.com/watch?v=OUpQu1Rc5AU&index=8&list=PLnr0T4N8qJf6q2DvuzWlPEZeGTq32Eugv Follows details of the created module. M x N relationship between the Exercise and Muscular Groups tables Exercise Table Table Name: Exercises Fields: Id (PK) Team_id (FK team module) name description difficulty image Exercise Groups Name of the table: exercise_grupomuscular Fields: Id (PK) exercise_id (FK exercise module) grupomuscular_id (FK muscle groups module) order Muscular Groups Table Table name: muscular_groups Fields: Id (PK) name description order Steps taken:\r\nCreate CRUD Exercises\r\nCreate CRUD Exercises Muscular Groups\r\nEdit the Exercise GRUD\r\n3.1. Add sub form with the configuration below Title: Muscular Groups Master Form Key: id (PK of the exercise table) Take FORM from Module: CRUD Exercises Muscular Groups Sub Form Database: exercise_group Sub Form Relation Key: exercicio_id (FK exercicio in the muscular-exercise table) 3.2. Add Master Detail Title: Muscular Groups Master Key: id Module target: CRUD Exercises Muscular Groups DB Table Module Target: exercise_grupomuscular Detail Key: exerccicio_id 3.3. Rebuild When I access the exercise registration form, the Muscle Groups Exercises form fields are displayed, I fill in the data and when saved displays the error below: https://drive.google.com/drive/folders/0B6F-PQeuceAXbXJ2U2xZeFFfcEU?usp=sharing Could you help me identify and solve this problem? Grateful.\r\n\r\n\r\nCan you paste here the schema both database tables ?\r\n\r\nHi, In the link below you will find all files related to the project.\r\nDatabase sql file;\r\nDatabese PNG file;\r\nDatabase model file workbeanch;\r\nProject sximo\r\nhttps://drive.google.com/drive/folders/0B6F-PQeuceAXbXJ2U2xZeFFfcEU?usp=sharing Thank you for your help.',NULL,'low','New',NULL,'2017-08-02 23:07:14',NULL),
(134,NULL,NULL,NULL,2847,'HELP!!!','FatalErrorException in ModuleController.php line 1677:\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'D:\\laragon\\www\\bibliotecavirtualLaravel/resources/views/sximo/module/template//config/config.php\' (include_path=\'.;C:/laragon/etc/php/pear\')',NULL,'low','New',NULL,'2017-08-03 22:09:12',NULL),
(135,NULL,NULL,NULL,3576,'Select with entry_by','Halo mang opix, bagaimana caranya agar select di form hanya menampilkan data berdasarkan entry_by, karen entry_by hanya berfunsi di table, saat saya coba buat select di form, data yg muncul semua data bukan di filter berdasarkan entry_by.\r\n\r\nThanks',NULL,'low','New',NULL,'2017-08-04 16:12:36',NULL),
(136,NULL,NULL,NULL,1467,'version 5.17 sximobuilder newly installed, module generator doesn\'t work well','Problems:\r\n\r\n1. Tried to rebuild exsit moduels, such as simplecalendar, after rebuild, looks like the route file are not updated.\r\n2. Create new modules failed for CURD.\r\n3. Can\'t backup old modules.',NULL,'low','Processed',NULL,'2017-08-05 01:47:46',NULL),
(137,NULL,NULL,NULL,3290,'Sximo 5.1.9 HAS ISSUES','Hi,\r\n\r\nI had sximo 5.1.8 but the source was lost and i cannot find it on downloads\r\nSecond I have tried to use sximo laravel v5.1.9 but it has alot of bugs\r\nAll Addon plugins does not work such as employees- support - customers\r\nAll getting 404 Not found page Error\r\n\r\nPlease help for the both issues\r\nRegards\r\nAbdelrahman Farag',NULL,'low','Processed',NULL,'2017-08-06 20:19:55',NULL),
(138,NULL,NULL,NULL,3579,'Payment Plugin','I just bought you a plugin and paid. But I have nothing. What happens?',NULL,'low','Processed',NULL,'2017-08-10 17:12:43',NULL),
(139,NULL,NULL,NULL,3492,'Editor not showing on textarea with editor','Editor not showing on \"textarea with editor\" field type',NULL,'low','Processed',NULL,'2017-08-11 14:18:15',NULL),
(140,NULL,NULL,NULL,327,'Laravel - RESTfull API Client & Server','Hi I purchased Laravel - RESTfull API Client & Server plugin for Sximo 5 LTS which us really useless there is no use of this plugin i wasted my $8, I am unable to work with REST api. Kindly give my money back. \r\n\r\nThanks,\r\nAli',NULL,'low','New',NULL,'2017-08-16 16:13:30',NULL),
(141,NULL,NULL,NULL,1007,'No found my key of SXIMO 5.1 LTS','--------------------------------------------\r\nRE: SXIMO 5.1 LTS No link\r\nM\r\nMarco Joe Alegría Vásquez\r\n\r\n\r\n  Responder|\r\nmar 30/06/2015, 09:16 a.m.\r\nTaufik firmansyah (kangopik@gmail.com) \r\nElementos enviados\r\n\r\n\r\n2 archivos adjuntos (289 KB)  Descargar todo  Guardar todo en OneDrive - Personal\r\nDear Sximo Builder\r\n\r\nI bought the 5.1 update but the link does not exist. Please appreciate  provide a valid link to work with SXIMO 5.1 LTS.\r\n\r\nhttp://sximobuilde.com/uploads/src/sximo-5-1-lts-beta.zip\r\n\r\nAttachment 2 files.\r\n\r\nKind Regard.\r\n--------------------------------------------',NULL,'low','Processed',NULL,'2017-08-17 04:25:43',NULL),
(142,NULL,NULL,NULL,2719,'Learn Themes','How can I download Learn Themes  theme?',NULL,'low','Processed',NULL,'2017-08-22 16:29:03',NULL),
(143,NULL,NULL,NULL,3506,'Password hash algorithm','Hi,\r\nKindly provide the Password Hash algorithm used for the User authentication as i need to use the tb_users table in my other application developed and connected to the sximo database',NULL,'low','Processed',NULL,'2017-08-23 06:10:52',NULL),
(144,NULL,NULL,NULL,2365,'GIT Access','Hi,\r\n\r\nAsked for this a few times and requested access again las week and still no feedback?',NULL,'low','Processed',NULL,'2017-08-24 17:12:02',NULL),
(145,NULL,NULL,NULL,3362,'Forms with File Uploads','Creating a form with file upload is working. But when editing an entry with images/files, the files field come up empty.',NULL,'low','New',NULL,'2017-08-28 23:37:43',NULL),
(146,NULL,NULL,NULL,3508,'Total 1 result and no pagination when using GROUP BY','I am using version 5.1.9 with Ajax plugins. When I create simple module for example listing nationalities it shows correctly total and pagination under the table. When I use \'GROUP BY\', the Total is 1 and no pagination. \r\n\r\n\r\npublic static function querySelect(  ) {\r\n    return \" SELECT nationalities.* ,\r\n        count(interpreters.nationality) AS Interpreters\r\n    FROM nationalities\r\n	LEFT JOIN interpreters ON interpreters.nationality = nationalities.id \";\r\n	}	\r\n	public static function queryWhere(  ){\r\n		return \"  WHERE nationalities.id IS NOT NULL \";\r\n	}\r\n	public static function queryGroup(){\r\n		return \" GROUP BY nationalities.id \";\r\n	}\r\n	\r\n	\r\nWhat would be the quickest way to fix it?\r\nThank you.',NULL,'low','Processed',NULL,'2017-08-31 09:54:54',NULL),
(147,NULL,NULL,NULL,3508,'Database select not working for the generated forms.','When I generate a form with Form Generator and set up fields as Data Type: Database, the dropdown isn\'t populated with the records from db.\r\n\r\nConsole:\r\n\r\npost/comboselect?filter=languages:id:language Failed to load resource: the server responded with a status of 404 (Not Found)\r\npost/comboselect?filter=areas:id:name Failed to load resource: the server responded with a status of 404 (Not Found)',NULL,'low','Processed',NULL,'2017-08-31 11:55:01',NULL),
(148,NULL,NULL,NULL,3492,'SXIMO 5 LARAVEL','When trying to upload files in file manager, I get the error:\r\n\r\nunable to connect to backend.\r\n\r\non debugger get the message:\r\nelfinder\r\nFailed to load resource: the server responded with a status of 405 (Method Not Allowed)\r\n\r\nplz i need help',NULL,'low','New',NULL,'2017-09-01 02:10:45',NULL),
(149,NULL,NULL,NULL,3581,'invoice generator','Hi, i purchased the sximo 5 system , and would like to download invoice generator, but it shows me this error\r\n\r\nYou already have licence for this item !\r\nerror',NULL,'low','Processed',NULL,'2017-09-04 04:05:31',NULL),
(150,NULL,NULL,NULL,1314,'upgrade','Can I upgrade Laravel CRUD - CMS - Sximo 5 LTS\r\nI bought it before and never use it\r\nThanks',NULL,'low','Processed',NULL,'2017-09-04 09:16:53',NULL),
(151,NULL,NULL,NULL,3399,'Delete front page FrontEnd DataTable CodeIgniter','Hello, please, I need the system to go directly to the login. I do not want anyone to enter the main page. How should I do it?. It does not work for me to disable the frontend because the page keeps popping up. Thank you very much.',NULL,'low','New',NULL,'2017-09-07 12:26:04',NULL),
(152,NULL,NULL,NULL,3508,'Downloading Users - ReflectionException in Route.php line 333:','When I try to download users I get an error:\r\n\r\nReflectionException in Route.php line 333:\r\nMethod App\\Http\\Controllers\\core\\UsersController::getDownload() does not exist',NULL,'low','New',NULL,'2017-09-15 08:50:52',NULL),
(153,NULL,NULL,NULL,3508,'User is able to export global records despite restricted access.','When logged in as a user with permissions set to access only own records, exporting to Excel, pdf, etc. includes all the records of all users.',NULL,'low','New',NULL,'2017-09-15 09:25:35',NULL),
(154,NULL,NULL,NULL,3508,'Unique email validation - How to ignore a given ID when updating a record.','I have a table with contacts and would like to make sure that email adresses are not repeated. I can add unique email validation and it works fine:\r\n\r\n$rules = $this->validateForm();\r\n$rules[\'email\'] = \'required|unique:interpreters,email,NULL,1’;\r\n\r\nThe problem is that, when I want to update the record, for example add  mobile number, on save it throws that the email already exists.\r\nThat problem is described here:\r\n\r\nhttps://laracasts.com/discuss/channels/laravel/forcing-a-unique-rule-to-ignore-a-given-id',NULL,'low','New',NULL,'2017-09-15 09:33:47',NULL),
(155,NULL,NULL,NULL,2097,'Gallery PRO','Hi \r\ni have just purchased the Gallery PRO but i cant download.can you help please urgently\r\nthanks',NULL,'low','New',NULL,'2017-10-08 14:32:09',NULL),
(156,NULL,NULL,NULL,3670,'404 Error on all Modules','Installed on Mac localhost with mamp.\r\n\r\nAll Modules show 404 error\r\n\r\nWhen trying to create a module, I get this error\r\nWhoops, looks like something went wrong.\r\n\r\n1/1\r\nFatalErrorException in ModuleController.php line 1677:\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'/Applications/mampstack-7.0.23-0/apache2/htdocs/sximo/resources/views/sximo/module/template//config/config.php\' (include_path=\'.:/Applications/mampstack-7.0.23-0/php/lib/php\')\r\n\r\nSomething tells me this is a simple fix.',NULL,'low','Processed',NULL,'2017-10-10 01:15:11',NULL),
(157,NULL,NULL,NULL,1910,'Pagination not aviailable in rest api','Please send me a solution for the same in sximoapicontroller',NULL,'low','New',NULL,'2017-10-10 14:56:32',NULL),
(168,NULL,NULL,NULL,2864,'Cannot Buy Ultimate Version','Hi,\r\n\r\nWe was talking on chat. Cannot buy upgrade. Could you please help me?\r\n\r\nThank you',NULL,'low','Processed',NULL,'2017-10-18 07:05:02',NULL),
(159,NULL,NULL,NULL,2116,'where is the download ultimate-sximo-5 source ?','I purchase the code. after payment, no where to download the code.\r\n\r\nThank you.',NULL,'low','Processed',NULL,'2017-10-14 13:13:20',NULL),
(160,NULL,NULL,NULL,3425,'Question About sximo laravel','Hi, \r\nI have one question how to seup 2 databes (write and read) in shimo ?\r\n\r\nThanks',NULL,'low','New',NULL,'2017-10-14 18:04:35',NULL),
(165,NULL,NULL,NULL,2768,'Hello','I purchase CrudEngine Class. Is this a addon for Ultimate Sximo Builder 5? I think no.\r\nI can return Engine Class?\r\n\r\nRegards Wittig',NULL,'low','Processed',NULL,'2017-10-15 14:45:34',NULL),
(166,NULL,NULL,NULL,3670,'All Modules I create result in spinning wheel when trying to add new records','Whenver i create a new record, I get the unending spinning wheel. Sometimes the record gets added into the database, but most of the time not.\r\n\r\nPlease advise. This seems to be my only outstanding issue to utilize ULTIMATE.',NULL,'low','New',NULL,'2017-10-17 01:34:14',NULL),
(167,NULL,NULL,NULL,59,'If possible to sale sximo5.net script cart system','Dear support\r\n\r\n    If possible to sale script cart module same sximo5.net',NULL,'low','New',NULL,'2017-10-17 12:47:46',NULL),
(169,NULL,NULL,NULL,593,'Datatable Error - REST API Generator','See attached for the error displayed when I clicked on the REST API Generator button after installing Ultimate Sximo 5. Please help fix\r\n\r\n![Error](http://goo.gl/ip2ZhK)',NULL,'low','New',NULL,'2017-10-18 11:05:41',NULL),
(170,NULL,NULL,NULL,593,'Datatable Error - REST API Generator','See attached for the error displayed when I clicked on the REST API Generator button after installing Ultimate Sximo 5. Please help fix\r\n\r\n![Error](http://goo.gl/ip2ZhK)',NULL,'low','New',NULL,'2017-10-18 11:05:44',NULL),
(171,NULL,NULL,NULL,2097,'Sximo6','http://sximo6.sximobuilder.com/\r\n\r\nwhere can i download this one?\r\nthanks',NULL,'low','New',NULL,'2017-10-19 13:41:06',NULL),
(172,NULL,NULL,NULL,2601,'Help in Downloading the Ultimate Version of Sximo','Hello,\r\n\r\nNeed assistance in downloading the sximo utimate version. I already inputted my sximo 5 LTS license from codecanyon in here. Do i need to purchase anything else for me to download the ultimate version?\r\n\r\nThanks, \r\n\r\nCaleb',NULL,'low','New',NULL,'2017-10-19 14:29:00',NULL),
(173,NULL,NULL,NULL,3695,'DataTables warning: table id=CrudEngine-UsersTable - Ajax error. For more information about this error, please see http://datatables.net/tn/7','Hello Sximo,\r\n\r\nWhen i go to Administrator - Users i get this error: DataTables warning: table id=CrudEngine-UsersTable - Ajax error. For more information about this error, please see http://datatables.net/tn/7\r\n\r\nI have this problem in Chrome and Firefox. I work on WIndows 7, Xampp 3.2.2\r\n\r\nCan you help?\r\n\r\nGReetings,\r\n\r\nPatrick',NULL,'low','New',NULL,'2017-10-20 08:16:50',NULL),
(174,NULL,NULL,NULL,3695,'How to update to new version?','Hello Sximo,\r\n\r\nHow must i update to new version? I cannot find in wiki?\r\n\r\nGreetings,\r\n\r\nPatrick',NULL,'low','Completed',NULL,'2017-10-20 21:11:36',NULL),
(175,NULL,NULL,NULL,3695,'How to update to new version?','Hello Sximo,\r\n\r\nHow must i update to new version? I cannot find in wiki?\r\n\r\nGreetings,\r\n\r\nPatrick',NULL,'low','New',NULL,'2017-10-20 21:11:41',NULL),
(176,NULL,NULL,NULL,3485,'Report Creation Using Sximo 5.1.9','Please i would need you to show me how to generate a report from a datatable using daterange picker.',NULL,'low','New',NULL,'2017-10-23 12:28:57',NULL),
(177,NULL,NULL,NULL,3485,'Report Creation Using Sximo 5.1.9','Please i would need you to show me how to generate a report from a datatable using daterange picker.',NULL,'low','New',NULL,'2017-10-23 12:28:57',NULL),
(178,NULL,NULL,NULL,3695,'Files Folder permission','Hi Sximo,\r\n\r\nI installed Xammp with Sximo, in your tutorial i see next folder for premission. But some are on other location see the one begind the = sign.\r\n\r\n/app/Http/Controllers/  \r\n/app/Http/Models/ 	= /app/Models\r\n/resources/views/ 	 \r\n/storage/logs/ \r\n/storage/views/ 	= /storage/framework/views\r\n/storage/sessions/ 	= /storage/framework/sessions\r\n\r\nGreetings,\r\n\r\nPatrick',NULL,'low','New',NULL,'2017-10-23 20:22:19',NULL),
(179,NULL,NULL,NULL,3708,'WHERE DO I FIND MY DOWNLOAD','Just bought your Sximo5 Ultimate, Where do I download file pls.\r\n\r\nThanks',NULL,'low','Completed',NULL,'2017-10-25 13:55:04',NULL),
(180,NULL,NULL,NULL,2398,'Sximo5 Ultimate','Sore..\r\n\r\nBeberapa minggu yang lalu saya dapat email penawaran untuk Sximo5 Ultimate dan saya tidak lihat detailnya.\r\nSaya langsung beli saja ternyata itu butuh Sximo5 Builder sedangkan saya hanya punya yang versi 4.\r\nApakah bisa refund atau ada solusi yang lain..?\r\nNuhun Kang...\r\n\r\n\r\nSaka',NULL,'low','Processed',NULL,'2017-10-26 08:53:43',NULL),
(183,NULL,NULL,NULL,3717,'Total price of ULTIMATE SXIMO 5 is bit confusing','Hi Support,\r\n\r\nI am trying to buy ULTIMATE SXIMO 5 but i am bit confused on the Price and the lincence usage.\r\n\r\nCan you plesae give me a clarity \r\n1. If i buyed the ULTIMATE SXIMO 5 can i use in multiple projects with same licence.\r\n2. If i want to use in different projects how much is the cost.\r\n3. Is there refund policy \r\n4. is the licence is for life time ?',NULL,'low','New',NULL,'2017-10-29 07:08:31',NULL),
(182,NULL,NULL,NULL,3708,'View Modules Throw error 404!','Kindly assist, after successfully creating a module, I can preview. But immediately it\'s saved, View Modules throws error 404!. Kinldy guide me through what I\'m doing wrongly. Cheers!',NULL,'low','Processed',NULL,'2017-10-26 23:18:34',NULL),
(184,NULL,NULL,NULL,3717,'I am not able to create Module','I am getting error as \r\n\r\nApp\\Http\\Controllers\\Sximo\\ModuleController::getRebuild(): Failed opening required \'F:\\PAID\\codecanyon-11893533-laravel-crud-cms-sximo-5-lts/resources/views/sximo/module/template//config/config.php\' (include_path=\'D:\\xampp\\php\\PEAR\')',NULL,'low','New',NULL,'2017-11-01 07:45:22',NULL),
(185,NULL,NULL,NULL,1109,'Envate','Hi Any advice when i can purchase this version on envato ?',NULL,'low','New',NULL,'2017-11-02 08:48:21',NULL),
(186,NULL,NULL,NULL,3727,'Table Creator','How can i use the table creator?',NULL,'low','New',NULL,'2017-11-02 10:36:11',NULL),
(187,NULL,NULL,NULL,3728,'cant\'t find any download links for the purchased licence','Hi\n\nwe made a purchase of Sximo5 regular licence. cant\'t find any download links for the purchased licence. pls let us know as how to download the purchased package.\n\nThank you',NULL,'low','New',NULL,'2017-11-03 04:24:58',NULL),
(188,NULL,NULL,NULL,3717,'Cannot change General settings','HI, \r\nI am not able to change general settings. can you please help me out ? I am trying to change details its showing updated but data not getting updated.',NULL,'low','New',NULL,'2017-11-03 09:49:13',NULL),
(189,NULL,NULL,NULL,3198,'sximo ultimate','Dear Mangopick\r\n\r\nMay I know the status of the Sximo Ultimate that I already paid. I cant see anywhere inside the website',NULL,'low','New',NULL,'2017-11-06 10:36:41',NULL),
(190,NULL,NULL,NULL,3746,'404 page not found','Hi,\r\n\r\nBefore post this ticket, I read information about, and check all the stuff, and all is ok.\r\n\r\nThe problem comes in this page:\r\n\r\nhttp://localhost:8282/code/public/employees\r\n\r\nor another related with BASIC CRUD, BASIC FORM, etc.\r\n\r\nmain and login work correctly, even dashboard.',NULL,'low','New',NULL,'2017-11-06 22:27:23',NULL),
(191,NULL,NULL,NULL,3198,'Rebuild button','Dear Mangopick\r\n\r\nI in the middle of develop one module, and I already arrange the layout to 4 column but I cant see the tab to rebuild the code like the old sximo?\r\n\r\nso my question how can i refresh the layout?\r\n\r\n![text](https://ibb.co/kBcT3G) old sximo\r\n\r\nNew sximo\r\nhttps://ibb.co/i3cviG\r\n\r\nkindly advice.\r\n\r\nRegards',NULL,'low','New',NULL,'2017-11-08 06:55:49',NULL),
(192,NULL,NULL,NULL,3198,'Error inside creating user id','https://i.imgur.com/rMBrUU1.png\r\n\r\nHi Mangopick\r\n\r\ni faced an issue when creating the user inside user management module. kindly assist how can i troubleshoot on this.',NULL,'low','New',NULL,'2017-11-13 17:02:29',NULL),
(193,NULL,NULL,NULL,1521,'Adding php to pages CMS','Hi,\r\n\r\nI want to add some php to pages cms but cannot locate pages in file editor (using 5.1.9 btw) and when using summernote code gets commented out.\r\n\r\nplease afvise. Thanks',NULL,'low','New',NULL,'2017-11-14 00:50:16',NULL),
(194,NULL,NULL,NULL,3198,'sximo ultimate | Column more then 4','Hi Mangopick\r\n\r\njust a quick question, does sximo allowed to add more then 4 column ? is there any way to achieve this?\r\n\r\nRegards\r\nFaizan',NULL,'low','New',NULL,'2017-11-14 05:56:43',NULL),
(195,NULL,NULL,NULL,3761,'License','How to save License Code ? After infut the license not found save button',NULL,'low','New',NULL,'2017-11-14 11:36:11',NULL),
(196,NULL,NULL,NULL,3761,'Url Public','I installed the App on public_html with the main domain, and it appears mydomain / public URL, I want to delete \"public\", I\'ve tried toturialnya here: http://sximo5.net/docs/ultimate-sximo-5?view=209 but less clear. please help the details as I am not a programmer',NULL,'low','New',NULL,'2017-11-15 04:22:21',NULL),
(197,NULL,NULL,NULL,1521,'FB Login not working','Mango,\r\n\r\nI have completed a bug report here:\r\n\r\nhttp://sximo5.net/dev/sximo-5-lts-builder?issue=115\r\n\r\nAdditionally I fixed up some of the issues. Really keen to get fb login working - advice appreciated.\r\n\r\nSteve',NULL,'low','New',NULL,'2017-11-15 04:24:04',NULL),
(198,NULL,NULL,NULL,3695,'Read Discussion and Wiki from other products?','Hello,\r\n\r\nCan i read the Discussion and Wiki from other products? Now when i go to SXIMO 5 LTS - BUILDER and discussion the next warning : Please register Purchased Code for full access Discussion.\r\n\r\nWould be nice and learning to read this discussions.\r\n\r\nGReetings,\r\n\r\nPatrick',NULL,'low','New',NULL,'2017-11-15 21:09:19',NULL),
(199,NULL,NULL,NULL,2700,'Version 3.1 sximo','hello,\r\ni use the Laravel CMS - CRUD Builder - Administrator - https://codecanyon.net/item/laravel-cms-crud-builder-administrator/7194641\r\ni have some problem to delete images...\r\ncan you help me\r\n\r\nthanx',NULL,'low','New',NULL,'2017-11-17 11:30:11',NULL),
(200,NULL,NULL,NULL,3770,'pluggins','what pluggins can i buy to sximo 5 ultimate? ajax? datatables? are there compatibles of sximo lts?\r\nthanks.',NULL,'low','New',NULL,'2017-11-17 17:43:10',NULL),
(201,NULL,NULL,NULL,3784,'Use of undefined constant CNF_LANG - assumed \'CNF_LANG\'','Hi i purchased sximo 5 lts and ajax addon in envato website, But when i copy and paste ajax add on file into sximo 5 folter giving follwoing error, Use of undefined constant CNF_LANG - assumed \'CNF_LANG\'\r\n\r\nPlease help me to fix this',NULL,'low','New',NULL,'2017-11-22 16:14:16',NULL),
(202,NULL,NULL,NULL,3784,'Access for c-engine platform and class','I already purchase sximo5 lts, if i want to use crud engine, what dependency prods need to buy? else give an access to download c-engine platform and c-engine class',NULL,'low','New',NULL,'2017-11-23 00:28:03',NULL),
(203,NULL,NULL,NULL,3784,'Sximo 5 Ultimate can\'t access','I purchased Sximo 5 LTS - Builder on codecanyon website, Seems if i have purchased Sximo 5 LTS Builder i can access to Sximo 5 Ultimate , But i\'m unable to access, Please let me know why, how can i access, also can you explain both differences?',NULL,'low','New',NULL,'2017-11-23 01:58:55',NULL),
(204,NULL,NULL,NULL,3784,'Left side menu design not coming properly','When i close the left side menu Icons and text both displaying instead of displaying icon.\r\n\r\nPlease find the attachment and what could be the issue.\r\n\r\n![text](https://drive.google.com/open?id=1XMMBH_m492G8GKamYWx8R3_Wk5BMjOua)',NULL,'low','New',NULL,'2017-11-24 02:12:03',NULL),
(205,NULL,NULL,NULL,3784,'Edit row issue','I have the records in grid view generated using jquery grid, when i trying to edit it will be adding new records instead of update. Please hwlp what could be issue?',NULL,'low','New',NULL,'2017-11-24 14:57:40',NULL),
(206,NULL,NULL,NULL,3784,'Import csv not working','Hi,\r\n\r\nI\'m getting following error when i upload csv file using Import CSV option..\r\n\r\n\"Uncaught ReferenceError: uploadPreview is not defined\" in browser console also the data is not imported it just saying success message and closing popup.\r\n\r\nAlso when i download the template where can i specify necessary fields to upload instead of everything?',NULL,'low','New',NULL,'2017-11-25 13:26:55',NULL),
(207,NULL,NULL,NULL,3111,'Link download source','Hi,\r\n\r\nWhere do I find the download link?\r\nI already paid',NULL,'low','New',NULL,'2017-11-25 16:03:28',NULL),
(208,NULL,NULL,NULL,3111,'which is the version of instable ?','Which is the version of sximo with Rest Api unstable?',NULL,'low','New',NULL,'2017-11-27 11:38:18',NULL),
(209,NULL,NULL,NULL,3783,'Whoops, looks like something went wrong. ERROR','Esselamualeylum.\r\n\r\nI had some problem and you said to upgrade your php version. I upgraded Php version but sximo not working. Please help me, im working on 4 days. I didnt find any solution.\r\n\r\nMy url: selimtoker.com.tr/ufkayolculuk/public\r\n\r\nMy hosing details:\r\nhttp://185.111.233.70:2082\r\nydnselim\r\nGr8T8amA\r\n\r\nPlease help me',NULL,'low','New',NULL,'2017-11-27 19:43:28',NULL),
(210,NULL,NULL,NULL,3779,'Query Sximo5 Ultimate','how to add query Sximo5 Ultimate\r\n\r\nWHERE\r\ncountries.country_name = \'Canada\'\r\n\r\nSximo5 LTS++\r\n /app/models\r\n\r\npublic static function queryWhere(  ){\r\n		\r\n		return \" WHERE `countries.country_name` LIKE \'Canada\' \";\r\n	}\r\n	\r\n\r\nThanks',NULL,'low','New',NULL,'2017-11-28 04:38:29',NULL),
(211,NULL,NULL,NULL,3031,'Download','Gan, bagaimana caranya download Sximo Ultimate v 2.0 ya? \r\nThanks',NULL,'low','New',NULL,'2017-11-28 08:25:41',NULL),
(212,NULL,NULL,NULL,3111,'ApiRest Not Work','On screen when trying to select an \"apiuser\" does not list any users and the same happens when trying to add a module. How do I solve it?',NULL,'low','New',NULL,'2017-11-28 22:19:33',NULL),
(213,NULL,NULL,NULL,3111,'Crud many to many','how do I generate crud to many to many',NULL,'low','New',NULL,'2017-11-28 22:23:07',NULL),
(214,NULL,NULL,NULL,3784,'Page going to 404','I udpated recent updates, but i which i created module going to 404, let me know what issue?\r\n\r\nPleae find following for reference.\r\n\r\n\r\n![404Image](https://drive.google.com/file/d/18EYVBi8cnwbSSY44SAH8PbNTDdLeQ7QS/view)',NULL,'low','New',NULL,'2017-12-01 03:13:58',NULL),
(215,NULL,NULL,NULL,3784,'Rebuild not working properly','I updated the form tab  but its not rebuilding the code instead of form tab reset it, I dont know what i\'m missing please help me to fix this',NULL,'low','New',NULL,'2017-12-04 01:13:14',NULL),
(216,NULL,NULL,NULL,2826,'need some clarification','Hello, is my licence are for last ultimate release 6.0?\r\nmy licence number: aj5edfl8-5qgy-1cyo-jyej-z2a5ji5u9jky \r\nif yes where i can download ?\r\nif not  how to upgrade ?\r\n\r\nWhen i go to envato it\'s old release(Laravel CRUD - CMS - Sximo 5 LTS) on my download page.\r\n\r\nThanks\r\n\r\nFred',NULL,'low','New',NULL,'2017-12-07 07:40:32',NULL),
(217,NULL,NULL,NULL,3799,'Error while trying to export data','When you try to export data from the list, the following error appears:\r\n\r\nerror\r\n\r\nSorry, you are not allowed to access this page!\r\n\r\nCan you help me ?\r\n\r\nI have already given folder permissions, but the error persists.',NULL,'low','New',NULL,'2017-12-07 11:00:50',NULL),
(218,NULL,NULL,NULL,3718,'Does S5 Ultimate contain all the features of \"CrudEngine Class\" and \"Sximo 5 LTS - Builder\"','Does S5 Ultimate contain all the features of \"CrudEngine Class\" and \"Sximo 5 LTS - Builder\"\r\n\r\nWhere are the demos?',NULL,'low','New',NULL,'2017-12-07 17:08:50',NULL),
(219,NULL,NULL,NULL,3559,'bedanya apa','http://www.sximo5.net/source/jquery.net-crud-plugins \r\ndan\r\nhttp://www.sximo5.net/product/datatable.net-plugin\r\n\r\nlengkap mana ya ?\r\nsoal?\r\napaproduk itu sama ?',NULL,'low','New',NULL,'2017-12-08 13:13:26',NULL),
(220,NULL,NULL,NULL,85,'Datatable.net plugin','Hi,\r\n\r\nAs you can see i purchased ultimate, yet the system says i don\'t have access to datatable.net plugin. I used the ultimate, but i prefer the Sximo 5 LTS - Builder / sximo6. Can you enter the license to my account?\r\n\r\nThanks,',NULL,'low','New',NULL,'2017-12-10 19:33:26',NULL),
(221,NULL,NULL,NULL,3808,'unable to add my envato purchase code','Hi\r\nI am trying to add my envato purchase code but just get an error.\r\n\r\nLICENSE CERTIFICATE : Envato Market Item\r\n==============================================\r\n\r\nThis document certifies the purchase of:\r\nONE REGULAR LICENSE\r\nas defined in the standard terms and conditions on Envato Market.\r\n\r\nLicensor\'s Author Username:\r\nmangopik\r\n\r\nLicensee:\r\nZone1 Creative\r\n\r\nItem Title:\r\nSximo 5 Ultimate - Multipurpose App Starter\r\n\r\nItem URL:\r\nhttps://codecanyon.net/item/sximo-5-ultimate-crud-builder/20897239\r\n\r\nItem ID:\r\n20897239\r\n\r\nItem Purchase Code:\r\nf4c35b9f-3e45-4e65-8125-695827ef566a\r\n\r\nPurchase Date:\r\n2017-11-08 19:02:52 UTC\r\n\r\nFor any queries related to this document or license please contact Help Team via https://help.market.envato.com\r\n\r\nEnvato Pty. Ltd. (ABN 11 119 159 741)\r\nPO Box 16122, Collins Street West, VIC 8007, Australia\r\n\r\n==== THIS IS NOT A TAX RECEIPT OR INVOICE ====',NULL,'low','New',NULL,'2017-12-11 09:37:25',NULL),
(222,NULL,NULL,NULL,3809,'Does work with Laravel 5.5','Hi there, I have Laravel 5.5, will this still work good?',NULL,'low','New',NULL,'2017-12-11 14:19:21',NULL),
(223,NULL,NULL,NULL,2683,'git repo Access  - Waiting Approval','Request git repo Access \r\n \r\nPlease make sure you have entered your bitbucket username on your profile',NULL,'low','New',NULL,'2017-12-11 14:48:10',NULL),
(224,NULL,NULL,NULL,85,'Datatable.net plugin - 2','I guess you don\'t receive updates made to tickets, so i\'m opening a new one. Please change my license from ultimate to sximo + datatables. (And i purchased ajax etc. before)',NULL,'low','Completed',NULL,'2017-12-13 03:01:39',NULL),
(225,NULL,NULL,NULL,3819,'Update License & Refund','Halo mas, \r\n \r\n Tadi siang saya beli Sximo LTS dan plugin Rest API nya lewat codecanyon. yang ternyata setelah saya baca komentar di Restfullapi ada salah satu komen dari mas yg menyatakan fitur rest full api sudah include di Sixmo lts ver 5. Jadi lebih baik saya request refund daripada mubazir mas. apakah bisa bantu approve nya?\r\n \r\n Dan saya ingin upgrade license saya untuk ver Sximo Ultimate mas, apakah disana fitur Api juga tersedia? jika saya update dan next script tsb muncul/mas upload ke codecanyon apakah license saya disana jg akan berdtatus \"purchased\" ?\r\n \r\n \r\n Terima kasih',NULL,'low','New',NULL,'2017-12-17 14:42:30',NULL),
(226,NULL,NULL,NULL,3820,'S5 Ultimate','I have updated to S5 Ultimate but I can\'t download the files...',NULL,'low','Completed',NULL,'2017-12-18 18:40:11',NULL),
(227,NULL,NULL,NULL,3820,'Sximo 5 LTS to S5 Ultimate','Hi Support,\r\n\r\nI have purchased first the LTS version.\r\nNow I have upgraded the license to S5 Ultimate.\r\n\r\nWhat is the process to update an existing Project from Sximo 5 LTS to S5 Ultimate?\r\n\r\nCheers\r\n\r\nJonathan',NULL,'low','Completed',NULL,'2017-12-20 11:49:56',NULL),
(228,NULL,NULL,NULL,3820,'Dashboard','Hi Support,\r\n\r\nI want to modify the Dashboard.\r\nUnfortunantly there is no documentation where it is hooked in.\r\n\r\nCould you please give me a starting point where I can change the dashboard?\r\n\r\nCheers\r\n\r\nJonathan',NULL,'low','Completed',NULL,'2017-12-21 09:48:45',NULL),
(229,NULL,NULL,NULL,2605,'Can\'t Download Free Plugin','Hi,\r\nI haved licence code, but why i can\'t download free plugin?',NULL,'low','Processed',NULL,'2017-12-26 22:07:50',NULL),
(230,NULL,NULL,NULL,3839,'api post, put-patch request not working','Hi!\r\n\r\n\r\ni purchased your product s5 ultimate api and crud generator from envato market, here is the purchase code (323b983d-b895-42cb-a9a9-a89fd8d3cbf5), my purpose of buying this product was wholely the rest api generator and when i generated the api and tried to post the data into the table using post api request, it gave me 200 ok status but data was not inserted.\r\n\r\nI am really frustrated now due to the bugs i am facing, i need urgent response from you to solve this issue otherwise i will contact envato market and ask for the refund and will also leave a bad review about your product there, this really needs to be fixed as soon as possible.\r\n\r\nhopping to hear from you soon',NULL,'low','Processed',NULL,'2017-12-30 09:34:49',NULL),
(231,NULL,NULL,NULL,3846,'Ubah Source http://fonts.gstatic.com menjadi https://','Halo Mang Opick,\r\n\r\nsaya pakai sximo5 LTS v6, tapi error ketika running di https karena source berikut bukan https:\r\n\r\nwas loaded over HTTPS, but requested an insecure font \'http://fonts.gstatic.com/s/opensans/v15/MTP_ySUJH_bn48VBG8sNSugdm0LZdjqr5-oayXSOefg.woff2\'. This content should also be served over HTTPS.\r\n\r\nUbahnya dimana ya mang?\r\n\r\nTerima Kasih\r\n\r\nAchmad Fauzi',NULL,'low','New',NULL,'2018-01-06 16:22:33',NULL),
(232,NULL,NULL,NULL,3781,'Butuh Support','Dear Team Sximo,\r\n\r\nSepertinya masih banyak bug untuk plugin datatable dan jquery untuk diadosi baik itu di versi sximo5 terbaru maupun yg lama. Seperti saya coba plugin datatable terbaru install di sximo5 terbaru, fungsi export/bulk to word/pdf/print tidak berfungsi, dimana versi datatable sebelumnya masih bisa. Mohon bantuan tim sximo untuk meninjau kembali.\r\n\r\nTerimakasih.\r\n\r\nregards,\r\nyudhae',NULL,'low','New',NULL,'2018-01-06 19:01:07',NULL),
(233,NULL,NULL,NULL,3846,'Download v6 beda sama di demo','Halo mang opick, saya sudah download v6 di http://sximo5.net/source/sximo-5-lts-builder?download=sximo-5-lts-v.6.0- tapi kenapa beda ya sama demo di http://sximo6.sximobuilder.com/dashboard',NULL,'low','New',NULL,'2018-01-07 01:19:07',NULL),
(234,NULL,NULL,NULL,3849,'license not found','i have purchased ultimate sximo, but the purchased code i entered isnot valid. how to solve this problem, thanka,\r\n\r\nbest regards',NULL,'low','New',NULL,'2018-01-10 07:36:29',NULL),
(235,NULL,NULL,NULL,3846,'Sximo ultimate EntryBy Field Error dengan nested form filter','halo mang opick,\r\n\r\nAda masalah di sximo5 ultimate\r\nkalau saya buat **form nested filter dengan EntryBy** akan terjadi error pada grid view maupun form\r\ntapi **jika tidak digabungkan** form nested filter dengan EntryBy tidak ada masalah\r\nmohon solusinya\r\n\r\nterima kasih',NULL,'low','New',NULL,'2018-01-11 10:47:58',NULL),
(236,NULL,NULL,NULL,326,'THEMES','Good morning,\nhave you any other themes for the backend?\nHow can I change the css colors?\nThanks\nAndrea',NULL,'low','New',NULL,'2018-01-12 08:36:57',NULL),
(237,NULL,NULL,NULL,326,'THEMES','Good morning,\nhave you any other themes for the backend?\nHow can I change the css colors?\nThanks\nAndrea',NULL,'low','New',NULL,'2018-01-12 08:36:57',NULL),
(238,NULL,NULL,NULL,326,'THEMES','Good morning,\nhave you any other themes for the backend?\nHow can I change the css colors?\nThanks\nAndrea',NULL,'low','New',NULL,'2018-01-12 08:37:04',NULL),
(239,NULL,NULL,NULL,2652,'Sending email blast error','Hi Support\r\n\r\nI am getting an error when sending a blast email to active users on version 6.0, see error below.\r\n\r\n(1/1) ErrorException\r\nUndefined index: sximoconfig\r\nin UsersController.php (line 273)\r\nat HandleExceptions->handleError(8, \'Undefined index: sximoconfig\', \'C:\\\\laragon\\\\www\\\\amaqeda\\\\app\\\\Http\\\\Controllers\\\\Core\\\\UsersController.php\', 273, array(\'request\' => object(Request), \'rules\' => array(\'subject\' => \'required\', \'message\' => \'required|min:10\', \'groups\' => \'required\'), \'validator\' => object(Validator), \'count\' => 0, \'groups\' => array(\'3\'), \'i\' => 0, \'users\' => object(Collection), \'row\' => object(stdClass), \'data\' => array(\'note\' => \'<p> Lrem ipsum<br></p>\', \'row\' => object(stdClass), \'to\' => \'sdodla@gmail.com\', \'subject\' => \'Lorem ipsum\')))\r\nin UsersController.php (line 273)',NULL,'low','New',NULL,'2018-01-12 19:43:43',NULL),
(240,NULL,NULL,NULL,3857,'I have a problem','https://totalmda.gloyola.cl/public/\r\n\r\nhelpme',NULL,'low','New',NULL,'2018-01-13 16:44:41',NULL),
(241,NULL,NULL,NULL,3858,'Simopress download','I purchased a copy of Sximo 5 LTS from Codecanyon.  The banner said that I would get a free copy of the simopress.  But I could not download it unless I paid addition fee.  Please provide instruction as to how I could download it asap. I will wait for a day or so more and then I will have to initiate paypal refund if I do not receive the download.  Thanks!',NULL,'low','New',NULL,'2018-01-14 21:51:55',NULL),
(242,NULL,NULL,NULL,3858,'sximo ultimate-User Table Error','Just installed the ultimate version.  When I tried to add user, I got the error message: \"DataTables warning: table id=CrudEngine-UsersTable - Ajax error.\"  and 500 internal server error.',NULL,'low','New',NULL,'2018-01-15 06:58:19',NULL),
(243,NULL,NULL,NULL,3864,'how to install ?','already installed as per documentation at software.twisterinfotech.com\r\n\r\nbut cant login, there might be some database isse, i have to edit database.php file in software.twisterinfotech.com/config or \r\n\r\n.env file in software.twisterinfotech.com\r\n\r\ni did both then also cant login',NULL,'low','New',NULL,'2018-01-16 13:26:42',NULL),
(244,NULL,NULL,NULL,3864,'how to install ?','already installed as per documentation at software.twisterinfotech.com\r\n\r\nbut cant login, there might be some database isse, i have to edit database.php file in software.twisterinfotech.com/config or \r\n\r\n.env file in software.twisterinfotech.com\r\n\r\ni did both then also cant login',NULL,'low','New',NULL,'2018-01-16 13:26:44',NULL),
(245,NULL,NULL,NULL,3864,'how to install ?','already installed as per documentation at software.twisterinfotech.com\r\n\r\nbut cant login, there might be some database isse, i have to edit database.php file in software.twisterinfotech.com/config or \r\n\r\n.env file in software.twisterinfotech.com\r\n\r\ni did both then also cant login',NULL,'low','New',NULL,'2018-01-16 13:26:45',NULL),
(246,NULL,NULL,NULL,3859,'bugs in v6','Hi there !\r\nI have report some bugs in v6 in issues...thanks !',NULL,'low','New',NULL,'2018-01-17 14:55:14',NULL),
(247,NULL,NULL,NULL,3859,'bugs in v6','Hi there !\r\nI have report some bugs in v6 in issues...thanks !',NULL,'low','New',NULL,'2018-01-17 14:55:19',NULL),
(248,NULL,NULL,NULL,3841,'Upgrade Licence for S5 ULTIMATE','Hello\r\n\r\nI already buy a licence for Sximo5 and I want to upgrade to S5 ULTIMATE but in your system for payment you have only paypal. Is it possible to pay directly with my master card.\r\n\r\nThank you',NULL,'low','New',NULL,'2018-01-17 19:06:53',NULL),
(249,NULL,NULL,NULL,3727,'Ultimate widgets','Hi there, the updates fix a lot of problems with the 5lts recently i upgrated as well to the ultimate licence and downloaded the tickets and chat widgets. \r\n__\r\nI have installed them but i have a few problems with the chat widget i cannot start a new chat and \r\n__\r\nwith the tickets when i try to access the module says \"you dont have access to the page!\" \r\n_\r\nplease advice',NULL,'low','New',NULL,'2018-01-22 09:56:55',NULL),
(250,NULL,NULL,NULL,3833,'Ver Upgrade for Sximo 5  Lts','Hi Team,\r\nWe have purchase your product Sximo 5 LTS - Builder through codecanyon.net , But it is old version.It have so many issues. How to download new version for this product.\r\n\r\nMy purchase details are given below:\r\n\r\nLicensor\'s Author Username: mangopik Licensee: B N GOPAL Item Title: Laravel CRUD - CMS - Sximo 5 LTS Item URL: https://codecanyon.net/item/laravel-crud-cms-sximo-5-lts/11893533 Item ID: 11893533 Item Purchase Code: ed4f9388-cceb-4cce-91ef-6bc98ef6c54e Purchase Date: 2018-01-21 12:03:11 UTC License Certificate\r\n\r\nThanks & Regards,\r\nBhaskar',NULL,'low','New',NULL,'2018-01-23 08:42:47',NULL),
(251,NULL,NULL,NULL,1824,'Bug - duplicate of the entries while edit erly craated entries','While tryimg to edit and save existing entry - have error, create duplicate of early added entry:\r\nhttp://joxi.ru/bmo0zE9uxYN552',NULL,'low','New',NULL,'2018-01-24 07:10:42',NULL),
(252,NULL,NULL,NULL,1824,'Advanced Functionality REST FULL API','Good afternoon.\r\nTell me - how can I extend the functionality of the REST FULL API so that when updating my changes are not deleted',NULL,'low','New',NULL,'2018-01-24 07:14:46',NULL),
(253,NULL,NULL,NULL,2432,'Download S5 Ultimate','Hi \r\nI just paid for upgrade of license and not able to download it. Please let me know how to download',NULL,'low','New',NULL,'2018-01-25 14:21:58',NULL),
(254,NULL,NULL,NULL,1618,'i can\'t download my purchase','Hi,\r\n\r\nlast year october 2017 i bought the Ultimate Sximo 5 for the offerprice $9 (see below). I want to use it now for one project, but when i want to download it, i now see in the members area i have to pay extra.\r\n\r\nOfcourse i already have the Sximo bought through code canyon ,see attachements and i don\'t want to pay again extra.\r\n\r\nHow can i recieve my product?\r\n\r\nkind regards,\r\n\r\nBryan\r\n\r\nGegevens verkoper\r\nSximo Builder\r\n+62 81222663660\r\nhttp://sximobuilder.com\r\nsximobuilder@gmail.com\r\nAankoopgegevens\r\nUltimate Sximo 5\r\nNew Sximo 5 BUILDER Generation\r\n9,00 USD\r\nObjectnr.22\r\nTotaal9,00 USD\r\n\r\nLICENSE CERTIFICATE : Envato Market Item\r\n==============================================\r\n\r\nThis document certifies the purchase of:\r\nONE REGULAR LICENSE\r\nas defined in the standard terms and conditions on Envato Market.\r\n\r\nLicensor\'s Author Username:\r\nmangopik\r\n\r\nLicensee:\r\nBryan Wong\r\n\r\nItem Title:\r\nLaravel CMS  - Ajax CRUD Plugins\r\n\r\nItem URL:\r\nhttps://codecanyon.net/item/laravel-cms-ajax-crud-plugins/7899844\r\n\r\nItem ID:\r\n7899844\r\n\r\nItem Purchase Code:\r\n05a6002d-c594-4ea5-b997-fadedfb36610\r\n\r\nPurchase Date:\r\n2015-09-01 07:34:45 UTC\r\n\r\nFor any queries related to this document or license please contact Help Team via https://help.market.envato.com\r\n\r\nEnvato Pty. Ltd. (ABN 11 119 159 741)\r\nPO Box 16122, Collins Street West, VIC 8007, Australia\r\n\r\n==== THIS IS NOT A TAX RECEIPT OR INVOICE ====',NULL,'low','New',NULL,'2018-01-25 17:01:00',NULL),
(255,NULL,NULL,NULL,466,'Installation notes, Icons disappearing, syntax for drop-down list','1. When I installed and actrivited Sximopress from my Workpress Plugin, it showed an error saying the Heading was the correct.\r\nIt worked the second time of activiting it directly. Not sure if this has caused any issues!\r\n\r\n2. Created my first CRUD sucesssfully using the example from the document provided. But when I hover over the icons at the top of the table (Create, delete, print, etc) they all disapper.\r\n\r\n3. Can you please provide the syntax to use for a drop-down list for a field. I have a table called \"customer_type\" which I want to use as a list for the user to use.\r\n\r\nRegards,\r\nPre',NULL,'low','New',NULL,'2018-01-27 18:17:38',NULL),
(256,NULL,NULL,NULL,2815,'Crud Engine Table','I am working to set my tables/forms/fields up in S5 Ultimate. I am working in tables and format AS.\n\nSximo 5 LTS had a nice way to setup Lookup/DataBase in Tables. I have set the module to Ajax and in the lookup/databse to e107_dbs_customercompany|CompanyNumber|companyName or e107_dbs_customercompany:CompanyNumber:companyName (database:ID:REplyfield) and when viewing the module I am not getting the lookup\n\nIn Sximo 5 LTS I have used the field Format AS Link and included /Class Controller/show/primaryID to link 2 modules together. It appears that this has changed in Ultimate 5. Is there a way to link directly to a field form?',NULL,'low','New',NULL,'2018-01-31 05:00:37',NULL),
(257,NULL,NULL,NULL,1618,'no responce from you','Hi, \r\n\r\ni have emailed you no responce and got a ticket, but still can\'t get a responce from you.\r\n\r\nI bought the upgrade licence last year 2017, but i still can\'t download it. I don\'t get the download, instead I need to pay for another licence. I don\'t want to pay for an extra licence, i want the product i paid for.\r\n\r\nBryan',NULL,'low','New',NULL,'2018-01-31 07:34:27',NULL),
(258,NULL,NULL,NULL,3883,'Hi, how i can create custom dynamic menu?','Hi. How i can create custom dynamic orderable menu? (Like built-in system module).',NULL,'low','New',NULL,'2018-01-31 12:47:59',NULL),
(259,NULL,NULL,NULL,3883,'Hi, how i can create custom dynamic menu?','Hi. How i can create custom dynamic orderable menu? (Like built-in system module).',NULL,'low','New',NULL,'2018-01-31 12:47:59',NULL),
(260,NULL,NULL,NULL,3883,'Hi, how i can create custom dynamic menu?','Hi. How i can create custom dynamic orderable menu? (Like built-in system module).',NULL,'low','New',NULL,'2018-01-31 12:48:00',NULL),
(261,NULL,NULL,NULL,3883,'Hi, how i can create custom dynamic menu?','Hi. How i can create custom dynamic orderable menu? (Like built-in system module).',NULL,'low','New',NULL,'2018-01-31 12:48:01',NULL),
(262,NULL,NULL,NULL,3883,'Hi, how i can create custom dynamic menu?','Hi. How i can create custom dynamic orderable menu? (Like built-in system module).',NULL,'low','New',NULL,'2018-01-31 12:48:03',NULL),
(263,NULL,NULL,NULL,3883,'Hi, how i can create dynamic translatable module?','Hi. I need to create module with dynamic translatable fields (like menu data en/another language). How i can do it?',NULL,'low','New',NULL,'2018-01-31 13:47:41',NULL),
(264,NULL,NULL,NULL,1007,'I try to download from the url but I can not.','I try to download from the url but I can not.\r\n\r\n--------------------------------------------------\r\n\r\nNo found my key of SXIMO 5.1 LTS\r\nRE: SXIMO 5.1 LTS No link M Marco Joe Alegría Vásquez Responder| mar 30/06/2015, 09:16 a.m. Taufik firmansyah (kangopik@gmail.com) Elementos enviados 2 archivos adjuntos (289 KB) Descargar todo Guardar todo en OneDrive - Personal Dear Sximo Builder I bought the 5.1 update but the link does not exist. Please appreciate provide a valid link to work with SXIMO 5.1 LTS. http://sximobuilde.com/uploads/src/sximo-5-1-lts-beta.zip Attachment 2 files.\r\nKind Regard.\r\n\r\nMango Tm 5 months ago\r\nTry download here http://sximo5.net/source/sximo-5-lts-builder?download=sximo-5.1.9-new-looks\r\n\r\nMarco Alegria 4 months ago\r\nThx :) i loved it :)\r\n\r\nMarco Alegria 2 mins ago\r\nI try to download from the url but I can not. http://sximo5.net/source/sximo-5-lts-builder?download=sximo-5.1.9-new-looks Plz\r\n\r\n-----------------------------------------------------',NULL,'low','New',NULL,'2018-01-31 15:41:41',NULL),
(265,NULL,NULL,NULL,3886,'Problem displaying data. jQuery.','Hi. I am installing your plugin in a local enviropment with xampp. I receive an error in the chrome console and i cant see the crud data.\r\n\r\nhttps://imgur.com/a/EDL3I\r\n\r\nhttps://imgur.com/a/sz7LN',NULL,'low','New',NULL,'2018-02-01 18:52:59',NULL),
(266,NULL,NULL,NULL,3886,'Problem displaying data. jQuery.','Hi. I am installing your plugin in a local enviropment with xampp. I receive an error in the chrome console and i cant see the crud data.\r\n\r\nhttps://imgur.com/a/EDL3I\r\n\r\nhttps://imgur.com/a/sz7LN',NULL,'low','New',NULL,'2018-02-01 18:52:59',NULL),
(267,NULL,NULL,NULL,3455,'S5 ultimate order with paypal','Hi,\r\n\r\nI have a specific problem for my country.\r\n\r\nMy country is stopped all paypal account country base for Turkey citizens from last 1 year.\r\n\r\nOur goverment closed all paypal using. \r\n\r\nI want to buy your S5 Ultimate upgrade product.\r\n\r\nI have ordered your other 5 software from codecanyon.\r\n\r\nPlase inform us how can i buy your S5 Ultimate product (only 14$ upgrade) without paypal method.\r\n\r\nmaybe virtual product on any web site it can payable with direct credit card.\r\n\r\nThanks for your good softwares.',NULL,'low','New',NULL,'2018-02-02 15:56:58',NULL),
(268,NULL,NULL,NULL,3893,'The dropdown menu items of \"Control Panel\" is not clickable!','Hi\r\n\r\nI just purchased your Sximo 5 Ultimate product and installed in my local server. However, I observered that the dropdown menu items of \"Control Panel\" in the header is not clickable, which is making me difficult to setup. Please help me to solve this issue.\r\n\r\nScreenshot -- https://prnt.sc/iaapag',NULL,'low','New',NULL,'2018-02-05 09:21:12',NULL),
(269,NULL,NULL,NULL,2480,'Tranfer ke Bank Lokal, Bisa?','Sximopress berapa harganya di Rupiah? Bisa transfer ke rekening bank lokal?',NULL,'low','New',NULL,'2018-02-05 15:16:37',NULL),
(270,NULL,NULL,NULL,3795,'grid table search','dear\r\n\r\ngan saya coba ganti pencarian itu pakai LIKE gmn ya\r\n\r\njadi misal text nyrempet2 dikit masih ke detek, tidak harus match\r\nhttps://imgur.com/a/pL2wi\r\n\r\nseperti itu,\r\n\r\npakai cara ini gak bisa\r\nhttp://www.sximo5.net/docs/sximo-5-lts-builder?view=141\r\n\r\nTrims',NULL,'low','New',NULL,'2018-02-06 02:51:55',NULL),
(271,NULL,NULL,NULL,3898,'I bought the S5 Ultimate','I bought the S5 Ultimate program\r\nwhere can I download it?\r\nThanks\r\nRazvan Sitea\r\nsitearazvan@gmail.com',NULL,'low','New',NULL,'2018-02-07 13:19:36',NULL),
(272,NULL,NULL,NULL,3898,'please help me','Hello \r\nI added theme MEDILAB but can not be edited.\r\nand after adding theme medilab you can not log in to admin\r\ncan you help me please ?\r\n2. And there is a module for users to edit the pages ?\r\n3. Invoice Lite Generator missing file invoice.sql\r\n4. where is the Basecamp module ?\r\nthank you very much',NULL,'low','New',NULL,'2018-02-07 19:00:36',NULL),
(273,NULL,NULL,NULL,1618,'still no answer','Hi,\r\n\r\nstill is really frustrating, i need my latest version which I purchased but i can\'t download.\r\n\r\nWhen can you finally resolve this problem?\r\nIt is taking really long.\r\n\r\nBryan',NULL,'low','New',NULL,'2018-02-09 10:49:29',NULL),
(274,NULL,NULL,NULL,1618,'this is getting silly','Hi,\r\n\r\ni just want to download what I paid for.\r\nWhy can\'t you respond?\r\n\r\nThis is really really shitty \"service\".\r\n\r\n\r\nBryan',NULL,'low','New',NULL,'2018-02-13 14:18:43',NULL),
(275,NULL,NULL,NULL,3867,'How Download Sximo 5 Ultimate....','Hello, I just made the payment of maximum 5 ultimate but I could not download the file, where I can download it Thanks',NULL,'low','New',NULL,'2018-02-13 18:02:08',NULL),
(276,NULL,NULL,NULL,3867,'How Download Sximo 5 Ultimate....','Hello, I just made the payment of maximum 5 ultimate but I could not download the file, where I can download it Thanks',NULL,'low','New',NULL,'2018-02-13 18:02:13',NULL),
(277,NULL,NULL,NULL,3553,'I just upgraded to my 5 LTS','Where do I download the files?',NULL,'low','New',NULL,'2018-02-16 12:18:07',NULL),
(278,NULL,NULL,NULL,2431,'Global permission','Hi, I\'m using version 6 of sximo LTS, I have a problem when I disable Global permissions. When the edit function is active, you can no longer see the detailed records while in the display you see them.',NULL,'low','New',NULL,'2018-02-16 14:32:29',NULL),
(279,NULL,NULL,NULL,3903,'Error first run','Hi just installed the actual version (Sximo 5 LTS ( v.6.0 )Updated : Dec 06, 2017  Sximo 5 LTS ( v.6.0 )) and get an error at first launch http://sximo.plirux.com/public/, can you help please\r\n\r\n(1/1) FatalThrowableError\r\nClass \'Illuminate\\Routing\\ImplicitRouteBinding\' not found\r\n\r\nin Router.php (line 646)\r\nat Router->substituteImplicitBindings(object(Route))\r\nin SubstituteBindings.php (line 39)\r\nat SubstituteBindings->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin ShareErrorsFromSession.php (line 49)\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin StartSession.php (line 64)\r\nat StartSession->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin AddQueuedCookiesToResponse.php (line 37)\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin EncryptCookies.php (line 59)\r\nat EncryptCookies->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))\r\nin Router.php (line 574)\r\nat Router->runRouteWithinStack(object(Route), object(Request))\r\nin Router.php (line 533)\r\nat Router->dispatchToRoute(object(Request))\r\nin Router.php (line 511)\r\nat Router->dispatch(object(Request))\r\nin Kernel.php (line 176)\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request))\r\nin Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin CheckForMaintenanceMode.php (line 46)\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))\r\nin Kernel.php (line 151)\r\nat Kernel->sendRequestThroughRouter(object(Request))\r\nin Kernel.php (line 116)\r\nat Kernel->handle(object(Request))\r\nin index.php (line 53)',NULL,'low','New',NULL,'2018-02-18 15:55:18',NULL),
(280,NULL,NULL,NULL,3903,'Please refund me','Hi i shoun\'t buy you script because of first install and second install done, i get error vhen i want to start a project. Also, your help is not comming and i need to begin a 3 months project. S i\'ll choose another way to do it because i need help if support is requiered So i\'d like you to refund me please I hope it\'s ok for you. Thank you plrplr',NULL,'low','New',NULL,'2018-02-19 11:15:36',NULL),
(281,NULL,NULL,NULL,2958,'Ajax CRUD Plugins','Hello,\r\nI\'m trying to work with \"jquery Ajax Complete\" in S5 Ultimate, but there are multiple errors. \r\n\r\nThere is no filter search, download, etc.\r\n\r\nShould I buy an other plugin such as Ajax CRUD Plugins?',NULL,'low','New',NULL,'2018-02-21 11:55:48',NULL),
(282,NULL,NULL,NULL,3910,'Cant download upgrade after purchasing','Hi. A few minuts ago I\'ve bought upgrade from LTS 5 to Ultimate.\r\nIn this moment I cant downoad upgrade/ultimate script - I get information 5LTS is needed. But I have both licence now: 5 LTS and Upgrade to Ultimate!\r\n\r\nHow I can download my upgrade/ultimate script which I bought?',NULL,'low','New',NULL,'2018-03-01 17:44:17',NULL),
(283,NULL,NULL,NULL,2784,'buy','Hi, i buy for licence upgrade ultimate. Where i download?',NULL,'low','New',NULL,'2018-03-02 22:29:51',NULL),
(284,NULL,NULL,NULL,2784,'Error app record restore','Ccan you help me with this error: 2/2) QueryException \r\n\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column \'tb_audits.entry_by\' in \'where clause\' (SQL: SELECT tb_audits.* , COUNT(tb_audits.ModuleDataID ) AS Total FROM tb_audits WHERE tb_audits.AuditID IS NOT NULL \r\n AND tb_audits.entry_by =\'1\' GROUP BY tb_audits.ModuleDataID ORDER BY AuditID asc LIMIT 0 , 10 )',NULL,'low','New',NULL,'2018-03-05 11:57:10',NULL),
(285,NULL,NULL,NULL,3804,'Error when showing import template','(1/1) ErrorException\r\nCannot modify header information - headers already sent by (output started at /hsphere/local/home/a908500/hotels.monhotel.ci/app/Http/Controllers/Controller.php:700)\r\n\r\nin Controller.php (line 701)\r\nat HandleExceptions->handleError(2, \'Cannot modify header information - headers already sent by (output started at /hsphere/local/home/a908500/hotels.monhotel.ci/app/Http/Controllers/Controller.php:700)\', \'/hsphere/local/home/a908500/hotels.monhotel.ci/app/Http/Controllers/Controller.php\', 701, array(\'request\' => object(Request), \'task\' => \'true\', \'fields\' => array(array(\'field\' => \'id\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Id\', \'view\' => 0, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'0\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'nom\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Nom\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'1\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'datenaissance\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Datenaissance\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'2\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'lieunaissance\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Lieunaissance\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'3\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'nompere\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Nompere\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'4\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'nommere\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Nommere\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'5\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'adresse\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Adresse\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'6\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'nationalite\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Nationalite\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'7\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'numeropiece\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Numeropiece\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'8\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'datepiece\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Datepiece\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'9\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'lieupiece\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Lieupiece\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'10\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'checkin\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Checkin\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'11\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'checkout\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Checkout\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'12\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'hotel\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Hotel\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'13\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'destination\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Destination\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'14\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\'), array(\'field\' => \'piecetype\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Piecetype\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'15\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\')), \'output\' => resource, \'head\' => array(\'id\', \'nom\', \'datenaissance\', \'lieunaissance\', \'nompere\', \'nommere\', \'adresse\', \'nationalite\', \'numeropiece\', \'datepiece\', \'lieupiece\', \'checkin\', \'checkout\', \'hotel\', \'destination\', \'piecetype\'), \'f\' => array(\'field\' => \'piecetype\', \'alias\' => \'fichepolice\', \'language\' => array(\'fr\' => \'\', \'id\' => \'\'), \'label\' => \'Piecetype\', \'view\' => 1, \'detail\' => 1, \'sortable\' => 1, \'search\' => 1, \'download\' => 1, \'frozen\' => 1, \'limited\' => \'\', \'width\' => \'100\', \'align\' => \'left\', \'sortlist\' => \'15\', \'conn\' => array(\'valid\' => \'0\', \'db\' => \'\', \'key\' => \'\', \'display\' => \'\'), \'format_as\' => \'\', \'format_value\' => \'\')))\r\nat header(\'Content-Type: text/csv; charset=utf-8\')\r\nin Controller.php (line 701)\r\nat Controller->getImport(object(Request))\r\nin FichepoliceController.php (line 93)\r\nat FichepoliceController->show(object(Request), \'import\')\r\nat call_user_func_array(array(object(FichepoliceController), \'show\'), array(object(Request), \'fichepolouse\' => \'import\'))\r\nin Controller.php (line 55)\r\nat Controller->callAction(\'show\', array(object(Request), \'fichepolouse\' => \'import\'))\r\nin ControllerDispatcher.php (line 44)\r\nat ControllerDispatcher->dispatch(object(Route), object(FichepoliceController), \'show\')\r\nin Route.php (line 204)\r\nat Route->runController()\r\nin Route.php (line 160)\r\nat Route->run()\r\nin Router.php (line 572)\r\nat Router->Illuminate\\Routing\\{closure}(object(Request))\r\nin Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin IpblockedMiddleware.php (line 68)\r\nat IpblockedMiddleware->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin SubstituteBindings.php (line 41)\r\nat SubstituteBindings->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin ShareErrorsFromSession.php (line 49)\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin StartSession.php (line 64)\r\nat StartSession->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin AddQueuedCookiesToResponse.php (line 37)\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin EncryptCookies.php (line 59)\r\nat EncryptCookies->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))\r\nin Router.php (line 574)\r\nat Router->runRouteWithinStack(object(Route), object(Request))\r\nin Router.php (line 533)\r\nat Router->dispatchToRoute(object(Request))\r\nin Router.php (line 511)\r\nat Router->dispatch(object(Request))\r\nin Kernel.php (line 176)\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request))\r\nin Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin CheckForMaintenanceMode.php (line 46)\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure))\r\nin Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))\r\nin Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))\r\nin Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))\r\nin Kernel.php (line 151)\r\nat Kernel->sendRequestThroughRouter(object(Request))\r\nin Kernel.php (line 116)\r\nat Kernel->handle(object(Request))\r\nin index.php (line 54)',NULL,'low','New',NULL,'2018-03-13 18:41:01',NULL),
(286,NULL,NULL,NULL,3779,'error','![error](http://prntscr.com/irfw4q)',NULL,'low','New',NULL,'2018-03-15 07:55:20',NULL),
(287,NULL,NULL,NULL,3923,'presale question','hello taoufik, first of all thanks for this amazing solution, i wanyt to purchase the sximo ultimate i click to the buy boutton and it redirects me to buy sximo lts, i\'m wondering how to get the ultimate one and is it need a jax plugin',NULL,'low','New',NULL,'2018-03-21 10:39:29',NULL),
(288,NULL,NULL,NULL,1007,'I need install it in my host HOSTGATOR','I try install it but no can do it.\r\nNeed a tutorial with more details.',NULL,'low','New',NULL,'2018-03-26 02:11:44',NULL),
(289,NULL,NULL,NULL,1007,'I BUY AND NO HAVE SUPPORT!!! I need install it in my host HOSTGATOR','I BUY AND NO HAVE SUPPORT!!! I need install it in my host HOSTGATOR',NULL,'low','New',NULL,'2018-03-27 01:32:34',NULL),
(290,NULL,NULL,NULL,2700,'sximo5','hello,\r\n\r\ni buy sximo5, and i installed successfully. I have a problem that dont save field and arent empty\r\nplease check\r\n\r\ndo you need usr and pass to see it right?\r\nthanx',NULL,'low','New',NULL,'2018-03-29 15:31:47',NULL),
(291,NULL,NULL,NULL,3926,'Error Module','Mangopik saya mau tanya dong, saya buat module sesuai dengan yang ada di file pdf dokumentasi,\r\nsaya buat module employee, lalu saya buatkan menunya di, kalau module di akses dengan superadmin module employee bisa digunakan, tetapi kalau saya akses module dengan tipe user admin biasa atau user error seperti ini, tolong bantuanya mangopik..?\r\n\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column \'employee.entry_by\' in \'where clause\' (SQL: SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL\r\nAND employee.entry_by =\'5\' ORDER BY EmployeeId asc LIMIT 0 , 10 )\r\nin Connection.php (line 647)\r\nat Connection->runQueryCallback(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \', array(), object(Closure))in Connection.php (line 607)\r\nat Connection->run(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \', array(), object(Closure))in Connection.php (line 326)\r\nat Connection->select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in DatabaseManager.php (line 327)\r\nat DatabaseManager->__call(\'select\', array(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \'))in Facade.php (line 221)\r\nat DatabaseManager->select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in Facade.php (line 221)\r\nat Facade::__callStatic(\'select\', array(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \'))in Sximo.php (line 49)\r\nat DB::select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in Sximo.php (line 49)\r\nat Sximo::getRows(array(\'page\' => 1, \'limit\' => \'10\', \'sort\' => \'EmployeeId\', \'order\' => \'asc\', \'params\' => \'\', \'global\' => \'0\'), 5)in Controller.php (line 1002)\r\nat Controller->grab(object(Request))in EmployeeController.php (line 37)\r\nat EmployeeController->index(object(Request))\r\nat call_user_func_array(array(object(EmployeeController), \'index\'), array(object(Request)))in Controller.php (line 55)\r\nat Controller->callAction(\'index\', array(object(Request)))in ControllerDispatcher.php (line 44)\r\nat ControllerDispatcher->dispatch(object(Route), object(EmployeeController), \'index\')in Route.php (line 204)\r\nat Route->runController()in Route.php (line 160)\r\nat Route->run()in Router.php (line 572)\r\nat Router->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in IpblockedMiddleware.php (line 68)\r\nat IpblockedMiddleware->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in SubstituteBindings.php (line 41)\r\nat SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in ShareErrorsFromSession.php (line 49)\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in StartSession.php (line 64)\r\nat StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in AddQueuedCookiesToResponse.php (line 37)\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in EncryptCookies.php (line 59)\r\nat EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))in Router.php (line 574)\r\nat Router->runRouteWithinStack(object(Route), object(Request))in Router.php (line 533)\r\nat Router->dispatchToRoute(object(Request))in Router.php (line 511)\r\nat Router->dispatch(object(Request))in Kernel.php (line 176)\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request))in Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in CheckForMaintenanceMode.php (line 46)\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))in Kernel.php (line 151)\r\nat Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116)\r\nat Kernel->handle(object(Request))in index.php (line 54)\r\n(1/2) PDOException\r\n\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column \'employee.entry_by\' in \'where clause\'\r\nin Connection.php (line 319)\r\nat PDO->prepare(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in Connection.php (line 319)\r\nat Connection->Illuminate\\Database\\{closure}(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \', array())in Connection.php (line 640)\r\nat Connection->runQueryCallback(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \', array(), object(Closure))in Connection.php (line 607)\r\nat Connection->run(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \', array(), object(Closure))in Connection.php (line 326)\r\nat Connection->select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in DatabaseManager.php (line 327)\r\nat DatabaseManager->__call(\'select\', array(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \'))in Facade.php (line 221)\r\nat DatabaseManager->select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in Facade.php (line 221)\r\nat Facade::__callStatic(\'select\', array(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \'))in Sximo.php (line 49)\r\nat DB::select(\' SELECT employee.* FROM employee WHERE employee.EmployeeId IS NOT NULL AND employee.entry_by =\\\'5\\\' ORDER BY EmployeeId asc LIMIT 0 , 10 \')in Sximo.php (line 49)\r\nat Sximo::getRows(array(\'page\' => 1, \'limit\' => \'10\', \'sort\' => \'EmployeeId\', \'order\' => \'asc\', \'params\' => \'\', \'global\' => \'0\'), 5)in Controller.php (line 1002)\r\nat Controller->grab(object(Request))in EmployeeController.php (line 37)\r\nat EmployeeController->index(object(Request))\r\nat call_user_func_array(array(object(EmployeeController), \'index\'), array(object(Request)))in Controller.php (line 55)\r\nat Controller->callAction(\'index\', array(object(Request)))in ControllerDispatcher.php (line 44)\r\nat ControllerDispatcher->dispatch(object(Route), object(EmployeeController), \'index\')in Route.php (line 204)\r\nat Route->runController()in Route.php (line 160)\r\nat Route->run()in Router.php (line 572)\r\nat Router->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in IpblockedMiddleware.php (line 68)\r\nat IpblockedMiddleware->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in SubstituteBindings.php (line 41)\r\nat SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in ShareErrorsFromSession.php (line 49)\r\nat ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in StartSession.php (line 64)\r\nat StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in AddQueuedCookiesToResponse.php (line 37)\r\nat AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in EncryptCookies.php (line 59)\r\nat EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))in Router.php (line 574)\r\nat Router->runRouteWithinStack(object(Route), object(Request))in Router.php (line 533)\r\nat Router->dispatchToRoute(object(Request))in Router.php (line 511)\r\nat Router->dispatch(object(Request))in Kernel.php (line 176)\r\nat Kernel->Illuminate\\Foundation\\Http\\{closure}(object(Request))in Pipeline.php (line 30)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in CheckForMaintenanceMode.php (line 46)\r\nat CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148)\r\nat Pipeline->Illuminate\\Pipeline\\{closure}(object(Request))in Pipeline.php (line 53)\r\nat Pipeline->Illuminate\\Routing\\{closure}(object(Request))in Pipeline.php (line 102)\r\nat Pipeline->then(object(Closure))in Kernel.php (line 151)\r\nat Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116)\r\nat Kernel->handle(object(Request))in index.php (line 54)',NULL,'low','New',NULL,'2018-04-01 16:36:04',NULL),
(292,NULL,NULL,NULL,3544,'Untuk Order Plugin sximo wordpress apakah harus melalui evanto?','Untuk Order Plugin sximo wordpress apakah harus melalui evanto?',NULL,'low','New',NULL,'2018-04-07 11:09:12',NULL),
(293,NULL,NULL,NULL,3695,'UpdateS?','Hello Sximo,\r\n\r\nYou still alive and we are updates coming?\r\n\r\nGReetings,\r\n\r\nPatrick',NULL,'low','New',NULL,'2018-04-08 13:13:56',NULL),
(294,NULL,NULL,NULL,210,'Sximo 5 Ultimate','Hello,\r\n\r\nI cant download Sximo 5 Ultimate. I have bought these licenses but I cant find where download the products.\r\n\r\nThanks!.\r\n\r\nSximo 5 LTS - Builder\r\nPurchased Code : 2925958c-59e0-4aa9-b4b0-860a1994c6dd \r\n \r\njQuery.net CRUD Plugins\r\nPurchased Code : 7e8c4e24-1730-4b11-9224-fea11c69ac3f \r\n \r\nSupports / Ticket\r\nPurchased Code : fq5w1uwb-p8jr-ces7-0fit-uyg1luv99dxn \r\n \r\nS5 Ultimate\r\nPurchased Code : e92mqjc4-vp31-ln0h-7xue-eruyrzmbj0j2 \r\n \r\nSximopress\r\nPurchased Code : ec4da65e-b90f-40bb-a71a-5cdd92a20813',NULL,'low','New',NULL,'2018-04-09 20:29:42',NULL),
(295,NULL,NULL,NULL,3933,'[urgent] Laravel CRUD - CMS - Sximo 5 LTS - Cant find Version update on menu','hi,\r\n\r\njust purchased a Laravel CRUD - CMS - Sximo 5 LTS from codecanyon\r\n\r\nbut i can\'t find the vesion update or install software on menu and different layout as you advertise on https://codecanyon.net/item/laravel-crud-cms-sximo-5-lts/11893533\r\n\r\nor i download not the latest version from codecanyon?\r\n\r\nmy purchase code e3d87f76-a58e-44c0-a50b-4d370ced17ae',NULL,'low','New',NULL,'2018-04-14 08:58:50',NULL),
(296,NULL,NULL,NULL,3922,'invoice','hi,\r\n\r\nplease the invoice for my order \r\n\r\nQUARTZ MATRIX SRL\r\nVAT RO5150840\r\n\r\nrazvan.tudor@quartzmatrix.ro\r\n\r\nBR',NULL,'low','New',NULL,'2018-04-20 07:27:35',NULL),
(297,NULL,NULL,NULL,3937,'Sximo5 LTE Not Working As Expected','Hi,\r\n\r\nWe need your assistance for following;\r\n\r\n1. Dashboard builder is going to 404 (We\'re trying to create dashboard with charts, summary data and tables)\r\n2. How to plot charts for various data points\r\n3. Dropzone media is not working\r\n4. How to enable entire system backup from dashboard\r\n5. How to update the sximo builder from within app\r\n6. Theme change is not working, we have light theme and trying to select blue, but not working\r\n7. An admin is able to create superadmin from user management module, how to prevent this\r\n\r\n\r\nAppreiate your priority reply.\r\n\r\nThank you in advance.',NULL,'low','New',NULL,'2018-04-22 15:29:48',NULL),
(298,NULL,NULL,NULL,3939,'DataTables GUI CRUD - Sximo 5 errors (codeigniter)','hi there, \r\n\r\nmy licence - f9038994-e8f7-497f-aa70-984aa2a5ca44 - 26 Apr 2018\r\n\r\nI have purchased DataTables GUI CRUD - Sximo 5 through code canyon and it has bugs in ;\r\n\r\n1. adding data using a module  - shows error \r\n\r\n3. creating and editing a  module - \r\n\r\nA PHP Error was encountered\r\nSeverity: Warning\r\n\r\nMessage: count(): Parameter must be an array or an object that implements Countable\r\n\r\nFilename: sximo/Module.php\r\n\r\nLine Number: 276\r\n\r\nBacktrace:\r\n\r\nFile: C:\\xampp\\htdocs\\hotelacc\\application\\controllers\\sximo\\Module.php\r\nLine: 276\r\nFunction: _error_handler\r\n\r\nFile: C:\\xampp\\htdocs\\hotelacc\\index.php\r\nLine: 298\r\nFunction: require_once\r\n\r\n3. rebuilding a module - it dosent show rebuild success \r\n\r\n4. view data in user - it dosent show data \r\nDataTables warning: table id=usersTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1\r\n\r\ncan you please support me on this!\r\n\r\nThnak you!',NULL,'low','New',NULL,'2018-04-26 10:07:20',NULL),
(299,NULL,NULL,NULL,3904,'Unable to use Update tool','When attempting to update Sximo5 ultimate, I keep getting a Invalid Credits error http://take.ms/qxrEg\r\n\r\nPlease advise',NULL,'low','New',NULL,'2018-04-27 18:17:16',NULL),
(300,NULL,NULL,NULL,3946,'Error download','I\'m trying to download the free plugins as calendars for example, this is giving the second error.\r\n\r\n\r\nYou already have licence for this item !\r\nerror',NULL,'low','New',NULL,'2018-05-09 12:49:05',NULL),
(301,NULL,NULL,NULL,3946,'Sximo6','How do I upgrade to Sximo6?',NULL,'low','New',NULL,'2018-05-09 13:22:49',NULL),
(302,NULL,NULL,NULL,3897,'Parent Filter ( Lookup Filter Key)','Hi, I install a Sximo Builder Ultimate and the Lookup Filter Key is not working. I notice that the parent filter checkbox not show in the select modal like sximo ltd... Can you help me?',NULL,'low','New',NULL,'2018-05-09 21:11:43',NULL),
(303,NULL,NULL,NULL,2084,'Lcence problem','Hi, \r\n\r\ni cannot download any of free plugins in BROWSE section. What is the problem?\r\nThank you..\r\nbest',NULL,'low','New',NULL,'2018-06-03 19:23:33',NULL),
(304,NULL,NULL,NULL,3963,'Control Panel Menu not clickable','Hello,\r\n\r\nI just bought your script Sximo 5 Ultimate and run it on PHP Version 5.6.36.\r\nAfter I login, the control panel\'s menu is not clickable.\r\n\r\nPlease kindly advise.\r\n\r\nBest Regards,\r\nBorin',NULL,'low','New',NULL,'2018-06-22 16:52:07',NULL),
(305,NULL,NULL,NULL,3963,'Sximo 5 Ultimate - No Master Detail Function?','Hello,\r\n\r\nI am just bought Sximo 5 Ultimate Version and I expect it come with more features than the SXIMO 5 LTS - BUILDER. But it is not.\r\n\r\nCould you explain?\r\n\r\nIs there anyway I could get SXIMO 5 LTS - BUILDER instead of Sximo 5 Ultimate?\r\n\r\nBest Regards,\r\nBorin',NULL,'low','New',NULL,'2018-06-23 06:03:21',NULL),
(306,NULL,NULL,NULL,3089,'Export CSV - export all the records of the table, and not the row filter or show :(','Sximo 5 lts v6.0',NULL,'low','New',NULL,'2018-07-01 00:17:40',NULL),
(307,NULL,NULL,NULL,3922,'product','Hi,\r\n\r\n3 month ago we bought S5 Ultimate and the key was\r\nswmcqg1j-4y2s-8pu2-we2k-fc26m6im7rdt.\r\nThe package was bought via Public aquire system Quartz Matrix for Slobozia municipality.\r\nTryed few times but can\'t downloaded the package. \r\nCan you help us , pls?\r\n\r\nThank you,\r\nAdrian Teaca\r\nSlobozia Municipality',NULL,'low','New',NULL,'2018-07-09 12:00:35',NULL),
(308,NULL,NULL,NULL,2354,'Current Development Status','Hi There,\r\nHow are you?\r\nWe use the Sximo 5 LTS - Builder version, and notice that you have taken it out of CodeCanyon, and in your website you have a new version S5 Ultimate, please advice what is going on so we can keep using and upgrating your products.\r\n\r\nMany thanks\r\nRui Tito',NULL,'low','New',NULL,'2018-08-01 07:51:57',NULL),
(309,NULL,NULL,NULL,2628,'how can I download the ultimate sximo?','I just bought Sximo ultimate as you can see in my licenses page. If I click on download button on sximo ultimate, I am send to paypal page again. Beside that after I completed the payment, I realized that there is an upgrade license for 14 dollars wich I should be eligible for since I bought sximo lts 2 years ago. I think I should be refunded the difference 31 - 14 dollars. What do you think about it?',NULL,'low','New',NULL,'2018-08-02 13:33:39',NULL),
(310,NULL,NULL,NULL,4001,'Inquiry','Greetings!\r\n\r\ni would like to purchase the 31$ package. After i pay via paypal, how can i get the source code?',NULL,'low','New',NULL,'2018-08-13 16:41:50',NULL),
(311,NULL,NULL,NULL,4003,'s5 ultimate','Hi, i bought S5 ultimate but i don\'t know how to use or download project. Can you help me?',NULL,'low','New',NULL,'2018-08-14 14:45:34',NULL),
(312,NULL,NULL,NULL,4007,'editing fields from user','Hi, I was wondering how would I enable permission, so that the user who adds a listing to the table is able to edit only the listing they added and not the entire table itself\r\n\r\nThanks',NULL,'low','New',NULL,'2018-08-17 17:15:47',NULL),
(313,NULL,NULL,NULL,13,'test','test',NULL,'low','New',NULL,'2018-08-19 13:50:31',NULL),
(314,NULL,NULL,NULL,3922,'Frontend Refresh Data Table','Hello,\r\n\r\nI have a quick question: I did perform a few changes to the database (Add a new blank column) and I want to be able to view that inside Sximo Table and Forms.\r\n\r\nCurrently, I can\'t.\r\n\r\nCan you tell me what I have to do in order to refresh everything and see the view and forms inside sximo?\r\n\r\nThank you.',NULL,'low','New',NULL,'2018-08-20 07:20:13',NULL),
(315,NULL,NULL,NULL,4008,'License belum terbit','Saya sudah lakukan pembayaran untuk Sximo Ultimate, tapi belum dapat licensenya.\r\nMohon bantuannya untuk menyediakan licensenya segera.\r\nTerima kasih.',NULL,'low','New',NULL,'2018-08-20 10:29:29',NULL),
(316,NULL,NULL,NULL,4022,'buy  Upgrade License For only $ 14','Hi, I bought:\r\nItem URL:\r\nhttps://codecanyon.net/item/laravel-crud-cms-sximo-5-lts/11893533\r\nItem ID:\r\n11893533\r\nI also have the Item Purchase Code,\r\nPurchase Date:\r\n2018-06-04 09:44:52 UTC\r\nnow I would like to buy here Upgrade License For only $ 14 how should I proceed?\r\nthank you',NULL,'low','New',NULL,'2018-09-09 13:08:00',NULL),
(317,NULL,NULL,NULL,884,'how to use chat and note in S5 Ultimate','how to use chat and note in S5 Ultimate\r\n\r\nboleh bantu gan cara install chat dan note di S5 Ultimate \r\n\r\nplease gan',NULL,'low','New',NULL,'2018-09-13 08:42:55',NULL),
(318,NULL,NULL,NULL,884,'How to Use Basecamp','Halo gan \r\nbagaimana install modul to do task \r\n\r\nbasecamp\r\n\r\nboleh bantu kah ?',NULL,'low','New',NULL,'2018-09-13 09:54:57',NULL),
(319,NULL,NULL,NULL,3901,'BUG FILTER SEARCHING','* struktur database saya :\ntb_ceklist :\n- id\n- jabatan\n- ceklist\n\n* Di menu control panel -> bangun kode -> perbaharui -> form dan kolom searchable yang di centang hanya kolom jabatan lalu di klik save change.\n* Jika query pencarian di database dengan kondisi like di jabatan atau like ceklist maka total 44\n* Jika query pencarian di database dengan kondisi like di jabatan maka total 16\n* Kenapa Ketika di lakukan pencarian dengan pencarian 15 yang muncul totalnya 44 data seharusnya 16 data  karena di menu superadmin yang di centang searchable hanya kolom jabatan\n\nMohon bantuannya untuk solusinya. Terima kasih',NULL,'low','New',NULL,'2018-09-25 09:36:17',NULL),
(320,NULL,NULL,NULL,3901,'Bug Join','* struktur database saya :\ntb_ceklist :\n- id\n- jabatan\n- ceklist\n\ntb_mst_ceklist :\n- id_mst_ceklist\n- nama_mst_ceklist\n\njoin :\n- Master table : tb_mst_ceklist\n- Join Table : tb_ceklist\n- Master key : id_mst_ceklist\n- Joined key : ceklist\n\n\n* Di menu control panel -> bangun kode -> perbaharui -> SQL dilakukan joint antara table tb_ceklist dengan tb_mst_ceklist\n* Lalu di tab table yang di centang kolom jabatan dan nama_mst_ceklist\n* Kenapa di tab Form tidak muncul kolom yang telah di joint sebagaimana yg terdapat di tab table ? Bagaimana filter pencarian ketika akan di lakukan pencarian filter\n* Di table datatable kenapa yg muncul hanya kolom jabatan, padahal di tab Table saya mencentang 2 kolom yaitu kolom jabatan dan nama_mst_ceklist \n* Bagaimana caranya agar ketika di filter search bisa berdasarkan kolom join yang di centang di superadmin control panel -> bangun kode -> perbaharui -> Form',NULL,'low','New',NULL,'2018-09-25 09:39:26',NULL),
(321,NULL,NULL,NULL,2578,'https routing configuration','hi, i need to configure https protocol on sximo \nthere is a procedure ?',NULL,'low','New',NULL,'2018-09-27 13:41:26',NULL),
(322,NULL,NULL,NULL,2700,'git access','when we will have the access to the git?',NULL,'low','New',NULL,'2018-09-28 11:05:03',NULL),
(323,NULL,NULL,NULL,563,'Acess to bitbucket','Hi, pleaase give acess to bitbucket.\nhttps://kangopik@bitbucket.org/kangopik/s6.git\nI am still waiting aproval. Thanks in advance',NULL,'low','New',NULL,'2018-09-28 15:09:49',NULL),
(324,NULL,NULL,NULL,4047,'Error on adding menu','hello support, \r\n\r\nthere is a error when i try to add menu, please help\r\n\r\nError Number: 1366\r\n\r\nIncorrect integer value: \'\' for column \'parent_id\' at row 1\r\n\r\nINSERT INTO `tb_menu` (`parent_id`, `module`, `url`, `menu_name`, `menu_type`, `role_id`, `deep`, `ordering`, `position`, `menu_icons`, `active`, `access_data`, `allow_guest`) VALUES (\'\', \'rujie\', \'\', \'adsadsa\', \'internal\', NULL, NULL, NULL, \'top\', \'\', \'1\', \'{\\\"1\\\":\\\"0\\\",\\\"2\\\":\\\"0\\\",\\\"3\\\":\\\"1\\\"}\', \'0\')\r\n\r\nFilename: core/SB_Model.php\r\n\r\nLine Number: 120',NULL,'low','New',NULL,'2018-10-25 08:06:53',NULL),
(325,NULL,NULL,NULL,2578,'sximo gdpr patch ?','information about gdpr over sximo ultimate ?',NULL,'low','New',NULL,'2018-10-29 09:21:33',NULL),
(326,NULL,NULL,NULL,2096,'Discount for existing license holder of sximo 5 lts cant find and if i download sximo 5 ultimate will get New Sximo 5.1.9 Beta','Discount for existing license holder of sximo 5 lts cant find,\nif i download sximo 5 ultimate will get New Sximo 5.1.9 Beta can i see the demo of sximo 5 ultimate and what its version****text****',NULL,'low','New',NULL,'2018-11-13 13:52:46',NULL),
(327,NULL,NULL,NULL,2,'test','test',NULL,'low','New',NULL,'2018-12-09 15:54:22',NULL),
(328,NULL,NULL,NULL,583,'Multiples subforms ou multiples modules in one page linked','It will help a lot.\nMultiples subforms in one module or multiples modules in one page linked',NULL,'low','Processed',NULL,'2018-12-17 00:46:51',NULL),
(329,NULL,NULL,NULL,4064,'Issues on creating modules','Hello, I have configured S5 LTS on my hosting.. When I try to add a module I can choose between native, report or blank, but if i choose the native option, the module is created as a report.. I tried a lot of times but still got this issue... can you help me?.\r\n\r\nAnother question: what is the difference betwwen the LTS and the Ultimate versions of your script?\r\nAnd what about the console version? \r\nIn the home page I have read this pinned message, but I don\'t understand, the new mentioned version is for the SximoConsole? If i buy this module now, I can upgrade it to the new version?:\r\n\r\n\r\nWe\'are Back !\r\n\r\nWe\'are working on reviews for all current project except SximoConsole , and we will release new version ASAP\r\nDeadline on January 30 , 2019',NULL,'low','New',NULL,'2018-12-19 07:50:03',NULL),
(330,NULL,NULL,NULL,4068,'entry_by field','I want users only able to access they own records.\n\n\nI have unchecked Global in Permission.\n\nI have tried to create entry_by field but not works because i dont clearly understand whats entry_by field.\n\n\n\nPlease tell me step by step to create entry_by field.',NULL,'low','New',NULL,'2018-12-30 04:26:40',NULL),
(331,NULL,NULL,NULL,4068,'error upload file','I’m getting following error when i upload csv file using Import CSV option.. In browser console also the data is not imported it just saying success message and closing popup.\n\nAlso when i download the template where can i specify necessary fields to upload instead of everything?',NULL,'low','Processed',NULL,'2019-01-02 06:13:59',NULL),
(332,NULL,NULL,NULL,3559,'Sximo sc','bang ada link utk coba demo crud nya ga yg sc? ini terbuat dr code igniter ? apa ada utk menu membuat chart secara builder?',NULL,'low','New',NULL,'2019-01-07 23:16:15',NULL),
(333,NULL,NULL,NULL,4074,'yang sximo 5 ultimate kok banyak kekurangannya ya','bulan kemarin saya beli sximo 5 ultimate, tetapi hari ini saya pakai, dan ternyata banyak sekali kekurangan termasuk ada bug juga, seperti saat saya mau membuat Page CMS, disana saya tidak bisa membuatnya karena menu pilihan (select) tidak bekerja.\nmasih di page cms pada \"Set As Homepage\" pilihan Ya / Tidak nya juga tidak tampil.\n\npada menu builder code juga tidak disediakan link untuk kita tampilkan di halaman frondend\n\n\nmohon mas taufik memperbarui hal tersebut, saya sudah beberapa kali mengirimkan email tetapi tidak ada respon',NULL,'low','Processed',NULL,'2019-01-11 06:41:47',NULL),
(334,NULL,NULL,NULL,4077,'No download','Hi, I just bought Sximo Ultimate but did not receive anything for download.',NULL,'low','New',NULL,'2019-01-12 15:40:53',NULL),
(335,NULL,NULL,NULL,4077,'Problem with PHP 7','I am having few issues. I\'m using WAMP with PHP 7.1 and MYSql 5.7. I\'m able to install but when change the setting of the application from dashboard they does not store also the image of the logo is not uploading. Filter button in the CRUD view is also not working. Help please.',NULL,'low','Processed',NULL,'2019-01-14 16:30:30',NULL),
(336,NULL,NULL,NULL,4080,'trouble setting ul','hi \nreally like the idea of this app bit i cant get pass the login \nhave tried downloading the new version you sent me but still the same.\nmy username on code canyon is \npaultaylor08\ni have hosted server and lamp install \nplease help\npaul',NULL,'low','Processed',NULL,'2019-01-17 02:35:10',NULL),
(337,NULL,NULL,NULL,4081,'table db issues','Hi. I created new table in your example db, but I don\'t show it in Manage Database Table. Why ?',NULL,'low','Processed',NULL,'2019-01-17 15:51:17',NULL),
(338,NULL,NULL,NULL,4079,'i need modules for sximo 5 ultimate','hi i need sximo 5 ultimate modules',NULL,'low','Processed',NULL,'2019-01-18 07:54:14',NULL),
(339,NULL,NULL,NULL,4083,'Sximopress issue','Hi i purchased sximopress from codecanyon i am facing an issue ...if plugin is active and i create or edit any post or page i cant see post/page text and also when i try to save it .. IT doesn\'t save but if plugin is deactive everything works fine. Please fix it',NULL,'low','New',NULL,'2019-01-18 20:00:45',NULL),
(340,NULL,NULL,NULL,2727,'Transaksi selain codecanyon.net','mohon informasi untuk pembelian non codecanyon.net apakah bisa menggunakan bank transfer?\nterma kasih',NULL,'low','Processed',NULL,'2019-01-23 03:13:24',NULL),
(341,NULL,NULL,NULL,4079,'i need modules for sximo 5 ultimate','i am unable to use modules',NULL,'low','New',NULL,'2019-01-29 05:41:41',NULL),
(342,NULL,NULL,NULL,583,'Continuation of the project','Will this project continue? Or will the support be suspended?',NULL,'low','New',NULL,'2019-01-29 15:43:39',NULL),
(343,NULL,NULL,NULL,4072,'Sximo 5 LTS look','Hello!\nI bought SXIMO 5 LTS and Ajax Plugins.\n\nIt is possible that the looks like this: http://sximo6.sximobuilder.com/dashboard\n\nhttps://ibb.co/QCTDL4F\n\n\nIf so, how?\nWhat should I do to parameterize this look?\n\nThanks!\n\nBest regards!',NULL,'low','New',NULL,'2019-01-29 18:30:55',NULL),
(344,NULL,NULL,NULL,4086,'Extend License','Hi, what is the meaning of the Extend License (800$)?\r\nWhat can I do with this license?\r\nThanks',NULL,'low','New',NULL,'2019-01-29 21:09:29',NULL),
(345,NULL,NULL,NULL,4072,'JQuery Sximo 5 LTS + download problem','Hello!\n\nI can’t download JQuery Sximo 5 LTS + (Updated : Nov 23, 2017)! \nhttp://www.sximoinc.com/source/jquery.net-crud-plugins?download=jquery-sximo-5-lts-\n\n(file not found)\n\n\nI can only download the previous 5.1.9 (Updated : May 13, 2017) file.\n\nPlease help! \n\nThanks!',NULL,'low','New',NULL,'2019-01-30 09:34:11',NULL),
(346,NULL,NULL,NULL,4088,'http://sximoinc.com/source/sximo-5-lts-builder?download=sximo-5-lts-v.6','Malam gan,\n\nKemarin sudah beli di envato Laravel Multi Purpose Application - CRUD - CMS - Sximo 5 LTS dengan user: pras5158 License envato: 23ec8655-6d25-4a75-9982-79437b0a9ce3 - 29 Jan 2019\n\nAda beberapa yang akan ditanyakan :\n\n1. Saat merubah field menjadi Upload file radio button untuk memilih file/image dan allow multiple tidak muncul (didemonya juga tidak muncul)\n\n2. Apa perbedaan Sximo 5 LTS, S5 Ultimate dan sximo6 (demo)\n\n3. Apa ada nomor WA ?\n\n4. Untuk donload versi 6 apa harus beli lisensi lagi ? http://sximoinc.com/source/sximo-5-lts-builder?download=sximo-5-lts-v.6\n\nMohon solusinya ya gan\n\nTerima kasih',NULL,'low','New',NULL,'2019-01-31 13:55:20',NULL),
(347,NULL,NULL,NULL,4079,'i am ubale to import modules in sximo 5 lts','hi i am unable to import modules like customer orderrs',NULL,'low','New',NULL,'2019-02-01 07:21:57',NULL),
(348,NULL,NULL,NULL,4090,'Unable to login','Nothing works. I\'ve wasted a lot of time with this.',NULL,'low','New',NULL,'2019-02-03 03:44:01',NULL),
(349,NULL,NULL,NULL,4079,'i need free modules for sximo 5 ultimate','i need free modules for sximo 5 ultimate',NULL,'low','New',NULL,'2019-02-08 03:46:13',NULL),
(350,NULL,NULL,NULL,4079,'i need free modules for sximo 5 ultimate','i need free modules for sximo 5 ultimate',NULL,'low','New',NULL,'2019-02-08 03:46:25',NULL),
(351,NULL,NULL,NULL,4079,'i need free modules for sximo 5 ultimate','i need free modules for sximo 5 ultimate',NULL,'low','New',NULL,'2019-02-08 03:46:37',NULL),
(352,NULL,NULL,NULL,4095,'Data Privecy','Dear Manggopik\r\n\r\nThank for great Application,\r\n\r\nI have three questions\r\n\r\n1-How to force users to access only there own data, in module I remove **Golbal** Check and add **entry_by** field,in this way user can see only thier own data ,but can access other users data by changing ID number in the url. for example anymodule/update/**168**?return=\r\n\r\n2-How can I add file Privecy so that files that stored in **public** folder can not be accessd without login\r\nand also users can access only thier own files\r\n\r\n3-is RTL is supported in this new verstion?\r\n\r\nThanks For Support',NULL,'low','New',NULL,'2019-02-13 12:46:52',NULL),
(353,NULL,'marketing',NULL,4,'simpan ID tambahan otomotis','<p>saya ingin membuat ID tambahan yang di generate otomatis. ID ini akan disimpan saat proses menyimpan formnya. cuma saya kebingunan untuk bagaimana cara menyimpan ID yang saya generate ini saat form disimpan.\r\n</p><pre>\\DB::table(\'profile\')-&gt;where(\'id\', $request-&gt;input(\'id\'))-&gt;update(array(\'lead_id\' =&gt; $rand));\r\n</pre><p> saya coba pakai code itu, tidak tersimpan hasilnya</p>',NULL,'low','New',NULL,'2019-03-01 03:31:24',NULL),
(354,NULL,NULL,NULL,1172,'checkbox tidak muncul','checkbox di module generatornya tidak muncul',NULL,'low','New',NULL,'2019-03-01 08:17:35',NULL),
(355,NULL,NULL,NULL,1172,'versi sximo','apakah ada perbedaan antara vrsi sximo yang ada disini dengan yang ada di envato?\r\nkok sximo ini parah banget ya bug nya. padahal saya lagi dikejar deadline buat contact database. makanya saya beli lagi yang versi 5 ini, padahal saya sudah pernah beli sebelumnya\r\n\r\n\r\ntolong di respon donk',NULL,'low','New',NULL,'2019-03-01 08:31:46',NULL),
(356,NULL,NULL,NULL,4107,'i can\'t upload file','http://wood.thaiphangad.com/public\n\nEmail Address : superadmin@mail.com \nPassword : password \n\nplese help me',NULL,'low','New',NULL,'2019-03-26 18:33:53',NULL),
(357,NULL,NULL,NULL,4108,'Perbedaan Sximo LTS, Sximo Ultimate sama SPA','Halo Kang, saya mau tanya ini rencana mungkin minggu depan mau beli ini, dlu beli yang datatable nya udah oke, skrg pgn ke laravel nya itu bedanya apa yah yg LTS sama ULtimate, trus yg SPA kan baru tah, itu kan pake Vue sama CI , powerfull yang mana kang sama ultimate? terus beda harganya brapa?',NULL,'low','New',NULL,'2019-03-29 05:51:26',NULL),
(358,NULL,NULL,NULL,2605,'Checkbox di konfigurasi form upload tidak tampil','Checkbox di konfigurasi form upload tidak tampil saat saya ingin membuat file jadi multiple upload. tolong di cek',NULL,'low','New',NULL,'2019-04-02 11:11:41',NULL),
(359,NULL,NULL,NULL,4119,'Cascade Master Detail not displaying data','Got an instance of your CRUD generator, great stuff!!\n\nI have a problem:  When I setup a master detail a first level it works but at a second level of master detail, the data does not show up.   Is this a Bug?  How do I correct it??\n\nSee picture link\n\nhttps://onedrive.live.com/?cid=E19EB7CE2138DAA9&id=E19EB7CE2138DAA9%2113304&parId=E19EB7CE2138DAA9%21120&o=OneUp\n\n\nNeed help soon!!  THANK YOU',NULL,'low','New',NULL,'2019-05-07 07:32:23',NULL),
(360,NULL,NULL,NULL,1,'Access to S5 Ultimate and Sximo Console','Hi Team, \n\nI have previously purchased Sximo Builder and jQuery.net CRUD Plugins. \n\nHow can I download the latest versions? I get the error \"You dont have licence for this project !\" when I try. \n\nDaniel',NULL,'low','New',NULL,'2019-05-25 08:59:00',4),
(361,NULL,NULL,NULL,4,'Tanya sebelum pembelian','siang mas, mau nanya apa beda antara sximo 5 lts dengan s5 ultimate? apa masih disupport semuanya? rencanaya mau beli cuma bingung pilih diantara keduanya',NULL,'low','Completed',NULL,'2019-06-06 06:22:19',4),
(362,NULL,NULL,NULL,1,'Unable to Install','npm run dev\n\n> y@1.0.0 dev /var/www/023-cryptocafe.com.br/client\n> webpack-dev-server --inline --progress --config build/webpack.dev.conf.js\n\n/usr/bin/env: ‘node’: No such file or directory\n\nnpm ERR! Linux 4.4.0-154-generic\nnpm ERR! argv \"/usr/bin/nodejs\" \"/usr/bin/npm\" \"run\" \"dev\"\nnpm ERR! node v4.2.6\nnpm ERR! npm  v3.5.2\nnpm ERR! file sh\nnpm ERR! code ELIFECYCLE\nnpm ERR! errno ENOENT\nnpm ERR! syscall spawn\nnpm ERR! y@1.0.0 dev: `webpack-dev-server --inline --progress --config build/webpack.dev.conf.js`\nnpm ERR! spawn ENOENT\nnpm ERR! \nnpm ERR! Failed at the y@1.0.0 dev script \'webpack-dev-server --inline --progress --config build/webpack.dev.conf.js\'.\nnpm ERR! Make sure you have the latest version of node.js and npm installed.\nnpm ERR! If you do, this is most likely a problem with the y package,\nnpm ERR! not with npm itself.\nnpm ERR! Tell the author that this fails on your system:\nnpm ERR!     webpack-dev-server --inline --progress --config build/webpack.dev.conf.js\nnpm ERR! You can get information on how to open an issue for this project with:\nnpm ERR!     npm bugs y\nnpm ERR! Or if that isn\'t available, you can get their info via:\nnpm ERR!     npm owner ls y\nnpm ERR! There is likely additional logging output above.\n\nnpm ERR! Please include the following file with any support request:',NULL,'low','Pending',NULL,'2019-07-27 04:45:02',1),
(363,NULL,'marketing',NULL,4,'Help me download S5 Ultimate','Help me download S5 Ultimate . I paid paypal $ 31 . I don\'t see the download link of S5 Ultimate',NULL,'low','Processed',NULL,'2019-08-14 01:10:11',4),
(364,NULL,'marketing',NULL,4,'New Ticket teste : Discount for existing license holder of sximo 5 lts cant find and if i download sximo 5 ultimate will get New Sximo 5.1.9 Beta','Got an instance of your CRUD generator, great stuff!!\r\n\r\nI have a problem:  When I setup a master detail a first level it works but at a second level of master detail, the data does not show up.   Is this a Bug?  How do I correct it??\r\n\r\nSee picture link\r\n\r\nhttps://onedrive.live.com/?cid=E19EB7CE2138DAA9&id=E19EB7CE2138DAA9%2113304&parId=E19EB7CE2138DAA9%21120&o=OneUp\r\n\r\n\r\nNeed help soon!!  THANK YOU',NULL,'low','Pending',NULL,'2019-11-25 12:15:13',4),
(365,NULL,'marketing',NULL,1,'Pembayaran Invoice #19245','<p>Mohon untuk membantu mengaktivkan account sya , saya telah melakukan pembayaran&nbsp;</p>',NULL,'medium','New',NULL,'2019-11-26 04:39:21',NULL),
(366,364,NULL,NULL,1,NULL,'<p>Okay , thanks for contacting us</p>',NULL,'low','New',NULL,'2019-11-27 01:58:16',NULL),
(369,364,NULL,NULL,4,NULL,'<p>Okay Thanks</p>',NULL,'low','New',NULL,'2019-11-27 02:07:59',NULL);

