Re: [Tiki-devel] Changing page version number

Volker Wysk <post-hhF2Jplw28UoZk/[email protected]> Mon, 01 Aug 2022 17:28:32 +0200
Newsgroups	gmane.comp.cms.tiki.devel
Message-ID	<[email protected]>
Am Montag, dem 01.08.2022 um 15:42 +0100 schrieb Jonny Bradley via TikiWiki-
devel:
> Hi Volker
> 
> Really couldn't say without trying it, i'd imaging you'd need to delete
> the record in `tiki_history` for the existing version 1 first, 

So tiki_pages and tiki_history are the only involved tables. Meanwhile I've
figured as much, but I couldn't be sure.

I'm deleting the records for version 1, in tiki_pages and tiki_history, with
the remove_version() function from histlib. So I don't need to tidy up
version 1 in tiki_history.

> then you might need to flush the tiki caches, 

This is an important point, which is new to me. 

Judging from the sources in lib/cache, there are three caches: opcode_cache,
memcache and redis. I'm going to flush them all.

> can you try on a test version?

Yes, that's what I'm doing.

> Good luck!

Thanks!  :-)

Volker


> 
> jonny
> 
> 
> 
> 
> > On 31 Jul 2022, at 18:11, Volker Wysk <post-hhF2Jplw28UoZk/[email protected]> wrote:
> > 
> > Hi
> > 
> > Could it be as simple as:
> > 
> >   update tiki_pages set version = 1 
> >   where pageName = "mypage" and version = 2;
> > 
> > Or would that result in unexpected behavior?
> > Cheers, Volker
> > 
> > 
> > Am Sonntag, dem 31.07.2022 um 18:52 +0200 schrieb Volker Wysk:
> > > Hi!!
> > > 
> > > Is it possible to change the version number of a wiki page, which has one
> > > unique version with the number 2, to number 1?
> > > 
> > > I guess I would have to directly manipulate the database. Could some kind
> > > Tiki hacker show me how this is to be done?
> > > 
> > > I'm afraid I would break things, since I have hardly any experience.
> > > 
> > > Cheers,
> > > Volker
> > > _______________________________________________
> > > TikiWiki-devel mailing list
> > > [email protected]
> > > https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> > _______________________________________________
> > TikiWiki-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> 
> 
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
signature.asc (application/pgp-signature, 833 B)