Re: [Bodington-developers] 2.8 db updates?

[Alistair Y. <ali...@sm...>]

is it necessary to explicitly run /setup instead of /site? will / 
setup not drop and recreate existing tables and lose the existing  
content?

Alistair

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