Problem with upgrade.

[tekguru]

Guys need your help with the upgrade....

Steps taken so far:

1) Host took my live database and made a copy of it under a different name
2) All the files from the full 1.41 package were copied over into a subdirectory of the normal site
3) The CHMODs were performed
4) Config.php was modified to allow me to access the right database

If I try to access the portal ( http://www.4winmobile.com/forum/index.php ) I get:

Critical Error!
message_die() was called multiple times.
Error #1


Line : 60
File : /home/windows/public_html/forum/ctracker/classes/class_ct_database.php
SQL : SELECT * FROM phpbb_ctracker_config
Error #2
Could not add key announcement_date_display in config table

Line : 55
File : /home/windows/public_html/forum/includes/functions_mods_settings.php
SQL : INSERT INTO phpbb_config (config_name,config_value) VALUES('announcement_date_display','1')

Yetif I try to run the update .script all I get is:

Information

Database type :: mysql4
Previous phpBB version :: 2.0.22
Updated phpBB version :: 2.0.22
Previous IM version :: 1.4.0
Updated IM version :: 1.4.1
Updating phpBB database schema

Progress :: No updates required
Updating phpBB data

Progress :: No updates were required

Which takes about 3 seconds to run. So something is amis here, what is the exact procedure which should be followed? Obviously I can't log into the forum to run the update .script?

Help!

[Teelk]

This is exactly the same problem that florida4x4 had, it wasn't properly detecting version information or something.

But, I did provide an alternative upgrade for him. If you're 140 site is updated to phpBB 2.0.22 then you can go ahead and try it out. If your at say 2.0.21 or 2.0.20 you should be able to just run the db update .script from the update to 2.0.22 and then do the attached update.

Instructions are included.

[tekguru]

Hi Teelk, it is 2.0.22 so I'll grab this and give it a go tonight when I get in from work - fingers crossed! <img>

[tekguru]

Hi Teelk, I forgot I was on 'lates' this morning so had a chance to go through the alternative method this morning.

Followed the instructions in the Mod exactly. All went well apart from the SQL erroring reporting that:

#1050 - Table 'phpbb_cash' already exists

However on trying to run hierarchy_db_migrate.php (or the secondy update file) I now get:

phpBB : Critical Error

Could not get theme data for themes_id [19]

Which also of course occurs on any page I try to access.

Any ideas how we get around this one?

[Teelk]

The cash table already existing is probably because you had cashmod installed on your 140 board, so it shouldn't be an issue.

I'm still working out why the theme error keeps coming up.

[Helter]

since there are not 19 141 themes available, the problem has to be that either the 140 themes are still in the includes/def_themes file, the phpbb_themes table in the db, or the default theme in phpbb_config is set to 19
Check the second page of phpbb_config in your db for the "default_style"

[Teelk]

The sql in the update should have changed the default_style to 1, uninstalled all themes and then installed Integra2 as theme_id 1.

[ZacFields]

^ FYI, and i'm not 100% certain but I think that when I upgraded, it set the default template to 1, but my old 140 template was still installed... I think.

I do also vaguely remember that template 1 didn't exist either. You helped me fix that, but I don't think I was having the exact same problem.

Zac

[Teelk]

Try deleting everything in your cache folder but the index.html and the .htaccess file.

[tekguru]

since there are not 19 141 themes available, the problem has to be that either the 140 themes are still in the includes/def_themes file, the phpbb_themes table in the db, or the default theme in phpbb_config is set to 19
Check the second page of phpbb_config in your db for the "default_style"

The default theme was still set to 19. I reset it to 1 and at least I have some things loading so can now start to modify the theme to get my banners in my custom places.

Will post back as I discover more problems.

Cheers guys!

[ZacFields]

tek, there might still be problems after you reset your theme back to 1. If you go to your extreme styles and try to do anything with the theme, you might get that message back again.

Teelk, I think at this point he's right where I was when I kept getting that message. You sent me an SQL .script that fixed that, I wonder if that will work for him?

Zac

[tekguru]

Hi Zac, I can't even get that far easilly.

a) I'm running the test site in a /forum/ sub dir of the main site. Each time I log in I get redirected to the main site itself.

