is there possibilities that error causes from order_ref number keeps the same values without increment or any other payments table?
How to fix it?

If you need,
I can send you the database file to check with it.

database file screenshot

logs folder files: I didn't make any of these actions. No of these products are mine or shown in my pos screen. No of these database records belongs of my application. you can see that. I think it is a pirates or hackers attacks or sql injection.
I thinks my code files and database tables are modified by an external ressources in the same time.
How can I fix my system without losing my old sales and data?

Hello,

Open you database in phpmyadmin and then check the data of sma_payments table. You can delete all record for where sale_id
is grater then you current sale

Thank you

the problem is still coming with the new sales.
How to fix that

Now ,it works fine for the new sales. but it keeps the old wrong payment sales.

How can I merge the new with the old sales? I tried exporting and importing csv sales files and export database table but I failed I got duplicates or missing entries

Hi , bro
can I use my application now? if you try to test it please logout

Hello, please this error come back