Re: [Phpip-support] trying to install or upgrade to 4.2
Brought to you by:
trilexcom
Menu
▾
▴
Re: [Phpip-support] trying to install or upgrade to 4.2
|
From: <php...@li...> - 2006-08-22 16:38:41
|
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 > |
