dafoxx
April 22nd, 2009, 08:25 PM
Noob question here. Trying to upload the sql file via phpadmin. When I upload the sql file, I get the following:
http://farm4.static.flickr.com/3501/3465925547_286b670e4a_o.jpg
these are the first four insert statements:
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('10610','EASY - HATCH Fish Hatchery','9503.90.0080 - Duty = 0%','7-28369-10610-1','GEOSPACE INTERNATIONAL, Inc','Dennis Binkley, Geospace','no','no','Dongguan, China','Jun-08','','','','7.50','5.50','8.00','0.19','0.80','6','17.00','9.00','16.00','1.42','6.25','12','17.50','16.50','19.50','3.26','14.70');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('11102','RUNNAROO Running Bikes, Standard','','7-28369-11102-0','','','','','Dongguan, China','','','','','27.00','11.75','6.25','1.15','','','','','','','','2','28.50','14.00','12.00','2.77','');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('11104','RUNNAROO Running Bikes, Deluxe','','7-28369-12902-5','','','','','Dongguan, China','','','','','27.00','11.75','6.25','1.15','9.75','','','','','','','2','28.50','14.00','12.00','2.77','20.00');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('16330','R/C STUNT ROBOCAR JR','9503.90.0080 - Duty = 0%','7-28369-10630-9','GEOSPACE INTERNATIONAL, Inc','Dennis Binkley, Geospace','no','no','Shantou, China','Feb-09','','','','9.63','7.00','4.63','0.18','0.75','6','10.50','14.50','14.50','1.28','6.00','12','21.50','15.00','15.00','2.80','14.00');
I'm not seeing what is wrong.... plus it is only uploading 46 of 136 insert statements... Any and all help appreciated
http://farm4.static.flickr.com/3501/3465925547_286b670e4a_o.jpg
these are the first four insert statements:
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('10610','EASY - HATCH Fish Hatchery','9503.90.0080 - Duty = 0%','7-28369-10610-1','GEOSPACE INTERNATIONAL, Inc','Dennis Binkley, Geospace','no','no','Dongguan, China','Jun-08','','','','7.50','5.50','8.00','0.19','0.80','6','17.00','9.00','16.00','1.42','6.25','12','17.50','16.50','19.50','3.26','14.70');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('11102','RUNNAROO Running Bikes, Standard','','7-28369-11102-0','','','','','Dongguan, China','','','','','27.00','11.75','6.25','1.15','','','','','','','','2','28.50','14.00','12.00','2.77','');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('11104','RUNNAROO Running Bikes, Deluxe','','7-28369-12902-5','','','','','Dongguan, China','','','','','27.00','11.75','6.25','1.15','9.75','','','','','','','2','28.50','14.00','12.00','2.77','20.00');
INSERT INTO ITEM_MASTER (`item_no`,`description`,`harmonized_tarrif_code`,`upc_code`,`us_importer`,`records_by`,`lead`,`phthalates`,`mgf_location`,`mgf_date`,`testing_lab`,`testing_lab_location`,`testing_date`,`unit_l`,`unit_w`,`unit_h`,`unit_cube`,`est_unit_wt`,`inner_cs_pk`,`inner_l`,`inner_w`,`inner_h`,`inner_cube`,`inner_wt`,`mstr_cs_pk`,`mstr_l`,`mstr_w`,`mstr_h`,`mstr_cs_cube`,`mstr_cs_wt`) VALUES ('16330','R/C STUNT ROBOCAR JR','9503.90.0080 - Duty = 0%','7-28369-10630-9','GEOSPACE INTERNATIONAL, Inc','Dennis Binkley, Geospace','no','no','Shantou, China','Feb-09','','','','9.63','7.00','4.63','0.18','0.75','6','10.50','14.50','14.50','1.28','6.00','12','21.50','15.00','15.00','2.80','14.00');
I'm not seeing what is wrong.... plus it is only uploading 46 of 136 insert statements... Any and all help appreciated