45 minutes ago, melron said:

Do you use any "join" sql query ?? It seems like you have external data in your test database while at your main database you missing them. 

well i am not sure if i get it , but .. i created an backup of test database and i ran it into main database and yes it work fine (but i cant understand why cause its the same backup just with few changes like events,test chars ,etc :/ ) i am currently delete the code and i will insert from beggining even isn't code problem,hopefully find something i missing.
*P.S.1 i also created an new database which the code work again only with "test" databases backup.
*P.S.2 i even changed the name of table in code and still the same . 

 

 

1 hour ago, wongerlt said:

sellbuff_saveSellerData and sellbuff_restoreSellerData procedures.

yes at code picture i add last , you can see the table code 

7 hours ago, Irrelevant said:

well i am not sure if i get it , but .. i created an backup of test database and i ran it into main database and yes it work fine (but i cant understand why cause its the same backup just with few changes like events,test chars ,etc :/ ) i am currently delete the code and i will insert from beggining even isn't code problem,hopefully find something i missing.
*P.S.1 i also created an new database which the code work again only with "test" databases backup.
*P.S.2 i even changed the name of table in code and still the same . 

 

 

yes at code picture i add last , you can see the table code 

You are not probably looking at the right table. The thing that the code is using a specific table, doesn't mean you have to look only there. And again, does your sql query contains any 'join' word or does it run another instance of "select from where" as a parameter to run a query?

 

9 hours ago, Irrelevant said:

well i am not sure if i get it , but .. i created an backup of test database and i ran it into main database and yes it work fine (but i cant understand why cause its the same backup just with few changes like events,test chars ,etc :/ ) i am currently delete the code and i will insert from beggining even isn't code problem,hopefully find something i missing.
*P.S.1 i also created an new database which the code work again only with "test" databases backup.
*P.S.2 i even changed the name of table in code and still the same . 

 

 

yes at code picture i add last , you can see the table code 

i mean procedures not table...

if not then:

change

CALL sellbuff_restoreSellerData(?)

to

SELECT * FROM sellbuff_seller_data WHERE char_obj_id=?

change

CALL sellbuff_saveSellerData(?,?,?,?)

to

INSERT INTO sellbuff_seller_data VALUES (?,?,?,?)

2 hours ago, melron said:

You are not probably looking at the right table. The thing that the code is using a specific table, doesn't mean you have to look only there. And again, does your sql query contains any 'join' word or does it run another instance of "select from where" as a parameter to run a query?

 

to be honest i dont know , all queries i add was like that 

30 minutes ago, wongerlt said:

i mean procedures not table...

if not then:

change

CALL sellbuff_restoreSellerData(?)

to

SELECT * FROM sellbuff_seller_data WHERE char_obj_id=?

change

CALL sellbuff_saveSellerData(?,?,?,?)

to

INSERT INTO sellbuff_seller_data VALUES (?,?,?,?)

i will try after i finish the code again.

==================================
@melron and @wongerlt thank you very much for your time ,i am really appreciate that!
I decide to just remove this function  and just give root effect to these sellers which doesnt connect to any table.
Apologise for wasting your time !Wish you a nice day ,Thanks!