Error with mysql BD

Question

I have an error in my comic that I can’t fix I already used the CHECK TABLE command with the EXTENDED function and it says that there are no errors in the tables.

the problem is this:

I made some changes to my php/mysql system and they include new fields in the form and consequently new fields in the tables that are used in this form.

the new fields in the tables I created manually because they already had data and could not lose, until then normal I did the tests and everything worked correctly.

then I made the same changes in production, created the fields in the tables and put the altered pages in the production folder.

from then on the headache started, the changes that were made are not executed correctly in production, I thought it was a problem in Cód. but it wasn’t.

I deleted the test tables and played the production data in test and gave the same production problem.

I returned the data that were in the test tables and the problem ceases to occur.

I have compared the two tables and they are exactly the same in relation to the fields(name, type, attributes etc)

that is I must have some record that may be causing this problem, only this table has more than 16.000 lines.

any idea how to fix this problem?

please help me already taking my sleep to days this problem.

it does not record the data in these new fields, and in the Insert form it has some functions in Javascript that in Prod does not work but in test it works, such as checking the available balance of the product, the unitario x discount value calculation, value unit with discount x quantity, etc