Register for your free account! | Forgot your password?

You last visited: Today at 17:21

  • Please register to post and access all features, it's quick, easy and FREE!

 

Add wings in sql

Reply
 
Old   #1

 
elite*gold: 140
Join Date: Mar 2012
Posts: 616
Received Thanks: 141
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




アルカード is online now  
Old   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
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.


Xijezu is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
[BRUM] WTT KARK LVL 5 DEATH WINGS FOR BLODE + BIGLOS LVL 5 WINGS or ...
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...
4 Replies - Archlord Trading
Angel Wings oder Demon Wings?
Hallo, Wollte wissen was besser ist.. Angel Wings? oder Demon Wings? Danke schonma MFG
2 Replies - Terraria
WTS infinity wings lv 6 no neck ( white wings ) !!
PM!
1 Replies - Archlord Trading
WTT TB Wings from Sanctary for TB Wings On Harshlands Server
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...
0 Replies - Perfect World Trading
WTT Wings on Brumhart for Wings on Archon
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 ...
0 Replies - Archlord Trading



All times are GMT +2. The time now is 17:21.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.