[Request] Iteam mall/Gear issues

Bаne · 01/12/2011, 20:37

Ok, unity has a new set of custom armors (complements of Jade) and we would like to make them available for sell in the item mall....only problem is it crashes upon character load.

any advice or help would be highly appreciated...

-Bane

~~Alladrios~~ · 01/12/2011, 20:54

You could choose to send them straight to giftbox.

Code:

EXECUTE [PS_GameData].[dbo].[usp_AddGift] 
  '768' -- @UserUID
  , '100139' --,@ItemID
  , '15' --,@ItemCount
  , '0' -- ,@GiftPointPrice

Just an idea..

abrasive · 01/12/2011, 20:59

Run a SQL profiler and see which queries are being run upon character load.

Run the queries you find manually and see which one is erroring out.

Fix it, and enjoy not crashing

Bаne · 01/12/2011, 21:00

We have already tried that. it does'nt work...

but TY

And trying what you said now Abrasive.

Edit: it is client sided not DB

-Bane

abrasive · 01/12/2011, 21:03

Quote:

Originally Posted by [GM]Bane

We have already tried that. it does'nt work...

but TY

And trying what you said now Abrasive.

Edit: it is client sided not DB

-Bane

How did you come to this conclusion?

Bаne · 01/12/2011, 21:12

[Wednesday, January 12, 2011 2:08:48 PM CDT Jade] it is in the sdata.
[Wednesday, January 12, 2011 2:08:51 PM CDT Jade] that is the problem
[Wednesday, January 12, 2011 2:09:16 PM CDT Jade] I can add 2 of the new helms i made and it works
[Wednesday, January 12, 2011 2:09:22 PM CDT Jade] then i try added another
[Wednesday, January 12, 2011 2:09:40 PM CDT Jade] and the sgraphic crashs
[Wednesday, January 12, 2011 2:09:50 PM CDT Jade] it makes absolutly no sense

Bаne · 01/12/2011, 22:29

[3:26:54 PM CDT] Jade: well.
[3:27:05 PM CDT] Jade: If i delete the item that is making it crash then it stops crashing
[3:27:12 PM CDT] Jade: so it isn't an item in the inventory
[3:27:33 PM CDT] Jade: and importing tables into my DB doesn't work it crashes my sql
[3:27:38 PM CDT] Jade: if it did work..
[3:27:48 PM CDT] Jade: my life would be hella more wasy

Anything else? lol...

Bаne · 01/12/2011, 22:43

hmm...i pmd her but it might be a min for the response she had to go do something

Bаne · 01/13/2011, 01:11

[6:00:16 PM CDT] Jade: awesoe
[6:09:20 PM CDT] Jade: 'Violation of primary key constraint 'pk_ProductList' Cannot insert Duplicate key in object 'dbo.ProductList'
[6:09:33 PM CDT] Jade: is what i get when i try to insert.
[6:09:42 PM CDT] [GM]Bane: ok.
[6:09:37 PM CDT] Jade: with bulk insert
Edited: Jade does not want people to know she cusses

Edit Edit: Problem signature:
Problem Event Name: APPCRASH
Application Name: game.exe
Application Version: 1.0.0.1
Application Timestamp: 4aefda88
Fault Module Name: ntdll.dll
Fault Module Version: 6.1.7600.16559
Fault Module Timestamp: 4ba9b29c
Exception Code: c0000005
Exception Offset: 0002e1fe
OS Version: 6.1.7600.2.0.0.768.3
Locale ID: 1033
Additional Information 1: 257d
Additional Information 2: 257d8f504c598531c429b24cac277ae5
Additional Information 3: 5b92
Additional Information 4: 5b92f9641932e625af7439fa0ac6ed95

Read our privacy statement online:

If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt

Bаne · 01/13/2011, 01:25

[6:23:26 PM CDT] Jade: no i got that working
[6:23:40 PM CDT] Jade: back to the same issue as nefre
[6:23:43 PM CDT] Jade: before the game crashing on character load.

Update: [6:32:00 PM CDT] Jade: now it wont let me delete the rows in the DB

Bаne · 01/13/2011, 01:42

Ok, what program would you like to use???

-Bane

[Admin]Snuggle · 01/16/2011, 18:14

from the looks of things
you might be adding too much to the item mall o.O

Jaden151 · 01/16/2011, 21:39

Nope that isn't the problem at all. EC was remote into my test server for 6 hours trying to help me figure it out. No luck. It is strictly when i try to add my new items in. I have even deleted everything from the itemmall and only had a couple things in and it still crashs-

limited space was the first thing i thought of too

[Admin]Snuggle · 01/17/2011, 00:13

hmmm
well theres a few things i can think of that might cause that other than what i said before
unless EC tried all these o.O
1. your db doesnt match the sdata for the item mall EXACTLY
2. you might have encrypted the sdata more than once
i dont know o.o..just thoughts

Jaden151 · 01/17/2011, 04:28

Tried that. Just copied the import over. and also 4.5 doesn't need encrypting. Doesn't run at all if you encrypt.

Thanks for the suggestion though.