The main site is here:

http://www.4winmobile.com/portal.php

And the test site (with a seperate database) is

http://www.4winmobile.com/forum/portal.php

Now I know that somewhere there must be a setting to tell the new system to use the /forum/ directory fully, but as I can only get into ACP settings via SQLYog I'm at a loss to know what I need to alter.

b) The second problem is that even though the portal seems to be picking up news properly if I go into the forum I get shown only one forum - "Test Forum 1" - which is obviously completely wrong! No ideas where that date is coming from.

c) News base URL. Even though I have changed this to be http://www.4winmobile.com/forum/ the links on the portal as still not linking through to the sub forum.

c) Smileys - a lot of my smilies have now reset to the basics, how can I take these settings over from the main site?

d) The portal is displaying the name of the site as "4WinMobile - 6 Column!" is this intentional with the theme?

e) Getting back on the original thread I hope Teelk or some kind soul can finally resolve the theme 'Id' issue so I can start to sort out some of the above.

I know I'm hellishly glad I decided to test the upgrade before going with it on the live site!

[Dick Dynamite]

I need to keep an eye on this, because it might fix my problem, too.

[Helter]

do you have a separate db for your test site?
if so, use the "cookieMOD" from the dl section on your test site. If not you need to make a separate db and run the cookieMOD

[Dick Dynamite]

tek, there might still be problems after you reset your theme back to 1. If you go to your extreme styles and try to do anything with the theme, you might get that message back again.

Teelk, I think at this point he's right where I was when I kept getting that message. You sent me an SQL .script that fixed that, I wonder if that will work for him?

Zac

Could you please post it? What I've found to be the problem is that whenever you change your theme, it resets the "default_theme" to whatever number is was before.

[Teelk]

Run these queries...

Line number On/Off | Expand/Contract | Select all

UPDATE `phpbb_config` SET `config_value` = '1' WHERE `config_name` = 'default_style' LIMIT 1 ;UPDATE `phpbb_config` SET `config_value` = '1' WHERE `config_name` = 'override_user_style' LIMIT 1 ;TRUNCATE phpbb_themes;INSERT INTO `phpbb_themes` (`themes_id`, `template_name`, `style_name`, `head_stylesheet`, `body_background`, `body_bgcolor`, `body_text`, `body_link`, `body_vlink`, `body_alink`, `body_hlink`, `tr_color1`, `tr_color2`, `tr_color3`, `tr_class1`, `tr_class2`, `tr_class3`, `th_color1`, `th_color2`, `th_color3`, `th_class1`, `th_class2`, `th_class3`, `td_color1`, `td_color2`, `td_color3`, `td_class1`, `td_class2`, `td_class3`, `fontface1`, `fontface2`, `fontface3`, `fontsize1`, `fontsize2`, `fontsize3`, `fontcolor1`, `fontcolor2`, `fontcolor3`, `span_class1`, `span_class2`, `span_class3`, `img_size_poll`, `img_size_privmsg`) VALUES (1, 'Integra2', 'Integra2', 'Integra2.css', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 0, 0, 0, '', '006600', 'ff0000', '', '', '', 0, 0);

That should set default_theme to 1, set override_user_style to 1, empty your themes table and then install Integra2 as theme_id 1. Then when you get your forum back, delete the eXtreme Styles cache.

[Dick Dynamite]

Well, that fixes that. Now I need to get my forums back. Right now, all I have is "test forum 1"

[Teelk]

Is it resetting the default_style value when you try to switch themes still though?

If it does run the query again to get your style back to Integra2. Install another style and switch it to the default. Then uninstall Integra2 and reinstall it if you want it. That should take care of any further problems.

For the forums, have you tried deleting the includes/def_tree.php file, hit f5 on the forums to refresh, and then CHMOD the includes/def_tree.php file that is created to 666.

[Dick Dynamite]

Once I did all the other stuff, I resync'd the forums again, and it worked.

[tekguru]

