Cash.sql HILFE

[xFantaa]

Hallo Epvp,
Mein Problem ist wenn ich die Cash.sql wenn ich auf !Execute drücke dann kommt ein fehler und da steht:

Fehler:

 Spoiler

Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.

Line 1 und 2:

 Spoiler

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO

Mit freundlichen Grüßen

[nephren]

Deine tabelle stimmt nicht mit den vorgegeben werten überein.

"Truncate" <- Leeren bringt nichts. Du hast ne zahl in einer vorgesehenen Buchstaben spalte etc... mal überprüfen ^^

[{Skrillex}]

USE [PS_GameDefs]
GO
/****** Objekt: Table [dbo].[ProductList] Skriptdatum: 05/10/2013 11:24:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
DROP TABLE [dbo].[ProductList]
CREATE TABLE [dbo].[ProductList](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[ProductName] [varchar](50) NOT NULL,
[ProductCode] [varchar](20) NOT NULL,
[BuyCost] [int] NOT NULL,
[ItemID1] [int] NOT NULL,
[ItemCount1] [tinyint] NOT NULL,
[ItemID2] [int] NULL,
[ItemCount2] [tinyint] NULL,
[ItemID3] [int] NULL,
[ItemCount3] [tinyint] NULL,
[ItemID4] [int] NULL,
[ItemCount4] [tinyint] NULL,
[ItemID5] [int] NULL,
[ItemCount5] [tinyint] NULL,
[ItemID6] [int] NULL,
[ItemCount6] [tinyint] NULL,
[ItemID7] [int] NULL,
[ItemCount7] [tinyint] NULL,
[ItemID8] [int] NULL,
[ItemCount8] [tinyint] NULL,
[ItemID9] [int] NULL,
[ItemCount9] [tinyint] NULL,
[ItemID10] [int] NULL,
[ItemCount10] [tinyint] NULL,
[ItemID11] [int] NULL,
[ItemCount11] [tinyint] NULL,
[ItemID12] [int] NULL,
[ItemCount12] [tinyint] NULL,
[ItemID13] [int] NULL,
[ItemCount13] [tinyint] NULL,
[ItemID14] [int] NULL,
[ItemCount14] [tinyint] NULL,
[ItemID15] [int] NULL,
[ItemCount15] [tinyint] NULL,
[ItemID16] [int] NULL,
[ItemCount16] [tinyint] NULL,
[ItemID17] [int] NULL,
[ItemCount17] [tinyint] NULL,
[ItemID18] [int] NULL,
[ItemCount18] [tinyint] NULL,
[ItemID19] [int] NULL,
[ItemCount19] [tinyint] NULL,
[ItemID20] [int] NULL,
[ItemCount20] [tinyint] NULL,
[ItemID21] [int] NULL,
[ItemCount21] [tinyint] NULL,
[ItemID22] [int] NULL,
[ItemCount22] [tinyint] NULL,
[ItemID23] [int] NULL,
[ItemCount23] [tinyint] NULL,
[ItemID24] [int] NULL,
[ItemCount24] [tinyint] NULL,
CONSTRAINT [PK_ProductList] PRIMARY KEY CLUSTERED
(
[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Führe diese Query aus !

Und danach deine Cash.sql


MFG

[castor4878]

Column name or number of supplied values does not match table definition.

as far as I understand it, it means number of supplied values does not match table definition.

if you read the script you are trying to execute: you get, for instance:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (
'foo bar', 'UNIQUE_TEXT_IDENT', 12345,
100163,1,
100083,1,
... 20 couples useless to list ...
0,0,
0,0)

if you display the table structure (quite hard, it requires 1 right-click!), you can get, as in Ex example:

CREATE TABLE [dbo].[ProductList](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[ProductName] [varchar](50) NOT NULL,
[ProductCode] [varchar](20) NOT NULL,
[BuyCost] [int] NOT NULL,
[ItemID1] [int] NOT NULL, [ItemCount1] [tinyint] NOT NULL,
[ItemID2] [int] NULL,[ItemCount2] [tinyint] NULL,
item 3 up to 23
[ItemID24] [int] NULL,[ItemCount24] [tinyint] NULL)

comparing these two blocks leads to the difficult question: which required values is missing or which supplied values is in excess ?

it should be possible to assume that the (always useless, never used) RowID is the column for which the script does not provide value.

one possible fix is so to recreate the table, as suggered, but without that useless, never used column.

[xFantaa]

Originally Posted by ϟƘƦƖןןΣ✘

Führe diese Query aus !

Und danach deine Cash.sql


MFG

Hey DANKE

Hat geklappt