[xwiki-devs] dates for revisions was updated to the date of updates
Hi! I have next issue: After xwiki update from 3.2 to 4.5 all dates for revisions was updated to the date of updates. How can i fix it? I see only one way to change it in the DB: update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000) commit is it correct? will it have impact on other objects ( keys, indexes)? mayby someone has other ideas how to fix it ..
On Thu, Mar 28, 2013 at 1:07 PM, Добровольский Евгений <[email protected]> wrote:
Hi!
I have next issue:
After xwiki update from 3.2 to 4.5 all dates for revisions was updated to the date of updates.
This happens because the (default) wiki pages have changes between 3.2 and 4.5 and thus when you upgrade a new revision is created for all this changed documents. I find this normal.
How can i fix it?
I don't understand what problem you are trying to fix. Hope this helps, Marius
I see only one way to change it in the DB: update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000)
commit
is it correct? will it have impact on other objects ( keys, indexes)? mayby someone has other ideas how to fix it .. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
in our company we very often need to find some information in previous revisions. We try to find needed previous revisions by date, not by the number of revision. but all dates in the table of version (on the tab "History") are same. so we try to find way how to fix it. On Fri, Mar 29, 2013 at 9:46 AM, Marius Dumitru Florea < [email protected]> wrote:
On Thu, Mar 28, 2013 at 1:07 PM, Добровольский Евгений <[email protected]> wrote:
Hi!
I have next issue:
After xwiki update from 3.2 to 4.5 all dates for revisions was updated to the date of updates.
This happens because the (default) wiki pages have changes between 3.2 and 4.5 and thus when you upgrade a new revision is created for all this changed documents. I find this normal.
How can i fix it?
I don't understand what problem you are trying to fix.
Hope this helps, Marius
I see only one way to change it in the DB: update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000)
commit
is it correct? will it have impact on other objects ( keys, indexes)? mayby someone has other ideas how to fix it .. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- С уважением, Добровольский Евгений
XAR upgrade update only standard pages. I don't see how all the pages in your wiki could have the same date. On Fri, Mar 29, 2013 at 9:30 AM, Добровольский Евгений <[email protected]> wrote:
in our company we very often need to find some information in previous revisions. We try to find needed previous revisions by date, not by the number of revision.
but all dates in the table of version (on the tab "History") are same. so we try to find way how to fix it.
On Fri, Mar 29, 2013 at 9:46 AM, Marius Dumitru Florea < [email protected]> wrote:
On Thu, Mar 28, 2013 at 1:07 PM, Добровольский Евгений <[email protected]> wrote:
Hi!
I have next issue:
After xwiki update from 3.2 to 4.5 all dates for revisions was updated to the date of updates.
This happens because the (default) wiki pages have changes between 3.2 and 4.5 and thus when you upgrade a new revision is created for all this changed documents. I find this normal.
How can i fix it?
I don't understand what problem you are trying to fix.
Hope this helps, Marius
I see only one way to change it in the DB: update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000)
commit
is it correct? will it have impact on other objects ( keys, indexes)? mayby someone has other ideas how to fix it .. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- С уважением, Добровольский Евгений _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
yes, i know it, but at the current moment i have this bug and i have a question how to fix it. update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000) is it good? can i update field xwr_date in the table xwikircs without impact on other objects ? On Fri, Mar 29, 2013 at 10:43 AM, Thomas Mortagne <[email protected]
wrote:
XAR upgrade update only standard pages. I don't see how all the pages in your wiki could have the same date.
On Fri, Mar 29, 2013 at 9:30 AM, Добровольский Евгений <[email protected]> wrote:
in our company we very often need to find some information in previous revisions. We try to find needed previous revisions by date, not by the number of revision.
but all dates in the table of version (on the tab "History") are same. so we try to find way how to fix it.
On Fri, Mar 29, 2013 at 9:46 AM, Marius Dumitru Florea < [email protected]> wrote:
On Thu, Mar 28, 2013 at 1:07 PM, Добровольский Евгений <[email protected]> wrote:
Hi!
I have next issue:
After xwiki update from 3.2 to 4.5 all dates for revisions was updated to the date of updates.
This happens because the (default) wiki pages have changes between 3.2 and 4.5 and thus when you upgrade a new revision is created for all this changed documents. I find this normal.
How can i fix it?
I don't understand what problem you are trying to fix.
Hope this helps, Marius
I see only one way to change it in the DB: update xwikircs set xwr_date= FROM_UNIXTIME(CONVERT(substr(xwr_patch,locate('<date>', xwr_patch)+6,13),UNSIGNED INTEGER)/1000)
commit
is it correct? will it have impact on other objects ( keys, indexes)? mayby someone has other ideas how to fix it .. _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- С уважением, Добровольский Евгений _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- С уважением, Добровольский Евгений
participants (3)
-
Marius Dumitru Florea -
Thomas Mortagne -
Добровольский Евгений