It looks to me as if the SQL does work but the problem is I can't get into the Admin section. I can log into the forum but and logon the Admin link, but at that point the authorisation for PhpBB Security fires up and on entering the data I end back at the login prompt for the standard old system, that is the forum part of the path is lost.

If I add it in manually it makes no difference.

[tekguru]

Well after 4 atempts at 'hacking' various parts of the admin logon string I got in to the ACP.

Things noticed:

1) PhpBB Security is turned off and no values are shown for the number of allowed Mods and Admins. If I try and chage these nothing happens. I've double checked the CHMOD on includesphpbb_security.php and it makes no difference.

2) One bit of good news is that once I got into the ACP I could alter the .script path to get the redirection problem sorted out!

3) Resyncing has also made the forums viable again!

[ZacFields]

Tek,

To resolve where the .script is pointing to, go into your SQL through phpmyadmin, then look for the "site_config" table. Get in there.

Now you're going to want to change both your cookie_path and .script_path to /forum (I think that should be sufficient, you might have to try it with and without the slashes to see what works, my forum is not in a subdirectory so i'm not sure.

The cookie_path is like the 6th one down, but the .script one is on the next page, so you'll have to click on the > arrow to get to the 2nd page. If I knew how to write SQL queries I would just write one for you... would be a heck of a lot easier. lol.

Once you've gotten this far, let us know what problems you're running into, but I think the above fix should solve your pointing problem.

Zac

*EDIT* You're one step ahead of me I see <img>

[Leadfoot]

do you have a separate db for your test site?
if so, use the "cookieMOD" from the dl section on your test site. If not you need to make a separate db and run the cookieMOD

You will find that cracker tracker wont let the CookieMod run. Just rename your ctracker file to whatever and then run cookieMod. The change the ctracker file name back and you should be ok

[tekguru]

Cheers Zac, yeah getting there now, smilies sorted out, just got to work out why phpbb_security will not activate or save now <img>

Then I can start looking for real problems!

[Dick Dynamite]

Another issue I've gotten on one of my sites is:

Failed sending email :: PHP ::

DEBUG MODE

Line : 234
File : emailer.php

