[HELP]Crash item mall

Yes it's a good solution for NPC x)

Quote:

Originally Posted by Igris32 i delet my item mall and i put items in NPC...thats my solution >_<

And that is the beginning of a good server in which administrator knows how to work the most basic SQL statements...

Today i've seen that the item mall fix worked for me ,but,i got 1 thought..
May it don't work for them because they have Client and Server on the same machine?..
I mean..in the fix thread the girls say it must be done on the pc where the server is and not the client...Infact, i did it on my virtual machine...But Igris for example have server and use client on the same machine...May this be the problem?

Quote:

Originally Posted by JohnHeatz And that is the beginning of a good server in which administrator knows how to work the most basic SQL statements...

2 week ago i didnt even know what was SQL or shShaiya Studio or whatever program i use right now.Soo yes my knowledge is low but in this 2 week i learn alot.I got alot of questions and problems but by searching and reading on google and some firends help i solve almost all of them.There is alot more that i want to know but anyway the only "problem" my server have now is item mall.I didnt found any solution on google,friends dont know help me and ask help here was pretty useless cuz also here noone help solve this error.This is not the 1st and only thread about this error,there is 5-6 maybe more and noone of them have the solution.Just few useless answer thats all i found.

u need always a matching client and a matching db or u will have always problems..
+ dont forget SH studio can be sometimes a bitch ;)

Well if you think that is useless then you clearly want people to fix your issues for you, something that simply won't happen, how come I do a search on google for the error you have and I come by the microsoft site with the answer as of how to fix that?

I am not trying to be rude, but by knowing your error message you must be able to search for its fix

Quote:

Originally Posted by JohnHeatz Well if you think that is useless then you clearly want people to fix your issues for you, something that simply won't happen, how come I do a search on google for the error you have and I come by the microsoft site with the answer as of how to fix that? I am not trying to be rude, but by knowing your error message you must be able to search for its fix

I spend 4 day by searching to solve the problem on google but i didnt found anything,just ppl who talk about problem and no1 about solution.(useless threads) I contact some friend but they wasnt able to help me.(cuz they never work with SQL) Come here and ask help was the last step.Since alot of ppl have that problem and some ppl here know the solution (probably) i think some1 will post a solution but i was wrong.I never ask u to go on google and look for solution of my problem,but if u alredy know the solution way u just dont tell us? I have no idea how to solve problem,maybe i have to change something insade SQL,maybe i have to run some misteriuse query,maybe i just have to change some option on my PC, i have no idea...All i know is that i delete item mall and put items in NPC,and when i will found solution i will put item mall back.Maybe

You are not searching correctly, let me point you out in the right direction:

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

Ok now im realy in truble >_<
I can stay w/o Item Mall but...i cant stay w/o WH >_<

Quote:

2012-09-24 23:29:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2) 2012-09-24 23:29:28 ::SaveCharacter 10 [Admin]Titan ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(1,1,363481749961631 3344, 0, 100047,100,47, 0, 0,0,0,0,0,0,'', 10, '2012-09-24 23:29:02', 'B')}

This time i have realy to fix it somehow <_<
I have some idea about way it dont work and how to fix but the problem is that i dont know almost anything about SQL soo i dont know how to find the query i have to modify.
The problem is probably

Quote:

mon dd yyyy hh:mmAM (or PM)

or

Quote:

yy instead yyyy

or

Quote:

dd-mm-yyyy

or maybe im wrong. The point is that i dont know where to find that querry i want to try fix >_<