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 05:42:52
|
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. |
