P Server Item Mall Problem

05/07/2014 19:59 BurningShaiya#1

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

05/07/2014 20:12 [GM]SkyLine.�#2

Ich lese diese.Dann las er das Skript

Code:

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

05/07/2014 22:08 sony65#3

Delete column row in Productlist. ;)

03/18/2017 23:44 vanthong132#4

Quote:

Originally Posted by sony65

Delete column row in Productlist. ;)

Thank you...... after 8 year

03/22/2017 11:12 Blober#5

Please don't necro old posts. Just push the [Only registered and activated users can see links. Click Here To Register...] button.

04/04/2017 17:51 viniciohernandez#6

What episode do you use to give you the mall solution

Solution for Episode 5 and 6 Item mall Fix

[Only registered and activated users can see links. Click Here To Register...]