Help Most akward problem.

[Irrelevant]

Yesterday i post a problem with my offline buffer sellers ,i was just forgot 1line into offlinetradetables.
NOW my problem is so AKWARD!! The code is 100% functional  !

 

I use 2databases in navicat 1 for testing and 1 clean( no1 name=test and no2 name=main server)

(*1 serverfiles with 2 databases , so the code is the same*)

Problem: In my code seller changes  name color & tittle when selling buffs(like offline shops) . & when he stop selling it return into normal.

-In my test database everything works perfect , when buffer sells automatically changes colors & tittle .Also when stop sell return everything to normal.
BUT in my main server database isn't even save the seller as result player changes name color and tittle without get back to previous (i use the same table , even with copy paste the table isn't working)

look Pics here: https://imgur.com/a/abSahbO.

I told you most AKWARD problem, why is that happening only in 1/2 databases ? :/ any thoughts?



i let also code pic + query of table

https://imgur.com/a/kOx2pqt. 

query:

 

-- ------------------------------------------
-- Table structure for sellbuff_seller_data
-- ------------------------------------------
DROP TABLE IF EXISTS `sellbuff_seller_data`;
CREATE TABLE `sellbuff_seller_data` (
  `char_obj_id` decimal(11,0) NOT NULL,
  `lastTitle` varchar(16) DEFAULT NULL,
  `lastTitleColor` varchar(8) NOT NULL,
  `lastNameColor` varchar(8) NOT NULL,
  PRIMARY KEY (`char_obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Edited March 25, 2021 by Irrelevant

[Irrelevant]

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 

[wongerlt]

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 (?,?,?,?)

[Irrelevant]

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!