Problem with game item mall.

12/05/2012 18:32 krisko6#1

Hey everyone,
I used ShStudio to edit my Cash.Sdata , it took me an hour to add all item codes and etc. When i seved the file i took SQL file everything were going very good. But when i tried to execute the filed it gave error on everything. I added the Cash.Sdata and resterted the server. When i tried again it didn't work.
Good is the game still working fine and when i use item mail it says me that there is no item (it was someting like that xD).
Please tell me where is my mistake.I hope my work be usefull.

Yeah my english is bad , but i'm sure you still understand me :p

Thank You!

12/05/2012 18:39 nubness#2

Quote:

Originally Posted by krisko6

[...] ShStudio [...]

Oh God, why ?
I suggest you do it [Only registered and activated users can see links. Click Here To Register...], it always works perfectly.

12/05/2012 18:42 [ADMIN]Cryptic#3

what nubness said :p but otherwise tell us what error you got in SQL.

12/05/2012 18:47 Sh1nra#4

Try this: ;)

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

Credits: banned Zeus :rtfm:

12/05/2012 19:11 krisko6#5

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
-
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.

And down SQL says:
Query completed with errors.
_________________________________________

Sh1nra's code didn't work.Thanks anyway.
I will try the hard way xd

12/05/2012 20:06 Sh1nra#6

Quote:

Originally Posted by krisko6

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
-
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.

This are the errors from my script?

12/05/2012 20:09 [ADMIN]Cryptic#7

Run the script Sh1nra posted. Your problem is you have to many (or to few) columns. Your table probably doesnt match the script SH tool prints out.

to prevent this problem you could also have done the SQL manually.

12/05/2012 20:50 JohnHeatz#8

#Moved to the right section

12/06/2012 14:00 krisko6#9

Quote:

This are the errors from my script?

The errors what i posted yesterday are from ShStudio's file.

The error what your script gives me is :

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ProductList'.

Quote:

Originally Posted by [ADMIN]Cryptic

Run the script Sh1nra posted. Your problem is you have to many (or to few) columns. Your table probably doesnt match the script SH tool prints out.

to prevent this problem you could also have done the SQL manually.

What can i do manually i can add new columns or i should add all items codes and etc? And where i can find game item mall in SQL?
Thanks.

12/06/2012 17:26 Sh1nra#10

You have dbo.ProductList ?

12/06/2012 18:07 krisko6#11

Quote:

Originally Posted by Sh1nra

You have dbo.ProductList ?

Yes i have it and i checked in side but there is no item in it.

12/07/2012 12:49 [ADMIN]Cryptic#12

try deleting it and remaking it.