My Googlings seem ambigous. One is blaming it on the code, other is blaming it on the host. Both my sites run the same host [though http://www.dickdynamite.com is running from a better package than http://www.gamerrejects.com ], as well as the same IM file, so I'm lost.

[Teelk]

Cheers Zac, yeah getting there now, smilies sorted out, just got to work out why phpbb_security will not activate or save now <img>

Then I can start looking for real problems!

Did you overwrite your old includes/phpbb_security.php file? Since you used the alternative update method you need to do this.

Another issue I've gotten on one of my sites is:

Failed sending email :: PHP ::

DEBUG MODE

Line : 234
File : emailer.php

My Googlings seem ambigous. One is blaming it on the code, other is blaming it on the host. Both my sites run the same host [though http://www.dickdynamite.com is running from a better package than http://www.gamerrejects.com ], as well as the same IM file, so I'm lost.

It shouldn't be IM's fault, don't think emailer.php has changed any from a vanilla phpBB. Usually this is because the php mail function isn't set up correctly, but if one site works then I don't see how that's possible.

[Dick Dynamite]

I dunno. Try registering to both, and see what I see. I think it's the host, personally. Either that, or maybe CTracker is affecting something. I'm too tired to make another test account to see what's what, though.

Also, something I meant to ask before. [I'm still a newbie, but I'm learning]

1-How do I enable right-click for everyone?
2-How do I enable everyone to see each other's avatar/sig?[Sorry, a friend did them for me last time, and I wanna do them myself for this site.]
3-Is there a way to clear the shoutbox? I want to keep it, but erase all the shouts.

[tmotley]

1
ACP
General Admin
Configuration +
Profile Options
Administration
Allow user to copy and right click to Yes and override to Yes
Submit

2 for Avatar (I think this works.)
ACP
PCP
PCP Wizard
Alter Page Display
View Topic >> Left
user_avatar Display when to Display Always
Submit

2 for Signatures
ACP
General Admin
Configuration +
Profile Options
Profile Settings
Reading
Display signatures Yes (I wouldn't override user choice personally.)
Submit

3 partial Shoutbox 'fix'
ACP
General Admin
Configuration
Auto Prune Shouts set to 1 day (at least temporarily?)
Submit

[tmotley]

1) PhpBB Security is turned off and no values are shown for the number of allowed Mods and Admins. If I try and chage these nothing happens. I've double checked the CHMOD on includesphpbb_security.php and it makes no difference.

I had the problem with Phpbb Security not saving changes. http://integramod.com/forum/viewtopic.php?t=2670 includes this issue I think. On page 2, Teelk described a solution that worked for me.

Teelk also posted that information here... http://www.integramod.com/forum/viewtopic.php?t=2865

[CurlyDE]

For the forums, have you tried deleting the includes/def_tree.php file, hit f5 on the forums to refresh, and then CHMOD the includes/def_tree.php file that is created to 666.

I had the same problem and deleting the includes/dev_tree.php file now allows my forums to show up properly, but another file was not created. Did I read this post wrong or should another includes/def_tree.php file have been automagically created?

Thanks, Don

edit
Ignore my original message ... I copied the def_tree.php file back from the 141 zip file and resynced the forums. All is well now.

[tekguru]

Cheers guys will check out the security settings later!

[tekguru]

More problems I'm afradi at this end:

- refresh loop seems to be in effect whereby the page refreshes every 30 seconds or so. Even though meta refresh is turned off this still happens - causes havoc on mobile devices.
- Problem with LoFi Mod on Portal with the BBLite theme (comment text showing visible)
- General config - photo settings are not saved.
- Crackertracker blocking Meta+ tag saving / Welcome PM setting
- CAPTCHA Config - Not saving
- BBLite theme - view topic 'view next topic' image missing
- BBLite theme - view topic 'personal gallery' image missing
- No images in Crackertracker settings
- No images in Crackertracker footer

Any fixes guys, and is anyone else seeing these many problems? This will for me be q anightmare when I hav eot do it all again for real on the live system!

[tmotley]

- No images in Crackertracker settings
- No images in Crackertracker footer

Might be the same issue I notice here: http://www.integramod.com/forum/viewtopic.php?t=2863

- BBLite theme - view topic 'view next topic' image missing
- BBLite theme - view topic 'personal gallery' image missing

I used to used BBLite and there seemed to be so many missing images or 'DOWLOAD' instead of DOWNLOAD on an image that I made up a whole new set of buttons for everything. Are the images being defined by the theme and just not there or are they not being defined by the theme config at all?

[tekguru]

Cheers Tim (I think it is) the additions to theCFG file fixed that one and the theme downloaded did show as vesino (a) but as it was only downloaded at the weekend I thought it was up to date.

The missing images from BBLite appear to be there now which is weird, mind you I'm seeing occasional problems with the footer loadng too so something is adrift somewhere. I'm now considering changing theme but no ideas of what is as nice as BBLite.

[tekguru]

and another new one.... Is anyone else seing this:

If you navigate to an article using the 'comments' link on the portal then one loses the session ID and appears to be logged out once the new page has loaded.

[Teelk]

More problems I'm afradi at this end:

- refresh loop seems to be in effect whereby the page refreshes every 30 seconds or so. Even though meta refresh is turned off this still happens - causes havoc on mobile devices.
- Problem with LoFi Mod on Portal with the BBLite theme (comment text showing visible)
- General config - photo settings are not saved.
- Crackertracker blocking Meta+ tag saving / Welcome PM setting
- CAPTCHA Config - Not saving
- BBLite theme - view topic 'view next topic' image missing
- BBLite theme - view topic 'personal gallery' image missing
- No images in Crackertracker settings
- No images in Crackertracker footer

Any fixes guys, and is anyone else seeing these many problems? This will for me be q anightmare when I hav eot do it all again for real on the live system!

Make a new thread in the themes section for the BBlite issues, it'll be easier to give support since it won't be overlooked by the theme experts. I'm not sure but I think that the crackertrakcer images and footer missing has been fixed in the latest download. That could have been another theme however. It has to do with missing images in the .cfg file I think.

For CrackerTracker blocking things, use the debug mode as described in the KB.

If CAPTCHA isn't saving then you must be missing database information. Do the following...

Make sure the CAPTCHA table exists by trying to create it...

Line number On/Off | Expand/Contract | Select all

CREATE TABLE `phpbb_captcha_config` (   `config_name` varchar(255) NOT NULL default '',   `config_value` varchar(100) NOT NULL default '',   PRIMARY KEY  (`config_name`)) TYPE=MyISAM;

Fill the table with the following...

Line number On/Off | Expand/Contract | Select all

INSERT INTO `phpbb_captcha_config` VALUES ('width', '450');INSERT INTO `phpbb_captcha_config` VALUES ('height', '100');INSERT INTO `phpbb_captcha_config` VALUES ('exsample_code', 'SAMPLE');INSERT INTO `phpbb_captcha_config` VALUES ('background_color', '#E5ECF9');INSERT INTO `phpbb_captcha_config` VALUES ('jpeg', '1');INSERT INTO `phpbb_captcha_config` VALUES ('jpeg_quality', '90');INSERT INTO `phpbb_captcha_config` VALUES ('pre_letters', '0');INSERT INTO `phpbb_captcha_config` VALUES ('pre_letters_great', '1');INSERT INTO `phpbb_captcha_config` VALUES ('font', '1');INSERT INTO `phpbb_captcha_config` VALUES ('trans_letters', '0');INSERT INTO `phpbb_captcha_config` VALUES ('chess', '0');INSERT INTO `phpbb_captcha_config` VALUES ('ellipses', '1');INSERT INTO `phpbb_captcha_config` VALUES ('arcs', '1');INSERT INTO `phpbb_captcha_config` VALUES ('lines', '1');INSERT INTO `phpbb_captcha_config` VALUES ('image', '1');INSERT INTO `phpbb_captcha_config` VALUES ('bg_transition', '35');INSERT INTO `phpbb_captcha_config` VALUES ('gammacorrect', '0.8');INSERT INTO `phpbb_captcha_config` VALUES ('foreground_lattice_x', '15');INSERT INTO `phpbb_captcha_config` VALUES ('foreground_lattice_y', '15');INSERT INTO `phpbb_captcha_config` VALUES ('lattice_color', '#FFFFFF');INSERT INTO `phpbb_captcha_config` VALUES ('avc_version', '1.2.0');ALTER TABLE `phpbb_confirm` CHANGE `code` `code` CHAR(10) NOT NULL;

You might get a duplicate error message when inserting these, which means that some or all of the fields already exist. Most of the time the query should complete and fill any missing fields.

Photo info not saving is also probably missing fields. Try the following...

Line number On/Off | Expand/Contract | Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_local','0');INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_remote','0');INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_photo_upload','0');INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_filesize','102400');INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_max_width','800');INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_max_height','600');INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_path','images/photos');INSERT INTO phpbb_config (config_name, config_value) VALUES ('photo_gallery_path','images/photos/gallery');INSERT INTO phpbb_config (config_name, config_value) VALUES ('read_viewphoto','');

