Menu
▾
▴
Re: [Bodington-developers] 2.8 db updates?
|
From: Colin T. <col...@ou...> - 2006-08-31 10:39:26
|
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 |
