Cash SQL Error

[-FeaRs-]

Hello guys , My DB runs 4.5 and my client too , I edited the Cash , got script and execute..
And my prob again

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

[JohnHeatz]

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-

[-FeaRs-]

Originally Posted by JohnHeatz

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?

[JohnHeatz]

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

[-FeaRs-]

I tryed to delete everything From item mall and made again but same problem , QQ come on someone post how to fix that!

[JohnHeatz]

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

[-FeaRs-]

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..

[JohnHeatz]

You need to change the script....the INSERT query is wrong

[-FeaRs-]

Thanks John!
This Thread Can Be #Closed

[JohnHeatz]

#Closed as requested