Database restore of different versions

17 views
Skip to first unread message

Oliver de Souza

unread,
Apr 14, 2016, 5:33:22 AM4/14/16
to jorani
Hi

I have a jorani setup whereby the web application is on 0.4.6 and the database is a restore of a 0.4.3 jorani setup.

I believe that no db patch required from 0.4.3 to 0.4.6?

However there seems to be an odd behaviour following a users leave applications. Whenever an employee applies for a 1/2 leave, it shows 1 day requested. And if he applies for an 8 days leave, 9 days is shown as applied.
Was there a problem with the database restore?

Thank you
Oliver

Benjamin BALET

unread,
Apr 14, 2016, 5:37:31 AM4/14/16
to jor...@googlegroups.com
Hi,

You don't need to patch.

Sometimes, index are altered by the backup/restore. Most of the time, the index 0 is changed to last id + 1. This depends on your software and the option you'e chosen.

Oliver

--
You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+un...@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.
To view this discussion on the web visit https://groups.google.com/d/msgid/jorani/d3961e95-55a6-42c4-b909-09d8a6f26246%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Oliver de Souza

unread,
Apr 14, 2016, 5:47:08 AM4/14/16
to jorani
Hi Benjamin

Sorry but which index should i look for in the database? Which table? Also what should i change to get it back to zero?

Thank you

Regards
Oliver

Benjamin BALET

unread,
Apr 14, 2016, 5:52:03 AM4/14/16
to jor...@googlegroups.com
i don't know , it depends on your software.
check all tables, they should all have an index at 0, but i don't know the history of your data execpt for types and organization tables where index 0 has a functional meaning.

Oliver

--
You received this message because you are subscribed to the Google Groups "jorani" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jorani+un...@googlegroups.com.
To post to this group, send email to jor...@googlegroups.com.
Visit this group at https://groups.google.com/group/jorani.
Reply all
Reply to author
Forward
0 new messages