phpip-support

[Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  
 
If you need any help, feel free to email direct.
 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E



 

  _____  

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2



Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

 

 

  _____  

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

  _____  

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Sorry about the blank previous email.

 

Not sure what your driect email is.

 

So what I did was unpack version 4.2 and then copied everything over into
the 3.2 installation.

 

Then I ran the upgrade by doing this:

 

$ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p

Enter password:

ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist

 

Should I be doing it differently?

 

Thanks.

 

  _____  

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

  _____  

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Lets try this again, the upgrade file was incorrect.


Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E



 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 6:04 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2



Sorry about the blank previous email.

 

Not sure what your driect email is.

 

So what I did was unpack version 4.2 and then copied everything over into
the 3.2 installation.

 

Then I ran the upgrade by doing this:

 

$ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p

Enter password:

ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist

 

Should I be doing it differently?

 

Thanks.

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

I used the attached file in your previous email.  I get this error now:

$ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p
Enter password:
ERROR 1068 (42000) at line 11: Multiple primary key defined

Thanks.

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 5:20 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

Lets try this again, the upgrade file was incorrect.


Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E



 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 6:04 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2



Sorry about the blank previous email.

 

Not sure what your driect email is.

 

So what I did was unpack version 4.2 and then copied everything over into
the 3.2 installation.

 

Then I ran the upgrade by doing this:

 

$ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p

Enter password:

ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist

 

Should I be doing it differently?

 

Thanks.

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> 
http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Please try this out, I have rearrange the sql to drop current primary index
on the address table.  Please also edit this file at the bottom and put in
your password for the local phpip account.

Item to look for:
INSERT INTO `users` (`username`, `access_level`, `type`, `name`, `email`,
`password`, `groupid`) VALUES 
	('phpip', 'admin', 'local', 'ip admin', 'phpip@localhost', MD5(
'$password' ) , 1)"); 

Once this change has been made to phpip, please use the new local account
phpip with your password you defined in the above sql statement.


Michael Earls

http://www.vermeer.org
http://www.vermeer.org/pgp
http://www.phpip.net

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E 


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Tuesday, August 22, 2006 1:43 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

I used the attached file in your previous email.  I get this error now:

$ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p Enter password:
ERROR 1068 (42000) at line 11: Multiple primary key defined

Thanks.

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 5:20 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

Lets try this again, the upgrade file was incorrect.


Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E



 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 6:04 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2



Sorry about the blank previous email.

 

Not sure what your driect email is.

 

So what I did was unpack version 4.2 and then copied everything over into
the 3.2 installation.

 

Then I ran the upgrade by doing this:

 

$ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p

Enter password:

ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist

 

Should I be doing it differently?

 

Thanks.

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.



-------------------------------------------------------------------------
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
_______________________________________________
Phpip-support mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpip-support

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Np, after making the changes, I get this error now:

$ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p
Enter password:
ERROR 1060 (42S21) at line 1: Duplicate column name 'groupid'

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Tuesday, August 22, 2006 12:51 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

Please try this out, I have rearrange the sql to drop current primary index
on the address table.  Please also edit this file at the bottom and put in
your password for the local phpip account.

Item to look for:
INSERT INTO `users` (`username`, `access_level`, `type`, `name`, `email`,
`password`, `groupid`) VALUES 
	('phpip', 'admin', 'local', 'ip admin', 'phpip@localhost', MD5(
'$password' ) , 1)"); 

Once this change has been made to phpip, please use the new local account
phpip with your password you defined in the above sql statement.


Michael Earls

http://www.vermeer.org
http://www.vermeer.org/pgp
http://www.phpip.net

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E 


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Tuesday, August 22, 2006 1:43 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

I used the attached file in your previous email.  I get this error now:

$ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p Enter password:
ERROR 1068 (42000) at line 11: Multiple primary key defined

Thanks.

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 5:20 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

Lets try this again, the upgrade file was incorrect.


Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E



 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Monday, August 21, 2006 6:04 PM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2



Sorry about the blank previous email.

 

Not sure what your driect email is.

 

So what I did was unpack version 4.2 and then copied everything over into
the 3.2 installation.

 

Then I ran the upgrade by doing this:

 

$ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p

Enter password:

ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist

 

Should I be doing it differently?

 

Thanks.

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Saturday, August 19, 2006 9:21 AM
To: php...@li...
Subject: Re: [Phpip-support] trying to install or upgrade to 4.2

 

If you look under the SQL folder on the new version of phpIP there is a file
called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
database and then apply the SQL changes.  

 

If you need any help, feel free to email direct.

 

Michael Earls

http://www.vermeer.org <http://www.vermeer.org/> http://www.vermeer.org/pgp
http://www.phpip.net <http://www.phpip.net/> 

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E

 

 

________________________________

From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: Friday, August 18, 2006 10:09 PM
To: php...@li...
Subject: [Phpip-support] trying to install or upgrade to 4.2

Hi,

 

I already have an installed 3.2 version and want to upgrade to the newest
version.

 

I can install a clean new version onto the server, but what's the best way
to import the old database in 3.2 to this one?

 

I tried this:

 mysql newdatabase < oldatabasql.sql

But that didn't work, and looking at the database many of the old values are
slightly changed so it didn't import properly.

 

Or I can upgrade but I couldn't find any instructions on how to do this, I
attempted to do this by just coping over the new 4.2 version into the old
version directory, but when I ran the http://site/install.php it ran the
install but I couldn't select upgrade.

 

Any suggestions? I can do it either install method since the old site is
intact but I'm not quite getting it right.



-------------------------------------------------------------------------
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
_______________________________________________
Phpip-support mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpip-support

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

I would assume some of the data was imported after the error message.  I
would comment out or delete the duplicate column names.

michael

-- 
Michael Earls

http://www.vermeer.org
http://www.vermeer.org/pgp
http://www.phpip.net

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E


> Np, after making the changes, I get this error now:
>
> $ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p
> Enter password:
> ERROR 1060 (42S21) at line 1: Duplicate column name 'groupid'
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Tuesday, August 22, 2006 12:51 AM
> To: php...@li...
> Subject: Re: [Phpip-support] trying to install or upgrade to 4.2
>
> Please try this out, I have rearrange the sql to drop current primary
> index
> on the address table.  Please also edit this file at the bottom and put in
> your password for the local phpip account.
>
> Item to look for:
> INSERT INTO `users` (`username`, `access_level`, `type`, `name`, `email`,
> `password`, `groupid`) VALUES
> 	('phpip', 'admin', 'local', 'ip admin', 'phpip@localhost', MD5(
> '$password' ) , 1)");
>
> Once this change has been made to phpip, please use the new local account
> phpip with your password you defined in the above sql statement.
>
>
> Michael Earls
>
> http://www.vermeer.org
> http://www.vermeer.org/pgp
> http://www.phpip.net
>
> PGP Info: KeyID 0x168CBA4E
> Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E
>
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Tuesday, August 22, 2006 1:43 AM
> To: php...@li...
> Subject: Re: [Phpip-support] trying to install or upgrade to 4.2
>
> I used the attached file in your previous email.  I get this error now:
>
> $ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p Enter password:
> ERROR 1068 (42000) at line 11: Multiple primary key defined
>
> Thanks.
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Monday, August 21, 2006 5:20 PM
> To: php...@li...
> Subject: Re: [Phpip-support] trying to install or upgrade to 4.2
>
> Lets try this again, the upgrade file was incorrect.
>
>
> Michael Earls
>
> http://www.vermeer.org <http://www.vermeer.org/>
> http://www.vermeer.org/pgp
> http://www.phpip.net <http://www.phpip.net/>
>
> PGP Info: KeyID 0x168CBA4E
> Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E
>
>
>
>
>
> ________________________________
>
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Monday, August 21, 2006 6:04 PM
> To: php...@li...
> Subject: Re: [Phpip-support] trying to install or upgrade to 4.2
>
>
>
> Sorry about the blank previous email.
>
>
>
> Not sure what your driect email is.
>
>
>
> So what I did was unpack version 4.2 and then copied everything over into
> the 3.2 installation.
>
>
>
> Then I ran the upgrade by doing this:
>
>
>
> $ mysql phpip < Upgrade_3.1_to_4.2.sql -u root -p
>
> Enter password:
>
> ERROR 1146 (42S02) at line 1: Table 'phpip.NetMenu' doesn't exist
>
>
>
> Should I be doing it differently?
>
>
>
> Thanks.
>
>
>
> ________________________________
>
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Saturday, August 19, 2006 9:21 AM
> To: php...@li...
> Subject: Re: [Phpip-support] trying to install or upgrade to 4.2
>
>
>
> If you look under the SQL folder on the new version of phpIP there is a
> file
> called "Upgrade_3.1_to_4.2.sql".  I would suggest you backup the current
> database and then apply the SQL changes.
>
>
>
> If you need any help, feel free to email direct.
>
>
>
> Michael Earls
>
> http://www.vermeer.org <http://www.vermeer.org/>
> http://www.vermeer.org/pgp
> http://www.phpip.net <http://www.phpip.net/>
>
> PGP Info: KeyID 0x168CBA4E
> Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E
>
>
>
>
>
> ________________________________
>
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> php...@li...
> Sent: Friday, August 18, 2006 10:09 PM
> To: php...@li...
> Subject: [Phpip-support] trying to install or upgrade to 4.2
>
> Hi,
>
>
>
> I already have an installed 3.2 version and want to upgrade to the newest
> version.
>
>
>
> I can install a clean new version onto the server, but what's the best way
> to import the old database in 3.2 to this one?
>
>
>
> I tried this:
>
>  mysql newdatabase < oldatabasql.sql
>
> But that didn't work, and looking at the database many of the old values
> are
> slightly changed so it didn't import properly.
>
>
>
> Or I can upgrade but I couldn't find any instructions on how to do this, I
> attempted to do this by just coping over the new 4.2 version into the old
> version directory, but when I ran the http://site/install.php it ran the
> install but I couldn't select upgrade.
>
>
>
> Any suggestions? I can do it either install method since the old site is
> intact but I'm not quite getting it right.
>
>
>
> -------------------------------------------------------------------------
> 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
> _______________________________________________
> Phpip-support mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpip-support
>
>
>
> -------------------------------------------------------------------------
> 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
> _______________________________________________
> Phpip-support mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpip-support
>

Re: [Phpip-support] trying to install or upgrade to 4.2

[<php...@li...>]

Normally after it fails, I delete the database and recreate it and then
import the backup I made last week.

-----Original Message-----
I would assume some of the data was imported after the error message.  I
would comment out or delete the duplicate column names.

michael

-- 
Michael Earls

http://www.vermeer.org
http://www.vermeer.org/pgp
http://www.phpip.net

PGP Info: KeyID 0x168CBA4E
Fingerprint 14DD 0899 8FE4 1C16 9561 FA2A 1ACB CA91 168C BA4E


> Np, after making the changes, I get this error now:
>
> $ mysql phpip < Upgrade_3.2_to_4.2.sql -u root -p
> Enter password:
> ERROR 1060 (42S21) at line 1: Duplicate column name 'groupid'
>