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