no item located on that spot

Pave99 · 07/10/2015, 02:56

I'm getting the "no item located on that spot" using SQL 2014 SP1 ,Windows 7 64bit, Stinka's server files, andr3y's game.exe, Trayne's Itemmall fix and official 5.4 client, Including some photos...

If you need picture of something or something else i'll try my best helping you for helping me

Trayne01 · 07/10/2015, 11:46

With 4.5 PS_Game, is it working?

Pave99 · 07/10/2015, 14:44

Quote:

Originally Posted by Trayne01

With 4.5 PS_Game, is it working?

With 4.5 PS_Game and 5.4 Game it's ofc buggy but i can buy stuff. For a millisecond there is Purchased Starter Pack and then Please try to reconnect to server ERROR: 0
PS_DBAgent Log

Spoiler

PS_Game Log

Spoiler

PS_GameLog Log

Spoiler

SkuulCandy · 07/11/2015, 11:54

When you edit your Cash.Sdata, make sure this :
1 row producct ned 6 value :
If you add etain, the correct id is : 100045 not 10045

Pave99 · 07/11/2015, 15:46

thats not the point, nothing i buy works

[Alcatraz] · 07/12/2015, 09:12

if your itemmall info is the same as your database info you can try this fix

1 - Ran the CMD
2 - Type cd "c:\windows\system32"
3 - msdtc -uninstall (enter)
4 - I rebooted my pc
5 - Steps 1 and 2 again
6 - msdtc -install (enter)
7 - Steps from Microsoft - Enable Network DTC Access
8 - Control Panel > Administrative Tools > Services
9 - I started the service Distributed Transaction Coordinate

Solved two problems: DC after picking up items in BankTeller and the Item Mall.

Pave99 · 07/12/2015, 13:43

Quote:

Originally Posted by [Alcatraz]

if your itemmall info is the same as your database info you can try this fix

1 - Ran the CMD
2 - Type cd "c:\windows\system32"
3 - msdtc -uninstall (enter)
4 - I rebooted my pc
5 - Steps 1 and 2 again
6 - msdtc -install (enter)
7 - Steps from Microsoft - Enable Network DTC Access
8 - Control Panel > Administrative Tools > Services
9 - I started the service Distributed Transaction Coordinate

Solved two problems: DC after picking up items in BankTeller and the Item Mall.

I appreciate your help but after all of your steps it still doesn't work...

[Alcatraz] · 07/12/2015, 19:57

it was worth a try its one of the problems I had before figure I post it see if it fixes yours

from what I was reading your have a guild error because your missing the rank column your also getting a roll back from a error from items because its trying to fix a int number into a tinyint if I was you I would start by fixing as many errors as you can.

this will fix the guild problem

Code:

USE [PS_GameData]
GO

ALTER TABLE [dbo].[Guilds] DROP CONSTRAINT [DF__Guilds__DeleteDa__4A58F394]
GO

ALTER TABLE [dbo].[Guilds] DROP CONSTRAINT [DF__Guilds__CreateDa__4964CF5B]
GO

ALTER TABLE [dbo].[Guilds] DROP CONSTRAINT [DF__Guilds__Del__4870AB22]
GO

/****** Object:  Table [dbo].[Guilds]    Script Date: 7/12/2015 1:09:30 PM ******/
DROP TABLE [dbo].[Guilds]
GO

/****** Object:  Table [dbo].[Guilds]    Script Date: 7/12/2015 1:09:30 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Guilds](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[GuildID] [int] NOT NULL,
	[GuildName] [varchar](30) NOT NULL,
	[MasterUserID] [varchar](18) NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) NOT NULL,
	[Country] [tinyint] NOT NULL,
	[TotalCount] [smallint] NOT NULL,
	[GuildPoint] [int] NOT NULL,
	[Del] [tinyint] NULL,
	[CreateDate] [datetime] NULL,
	[DeleteDate] [datetime] NULL,
	[Rank] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Guilds] ADD  DEFAULT ((0)) FOR [Del]
GO

ALTER TABLE [dbo].[Guilds] ADD  DEFAULT (getdate()) FOR [CreateDate]
GO

ALTER TABLE [dbo].[Guilds] ADD  DEFAULT (getdate()) FOR [DeleteDate]
GO

the converting problem I would need to dig into the database to find the cause of it but you can do the same just figure out what your doing action wise then find the int data and then youll be about to find out what is erroring on converting it usually this is a problem caused by a custom script

Pave99 · 07/12/2015, 22:00

I noticed that here in example
2015-07-10 15:39:46 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,0,'', 60735,-887648446,60995, 0.000000,-9903822545737945900000000000.000000,3037.310791, '2012-12-00 00:06:07' ,113, 8017287467346698288,1852404846,NULL,17,NULL,NULL,N ULL,NULL,NULL,NULL,'uous Res Rune...','PointItem','0,0,0,0,0,0

is a part of my item mall item name. Dunno if it helps but ...

EDIT: Thanks for the Guilds script :)