sql error

scott_white85 · September 13, 2011

i tried to transferred the sql database from remote to local and then i got this error message

-- -- Dumping data for table `orders_total` -- INSERT INTO `orders_total`

(`orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order`)

VALUES (128, 42, 'Sub-Total:', 'S$400.00', 400.0000, 'ot_subtotal', 1),

(129, 42, 'United Parcel Service (1 pkg x 0 kgs total)

(UPS Worldwide Expedited (billed dimensional weight 1 KGS)):',

'S$52.86', 52.8600, 'ot_shipping', 2), (130, 42, 'Total:', 'S$452.86', 452.8600, 'ot_total', 4),

(131, 43, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(132, 43, 'United Parcel Service (1 pkg x 0 kgs total)

(UPS Worldwide Expedited (billed dimensional weight 1 KGS)):',

'S$51.26', 51.2600, 'ot_shipping', 2),

(133, 43, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(134, 44, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),

(135, 44, 'United Parcel Service (1 pkg x 6 kgs total)

(UPS Worldwide Expedited

(billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(136, 44, 'Total:', 'S$690.78', 6[...]

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2),

(' at line 206

this is the original code of table `orders_total`see below:

CREATE TABLE `orders_total` (

`orders_total_id` int(10) unsigned NOT NULL auto_increment,

`orders_id` int(11) NOT NULL,

`title` varchar(255) NOT NULL,

`text` varchar(255) NOT NULL,

`value` decimal(15,4) NOT NULL,

`class` varchar(32) NOT NULL,

`sort_order` int(11) NOT NULL,

PRIMARY KEY (`orders_total_id`),

KEY `idx_orders_total_orders_id` (`orders_id`)

) ENGINE=InnoDB AUTO_INCREMENT=1225 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1225 ;

--

-- Dumping data for table `orders_total`

--

INSERT INTO `orders_total` (`orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order`) VALUES (128, 42, 'Sub-Total:', 'S$400.00', 400.0000, 'ot_subtotal', 1),

(129, 42, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$52.86', 52.8600, 'ot_shipping', 2),

(130, 42, 'Total:', 'S$452.86', 452.8600, 'ot_total', 4),

(131, 43, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(132, 43, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(133, 43, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(134, 44, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),

(135, 44, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(136, 44, 'Total:', 'S$690.78', 690.7800, 'ot_total', 4),

(137, 45, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(138, 45, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(139, 45, 'Total:', 'S$201.26', 201.2600, 'ot_total', 4),

(140, 46, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(141, 46, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(142, 46, 'Total:', 'S$201.26', 201.2600, 'ot_total', 4),

(143, 47, 'Sub-Total:', 'S$710.00', 710.0000, 'ot_subtotal', 1),

(144, 47, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$54.46', 54.4600, 'ot_shipping', 2),

(145, 47, 'Total:', 'S$764.46', 764.4600, 'ot_total', 4),

(146, 48, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),

(147, 48, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(148, 48, 'Total:', 'S$690.78', 690.7800, 'ot_total', 4),

(149, 49, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1),

(150, 49, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(151, 49, 'Total:', 'S$680.78', 680.7800, 'ot_total', 4),

(152, 50, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(153, 50, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(154, 50, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(155, 51, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(156, 51, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(157, 51, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(158, 52, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(159, 52, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(160, 52, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(161, 53, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(162, 53, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(163, 53, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(164, 54, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(165, 54, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(166, 54, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(167, 55, 'Sub-Total:', 'S$300.00', 300.0000, 'ot_subtotal', 1),

(168, 55, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$52.06', 52.0600, 'ot_shipping', 2),

(169, 55, 'Total:', 'S$352.06', 352.0600, 'ot_total', 4),

(170, 56, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(171, 56, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2),

(172, 56, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),

(173, 57, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1),

(174, 57, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(175, 57, 'Total:', 'S$680.78', 680.7800, 'ot_total', 4),

(176, 58, 'Sub-Total:', 'S$900.00', 900.0000, 'ot_subtotal', 1),

(177, 58, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$55.26', 55.2600, 'ot_shipping', 2),

(178, 58, 'Total:', 'S$955.26', 955.2600, 'ot_total', 4),

(179, 59, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1),

(180, 59, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(181, 59, 'Total:', 'S$680.78', 680.7800, 'ot_total', 4),

(182, 60, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),

(183, 60, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(184, 60, 'Total:', 'S$690.78', 690.7800, 'ot_total', 4),

(185, 62, 'Sub-Total:', 'S$1,680.00', 1680.0000, 'ot_subtotal', 1),

(186, 62, 'United Parcel Service (1 pkg x 18 kgs total) (UPS Worldwide Expedited (billed dimensional weight 18 KGS)):', 'S$207.08', 207.0800, 'ot_shipping', 2),

(187, 62, 'Total:', 'S$1,887.08', 1887.0800, 'ot_total', 4),

(188, 63, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),

(189, 63, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(190, 63, 'Total:', 'S$690.78', 690.7800, 'ot_total', 4),

(191, 64, 'Sub-Total:', 'S$888.00', 888.0000, 'ot_subtotal', 1),

(192, 64, 'United Parcel Service (1 pkg x 12 kgs total) (UPS Worldwide Expedited (billed dimensional weight 12 KGS)):', 'S$182.71', 182.7100, 'ot_shipping', 2),

(193, 64, 'Total:', 'S$1,070.71', 1070.7100, 'ot_total', 4),

(194, 65, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1),

(195, 65, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),

(196, 65, 'Total:', 'S$578.78', 578.7800, 'ot_total', 4),

(197, 66, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1),

(198, 66, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2),

(199, 66, 'Total:', 'S$577.98', 577.9800, 'ot_total', 4),

(200, 67, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1),

(201, 67, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2),

(202, 67, 'Total:', 'S$577.98', 577.9800, 'ot_total', 4),

(203, 68, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1),

(204, 68, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2),

(205, 68, 'Total:', 'S$577.98', 577.9800, 'ot_total', 4),

(206, 69, 'Sub-Total:', 'S$456.00', 456.0000, 'ot_subtotal', 1),

(207, 69, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$128.38', 128.3800, 'ot_shipping', 2),

(208, 69, 'Total:', 'S$584.38', 584.3800, 'ot_total', 4),

(209, 70, 'Sub-Total:', 'S$1,057.00', 1057.0000, 'ot_subtotal', 1),

(210, 70, 'United Parcel Service (1 pkg x 13 kgs total) (UPS Worldwide Expedited (billed dimensional weight 13 KGS)):', 'S$191.30', 191.3000, 'ot_shipping', 2),

(211, 70, 'Total:', 'S$1,248.30', 1248.3000, 'ot_total', 4),

(212, 71, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(213, 71, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2),

(214, 71, 'Total:', 'S$521.98', 521.9800, 'ot_total', 4),

(215, 72, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1),

(216, 72, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Saver (billed dimensional weight 6 KGS)):', 'S$143.85', 143.8500, 'ot_shipping', 2),

(217, 72, 'Total:', 'S$528.85', 528.8500, 'ot_total', 4),

(218, 73, 'Sub-Total:', 'S$920.00', 920.0000, 'ot_subtotal', 1),

(219, 73, 'United Parcel Service (1 pkg x 12 kgs total) (UPS Worldwide Expedited (billed dimensional weight 12 KGS)):', 'S$183.51', 183.5100, 'ot_shipping', 2),

(220, 73, 'Total:', 'S$1,103.51', 1103.5100, 'ot_total', 4),

(221, 74, 'Sub-Total:', 'S$732.00', 732.0000, 'ot_subtotal', 1),

(222, 74, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$131.58', 131.5800, 'ot_shipping', 2),

(223, 74, 'Total:', 'S$863.58', 863.5800, 'ot_total', 4),

(224, 75, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(225, 75, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$107.62', 107.6200, 'ot_shipping', 2),

(226, 75, 'Total:', 'S$499.62', 499.6200, 'ot_total', 4),

(227, 76, 'Sub-Total:', 'S$1,155.00', 1155.0000, 'ot_subtotal', 1),

(228, 76, 'United Parcel Service (1 pkg x 18 kgs total) (UPS Worldwide Expedited (billed dimensional weight 18 KGS)):', 'S$185.48', 185.4800, 'ot_shipping', 2),

(229, 76, 'Total:', 'S$1,340.48', 1340.4800, 'ot_total', 4),

(230, 77, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(231, 77, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$107.62', 107.6200, 'ot_shipping', 2),

(232, 77, 'Total:', 'S$499.62', 499.6200, 'ot_total', 4),

(239, 81, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(240, 81, 'Total:', 'S$392.00', 392.0000, 'ot_total', 4),

(241, 82, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(242, 82, 'Total:', 'S$392.00', 392.0000, 'ot_total', 4),

(243, 83, 'Sub-Total:', 'S$784.00', 784.0000, 'ot_subtotal', 1),

(244, 83, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(245, 83, 'FL TAX 7.0%:', 'S$54.88', 54.8800, 'ot_tax', 3),

(246, 83, 'Total:', 'S$838.88', 838.8800, 'ot_total', 4),

(247, 84, 'Sub-Total:', 'S$784.00', 784.0000, 'ot_subtotal', 1),

(248, 84, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(249, 84, 'FL TAX 7.0%:', 'S$54.88', 54.8800, 'ot_tax', 3),

(250, 84, 'Total:', 'S$838.88', 838.8800, 'ot_total', 4),

(257, 87, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1),

(258, 87, 'Courier (UPS):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(259, 87, 'Total:', 'S$385.00', 385.0000, 'ot_total', 4),

(260, 88, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1),

(261, 88, 'Courier (UPS):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(262, 88, 'Total:', 'S$385.00', 385.0000, 'ot_total', 4),

(271, 91, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(272, 91, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(273, 91, 'FL TAX 7.0%:', 'S$27.44', 27.4400, 'ot_tax', 3),

(274, 91, 'Total:', 'S$419.44', 419.4400, 'ot_total', 4),

(277, 93, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(278, 93, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(279, 93, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(280, 94, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(281, 94, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(282, 94, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(283, 95, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(284, 95, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(285, 95, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(292, 98, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(293, 98, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(294, 98, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(295, 99, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(296, 99, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(297, 99, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(314, 104, 'Sub-Total:', 'S$934.00', 934.0000, 'ot_subtotal', 1),

(315, 104, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(316, 104, 'FL TAX 7.0%:', 'S$65.38', 65.3800, 'ot_tax', 3),

(317, 104, 'Total:', 'S$999.38', 999.3800, 'ot_total', 4),

(318, 105, 'Sub-Total:', 'S$934.00', 934.0000, 'ot_subtotal', 1),

(319, 105, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(320, 105, 'FL TAX 7.0%:', 'S$65.38', 65.3800, 'ot_tax', 3),

(321, 105, 'Total:', 'S$999.38', 999.3800, 'ot_total', 4),

(322, 106, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(323, 106, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(324, 106, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(325, 107, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(326, 107, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(327, 107, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(328, 108, 'Sub-Total:', 'S$450.00', 450.0000, 'ot_subtotal', 1),

(329, 108, 'Special (Flotech Singapore will call you):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(330, 108, 'Total:', 'S$450.00', 450.0000, 'ot_total', 4),

(331, 109, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),

(332, 109, 'Sea (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(333, 109, 'Total:', 'S$0.00', 0.0000, 'ot_total', 4),

(334, 110, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(335, 110, 'Special (Flotech Singapore will call you):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(336, 110, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(337, 111, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(338, 111, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(339, 111, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(340, 112, 'Sub-Total:', 'S$800.00', 800.0000, 'ot_subtotal', 1),

(341, 112, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(342, 112, 'Total:', 'S$800.00', 800.0000, 'ot_total', 4),

(343, 113, 'Sub-Total:', 'S$777.00', 777.0000, 'ot_subtotal', 1),

(344, 113, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(345, 113, 'Total:', 'S$777.00', 777.0000, 'ot_total', 4),

(346, 114, 'Sub-Total:', 'S$770.00', 770.0000, 'ot_subtotal', 1),

(347, 114, 'Courier (DHL - <a href="#">click here for pricing calculation</a>):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(348, 114, 'Total:', 'S$770.00', 770.0000, 'ot_total', 4),

(349, 115, 'Sub-Total:', 'S$535.00', 535.0000, 'ot_subtotal', 1),

(350, 115, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(351, 115, 'Total:', 'S$535.00', 535.0000, 'ot_total', 4),

(352, 116, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(353, 116, 'Sea (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(354, 116, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(355, 117, 'Sub-Total:', 'S$300.00', 300.0000, 'ot_subtotal', 1),

(356, 117, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(357, 117, 'Total:', 'S$300.00', 300.0000, 'ot_total', 4),

(358, 118, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1),

(359, 118, 'Courier (DHL - <a href="#">click here for pricing calculation</a>):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(375, 123, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(376, 124, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(377, 124, 'Courier (DHL - Pricing: <a href="jumbo.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3TwsqdeDyImwGrpS4&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f" rel="nofollow" target="_blank">Jumbo Box</a> | <a href="export.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3Twsq',&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2),

(378, 124, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(379, 125, 'Sub-Total:', 'S$200.00', 200.0000, 'ot_subtotal', 1),

(380, 125, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(381, 125, 'Total:', 'S$200.00', 200.0000, 'ot_total', 4),

(382, 126, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1),

(383, 126, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2),

(384, 126, 'Total:', 'S$150.00', 150.0000, 'ot_total', 4),

(385, 127, 'Sub-Total:', 'S$140.00', 140.0000, 'ot_subtotal', 1),

(386, 127, 'Courier (DHL - Ref. Rate: <a href="jumbo.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3TwsqdeDyImwGrpS4&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f" rel="nofollow" target="_blank">Jumbo Box</a> | <a href="export.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3Tw',&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2),

(387, 127, 'Total:', 'S$140.00', 140.0000, 'ot_total', 4),

♥geoffreywalton · September 13, 2011

Edit all the lines with phpmyadmin it them, here is one example

(377, 124, 'Courier (DHL - Pricing: <a href="jumbo.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3TwsqdeDyImwGrpS4&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f" rel="nofollow" target="_blank">Jumbo Box</a> | <a href="export.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3Twsq',&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2),

to

(377, 124, 'Courier (DHL - Pricing:Jumbo Box:', 'S$0.00', 0.0000, 'ot_shipping', 2),

Then I'd look at your carrier descriptions.

HTH

G

sql error

Recommended Posts

scott_white85

♥geoffreywalton

Archived

Browse

Activity