Icy Phoenix

Man I am so sorry Inform. Sometimes I hate text. It is hard for me to convey at times what I wish to say and I make things worse.

I have taken the old integramod site and downgraded it and the database to a phpBB2.0.23 That is what it is now.

Give me 5 minutes and It will be back up in working order.

Okay. If you successfully went down to a working 2.0.23 forum, I'll start from there and see if there are any outstanding issues :).

Thanks man. I promise that is where the project is at the way it sits right now. It is located at http://littleelmforums.com/icy/index.php


I have tried many ways and failed every time. Hopefully you can find where I went wrong. I even had my wife sit here with me and follow along the steps. No go.

I think I see what the problem is.

There are two issues:
- First off, the theme cache isn't cleared. So it keeps looking for phpBB2's subSilver.
- Secondly, the CMS is incorrectly set up, there are no pages created. You need to manually go to cms.php to create one.


So, we need to fix this. If you REALLY want to do it yourself in the meantime, do this:

1. Open your board locally (with everything backed up, yada yada yada)
   
2. Save config.php somewhere (I named mine __config.php)
   
3. Delete everything but that file (keep images/ and uploads/ I guess. At least you have them in your backup. The exact list of files is listed in the file you linked).
   
4. Upload IP files in the same directory
   
5. Delete IP's config.php
   
6. Put back your config.php (rename __config.php to config.php)
   
7. Visit install/database_upgrade.php
   
8. "Please click Here to update!"
   
9. Open config.php, replace "PHPBB_" with "IP_" manually. install/install.php has an action that does it, but... To open install/install.php, you need that done. Sorry
   
10. Go to login_ip.php, and login with your administrator.
    
11. You'll be redirected to a blank page, or see "Template->loadfile(): File ./templates/default/layout/ for handle body is empte"
    
12. In your URL, replace "index.php" with "cms.php" (it's important that you keep your SID)
    
13. Login again (needed to administrate the website)
    
14. Go to "CMS pages"
    
15. Click "Add new page"
    
16. Select whichever one you like (3 columns, 2 columns). Give it a name (like "index").
    
17. Submit.
    

Here! Your site now fully works. You don't get the nice default portal, though, but it's easy enough to set it up yourself :).
Obviously this is sub-optimal – I just wanted to give you "A Way". We'll have to rework this upgrade procedure, but at least you're not "stuck" if really needs be...

I really appreciate your taking the time to look in to this for me. I was going bonkers trying to get it figured out. I could have swore I was following all directions to the T.

I am going to take a quick stab at this and see how it goes. I just need to get some coffee and medicine in me first.

Thanks again chief. Much appreciated!

Ray

**EDIT**

Ok I gave it a try and this is where I am at and am stopping right here until I hear further.

Open config.php, replace "PHPBB_" with "IP_" manually. install/install.php has an action that does it, but... To open install/install.php, you need that done. Sorry

so after editing config.php do I attempt to open install.php at this time? If so, this is what I get:



If not and I move on to the next step which is to open the login.php file, it tells me it can not open login.php as no config file is found.

The table ' littleelm.ip_forums ' does not exist but it is in the database. I double checked.

oh my, I'm so sorry. I didn't mean that phpbb_, I meant the one in the line with

