Menu
▾
▴
Re: [Bodington-developers] 2.8 db updates?
|
From: Alistair Y. <ali...@sm...> - 2006-08-31 10:40:54
|
nope! On 31 Aug 2006, at 11:39, Colin Tatham wrote: > Alistair Young wrote: >> well, whoever did that upgrader, I love you and want to have your >> babies! > > I think you did some work on it, didn't you? :-) > >> 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 >> >> >> >> --------------------------------------------------------------------- >> ---- >> 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 |
