no item located on that spot

07/10/2015 02:56 Pave99#1
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...

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

If you need picture of something or something else i'll try my best helping you for helping me :p
07/10/2015 11:46 Trayne01#2
With 4.5 PS_Game, is it working?
07/10/2015 14:44 Pave99#3
Quote:
Originally Posted by Trayne01 View Post
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
PS_Game Log
PS_GameLog Log
07/11/2015 11:54 SkuulCandy#4
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
07/11/2015 15:46 Pave99#5
thats not the point, nothing i buy works
07/12/2015 09:12 [Alcatraz]#6
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.
07/12/2015 13:43 Pave99#7
Quote:
Originally Posted by [Alcatraz] View Post
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...
07/12/2015 19:57 [Alcatraz]#8
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
07/12/2015 22:00 Pave99#9
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 :)