I have a bug in my bd that I can not fix I already used the CHECK TABLE command with the EXTENDED function and it says that it has no errors in the tables.
The problem is as follows:
I have made some changes to my system in php / mysql 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 created manually because they already had data and could not lose, until normal I did the tests and everything worked correctly.
I made the same changes in production, I created the fields in the tables and put the changed pages in the production folder.
From there the headache started, the changes that were made are not executed correctly in production, I thought it was a problem in code. but it was not.
I deleted the test tables and threw the production data to test and gave the same production problem.
I returned the data that was in the test tables and the problem no longer occurs.
I have already compared the two tables and they are exactly the same in relation to the fields (name, type, attributes etc)
I should have some record that might be causing this problem, but this table has more than 16,000 rows.
Any ideas how to fix this problem?
Please help me, please, already taking my sleep to days with this problem.
It does not write the data in these new fields, and in the form of insert it has some functions in javascript that in prod does not work but in test works, such as checking the available balance of the product, the unit value calculation x discount, unit value with discount x quantity, etc.