Page 1 of 1

[MORE PROBS] Upgrade problems... was... Upgrade Instructions

PostPosted: Wed Dec 06, 2006 5:03 pm
Author: ianbutty
I know the instructions will be posted somewhere on this site but I can't find them and they are not in the 140.zip file.

Can someone please tell me where the upgrade instructions are to go from IM1.3.2c (phpBB v2.0.13 if it makes any difference).

Thanks,
Ian.

PostPosted: Wed Dec 06, 2006 5:20 pm
Author: Imajica

Re: Upgrade Instructions

PostPosted: Wed Dec 06, 2006 5:20 pm
Author: Imajica

Re: Upgrade Instructions

PostPosted: Wed Dec 06, 2006 5:24 pm
Author: Helter
you may do better with this one
http://www.integramod.com/forum/dload.p ... file_id=95
the other file will give you 140, but it will also require all the phpBB updates and the security mod update

Re: Upgrade Instructions

PostPosted: Thu Dec 07, 2006 6:22 am
Author: ianbutty
Thank for the details of the upgrade. I've hit my first problem... runing db_update1.php I get the following error....

[code]phpBB ]

I can confirm that I don't have a table in my database called phpbb_sessions_keys. Can anyone suggest what I need to do to create it or by pass the error?

Thanks

Re: Upgrade Instructions

PostPosted: Thu Dec 07, 2006 6:48 am
Author: ianbutty
I've got a little further with this....

Created the missing table using the following SQL:
Code: Select all
CREATE TABLE `phpbb_sessions_keys` (   `key_id` varchar(32) NOT NULL default '0',   `user_id` mediumint(8) NOT NULL default '0',   `last_ip` varchar(8) NOT NULL default '0',   `last_login` int(11) NOT NULL default '0',   PRIMARY KEY  (`key_id`,`user_id`),   KEY `last_login` (`last_login`) ) TYPE=MyISAM;


Next I deleted and recreated the phpbb_sessions table as that had some fields missing from it (namely session_admin).

Code: Select all
CREATE TABLE phpbb_sessions (   session_id varchar(32) NOT NULL default '',   session_user_id mediumint(8) NOT NULL default '0',   session_start int(11) NOT NULL default '0',   session_time int(11) NOT NULL default '0',   session_ip varchar(8) NOT NULL default '0',   session_page int(11) NOT NULL default '0',   session_logged_in tinyint(1) NOT NULL default '0',   session_robot varchar(32) default NULL,   session_admin tinyint(2) DEFAULT '0' NOT NULL,   PRIMARY KEY  (session_id),   KEY session_user_id (session_user_id),   KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) TYPE=MyISAM;


Now when I run the db_update1.php script I get redirected to the login screen. Whey I try to login I get an "Error in obtaining userdata" message. Namely:
SQL Error : 1054 Unknown column 'user_activate_date' in 'field list'

Any suggestions?

Re: Upgrade Instructions

PostPosted: Thu Dec 07, 2006 8:28 am
Author: ianbutty
A further update....
I've been creating fields in tables when errors have appeared. Needed to add quite a few of them. Mainly in phpbb_user. Mostly associated with phpbbsecurity.

Current state of the installation is that every account (including my admin accounts) are locked due to having exceeded log in attemps. So I currently can't get in to my own site!

I'm not sure whether or not the db_updates*.php scripts have worked or not. I'm not familiar enough to know if the database has extra fields/tables from them. HOWEVER... the behaviour of the scripts was and is odd, instead of one script providing a link to the next one they each took me to the login screen.

So... I'm out of ideas now... so urgent help would be appreciated as my site is currently down.

FYI http://forum.iphotos.co.uk is the the website.
Thank you in advance for any help.

Regards,
Ian M Butterfield.

Re: [Urgent] Upgrade problems... was... Upgrade Instructions

PostPosted: Thu Dec 07, 2006 8:48 am
Author: Helter
it looks like you did the update out of order. if you still have a backup of your original files, redo the update and follow the instructions in the READ ME file exactly. Dont wory about duplicate tables/fields errors

Re: [Urgent] Upgrade problems... was... Upgrade Instructions

PostPosted: Thu Dec 07, 2006 8:54 am
Author: ianbutty
How do you mean out of order?

I copied all the files to the server and the first thing I ran was db_update1.php. Which fell over because the install directory existed (so I renamed it) and the sessions_key table didn't exist.

Is there something I should have done before running db_update1.php?

Thanks,
Ian.

Re: [Urgent] Upgrade problems... was... Upgrade Instructions

PostPosted: Thu Dec 07, 2006 2:34 pm
Author: Helter
this is the "READ ME FIRST" file that is included in the update


