phpesp-general

[phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[boardtc <bo...@gm...>]

I have just moved isps. I have a php survey I would like to remain active.
My previous installation was v 1.7.5. I have a full .sql backup including
data.

I see the latest version is 2.1.4. Can I install that at my new isp and
then restore the 1.7.5 database and run some kind of upgrade?

Thanks!

Cheers,

Tom.

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[Franky V. L. <lie...@te...>]

On Fri, 1 Mar 2013 16:16:16 +0000
boardtc <bo...@gm...> wrote:

> I have just moved isps. I have a php survey I would like to remain
> active. My previous installation was v 1.7.5. I have a full .sql
> backup including data.
> 
> I see the latest version is 2.1.4. Can I install that at my new isp
> and then restore the 1.7.5 database and run some kind of upgrade?
> 
> Thanks!
> 
> Cheers,
> 
> Tom.

Just execute the mysql_update scripts in scripts/db/:

mysql_update-1.8.2h-1.8.2i.sql
mysql_update-1.8.2k-2.0.0.sql

Franky

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[boardtc <bo...@gm...>]

Thanks Franky.

My isp had a 2.1.1 install I ran. I then dropped the installed tables and
restored my 1.7.5 backup. Then I ran the  sql_update-1.5-1.6.sql script.My
survey was not active so I tried to logion to manage but my login did not
work, maybe because I dropped the installed tables..

What is the correct process I should do?


Cheers,

Tom.


On 2 March 2013 23:23, Franky Van Liedekerke <lie...@te...> wrote:

> On Fri, 1 Mar 2013 16:16:16 +0000
> boardtc <bo...@gm...> wrote:
>
> > I have just moved isps. I have a php survey I would like to remain
> > active. My previous installation was v 1.7.5. I have a full .sql
> > backup including data.
> >
> > I see the latest version is 2.1.4. Can I install that at my new isp
> > and then restore the 1.7.5 database and run some kind of upgrade?
> >
> > Thanks!
> >
> > Cheers,
> >
> > Tom.
>
> Just execute the mysql_update scripts in scripts/db/:
>
> mysql_update-1.8.2h-1.8.2i.sql
> mysql_update-1.8.2k-2.0.0.sql
>
> Franky
>

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[Franky V. L. <lie...@te...>]

On Tue, 5 Mar 2013 23:20:51 +0000
boardtc <bo...@gm...> wrote:

> Thanks Franky.
> 
> My isp had a 2.1.1 install I ran. I then dropped the installed tables
> and restored my 1.7.5 backup. Then I ran the  sql_update-1.5-1.6.sql
> script.My survey was not active so I tried to logion to manage but my
> login did not work, maybe because I dropped the installed tables..
> 
> What is the correct process I should do?
> 
> 
> Cheers,
> 
> Tom.

You ran the wrong update script, you need to run the newer ones:

mysql_update-1.8.2h-1.8.2i.sql
mysql_update-1.8.2k-2.0.0.sql

Franky

> 
> On 2 March 2013 23:23, Franky Van Liedekerke <lie...@te...>
> wrote:
> 
> > On Fri, 1 Mar 2013 16:16:16 +0000
> > boardtc <bo...@gm...> wrote:
> >
> > > I have just moved isps. I have a php survey I would like to remain
> > > active. My previous installation was v 1.7.5. I have a full .sql
> > > backup including data.
> > >
> > > I see the latest version is 2.1.4. Can I install that at my new
> > > isp and then restore the 1.7.5 database and run some kind of
> > > upgrade?
> > >
> > > Thanks!
> > >
> > > Cheers,
> > >
> > > Tom.
> >
> > Just execute the mysql_update scripts in scripts/db/:
> >
> > mysql_update-1.8.2h-1.8.2i.sql
> > mysql_update-1.8.2k-2.0.0.sql
> >
> > Franky
> >

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[boardtc <bo...@gm...>]

Thanks! I ran both of those in sequence, the 2nd one errored as conditions
was already there. My survey is still inactive and I can't login - I guess
I blew the new login away and the old password is encrypted and I can't
remember it :-(

Cheers,

Tom.


On 5 March 2013 23:50, Franky Van Liedekerke <lie...@te...> wrote:

>
> You ran the wrong update script, you need to run the newer ones:
>
> mysql_update-1.8.2h-1.8.2i.sql
> mysql_update-1.8.2k-2.0.0.sql
>
> Franky
>

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[boardtc <bo...@gm...>]

Ok. I sorted out my login issue, going back to some password backup files.
After all the list of depreciations on the page my survey says: [ Error
processing survey: Survey is not active. ]

But when I go into manage the survey in question is active?

Thanks for any ideas.


Cheers,

Tom.


On 6 March 2013 00:09, boardtc <bo...@gm...> wrote:

>
> Thanks! I ran both of those in sequence, the 2nd one errored as conditions
> was already there. My survey is still inactive and I can't login - I guess
> I blew the new login away and the old password is encrypted and I can't
> remember it :-(
>
> Cheers,
>
> Tom.
>
>
> On 5 March 2013 23:50, Franky Van Liedekerke <lie...@te...> wrote:
>
>>
>> You ran the wrong update script, you need to run the newer ones:
>>
>> mysql_update-1.8.2h-1.8.2i.sql
>> mysql_update-1.8.2k-2.0.0.sql
>>
>> Franky
>>
>
>

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[Franky V. L. <lie...@te...>]

 

I'm guessing you messed up somehow with your database. I haven't
looked at the code for about 2 years, so for now you need to do your own
debugging. My advise: start your upgrade over again, and be carefull
this time. Check the mysql files and execute everything in the upgrade
sql files (only those newer than your own release), and try again ...


Franky 

On 2013-03-06 16:25, boardtc wrote: 

> Ok. I sorted out my
login issue, going back to some password backup files. After all the
list of depreciations on the page my survey says: [ Error processing
survey: Survey is not active. ] 
> 
> But when I go into manage the
survey in question is active? 
> 
> Thanks for any ideas. 
> 
>
Cheers,
> 
> Tom. 
> 
> On 6 March 2013 00:09, boardtc
<bo...@gm...> wrote:
> 
>> Thanks! I ran both of those in
sequence, the 2nd one errored as conditions was already there. My survey
is still inactive and I can't login - I guess I blew the new login away
and the old password is encrypted and I can't remember it :-( 
>> 
>>
Cheers,
>> 
>> Tom. 
>> 
>> On 5 March 2013 23:50, Franky Van Liedekerke
<lie...@te...> wrote:
>> 
>>> You ran the wrong update script,
you need to run the newer ones:
>>> 
>>>
mysql_update-1.8.2h-1.8.2i.sql
>>> mysql_update-1.8.2k-2.0.0.sql
>>>

>>> Franky

 

Re: [phpesp-general] Installing latests 2.1.4 with 1.7.5 backup ?

[boardtc <bo...@gm...>]

Good advise and many thanks. I am unsure if I need to blow away the
database once it's installed and restore my old one, I think so. Then I
need to run the 2 upgrade sql files in order and al should be ok.
After installation, I also copy my index.html file over which links the
survey.

Cheers,

Tom.


On 6 March 2013 16:34, Franky Van Liedekerke <lie...@te...> wrote:

> **
>
> I'm guessing you messed up somehow with your database. I haven't looked at
> the code for about 2 years, so for now you need to do your own debugging.
> My advise: start your upgrade over again, and be carefull this time. Check
> the mysql files and execute everything in the upgrade sql files (only those
> newer than your own release), and try again ...
>
>
>
> Franky
>