error 0

Hello,

here's my problem, when I buy an item in its item mall gives me an error 0 yet.

Test solution:
1 - / vchkoff / nprotectoff
2 - usp_Save_User_BuyPointItems_NCash.txt -> Fix This Error When try buy 0 Any Item.

I have the same problem error 0.

thank you all for your advice

Is your Distributed Transaction Coordinator service running in windows?

i got the error only when i buy Premium Package and i dont know how to fix

Quote:

Originally Posted by abrasive Is your Distributed Transaction Coordinator service running in windows?

Yes, Distributed Transaction Coordinator activate (auto)

Quote:

Originally Posted by remnikalija i got the error only when i buy Premium Package and i dont know how to fix

Make sure all the items available in that pack can be stacked. Check Item table on "Count" column.

If you try to give more than the count number of the item the game will crash.

It always gives me the error with every item, however I have good sync with Cash edior

I have looked in the log and it gives me this error

Quote:

2011-01-15 11:33:46 PS_DBAGENT__system log start (DBAgent01) 2011-01-15 11:33:48 UpdateGuildPointRankDB Result=-1 2011-01-15 11:33:56 connect game 2011-01-15 11:35:55 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Procédure stockée*'usp_Read_User_CashPoint_PayLetterT' introuvable., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC) 2011-01-15 11:35:55 ::LoadCharacter 11 test qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,1)} 2011-01-15 11:37:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Procédure stockée*'usp_Read_User_CashPoint_PayLetterT' introuvable., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC) 2011-01-15 11:37:15 ::LoadCharacter 11 test qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,1)}

Do you have a stored procedure named usp_Read_User_CashPoint_PayLetterT?

Quote:

Originally Posted by abrasive Do you have a stored procedure named usp_Read_User_CashPoint_PayLetterT?

no :(

it should be in PS_GameData / Programmability / Stored Procedures

But he does is not

Do you have any stored procedures under PS_GameData that look like they are meant for reading user's cashpoints?

Also what database and server files are you using? I don't recall having a stored procedure named usp_Read_User_CashPoint_PayLetterT, but I could be mistaken.

Quote:

Originally Posted by abrasive Do you have any stored procedures under PS_GameData that look like they are meant for reading user's cashpoints? Also what database and server files are you using? I don't recall having a stored procedure named usp_Read_User_CashPoint_PayLetterT, but I could be mistaken.

I give you the log the full error

PS_DBAGENT_system.log

Quote:

2011-02-17 19:40:22 PS_DBAGENT__system log start (DBAgent01) 2011-02-17 19:40:31 connect game, Name= 2011-02-17 19:40:31 connect game, Name= 2011-02-17 19:41:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2) 2011-02-17 19:41:38 SaveBuyPointItem 3 Test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,349,'AC_1000 75_1','2011-02-17 19:41:38')} 2011-02-17 19:41:46 3 1 SERVICE_CONTROL_STOP 2011-02-17 19:41:50 1 1 SAgent::Disconnect: (4, 64) 2011-02-17 19:41:50 1 1 T=000:01:00:000, RC=7,RCS=0, RB=271,RBS=3, SC=21,SCS=0, SB=3374,SBS=42 2011-02-17 19:41:50 disconnect game, Name=Game01 2011-02-17 19:41:50 1 1 SAgent::Disconnect: (4, 64) 2011-02-17 19:41:50 1 1 T=000:01:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=26 2011-02-17 19:41:50 disconnect game, Name=Game01 2011-02-17 19:41:50 save market... wait plz... 2011-02-17 19:41:50 save all... wait plz... enter /uc 2011-02-17 19:41:51 PS_DBAGENT__system log end (DBAgent01) 2011-02-17 19:41:51 3 1 SService::ServiceCtrlDispatcher(): service shutdown

This is a completely different issue than the missing stored procedure you were just talking about?

if you run this:
It gives you an error like this?

Quote:

Originally Posted by abrasive This is a completely different issue than the missing stored procedure you were just talking about? if you run this: Code: usp_Save_User_BuyPointItems_NCash(1,3,349,'AC_1000 75_1','2011-02-17 19:41:38') It gives you an error like this? Code: Erreur de conversion du type de données varchar en datetime.

Yes error conversion