define('PHPBB_INSTALLED',...

^ change it there.

The other one mustn't be changed!

 

Off Topic

:

You needn't translate the french error messages, btw – french is my mother tongue

Ok now we are getting somewhere! Thanks!!

I now have a cms page ready to roll (have a home page) and now trying to create forums. If I click forum, it tells me This board has no forums. I'm sure it is going to be as simple as setting up the cms page. Can you see the grin on my face that is ear to ear right now?

I'll report back again. Thanks again!

*EDIT*

Ok, I don't have any forums at all. No categories no nothing. That is the very important part. lol I have to work on that. Everything else though is working 100% top notch thus far.

Huh, I'm surprised. It should have converted the forums :o.

It might be a permission issue, but I'd be surprised... Try to get into the administration, then forums > management.

Did it work all correctly when it was a phpBB2.0.23, though? From the link you've posted, it seems like it ...


When you ran the database_update script, did it show any error?

thats where I am at now. There is no forums set up at all. I have checked the DB and they are in fact intact categories and forums as well as all replies and threads.

I cleared tha cache in the cms just to be sure and everything turned white. I'm still logged in and have a SID but everything on screen is all white. I have lost the site. Was all good until cache clear.

Okay. Then I might have an idea... Could you please try to clear the cache once again?

go to

adm/erc.php

select "Clear cache"


edit: Okay hahaha. If clearing cache didn't work, do this.

open
find
after add (on a new line)

Refresh. You should see an error. Please post it here

Done. And still have a all white screen. Sorry so slow on reply man. Had someone come by real quick. Back to business now.

*EDIT* Just saw that edit you needed me to do. Did it and still white screen after refresh. No error is printing on screen

Okay... It's a bit hard to debug-at-a-distance... Maybe you have a php / apache error log in your server that'd have more informations?

I might be able to set something in my php.ini that will parse errors for me. Never thought of that as I am not really a server guy. let me take a quick look see and I'll report back.

On a side note, Ironically enough, the browser tab still tells me what page I am on and shows the favicon.

I'll be right back here in a short with an answer of some type.

*EDIT*

Ok I turned error reporting on, on the server via pph.ini and included this,

And still a no go. I'm not seeing anything in my server error logs. I'll admit, I have no clue what I am looking for.

Okay, thanks. I'm still enjoying the end of summer, I'll try to take a look during the week! Thanks.

Hey no probs at all chief. I really appreciate all you have done thus far. Enjoy your self and we'll work on it later. I'm in no hurry. Have a pint for me bud!

Right here. Thanks for your patience, sorry for the rough edges. People don't convert from 2.0.23 that often

No apologies needed man. I know phpBB2.0.23 was dead long ago. The board I am attempting to upgrade should have been done long ago back when the action was still hot. Me and my buddy might be one of the rare ones left running a 2.0.23.

I am building from scratch for my self so no upgrade needed on my site. I like IP the way it is and am itching to get something going as it is out of the box. I am enjoying the system. I just hope I am not a big PITA lol. I am enjoying fixing up things here and there on the plugins. I love to help contribute when able.

So, let's try this.

OPEN
FIND
REPLACE WITH

Now you should be able to visit install/install.php ...

There, run every fix available, from bottom to top.

Warning: the functions that fix posts will probably take some time. The conversion procedure will ask you how many posts you want to process at a time... You'll probably want to increase that number (I think it's usually 100 posts by default).

Don't increase it too much, though, or you might exceed PHP's time limit (30s by default, though IP tries to increase it if the server allows it)

I'll give that a try here in a bit and let you know. Thanks for helping out.

If you are willing to share with me a copy of your DB in Integramod, I will try the conversion and address you to the procedure.

Right, I could take a stab at this as well... You can censor the user's info, mostly the IDs are important

Ok fellas. I appreciate the offers on that. let me get with my friend who owns the site and talk it over with him. I know I can trust you guys, but I just can't hand over 1400+ users info as you can easily understand I am sure.

let me get back to you on this ASAP.

Thanks guys!

Did you try the snippet I gave you with install/install.php? It might help :).

I have not. I do plan on doing that tonight. I have been sidetracked pretty much the last couple days. I was really waiting for the guy to get back to me about me sharing the database with you 2 guys for testing. I guess he is still pondering it as I have not heard a reply yet.

I'll give it a try here in a bit and report back to you.

Thanks man!


**EDIT**

Ok I gave this a try today. I noticed a couple things.

1. I think there are some settings on my WAMP server (localhost) that is wrong. White pages galore.
2. Un commenting that in the install.php did in fact work.
3. It was for not due to my WAMP server.

I do have a 100% working phpBB board on a live server with the populated database ready to go. I am going to try it there and see if I can get any different result. My WAMP works good but I am not a server person and do not know how to set them up properly so I am sure it is weird settings wise.

