Register for your free account! | Forgot your password?

You last visited: Today at 00:04

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


Add wings in sql

Old   #1

elite*gold: 0
Join Date: Mar 2012
Posts: 707
Received Thanks: 170
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 offline  
Old   #2
You're the one who died

elite*gold: 0
Join Date: May 2011
Posts: 4,843
Received Thanks: 3,222
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:
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:
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  
2 Users

« Previous Thread | Next Thread »

Similar Threads
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 ) !!
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 Either pm me on here Or on Archon server w/ Tungl or R0b1nh00d ...
0 Replies - Archlord Trading

All times are GMT +1. The time now is 00:04.

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

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