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 <thomas.mortagne(a)xwiki.com
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, Добровольский Евгений
> <evgdobr(a)gmail.com
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 <
> > mariusdumitru.florea(a)xwiki.com
wrote:
> >
> >> On Thu, Mar 28, 2013 at 1:07 PM, Добровольский Евгений
> >> <evgdobr(a)gmail.com
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
> >> > devs(a)xwiki.org
> >> >
http://lists.xwiki.org/mailman/listinfo/devs
> >> _______________________________________________
> >> devs mailing list
> >> devs(a)xwiki.org
> >>
http://lists.xwiki.org/mailman/listinfo/devs
> >>
> >
> >
> >
> > --
> > С уважением,
> > Добровольский Евгений
> > _______________________________________________
> > devs mailing list
> > devs(a)xwiki.org
> >
http://lists.xwiki.org/mailman/listinfo/devs
>
>
>
> --
> Thomas Mortagne
> _______________________________________________
> devs mailing list
> devs(a)xwiki.org
>
http://lists.xwiki.org/mailman/listinfo/devs
>
--
С уважением,
Добровольский Евгений