I did get the go ahead on that database too so if one of you fellas want to give it a try. let me know and I'll get you a good download link to the database since I obviously can't post it public.

So, you managed to convert the DB?

No, I never got it done. I am trying but failing miserably. I can not get upgraded to icy no matter what I try.

When I mentioned the database, I was saying that I talked to my buddy and he said ti is ok to share the Database with you or luca to try and convert the site over if you want to try. If not, it's no big deal. I'll keep trying.

Okay. You can give me a link; I'll try to do it by the end of the week / next week maybe.

Ill get the db zipped up and get a link to you as soon as possible. I got some things to do right now but will be back on the pc later on and will get it to you.

MWE, I'm happy to report it works locally! I'm not exactly sure what happens, but it might be you didn't set subforums as normal forum before the conversion. So what happened was that the forum id=13 got a wrong parent. I updated manually (in the DB) its parent to 84 (which is the ID of your first category in my db) and it works now.


MG: All the CMS query seem bogus...




We should also probably change the drop table to "drop table if exists" (so that we get less errors)

DOH!! I forgot about sub forums. This is why I NEVER mess with anything sql related. I always farm that out to someone else. I am in no way shape or form a sql person. Never have been.

Informpro wrote: [View Post]

MWE, I'm happy to report it works locally! I'm not exactly sure what happens, but it might be you didn't set subforums as normal forum before the conversion. So what happened was that the forum id=13 got a wrong parent. I updated manually (in the DB) its parent to 84 (which is the ID of your first category in my db) and it works now.

Well to be honest, I only ever got to the point of having a working cms one time before all the pages turned white one me after I cleared the CMS cache. After that no matter what I tried, I could not get anything to work no matter what route I took. I am willing to say i had bad cookie settings and site path and all that.

The guy who owns the site is traveling for work right now so I still have a little time to mess with it. This favor is one that finally turned out to stump me. lol None of his website needs have ever stumped me ever before.

