Menu
▾
▴
Re: [Bodington-developers] 2.8 db updates?
|
From: Alistair Y. <ali...@sm...> - 2006-08-31 10:02:06
|
well, whoever did that upgrader, I love you and want to have your babies! worked perfectly :) Alistair On 31 Aug 2006, at 10:28, Colin Tatham wrote: > Alistair Young wrote: >> is it necessary to explicitly run /setup instead of /site? > > Yes > >> will / >> setup not drop and recreate existing tables and lose the existing >> content? > > No (unless you choose that option). > When you run /setup it should tell you what version of the code the > existing database is compatible > with. It also lists existing tables and missing tables. If you > choose to continue, it will run the > upgrade SQL and then give you a page with a link to enter the site > (that's when I had to reload the > webapp, as the clicking on the link to go to the site gave me an > error page.) > > If you run /setup again, after upgrading and reloading, it should > report the database as supporting > the current version, and there should be no list of missing tables. > > Why don't you test it with a database dump, and see what harpoons? > > Colin > >> On 31 Aug 2006, at 10:04, Colin Tatham wrote: >> >> >>> Alistair Young wrote: >>> >>>> brilliant! thanks Colin. >>> >>> Just checked, and the SQL for Newsfeeds is included, so you don't >>> need to run that separately. >>> Also noticed that I needed to reload the webapp after running Setup >>> Servlet (but SetupServlet >>> managed to identify the missing tables and create them OK...) >>> >>> Colin >>> >>> >>>> Bring your earplugs to the tetra bash, the >>>> fc will be piping us in! >>>> >>>> Alistair >>>> >>>> On 31 Aug 2006, at 09:32, Colin Tatham wrote: >>>> >>>> >>>> >>>>> Alistair Young wrote: >>>>> >>>>> >>>>>> Thanks Colin. I'm showing my ignorance here but how does one run >>>>>> the >>>>>> upgrade code? I presume running setup on a live database is a bad >>>>>> thing? Is it something else that should be run? >>>>> >>>>> When you run the 2.8 code against an existing database it should >>>>> detect the version (by looking at >>>>> existing tables) and then automatically run any SQL necessary. >>>>> Obviously test it on a dump of your >>>>> live data first! >>>>> >>>>> You'll need to run the NewsFeed SQL separately, as it's not >>>>> included in the upgrade code. >>>>> >>>>> Colin >>>>> >>>>> >>>>> >>>>>> On 31 Aug 2006, at 08:59, Colin Tatham wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> Alistair Young wrote: >>>>>>> >>>>>>> >>>>>>> >>>>>>>> Dearest bodders, it's been a while but now we're upgrading >>>>>>>> to 2.8 >>>>>>>> - does >>>>>>>> anyone know if there are db updates required since the last >>>>>>>> release? >>>>>>> >>>>>>> The SQL for NewsFeeds needs to be run: >>>>>>> /server/resources/NewsFeedResource.sql >>>>>>> >>>>>>> I think Aggie added QuickLinks to the upgrade code, so you >>>>>>> shouldn't need to run anything for them... >>>>>>> >>>>>>> Colin >>>>>>> >>>>>>> -- >>>>>>> ____________________________________ >>>>>>> Colin Tatham >>>>>>> VLE Team >>>>>>> Oxford University Computing Services >>>>>>> >>>>>>> http://www.oucs.ox.ac.uk/ltg/vle/ >>>>>>> http://bodington.org >>>>>>> >>>>>>> ---------------------------------------------------------------- >>>>>>> -- >>>>>>> -- >>>>>>> -- >>>>>>> --- >>>>>>> Using Tomcat but need to do more? Need to support web services, >>>>>>> security? >>>>>>> Get stuff done quickly with pre-integrated technology to make >>>>>>> your >>>>>>> job easier >>>>>>> Download IBM WebSphere Application Server v.1.0.1 based on >>>>>>> Apache >>>>>>> Geronimo >>>>>>> http://sel.as-us.falkag.net/sel? >>>>>>> cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>>>> _______________________________________________ >>>>>>> Bodington-developers mailing list >>>>>>> Bod...@li... >>>>>>> https://lists.sourceforge.net/lists/listinfo/bodington- >>>>>>> developers >>>>>> >>>>>> >>>>>> >>>>>> ----------------------------------------------------------------- >>>>>> -- >>>>>> -- >>>>>> ---- >>>>>> Using Tomcat but need to do more? Need to support web services, >>>>>> security? >>>>>> Get stuff done quickly with pre-integrated technology to make >>>>>> your >>>>>> job easier >>>>>> Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>>> Geronimo >>>>>> http://sel.as-us.falkag.net/sel? >>>>>> cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>>> _______________________________________________ >>>>>> Bodington-developers mailing list >>>>>> Bod...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> ____________________________________ >>>>> Colin Tatham >>>>> VLE Team >>>>> Oxford University Computing Services >>>>> >>>>> http://www.oucs.ox.ac.uk/ltg/vle/ >>>>> http://bodington.org >>>>> >>>>> ------------------------------------------------------------------ >>>>> -- >>>>> -- >>>>> --- >>>>> Using Tomcat but need to do more? Need to support web services, >>>>> security? >>>>> Get stuff done quickly with pre-integrated technology to make your >>>>> job easier >>>>> Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>> Geronimo >>>>> http://sel.as-us.falkag.net/sel? >>>>> cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>> _______________________________________________ >>>>> Bodington-developers mailing list >>>>> Bod...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers >>>> >>>> >>>> >>>> ------------------------------------------------------------------- >>>> -- >>>> ---- >>>> Using Tomcat but need to do more? Need to support web services, >>>> security? >>>> Get stuff done quickly with pre-integrated technology to make your >>>> job easier >>>> Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>> Geronimo >>>> http://sel.as-us.falkag.net/sel? >>>> cmd=lnk&kid=120709&bid=263057&dat=121642 >>>> _______________________________________________ >>>> Bodington-developers mailing list >>>> Bod...@li... >>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers >>>> >>>> >>> >>> >>> -- >>> ____________________________________ >>> Colin Tatham >>> VLE Team >>> Oxford University Computing Services >>> >>> http://www.oucs.ox.ac.uk/ltg/vle/ >>> http://bodington.org >>> >>> -------------------------------------------------------------------- >>> -- >>> --- >>> Using Tomcat but need to do more? Need to support web services, >>> security? >>> Get stuff done quickly with pre-integrated technology to make your >>> job easier >>> Download IBM WebSphere Application Server v.1.0.1 based on Apache >>> Geronimo >>> http://sel.as-us.falkag.net/sel? >>> cmd=lnk&kid=120709&bid=263057&dat=121642 >>> _______________________________________________ >>> Bodington-developers mailing list >>> Bod...@li... >>> https://lists.sourceforge.net/lists/listinfo/bodington-developers >> >> >> >> --------------------------------------------------------------------- >> ---- >> Using Tomcat but need to do more? Need to support web services, >> security? >> Get stuff done quickly with pre-integrated technology to make your >> job easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache >> Geronimo >> http://sel.as-us.falkag.net/sel? >> cmd=lnk&kid=120709&bid=263057&dat=121642 >> _______________________________________________ >> Bodington-developers mailing list >> Bod...@li... >> https://lists.sourceforge.net/lists/listinfo/bodington-developers >> >> > > > -- > ____________________________________ > Colin Tatham > VLE Team > Oxford University Computing Services > > http://www.oucs.ox.ac.uk/ltg/vle/ > http://bodington.org > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Bodington-developers mailing list > Bod...@li... > https://lists.sourceforge.net/lists/listinfo/bodington-developers |
