Data Is Incorrect After Migration

0

I migrated my server the server time is different, now it messed up my data, the sales are now showing on a different date. Even tho my timezone is still the same under settings

Question Resolved For: Stock Manager Advance (Invoice & Inventory System) 0 Votes 15 Answers 112 Views
Asked by John Guilbert Caringal 1 month ago

0

Answered by Mian Saleem 1 month ago

Hello,

Please try to change to some other timezone and then set it back. If it is still the same, you can directly check your database for the saved dates in sma_sales table.

Thank you

0

Answered by John Guilbert Caringal 1 month ago

I already did changed the timezone.

The problem is I have 3000+ sales recorded already and I cannot change the date manually

0

Answered by John Guilbert Caringal 1 month ago

Btw, these are POS Sales

0

Answered by John Guilbert Caringal 1 month ago

It is showing correct date in the database, but on the "POS Sales" the date is ahead of 6 hours. It is messing up the reports for daily sales and monthly sales

0

Answered by Mian Saleem 1 month ago

Hello,

If the date in the database is correct and you have updated the timezone then there shouldn't be such issue. It should be same as it was on your previous server. I am not sure about the reason, did you check with your server admin for your server timezone? You can try to set the default timezone on your server.

Thank you

0

Answered by John Guilbert Caringal 1 month ago

The date in the database is also wrong when moved to the new server. I am using xampp localhost. And changed the server time to show the correct timezone.

0

Answered by John Guilbert Caringal 1 month ago

Here's the situation, my last order from the database is dated 05/22/2024 - 21:00AM but when I moved the database and check phpmyadmin it shows 05/23/2024 - 06:00AM

0

Answered by Mian Saleem 1 month ago

Hello,

Exporting and importing database shouldn't change date or time. Please check with your server admin as they can guide further.

Thank you

0

Answered by John Guilbert Caringal 4 weeks ago

Actually it did. I tried moving it to a new cpanel and I experience the same thing. Please help

0

Answered by John Guilbert Caringal 4 weeks ago

Contacted the support and i was told theres nothing wrong with the server.

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.