Have you tried with the fix I provided? (manually opening phpmyadmin and fixing up the forum's parent)?

I'm going to try it today. Not quite sure I know how but I'll take a look at it. SQL is not my thing. I think I got real lucky scrubbing the database even without farking it up.

On a side note, I was able to get the site upgraded to phpBB3 with Kiss Portal. It is real nice and easy to upgrade, but not quite sure it is what we want for his site. I will still keep trying here with icy. I enjoy using it much better than I do the other combo.

Yeah I'm going to have to say uncle (means I Give in the states). I am HORRIBLE with Sql work. I was doing this for him for free as a favor to help him out beings how he is a good friend of mine. Not sure I can tie any more time up in it. I just can't figure it out. I am not sure what or how to make subforums regular forums and all that. I keep farking the database up.

Glad to hear it worked on your end. No white pages no nothing?

I've been really busy this week, finishing up a 3-months project for friday (yesterday).

I'll try to craft a SQL query you'll be able to run. Would that be okay?

Oh yeah man it's all good. Major projects come first. This is just a hobby here.

Please try this SQL query after the conversion, just before clearing cache.

I'll give her a go bud and see what happens. I have tried several other times since then and I cant even get back to the point of having a basci CMS anymore. Not sure what is wrong.

I'll take another shot at it tonight. I really appreciate the help.

**EDIT**

Ok guys, here goes.

So apparently after ALL these years of building websites and uploading them to servers and getting them working, I suddenly do NOT know how to set a path properly.

The site I am attempting to upgrade resides at http://lixxxxxxlmforums.com/icy

I go to load the site by visiting http://lixxxxxxxforums.com/icy/install/database_upgrade.php (added x's for security) and it loads the original site located at http://lixxxxxxxmforums.com with no style at all. page is wacked.

So now I go to http://litxxxxmforums.com/icy/adm/erc.php and click reset path. here is what it suggests.

No http

Domain: litxxxxxforums.com (once again x's for obvious reasons)

Port : 80

Path: /icy/adm


This does not work. it goes back to the original old site. I would have to guess it is from the domain being wrong. I have reset it every which way but loose and It resorts back to the old site minus the style every single time.

I thought I knew what I was doing. This simple upgrade has made me feel like a moron. Literally.

**EDIT AGAIN**

Ok Progress. I got to the icy phoenix update script page instead of the old website loading. Had to have been a cookie issue. I am now making double sure all files are chmod properly. (please pardon me keeping notes, I just want to be sure I document everything I have done).

Ok all files are CHMOD properly.

Here is a list and I will check each one off

Quote:

So, we need to fix this. If you REALLY want to do it yourself in the meantime, do this:

Open your board locally (with everything backed up, yada yada yada) DONE
Save config.php somewhere (I named mine __config.php) DONE
Delete everything but that file (keep images/ and uploads/ I guess. At least you have them in your backup. The exact list of files is listed in the file you linked). DONE
Upload IP files in the same directory DONE
Delete IP's config.php DONE
Put back your config.php (rename __config.php to config.php) DONE
Visit install/database_upgrade.php DONE
"Please click Here to update!" DONE
Open config.php, replace "PHPBB_" with "IP_" manually. install/install.php has an action that does it, but... To open install/install.php, you need that done. Sorry DONE
This is where things go wrong. Install.php will not open unless I un-comment the bypass session. Went in there and no option to install or anything. Just a bunch of upgrade stuff and fix this and thats. Nothing to fix yet I am guessing?
Go to login_ip.php, and login with your administrator. DONE WITH ERRORS

Code: [Hide] [Select]

Code: [Show]

Critical Error

Could not open ./templates/subSilver/subSilver.cfg

DEBUG MODE

Line : 2626
File : functions.php

And this is where I get stuck fellas. I cn not go any further. As the details below say to preserve sid, well I never even get to that point. Only the error above with no sid. I never get to login.

You'll be redirected to a blank page, or see "Template->loadfile(): File ./templates/default/layout/ for handle body is empty."
In your URL, replace "index.php" with "cms.php" (it's important that you keep your SID)
Login again (needed to administrate the website)
Go to "CMS pages"
Click "Add new page"
Select whichever one you like (3 columns, 2 columns). Give it a name (like "index").
Submit.

Ok Boys and Ghouls, it has been a LONG day. After much cursing, many pots of coffee, and many fists hitting the desk in rage, I got a website running. Here are a few shots.

Here is my ACP, notice I now have forums YAY!



Here is the forum in action on the index YAY! Notice I got posts?


Uh oh! No Threads!


All posts and data is populated in the database, checked and rechecked and even ran utilities in the install/install.php to fix posts and sigs and all. No matter what I try, this is where I am stuck, BUT..... Yeah there is a but, I am SO happy to be at this point! I am far ahead of where I was this morning.

I had to populate my ranks by manual process as well and my groups are in the database and group descriptions, but no members of the groups were added. I have tried several times to get groups updated and no such luck.


Can anyone point me in the right direction to fix these few items? So far I have not found any other issues as I have been working on only these three issues and fixed one of the 3.

So I got digging in the database today and I found ip_topics. I am curious if this is where my problem is for the forums not showing any text as this table is completely empty. If so, What do I need to do to insert the data I need?

In the mean time, I will keep digging and try to get it to work.

Whoops. Sounds like there were some issues indeed. Did you run the topics conversion? Also, why ip_topics? Wasn't your table named phpbb_topics? I can confirm my local working copy has the topics, so I know it's very fixable at least.

Well kinds funny story here actually.

I went on a cussing rant a couple days ago and my wife said Ray, you have been trying for over a month now and apparently you are going to have to figure this out on your own so just shut up and do it.

So I installed a fresh IP install and started converting the database table by table manually. It's the only thing I can do. I had to try something.

I know you have a major project going on, mort is out of the game now days and Luca is very busy. So when a guy has to help him self, he has to do what he can do. and I am to the point of where I can get, once again, without help.

As far as converting goes, not gonna happen for me. I can not get a working CMS again. I have tried and tried. All I get is pure white pages. Now, when I get lucky enough on that rare instance where the update script will run for me, it says within one second that it is complete to click here and all the stats say it is up to date. When I look at the database, nothing has been done.

So in either situation, really, I loose. It's pretty much game over. All I can do is what I can do. If it's not gonna work for me, then it's not gonna work. And trust me when I say I have followed every step to a T. My wife has even sat down and tried it MULTIPLE times. She has been with me since phpBB 1.x days She knows her way around a forum / cms really well. She couldn't even get it to work. Server settings maybe?


I'm at a loss man. I just don't know what to do. A month is way to long to try to get something to work, but unlike the average user, I have been willing to put in the work. Most users are just lazy and expect you to do it for them the minute they try and fail. One should never be willing to help anyone who is not willing to help them selves. I would pay someone but I just can't. For one, I'm broke as hell and for 2, .... nah we'll leave # 2 alone for now. I can easily say I have installed over 400-500 working copies of Integra for folks and never charged a once. lol I got donated a couple times but never charged. what really is a 15 minute job worth? A beer? A sandwich? Surely not 40 or $50 like some guys like to charge.

Take care man and have a great day. If I figure anything else out, I'll report back but for now, it's not looking to good........ once again.


P.S. on a side note, I have built my self a network of 2 sites using Icy and I have to say they are pretty bad @ss. I love the system. So far so good. I just wish we could bring more people back in to get some community going again.

Okay. Let me do this again. With you, pasting all the steps I do in realtime.

• Install phpBB2.0.23 and setup your database.
  
• Check topics work (they do! yay.)
  
• Log in as administrator. Since it redirected me to littleelm.com, I changed it in the URL (my browser's address bar)
  
• Click on the admin panel. Also redirected me when I logged in... I just fixed the URL manually.
  
• Fix the URL for the last time (after you've connected to the ACP)
  
• General Admin > Configuration
  
• Domain name => Probably localhost
  
• Server port the ":xxx" part... IF YOU HAVE ONE. My URL is "localhost:8888", so I input 8888. 80 is the default if you don't see one.
  
• Script path => depending on your server. My URL for the forum is "http://localhost/ipconvert/", so I put ipconvert/ there
  
• Cookie domain => Your domain with a leading dot. if your domain is "localhost", then input ".localhost"
  
• Cookie path => same as script path
  
• Save the configuration ! Check that you can log out / log back in without needing to fix the URL in your browser's address bar yourself :-).
  
• Save config.php to __bak_config.php
  
• Delete everything but this file.
  
• Upload Icy files
  
• Delete the just-uploaded config.php
  
• Rename your __bak_config.php to config.php (its old name)
  
• Visit install/database_update.php
  
• "Click *here* to upgrade"
  
• ... Wait for a bit, until "Update completed!" is displayed!
  
• Clear cache (I used the adm/erc.php file for that. You can also delete every single .php file in the cache/ directory, manually. Make sure to keep the folders..)
  
• Open install/install.php
  
• find (L14)
  Code: [Hide]

  Code: [Show]

  1. //define('BYPASS_SESSION', true); 
  
  
• replace with (L14)
  Code: [Hide]

  Code: [Show]

  1. define('BYPASS_SESSION', true); 
  
  
• Run every converter, from bottom to top (the one that converts config.php for you should be the 2nd-from-bottom. I think the bottom-most one doesn't work. It doesn't matter, we don't have old IP files)
  
• Run this SQL query:
  Code: [Hide]

  Code: [Show]

  1. UPDATE phpbb_forums SET parent_id = 86 WHERE forum_id = 13;  
  (The one I gave you previously had a bug. Sorry, didn't test thoroughly enough...)
  
• For now, index.php will be empty. But forum.php should work. PLEASE CHECK TOPICS ARE WORKING! (they work for me
  
• Lastly, we need to fix index.php.. Let's go!
  
• For some reason I don't quite understand, the SID is broken at this point... Let's fix it...
  
• OPEN includes/sessions.php
  
• FIND (line 91)
  Code: [Hide]

  Code: [Show]

  1. if (defined('NEED_SID') && !defined('IN_LOGIN') && ($session_cookie_empty || $session_empty || !isset($_GET['sid']) || ((isset($_GET['sid']) && ($this->session_id !== $_G ET['sid'])))))  
  
  
• IN LINE BEFORE, ADD (add it right before the if. Not on the line before)[code]if (false)//[/cpde]
  
• Log in. You can visit login_ip.php directly, or click "log in" from forum.php
  
• You'll get redirected to the forum.php, with "?sid=..." in the address bar (URL). Only change "forum" by "cms", so that you have "/cms.php?&sid=blablabla...."
  
• You'll be prompted to login again. Do so.
  
• You're now on the CMS page. Click CMS pages
  
• Click "Add new page"
  
• Select whichever layout you want. Enter whichever name you want. Submit.
  
• Visit index.php! Your website is now fully functional (the topics still work here ;-).)
  

It might seem like a lot of steps, but I heavily broke it down.

@MG might be able to help us with the SID thing...

Cheers!

I really do appreciate the help man. I will follow the instructions line for line. If I have any issues, I will record the process so you guys can see exactly what is going on. I fear a large file though which is ok. Ill load it on youtube again if needs be. Going to have my wife sit in as well since she knows her way around a forum / cms as good if not better than I do.

I will tackle this hopefully in the morning when I am clear minded. I have had my meds tonight for my back and am going downhill quickly.

If there's still some kind of issue left, I'll just be sending you a dump of the database. Would be easier.

I repeated the process another time to confirm it worked when I did it. I think I took around 10mins. But it was 4am localtime, so there might be a few typos. I'll try when I get home later today.

yeah if there is any issues after those detailed instructions you gave, it has to be server settings. I've had white pages galore on my localhost as well as a regular server that is a datacenter.


But at any rate, I am going to take a stab at this here in about 15 minutes or so. I'm just cleaning up my hosting package right now and then going to give it a try there first.


**EDIT**

Ok man here goes.

It is with great happiness that I am here to tell you that it all worked! The site is up and running and everything is good and right where it should be as far as I can tell. I do have to re-position the sub-forums and a couple others but that is a drop in the bucket compared to what I have went through thus far lol

I sincerely appreciate the help man. I owe you in one fashion or the other. Not sure what or how, but I do owe you big time man. My wife is smiling ear to ear now as she don't have to listen to me nag about the server not working lol. It's always the servers fault right?

I hope if anyone joins in the future they find this thread and skip right to the last page here and follow the instructions. I think the how to doc is nicely patterned but it does no justice for upgrading from Integra and I can see why. How many refugees are there really?

I am going to go ahead and say we can mark this one solved!

Hey Informpro,


**EDIT**

Never mind. I will come back and let you know what I was going to say . i got an issue suddenly I'm not sure how to fix. I'll try my best on my own first. All my forums are gone. I can go to view forum and all topics are there, but if I choose a topic, I get the old This post does not exist error. This happened suddenly. I can't recreate it because I am not sure what I did. All I been doing since I verified the forums worked was adding all my cms pages and parent blocks. literally that is all.

**EDIT**

Cash Plugin off of Git was installed. Icy version I used was the one off of Git as well. When I disable the cash plugin I get my forums back and in working order. If I reenable the cash plugin again I get this:



If I go back in to the plugin it self on the config page and disable the plugin, I get the same error. The only way to stop the error and get the forums back is to go in to the plugins panel and disable it all together.

So I have verified this is NOT related to the upgrade to icy from phpBB.

Just to be sure I gave the exact info correctly the plugin cash came from Git. The version of Icy I am using is 2.2.2.107

**EDIT**

Okay, noted. I'll try to look during the week, maybe wednesday.

Sounds good.

Actually -- would you mind opening a new topic? I think this one has lived long enough already (...and is already marked as solved).

My thoughts exactly man. Going to bed now. It's late. I'll open one for you in the morning. =}