Cash SQL Error

09/18/2012 14:15 -FeaRs-#1
Hello guys , My DB runs 4.5 and my client too , I edited the Cash , got script and execute..
And my prob again
Code:
Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 2
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 3
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 4
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 5
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 6
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 7
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 8
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 9
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 10
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 11
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 12
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 13
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 14
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 15
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 16
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 17
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 18
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 19
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 20
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 21
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 22
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 24
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 25
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 26
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 27
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 28
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 29
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 30
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 31
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 32
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 33
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 34
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 35
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 36
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 37
Insert Error: Column name or number of supplied values does not match table definition.
Im mad of it!! , Can someone help meh?!

Regards, Sindacco
09/18/2012 18:14 JohnHeatz#2
And this would be why people need to do SQL scripts by themselves... Read the script that you are running, it is clearly noticeable that it is adding more data than what it should, Row -perhaps-
09/18/2012 19:10 -FeaRs-#3
Quote:
Originally Posted by JohnHeatz View Post
And this would be why people need to do SQL scripts by themselves... Read the script that you are running, it is clearly noticeable that it is adding more data than what it should, Row -perhaps-
Cant make SQL Script on my own , John , u have the fix for this error?
09/18/2012 23:47 JohnHeatz#4
You must check the script you are using because it is clearly entering more information than what should be into your table, exactly why I don't let some software create scripts for me
09/20/2012 13:05 -FeaRs-#5
I tryed to delete everything From item mall and made again but same problem , QQ come on someone post how to fix that!
09/20/2012 17:18 JohnHeatz#6
It will keep giving you the same issue if you do it the same way, read what I have said, your script is adding more information than what the table contains, all you need to do is read the script and remove the information that is not supposed to be INSERTed
09/20/2012 18:23 -FeaRs-#7
I edited only one thing o.o and same error again.
You meant the information which is not allowed?
All i edited is "Create Item"
Name : 30 day pack
and inserted 30 day items..
09/20/2012 18:47 JohnHeatz#8
You need to change the script....the INSERT query is wrong
09/20/2012 18:59 -FeaRs-#9
Thanks John!
This Thread Can Be #Closed
09/20/2012 19:04 JohnHeatz#10
#Closed as requested