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 156 Views
Asked by John Guilbert Caringal 2 months ago

0

Answered by Mian Saleem 2 months ago

Hello,

Do you have access to your old server? If yes, you can check the date time there. The database should have same. You can try to export the database again.

I have no clue why migrating the database has such issue but it the item is not showing the date in database then I can check the item.

Thank you

0

Answered by Mian Saleem 2 months ago

Hello,

Please don't share the private data in public replies.

I have checked the file. It looks fine. May be you can remove the time_zone line SET time_zone = "+00:00"; and try to import to new server.

Thank you

0

Answered by John Guilbert Caringal 2 months ago

Which table should I remove it from?

0

Answered by Mian Saleem 2 months ago

It's not table but in the exported file. That you shared with me using google drive. Thanks

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.