|
You last visited: Today at 21:19
Advertisement
Add wings in sql
Discussion on Add wings in sql within the Rappelz Private Server forum part of the Rappelz category.
07/23/2015, 20:53
|
#1
|
elite*gold: 50
Join Date: Mar 2012
Posts: 1,036
Received Thanks: 428
|
Add wings in sql
I tried to add wings in sql and this is problem i get
Msg 213, Level 16, State 1, Line 5
Column name or number of supplied values does not match table definition.
here is code
use Arcadia
--All stats +60%
INSERT INTO [ItemResource] VALUES('105326','10105326','20105326','1','110','6 07','21','0','0','0','1','1','0','0','0','1','1',' 1','15','1','1','1','1','0','0','0','0','0.00','1. 00','10','0','0','0','0','3','0','1090553351','216 0000','2','0.00','0','0.00','0.00','0','0.00','0.0 0','0','0.00','0.00','0','0.00','0.00','98','8255. 00','0.70','0','0.00','0.00','0','0.00','0.00','0' ,'0.00','0.00','0','0','0.00','0.00','0.00','0.00' ,'0','0.00','0.00','0.00','0.00','0','0','0','0',' 0','0','0','0','0','0','0','0','0','black_wings_1s t','black_wings_1st','black_wings_1st','black_wing s_1st','black_wings_1st','black_wings_1st','black_ wings_1st','black_wings_1st','black_wings_1st','bl ack_wings_1st','black_wings_1st','black_wings_1st' ,'black_wings_1st','black_wings_1st','black_wings_ 1st','black_wings_1st','black_wings_1st','black_wi ngs_1st','black_wings_1st01','drop_etc_pouch','0', 'bw1','')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_item_010009','0','105326',N'Sovereign')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_item_010009','0','10105326',N'Sovereign')
INSERT INTO [StringResource] ([name], [group_id], [code], [value]) VALUES (N'name_itemtooltip_10010','0','20105326',N'@#auto _tooltip#@')
|
|
|
07/23/2015, 22:55
|
#2
|
elite*gold: 0
Join Date: May 2011
Posts: 5,086
Received Thanks: 3,472
|
The query is build for a different ItemResource structure.
Let's assume I created a table with the following columns:
[id], [name]
I've got the following query:
Code:
INSERT INTO test_table VALUES (1, 'test')
This query assumes that there are only 2 columns in my table. The query runs successfully.
Now, assume I've got this query:
Code:
INSERT INTO test_table VALUES (1, 'test', 12341234)
If I try to insert this into the same table I had above it can't ant wont work, because there is 1 more value which "has no column".
This is the case in your query.
Your table has less columns than your query you're trying to insert.
You can try to update your query to the new structure, that'd be the only solution.
|
|
|
 |
Similar Threads
|
[BRUM] WTT KARK LVL 5 DEATH WINGS FOR BLODE + BIGLOS LVL 5 WINGS or ...
02/05/2013 - Archlord Trading - 4 Replies
Hello I'd like to trade my kark with lvl 5 death wings in brumhart server for
Blode + Biglos lvl 5 wings (I add neckl of fortune with lvl 3 cloack for this offer)
or
Blode + WC
or
Blode + release (empty or wings) + WC
|
Angel Wings oder Demon Wings?
01/01/2012 - Terraria - 2 Replies
Hallo,
Wollte wissen was besser ist..
Angel Wings?
oder Demon Wings?
Danke schonma
MFG
|
WTS infinity wings lv 6 no neck ( white wings ) !!
08/06/2011 - Archlord Trading - 1 Replies
PM!
|
WTT TB Wings from Sanctary for TB Wings On Harshlands Server
06/26/2010 - Perfect World Trading - 0 Replies
Hi guys, I'm starting a new character on the Harshlands server and would like to trade someone my Spectral Haze wings from Sanctuary server.
If your unable to trade me the same exact item I will go for the wildfire wings with a decent mount or even coinage to make it an even trade.
Please let me know asap
Thank you.
|
WTT Wings on Brumhart for Wings on Archon
05/08/2010 - Archlord Trading - 0 Replies
http://i43.tinypic.com/2q9xtu0.jpg
http://i39.tinypic.com/2ry54dj.jpg
Either pm me on here
Or on Archon server w/ Tungl or R0b1nh00d
I'll even throw in 1,000,000 on and whatever stones and stuff I have on Brum.
|
All times are GMT +1. The time now is 21:20.
|
|