P Server Item Mall Problem

[BurningShaiya]

Hi ihrs,

Wir haben da ein Problem mit der Item Mall. Wir haben auch schon die Suchfunktion benutzt, jedoch ergab die suche nichts nützliches.


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.


Danke im Voraus und MfG

[[GM]SkyLine.™]

Ich lese diese.Dann las er das Skript

USE [PS_GameDefs]
GO
/****** Objekt:  Table [dbo].[ProductList]    Skriptdatum: 12/05/2012 18:44:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
DROP TABLE [dbo].dbo[ProductList]
CREATE TABLE [dbo].[ProductList](
 [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

[sony65]

Delete column row in Productlist.

[vanthong132]

Originally Posted by sony65

Delete column row in Productlist.

Thank you...... after 8 year

[Blober]

Please don't necro old posts. Just push the button.

[viniciohernandez]

What episode do you use to give you the mall solution

Solution for Episode 5 and 6 Item mall Fix