Icy Phoenix

Hello guys/gals.

I come from Integramod as an admin over there. I think it is safe to say, that project is DOA. I have a friend that has asked me if it is possible to port over his Integramod 1.4.1 phpBB2.0.23 to Icy Pheonix.

I have done a search and did find results. It is an old thread from 2009 with an old friend of mine in it DWho. Now ordinarily I would never have posted again about the same subject but due to the age of said subject, I was not sure if it was safe to say the same procedures still applied.

I will be right up front here. I have worked with phpBB 2.x for many years and still do but to this day, I have never ported anything over. Is this hard to do? I understand and have told him that he would loose his Full album pack, arcade and all other fancy mods as it would need to be a vanilla database to convert. And that is very easily understood why. When the man asked me, this is the first place that came to mind without putting a second thought to it. I have been lurking for years but never joined or posted. I like the system and think it would be his best plan of action at this point in time.

His board is not huge by any means. He has a tad over 1400 members and many categories and forums. it is not very lively right now since Facebook took hold so now is the time to convert if he is going to.

Thanks for taking a look at my post and sharing any info you may care to share. Have a great night! I look forward to hearing from you all soon.

Ray

Hi Ray,
First of all welcome here!

I have coded an upgrade procedure from vanilla phpbb 2.0.23 which should work fine: http://www.icyphoenix.com/docs/readme_english.html#upgrade_ip

Anyway, Full Album Pack is my "creature" (updated from original Smartor's Album) and it could be upgraded if you follow the procedure listed for Icy Phoenix 1.3... it may seem a bit complex, but with a bit of patience, you should succeed.

Should he need any support in converting I may help in the process.

Let me know.

Thanks for the welcome!

And I will go have a look at that link for the conversion. As far as the album pack goes, not sure I am going to need to do it or not to be honest. I'll discuss that with him further.

As far as I remember (I was a admin at IntegraMOD few years ago as well...) IntegraMOD didn't amend original DB structure of phpBB and its mod like Icy Phoenix does, so everything should work fine if you run the upgrade.

There also a cleanup tool to remove all unused files and db tables... but those should be tested on a backup first to make sure you won't miss anything important.

I never got that far in to things over there. I did do some minor work to IMPortal and released it at one point in time and did some very minor tweaking to Integramod. I never converted anything or packaged it up all together. Other than that, I mainly kept forums clean of spam and or problem children. Honestly what I DON"T know about all this stuff will fill a dictionary. I can install mods very easily and update databases to get said mods to work and that is about it. My means are very limited.

I'll have to check on the database tools if they can be found anywhere anymore and see if it is something I might be able to do. I have botched up more than 1 database in my time.

MWE_001 wrote: [View Post]

I'll have to check on the database tools if they can be found anywhere anymore and see if it is something I might be able to do. I have botched up more than 1 database in my time.

You will find everything within the install folder... install.php, database_update.php, clean_tables_ip.php, convert_utf8_nodbal.php...

Just remember that install.php is a multifunction file... after a setup you can relaunch it to display and run other maintenance features.

Oh ok well that's nice they are are all in one handy spot. lol I like that.

Ok I went ahead and gave this a shot, it was a no go. I am not so sure I did it right to be honest. Am I supposed to clean the old integramod database up first? If so, how? If I try to use the Integramod config file, I get errors on screen and upgrade will go no further.

I gave it an honest shot. I worked on it for 3 hours to no grounds gained at all. I am not sure what I am doing wrong.

As MG said, you don't really need to clean the database tables. It should work fine.

I think achaab wrote a script some time ago that cleaned the tables.

Make sure to backup your tables.

MG linked you to a procedure on how to proceed. I'm not sure which step went wrong for you, if you could explain it in a bit more details.

Or if you have an Integramod .zip that I could install to try for myself.

Hi Informpro. Hope all is well.

Well, what I did was scrub the database and reverted the Integramod back to a standard run of the mill phpBB 2.0.23 So as far as Integramod goes, it is out of the equation now. Now I am working with a vanilla phpBB.


So I went HERE.

1. I logged in as admin and immediately went and locked the board even though it is on a WAMP server and no one can log in anyhow,
2. I backed up my new scrubbed database TWICE one in each location for redundancy. Grabbed a copy of the fresh phpBB2.0.23 forum that works perfect with new scrubbed database.
3. (this is where things go wrong) The guide now tells me to go follow the upgrade instructions for 2.0.0.86
4. #8 says to remove those folders. I don't have them anyhow but ok. Removed.
5. #9 says to remove all old IP files, once again, I don't have any it is phpBB 2.0.23 board I'm upgrading?
6. #10 says to pay close attention to those particular files maybe especially the config.php
7. #11 is self explanatory. Even a dummy like me knows how to unpack said files
8. #12 Upload all IP files BUT config.php (so does that mean that my phpBB 2.0.23 config remains?
9. #13 permissions are a non deal here as it is localhost WAMP all files are writable at this point in time.
10. Run install/database_update.php Done and it worked! WOOT!
11. Delete or rename install folder.

Now number 11 throws me for a loop as their is a conflict of interest going on. If I go back to upgrading from a phpBB, it says to once again, run the install/install.php to run further utilities. At this point in time, things go real wrong.

When I attempt to run the install.php at my localhost site which is on my wamp server littleelm/install/install.php it refreshes and now I am at littleelm/install/install/install.php BUT the whole time at the top of the page it is telling me no config file is present. I left my phpBB2.0.23 config in place. Hmmm Ig I try to run it again, now I got to littleelm/install/install/install/install.php and over and over.


I know this is probably just a trivial end user problem but the instructions for a conversion are not so cut and dry. I believe it assumes one knows all there is to know about upgrading, downgrading and converting. Sometimes that is just not the case.


Now I know what I am about to link you to is VERY old, but the guy had the same exact issues I am having right down to the T including database issues. I can not go off of any of his procedures because it is so old but it gives me an idea that this is not just me. In one of his pictures he posts, it says his IP is up to date and then under the green box it has utilities he can run. I have never saw that a once. So he obviously made it a step further than what I did. Check This out.

I think I have covered step by step what I did or attempted to do. See anything in my post that I can try different? I don't know where I am going wrong.

At step 11, once the conversion is done, instead of going back to install/install.php, do this:

OPEN
FIND
REPLACE WITH

And tell me if it works.

Step 18 tells me to re run the install and when I do, All I get is a white page, nothing on it. If I try the fix you suggested, I still get nothing but a white page on running the install.php

Just for giggles, I renamed the install folder and navigated to forum.php and still a white page.

I don't understand why you're at step 18 of 11?

Good catch and I should have explained better. My apologies.

I went to the config.php as you had suggested and tried the edits and it did not work.

Just to be certain I did not miss anything, I started from scratch and attempted it all again. When it instructed me to run the install.php, all I got was the white page. I then altered the config.php as you suggested and once again I got a white screen.


I stopped right there and posted.

I am on a WAMP server localhost. Server specs are as follows:

Apache version: 2.4.9
php version: 5.5.12
mysql version: 5.6.17


I do have a fresh website uploaded with a clean database ready to try again located on a live server so someone can see it in action. it is located at http://littleelmforums.com/icy/index.php

If I want to help you, trying out with a fresh phpBB.0.23 and upgrading to IP is what I need to do, right?

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?