This file is to update phpBB to Integramod 140/phpBB 2.0.21
It is critical that you follow the directions as stated.

1- Uninstall all templates other than subsilver.
2- Get a complete backup of your phpBB installation and database. (store in a safe place)
3- upload to your forum root
db_update1.php
db_update2.php
db_update3.php
db_update4.php
db_update5.php
4- go to http://www.your_forum/db_update1.php
the bottom of the page will have a link to the next update file.
5- In step 5, you are asked to enter some field names for phpBB security. It is strongly suggested that you use the suggested names. When you have entered this information, select "Submit"
6- BEFORE you click the "GO TO STEP 6" link you must upload the files in the "root" folder, overwritting your original phpBB files.
You must also set your file permissions using either your Cpanel or FTP client.
7-Click "GO TO STEP 6"
8-Delete the install folder and delete all 5 db_update* files
Your forum should now be Integramod 140 with phpBB 2.0.21 and security mod 1.0.3


Prillian

By default this script does not install the Prillian instant messenger.

to install prillian, first, OPEN http://www.forum root/config.php

FIND


define('PHPBB_INSTALLED', true);

AFTER, ADD

define('PRILLIAN_INSTALLED', true);

Save and Close

Rename forum root/-prill_install to forum root/prill_install
(your just removing the - (dash) from the beginning of the name.

from your browser, go to http://www.yoursite.com/prill_install/im_install.php

when install routine is complete, delete the Prill_Install folder


The update files will not run with the new forum files installed, since they look for tables/fields that do not exist yet

Re: [Urgent] Upgrade problems... was... Upgrade Instructions

PostPosted: Thu Dec 07, 2006 2:51 pm
Author: ianbutty
Yeah, I eventually guessed what was going on!

I uploaded the files before running the db_update files. I made a bad assumption that the db_update files ONLY did SQL ALTER / ADD / INSERT commands. Didn't realise they need the *old* php scripts to present.

Well you live and learn. I'm now at the copy files to the server stage (db_updates having run OK) so hopefully everything should be fine now.

Thanks for all the help.

Regards,
Ian.

Re: Upgrade problems... was... Upgrade Instructions

PostPosted: Fri Dec 08, 2006 3:53 am
Author: ianbutty
Ok, so the upgrade was successful.... but I'm now locked out of my own site. I tend to have only one style/theme and I alocate that to all users.

I uploaded and tested (or so I thought) the ICGStation theme. Switched all users to the theme. Unfortunately now no-one can login or register. I have been able to login with one of my admin accounts... but it won't let me go into admin to change the theme/style.
(Instead of going to the admin screen or the enter the password again screen... I get the same truncated view as shown in the screen shot below).

The site is http://forum.iphotos.co.uk - try registering and you get a truncated display:
[flash=,:2kqkyrat]http://www.iphotos.co.uk/tmp/screenshot2.jpg[/flash:2kqkyrat]

The registration screen does not display correctly.

When a valid user logs in all they get is the theme header and footer - no content or menus. (You can see both when not logged in!)
[flash=,:2kqkyrat]http://www.iphotos.co.uk/tmp/screenshot.jpg[/flash:2kqkyrat]

Any suggestions?

Re: [MORE PROBS] Upgrade problems... was... Upgrade Instruct

PostPosted: Fri Dec 08, 2006 8:54 am
Author: Helter
is this the 140 version of ICGStation? 132 themes will not work. If this is the 132 version, rename it and upload the correct version.

Re: [MORE PROBS] Upgrade problems... was... Upgrade Instruct

PostPosted: Tue Dec 12, 2006 8:18 am
Author: ianbutty
"HelterSkelter";p="18173" wrote:is this the 140 version of ICGStation? 132 themes will not work. If this is the 132 version, rename it and upload the correct version.


Definately the 140 version of the theme. Downloaded from:
http://www.integramod.com/forum/dload.p ... &file_id=7

Any suggestions?

Re: [MORE PROBS] Upgrade problems... was... Upgrade Instruct

PostPosted: Tue Dec 12, 2006 8:32 am
Author: Helter
looks like it is working fine in fisubice?

Re: [MORE PROBS] Upgrade problems... was... Upgrade Instruct

PostPosted: Tue Dec 12, 2006 8:43 am
Author: ianbutty
Yes working OK in fisubice (which I've had to move to while I get ICGStation working). Although I did have a couple of minor probs with fisubice but they were to do with the location of some of the graphics (the language wasn't recognised and the language specific fisubice graphics weren't being found).

Fisubice never had any trouble with the login / register screens as shown in the screen captures.
ICGStation never had any problems with the graphics... just no one can register or login.