You might get a duplicate error message when inserting these, which means that some or all of the fields already exist. Most of the time the query should complete and fill any missing fields.

[tekguru]

Cheers again Teelk, the SQL above did the trick, and I'll check out the BBLite issues fully and then post a new thread when completely evaluated.

[Helter]

nice! that just cut your page load time to 1.5

[tekguru]

Yep - we're getting there!

So the remaining major upgrade issues I have remaining before I can go live are:

1) Fix problem with LoFi Mod on Portal - if I go LoFi I get the following at the top of the portal:

<!-- *************************************************************************** * layout6-lt12br.tpl * ------------------- * begin : Friday, March 11, 2005 * copyright : (C) 2004 Okki - Auke Douma * website : http://www.douma.ws * email : <a>okki@douma.ws</a> * * 6 block forum layout for IntegraMOD or IM Portal * *************************************************************************** *************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * *************************************************************************** -->

2) If one clicks on the commetn link on a news article the session ID is lost and it looks like the user has been logged out, however if one hits the back button on the browser and refreshes they are still logged in. If the user does not go back from the comment view then they contineu to be logged out. This does not happen on the IM site here so something must be different.

3) Page refresh, the site pages refresh every 30 seconds or so which prevents the site being visible using mobile devices. I know we had this issue with 1.40 originally and part of the code was deleted from the theme to fix it. However that data was onthe old integramod and I cna't find it here. I had thougt it was to do with the meta refresh tag but it seems it is no longer used so it can't be that. So I need a way of stopping that refresh.

