[Xerte-dev] Re: Preparation for 1.8 Release

[Pat Lockley]

It did used to fail, but the drops now stop that.

On Thu, Jul 12, 2012 at 3:42 PM, Ron Mitchell <ronm at mitchellmedia.co.uk> wrote:
> As I said I've always used the full install option even locally on xampp for
> the very reason that I didn't want to accidentally overwrite an existing
> install. However having just tested a full install from the same location as
> a previous for xampp install and adding toolkits_data as the db I was
> suprised that the same thing happened e.g. no prompt just over written db
> and projects no longer visible. I thought the full install used to fail when
> trying to write to tables that already existed.
>
> Personally I think it shouldn't be possible to run setup again on an
> existing install or at least when trying to do so it switches to
> upgrade/update or warns of the consequences.
>
> -----Original Message-----
> From: xerte-dev-bounces at lists.nottingham.ac.uk
> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
> Sent: 12 July 2012 14:46
> To: For Xerte technical developers
> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>
> Ok, will have a look over the weekend
>
> Is "Policy" to drop or not to drop? I would say keep drops in separate
> script?
>
> On Thu, Jul 12, 2012 at 2:37 PM, Julian Tenney
> <Julian.Tenney at nottingham.ac.uk> wrote:
>> Tend to agree because there's going to be someone who upgrades, messes
>> it up, loses all their work and gets upset.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Ron
>> Mitchell
>> Sent: 12 July 2012 14:26
>>
>>
>> To: 'For Xerte technical developers'
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> Having just tested the For XAMPP People option and removed the error
>> about demo.txt I created a test project and then re-ran setup with the
>> For XAMPP People option again. No errors, no prompts but database is
>> obviously overwritten and previous project disappears. I guess this
>> has always been the case with the For XAMPP People option but with the
>> objective of making initial install simple for people I think there
>> really ought to be at least a warning/prompt that re-running setup
>> will lose all existing projects
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Julian
>> Tenney
>> Sent: 12 July 2012 12:06
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>>> Presumably if you're doing a re-install you expect (and want to?)
>>> lose anything which might already be there.
>>
>> I'd delete htdocs xerte toolkits and mysql/data/toolkits (or whatever
>> the folder's called) then drop the new files into htdocs and then go
>> to setup for a fresh install.
>>
>>
>>
>> I'm not sure how I'd try and keep existing content, or what I'd assume
>> would happen if I went over the top. I'd probably assume nothing would
>> be deleted without my say-so.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of David
>> Goodwin
>> Sent: 12 July 2012 12:02
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> I would have added the drop's so if you're installing it a second time
>> (over the top of an existing one) you don't get a load of error
>> messages from MySQL/PHP saying "TAble X already exists" or whatever.
>>
>>
>>
>> Presumably if you're doing a re-install you expect (and want to?) lose
>> anything which might already be there.
>>
>>
>>
>>
>>
>> David.
>>
>>
>>
>> On 12 Jul 2012, at 11:59, Pat Lockley wrote:
>>
>>
>>
>> Erm
>>
>>
>>
>> Well, the XAMPP version relies on
>>
>>
>>
>> 1) The database server being called localhost
>>
>> 2) The folder being xertetoolkits
>>
>> 3) The passwords being the default
>>
>>
>>
>> So if you had 1.7 and then tried to install 1.8 on the same local PC -
>> it'd die I suspect on the fact the xampp.sql in setup doesn't have any
>> drop commands.
>>
>>
>>
>> But it'd not work anyways as you'd never be able to access it (as the
>> urls and paths are fixed). So a second xampp install would point to
>> http://localhost/xertetoolkits/ - but that would be the old 1.7
>> install. So the 1.8 install wouldn't ever really be accessible.
>>
>>
>>
>> The XAMPP install is more important (in my mind) than the full install
>> - just because it gives people who aren't technical a chance of
>> getting it installed.
>>
>> It is a valid question though as there are now drop statements in
>> basic.sql
>> - which weren't there originally. I think the drops are a bit of a
>> risk, but happy to be told otherwise.
>>
>> On Thu, Jul 12, 2012 at 11:22 AM, Julian Tenney
>> <Julian.Tenney at nottingham.ac.uk> wrote:
>>
>> I don't know, this has always been an issue I guess. Warn the user?
>> Try and migrate the content from one to another?
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Ron
>> Mitchell
>> Sent: 12 July 2012 11:22
>>
>>
>> To: 'For Xerte technical developers'
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>>
>>
>>
>>
>> Yes but as I said what happens if there's already an install?
>>
>> Meeting now will test again later.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Julian
>> Tenney
>> Sent: 12 July 2012 11:13
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> The quick one.
>>
>>
>>
>> I think it's there to give a real easy way of setting up for the
>> non-techs, I think that's important.
>>
>>
>>
>> Thanks.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Ron
>> Mitchell
>> Sent: 12 July 2012 11:13
>> To: 'For Xerte technical developers'
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> I've not seen that error but I always use the full install option when
>> testing with xampp not the quick xampp install option. Which did you use?
>>
>>
>>
>> Although I understand why the quick install option is there I've
>> always thought that has disadvantages too e.g. what happens when
>> someone thinks ok I'll test 1.8 on the same xampp install where I have
>> 1.7. They create a new directory, run setup, choose the xampp option
>> rather than full install - does it overwrite the existing 1.7 database
>> or fail to install because the database already exists?
>>
>>
>>
>> I have an online meeting now until about 12.30 but will test xampp
>> stuff after that.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Julian
>> Tenney
>> Sent: 12 July 2012 10:53
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> OK. So how do we stop the error?
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Ron
>> Mitchell
>> Sent: 12 July 2012 10:53
>> To: 'For Xerte technical developers'
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> By default when you do a new install the guest access is enabled. You
>> then need to edit config.php and comment/uncomment the authentication
> required.
>> So no for a demo.txt etc and means it's easy to test that the install
>> has completed correctly before enable chosen authentication.
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat
>> Lockley
>> Sent: 12 July 2012 09:47
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> I don't know how authentication works anymore, the old XAMPP route
>> used to copy demo so people didn't have to do it, but with the new
>> authentication I don't know if demo is spurious anymore?
>>
>> On Thu, Jul 12, 2012 at 9:40 AM, Julian Tenney
>> <Julian.Tenney at nottingham.ac.uk> wrote:
>>
>> What do I need to do?
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat
>> Lockley
>> Sent: 12 July 2012 09:39
>>
>>
>> To: For Xerte technical developers
>>
>> Subject: [Xerte-dev] Re: Preparation for 1.8 Release
>>
>>
>>
>> I'm guessing that the old setup had demo.txt in, and demo.txt has been
>> removed from /setup?
>>
>> On Thu, Jul 12, 2012 at 9:37 AM, Julian Tenney
>> <Julian.Tenney at nottingham.ac.uk> wrote:
>>
>> Doing an xampp install I get this error, what's the problem?
>>
>>
>>
>> <image001.png>
>>
>>
>>
>> From: xerte-dev-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Julian
>> Tenney
>> Sent: 12 July 2012 09:35
>> To: For Xerte technical developers
>> Subject: [Xerte-dev] Preparation for 1.8 Release
>>
>>
>>
>> A couple of us are going to deploy Toolkits 1.8 in anger next Friday:
>> everyone seems to think that everything is ready, it would be good to
>> have one final check that everything we think works still does.
>>
>>
>>
>> Ron, can you update the test server with the latest svn files so we
>> can see it running on a server please?
>>
>>
>>
>> Can anyone do an LDAP setup and test that?
>>
>>
>>
>> Can everyone do a localhost / xampp setup and check all your bits and
>> pieces still work please?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
>> message in error, please send it back to me, and immediately delete
>> it. Please do not use, copy or disclose the information contained in
>> this message or in any attachment. Any views or opinions expressed by
>> the author of this email do not necessarily reflect the views of the
> University of Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
> message in
>> error, please send it back to me, and immediately delete it.   Please do
> not
>> use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of
> Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
> message in
>> error, please send it back to me, and immediately delete it.   Please do
> not
>> use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of
> Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
> message in
>> error, please send it back to me, and immediately delete it.   Please do
> not
>> use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of
> Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
>> message in error, please send it back to me, and immediately delete
>> it. Please do not use, copy or disclose the information contained in
>> this message or in any attachment. Any views or opinions expressed by
>> the author of this email do not necessarily reflect the views of the
> University of Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
> message in
>> error, please send it back to me, and immediately delete it.   Please do
> not
>> use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of
> Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>>
>> Pale Purple Ltd.  (Company No: 5580814)
>>
>> 'Business Web Application Development and Training in PHP'
>>
>>
>>
>> http://www.palepurple.co.uk
>>
>> Office: 0845 0046746     Mobile: 07792380669
>>
>>
>>
>> Follow us on Twitter: @PalePurpleLtd
>>
>>
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> This message and any attachment are intended solely for the addressee
>> and may contain confidential information. If you have received this
> message in
>> error, please send it back to me, and immediately delete it.   Please do
> not
>> use, copy or disclose the information contained in this message or in
>> any attachment.  Any views or opinions expressed by the author of this
>> email do not necessarily reflect the views of the University of
> Nottingham.
>>
>> This message has been checked for viruses but the contents of an
>> attachment may still contain software viruses which could damage your
> computer system:
>> you are advised to perform your own checks. Email communications with
>> the University of Nottingham may be monitored as permitted by UK
> legislation.
>>
>>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev