Jump to content
  • 0

trouble inserting items into database

carl101

Asked by carl101,

 Share

Question

carl101 Newbie

carl101

Posted
Posted

trying to add these into database traders and keep getting this error but i cant see whats its on about

 

dot.gif #1136 - Column count doesn't match value count at row 1

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["pook_H13_medevac_INS",2]',30,'[2,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',519,'trade_any_vehicle'),
('["pook_H13_amphib_CIV",2]',15,'[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle'),
('["pook_H13_civ_yellow",2]',15,'[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle'),
('["pook_H13_civ_ru_black",2]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle'),
('["pook_H13_gunship",2]', 15, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 493, 'trade_any_vehicle'),
('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons'),
('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons'),
('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons'),
('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons'),
('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons'),
('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons'),
('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons'),
('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons'),
('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons'),
('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons'),
('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 487, 'trade_weapons'),
('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]]', '[2,"ItemGoldBar10oz",1]', 526, 'trade_weapons'),
('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 477, 'trade_weapons'),
('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 508, 'trade_items'),
('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 530, 'trade_items'),
('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 662, 'trade_items'),
('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 678, 'trade_items'),
('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 680, 'trade_items');

please tell me what im missing, stared at it for ages now

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
Turtle Newbie

Turtle

Posted
Posted 
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["pook_H13_medevac_INS",2]', 30, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["pook_H13_amphib_CIV",2]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["pook_H13_civ_yellow",2]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["pook_H13_civ_ru_black",2]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 519, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["pook_H13_gunship",2]', 15, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 493, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 485, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSaw ",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawB",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawG",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawP",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ChainSawR",3]', 15, '[1,"ItemBriefcase100oz",1]', '[4,"ItemGoldBar10oz",1]', 486, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 487, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 526, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["DMR",3]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["itemcombolock",1]', 15, '[5,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 680, 'trade_items');
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to question listing
  • Advertisement

  • Discord

×
×
  • Create New...