4) Picky but annoying this one <img> The site when loaded into a brwoser shows the page title as (for example on the portal) "4WinMobile - 6 column!" that is it includes the page layout used - how can one take out the layout name?

[Teelk]

It grabs the page title from the name of the page. Rename the page in ACP>IM Portal>Page Management.

I'll check into the other issues.

[tekguru]

Thanks Teelk, page now renamed, if you can look into the other issues that would be great as I desperately want to go live on Sunday if I can..

[Teelk]

Comment issue is a cookie problem. Because of the way the news block is coded, append_sid doesn't carry over and the sid isn't included in the block links. However, if cookies are enabled on your browser, and the proper cookie settings are in your board config, you'll find that the problem of it logging you out will disappear. I suggest downloading the cookiemod in the downloads section and running it. If your site is local right now and your waiting for it to be complete before uploading it and going live, then I suggest waiting until your site is on it's permanent server before running the cookiemod.

I believe the fix for the refresh problem had to do with the meta+ mod, because the refresh tags are empty I believe the browser waits 0 seconds before refreshing, it's never affected me, however, it's just a guess. I would definitley consider this a bug and I'll note it in my todo list. In the meantime I suggest deleting the code form overall_header.tpl that generates the refresh meta tags.

OPEN includes/yourtheme/overall_header.tpl
FIND AND DELETE

Line number On/Off | Expand/Contract | Select all

{META_HTTP_EQUIV_TAGS}

The lo-fi problem was taken care of in another thread, correct?

[tekguru]

Thanks Teelk, duly noted. Will try that change to fix that one. understood abnout the portal and the SID so that is one less worry <img>

The Lo-Fi I'm still open on, I've looked for the fix since reading your post and have been unable to spot it - I must be missing something obvious - do you have a reference to it?

[tekguru]

Hi Teelk, well we went live earlier than expected as my host decided to copy the files over from test when asked if they could do it once I gave the go ahead.

The Portal/comments problems is indeed fixed, but the refresh issue looks like it is still there according to my readers - on the LoFi theme, so unless the meta data needs taking out of there as well somewhere?

Also have a problem with the stats as I get the below message showing up:

[flash=,:1byflxrt]http://www.4winmobile.com/news/notouch.png[/flash:1byflxrt]

If that can be fixed as well as the LoFi comment text so far I'm happy

[Teelk]

For the lofi refreshing do the following...

OPEN templates/yourtheme/lofi/lofi_header.tpl
FIND AND DELETE

Line number On/Off | Expand/Contract | Select all

{META_HTTP_EQUIV_TAGS}

OPEN templates/yourtheme/lofi/bots/lofi_bots_header.tpl
FIND AND DELETE

Line number On/Off | Expand/Contract | Select all

{META_HTTP_EQUIV_TAGS}

For the error messages on the stats page, is that only in lo-fi as well? You can check to see if the file templates/yourtheme/sub_templates.cfg is CHMOD'd properly, it should be 666.

[tekguru]

Cheers Teelk, the LoFi templates are now fixed, and it was the BBLite.CFG file that had been un-CHMODed when my host copied my updated files. So all working now for the users at least, now I've justgot to get th Ctracker fully sorted and I think I'm happy.

Cheers for the assistance so far mate, appreciated!

[Teelk]

No problem, there's a CrackerTracker patch coming soon that should clear up 90% of the false blocks.

[tekguru]

Thanks again Teelk, looking forward to those definiative fixes <img>