https://www.icyphoenix.com/viewtopic.php?f=2&t=9609
-----------------------------------
MWE_001
Sat 30 Jul, 2016 09:07

Integramod And Icy Phoenix Questions
-----------------------------------
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


-----------------------------------
Mighty Gorgon
Sat 30 Jul, 2016 23:01

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Hi Ray,
First of all welcome here! :mri:

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.


-----------------------------------
MWE_001
Sat 30 Jul, 2016 23:06

Re: Integramod And Icy Pheonix Questions
-----------------------------------
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.


-----------------------------------
Mighty Gorgon
Sat 30 Jul, 2016 23:13

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
MWE_001
Sun 31 Jul, 2016 04:00

Re: Integramod And Icy Pheonix Questions
-----------------------------------
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.   :oops:


-----------------------------------
Mighty Gorgon
Sun 31 Jul, 2016 11:25

Re: Integramod And Icy Phoenix Questions
-----------------------------------
[quote user="MWE_001" post="60603"]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.   :oops:[/quote]

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.


-----------------------------------
MWE_001
Sun 31 Jul, 2016 16:42

Re: Integramod And Icy Pheonix Questions
-----------------------------------
Oh ok well that's nice they are are all in one handy spot. lol I like that.


-----------------------------------
MWE_001
Mon 15 Aug, 2016 06:10

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Mon 15 Aug, 2016 11:34

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
MWE_001
Mon 15 Aug, 2016 20:26

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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 [url=http://www.icyphoenix.com/docs/readme_english.html#upgrade_phpbb]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  :mricy: 
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  [b]Done and it worked! WOOT![/b]
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 [url=http://www.icyphoenix.com/viewtopic.php?f=35&t=7678&start=0]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.


-----------------------------------
Informpro
Mon 15 Aug, 2016 20:54

Re: Integramod And Icy Phoenix Questions
-----------------------------------
At step 11, once the conversion is done, instead of going back to install/install.php, do this:

OPEN[code]config.php[/code]
FIND[code]define('PHPBB_INSTALLED', true);[/code]
REPLACE WITH[code]define('IP_INSTALLED', true);[/code]

And tell me if it works.


-----------------------------------
MWE_001
Mon 15 Aug, 2016 21:10

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Mon 15 Aug, 2016 22:05

Re: Integramod And Icy Phoenix Questions
-----------------------------------
I don't understand why you're at step 18 of 11?


-----------------------------------
MWE_001
Mon 15 Aug, 2016 22:13

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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


-----------------------------------
Informpro
Mon 15 Aug, 2016 22:28

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?


-----------------------------------
MWE_001
Mon 15 Aug, 2016 22:43

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Mon 15 Aug, 2016 22:55

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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 :).


-----------------------------------
MWE_001
Mon 15 Aug, 2016 22:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Tue 16 Aug, 2016 23:24

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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:
[list=1]
[*]Open your board locally (with everything backed up, yada yada yada)
[*]Save config.php somewhere (I named mine __config.php)
[*]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).
[*]Upload IP files in the same directory
[*]Delete IP's config.php
[*]Put back your config.php (rename __config.php to config.php)
[*]Visit install/database_upgrade.php
[*]"Please click Here to update!"
[*]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 :(
[*]Go to login_ip.php, and login with your administrator.
[*]You'll be redirected to a blank page, or see "Template->loadfile(): File ./templates/default/layout/ for handle body is empte"
[*]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.
[/list]


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...


-----------------------------------
MWE_001
Wed 17 Aug, 2016 14:50

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.  :lol: 

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.  :mrorange: 

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 

[color=red]so after editing config.php do I attempt to open install.php at this time? If so, this is what I get: [/color]

[code linenumbers=false]
[Icy Phoenix Debug] PHP Notice: in file /includes/sessions.php on line 1399: strpos(): Empty needle
Critical Error

Could not get theme data for themes_id [1]

DEBUG MODE

SQL Error : 1146 La table 'littleelm.ip_forums' n'existe pas

Line : 2596
File : functions.php 
[/code]

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.


-----------------------------------
Informpro
Wed 17 Aug, 2016 15:43

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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!

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


-----------------------------------
MWE_001
Wed 17 Aug, 2016 16:41

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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!  :mricy:

*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.


-----------------------------------
Informpro
Wed 17 Aug, 2016 16:46

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?


-----------------------------------
MWE_001
Wed 17 Aug, 2016 16:48

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Wed 17 Aug, 2016 16:49

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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[code]common[/code]
find[code]<?php
[/code]
after add (on a new line)[code]error_reporting(-1);[/code]

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


-----------------------------------
MWE_001
Wed 17 Aug, 2016 17:23

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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


-----------------------------------
Informpro
Wed 17 Aug, 2016 20:22

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?


-----------------------------------
MWE_001
Wed 17 Aug, 2016 20:26

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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, [code linenumbers=false]error_reporting(E_ALL);
ini_set('display_errors', 1);[/code]

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.


-----------------------------------
Informpro
Wed 17 Aug, 2016 21:10

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Okay, thanks. I'm still enjoying the end of summer, I'll try to take a look during the week! Thanks.


-----------------------------------
MWE_001
Wed 17 Aug, 2016 21:11

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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!  :mricy:


-----------------------------------
Informpro
Wed 17 Aug, 2016 21:16

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Right here. Thanks for your patience, sorry for the rough edges. People don't convert from 2.0.23 that often


-----------------------------------
MWE_001
Wed 17 Aug, 2016 21:20

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Sat 20 Aug, 2016 17:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
So, let's try this.

OPEN[code]install/install.php[/code]
FIND[code]//define('BYPASS_SESSION', true);[/code]
REPLACE WITH[code]define('BYPASS_SESSION', true);[/code]

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)


-----------------------------------
MWE_001
Sat 20 Aug, 2016 18:00

Re: Integramod And Icy Phoenix Questions
-----------------------------------
I'll give that a try here in a bit and let you know. Thanks for helping out.


-----------------------------------
Mighty Gorgon
Sat 20 Aug, 2016 22:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Sat 20 Aug, 2016 23:05

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Right, I could take a stab at this as well... You can censor the user's info, mostly the IDs are important


-----------------------------------
MWE_001
Sun 21 Aug, 2016 04:53

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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!


-----------------------------------
Informpro
Mon 22 Aug, 2016 22:31

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Did you try the snippet I gave you with install/install.php? It might help :).


-----------------------------------
MWE_001
Mon 22 Aug, 2016 22:34

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.  :mryellow:


-----------------------------------
Informpro
Tue 23 Aug, 2016 22:48

Re: Integramod And Icy Phoenix Questions
-----------------------------------
So, you managed to convert the DB? :D


-----------------------------------
MWE_001
Tue 23 Aug, 2016 22:55

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Tue 23 Aug, 2016 22:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Okay. You can give me a link; I'll try to do it by the end of the week / next week maybe.


-----------------------------------
MWE_001
Tue 23 Aug, 2016 23:10

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Wed 24 Aug, 2016 10:12

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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...

[code]INSERT INTO `phpbb_cms_layout` (`lid`, `name`, `template`, `global_blocks`, `config_vars`, `view`, `groups`) VALUES (1, '3 Columns', '3_column.tpl', 0, '', 0, '')
+++ Error: Unknown column 'config_vars' in 'field list'

INSERT INTO `phpbb_cms_layout` (`lid`, `name`, `template`, `global_blocks`, `config_vars`, `view`, `groups`) VALUES (2, '2 Columns', '2_column.tpl', 0, '', 0, '')
+++ Error: Unknown column 'config_vars' in 'field list'
...

INSERT INTO `phpbb_cms_layout_special` (`page_id`, `name`, `filename`, `global_blocks`, `config_vars`, `view`, `groups`) VALUES ('links', 'links', 'links.php', 0, '', 0, '')
+++ Error: Unknown column 'config_vars' in 'field list'[/code]


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


-----------------------------------
MWE_001
Wed 24 Aug, 2016 19:10

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
MWE_001
Fri 26 Aug, 2016 04:50

Re: Integramod And Icy Phoenix Questions
-----------------------------------
[quote user="Informpro" post="60820"]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.
[/quote]


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.  :oops:


-----------------------------------
Informpro
Fri 26 Aug, 2016 10:24

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Have you tried with the fix I provided? (manually opening phpmyadmin and fixing up the forum's parent)?


-----------------------------------
MWE_001
Fri 26 Aug, 2016 18:44

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.  :lol: 

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.


-----------------------------------
MWE_001
Fri 02 Sep, 2016 20:37

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?


-----------------------------------
Informpro
Sat 03 Sep, 2016 19:33

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?


-----------------------------------
MWE_001
Sat 03 Sep, 2016 20:50

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Oh yeah man it's all good. Major projects come first. This is just a hobby here.  :mryellow:


-----------------------------------
Informpro
Mon 05 Sep, 2016 23:45

Re: Integramod And Icy Phoenix Questions
-----------------------------------
[code]UPDATE phpbb_forums SET parent_id = 84 WHERE id = 13;[/code]

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


-----------------------------------
MWE_001
Mon 05 Sep, 2016 23:55

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.  :mricy:

**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) [color=red]DONE [/color]
    Save config.php somewhere (I named mine __config.php) [color=red]DONE [/color]
    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). [color=red]DONE [/color]
    Upload IP files in the same directory [color=red]DONE [/color]
    Delete IP's config.php [color=red]DONE [/color]
    Put back your config.php (rename __config.php to config.php) [color=red]DONE [/color]
    Visit install/database_upgrade.php [color=red]DONE [/color]
    "Please click Here to update!" [color=red]DONE [/color]
    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 [color=red]DONE [/color]
    [color=#ff5500]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? [/color]
     Go to login_ip.php, and login with your administrator. [color=red] DONE WITH ERRORS [/color]

     [code linenumbers=false]Critical Error

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

DEBUG MODE

Line : 2626
File : functions.php [/code]

[color=red]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. [/color]

    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.
[/quote]


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!
 [img]http://www.icyphoenix.com/files/images/11665/screenshot_25.jpg[/img] 


Here is the forum in action on the index  YAY! Notice I got posts?
 [img]http://www.icyphoenix.com/files/images/11665/screenshot_26.jpg[/img] 

Uh oh! No Threads! 
 [img]http://www.icyphoenix.com/files/images/11665/screenshot_27.jpg[/img] 

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.


-----------------------------------
MWE_001
Fri 09 Sep, 2016 19:22

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Sat 10 Sep, 2016 13:52

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
MWE_001
Sat 10 Sep, 2016 20:25

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.  :mricy: 

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.  :oops:  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.


-----------------------------------
Informpro
Sun 11 Sep, 2016 03:48

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Okay. Let me do this again. With you, pasting all the steps I do in realtime.

[list]
[*]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]//define('BYPASS_SESSION', true);[/code]
[*]replace with (L14)[code]define('BYPASS_SESSION', true);[/code]
[*]Run every converter, from bottom to top (the one that converts config.php for you should be the 2nd-from-bottom. [b]I think the bottom-most one doesn't work. It doesn't matter, we don't have old IP files[/b])
[*]Run this SQL query:[code]UPDATE phpbb_forums SET parent_id = 86 WHERE forum_id = 13; [/code](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. [b]PLEASE CHECK TOPICS ARE WORKING![/b] (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]if (defined('NEED_SID') && !defined('IN_LOGIN') && ($session_cookie_empty || $session_empty || !isset($_GET['sid']) || ((isset($_GET['sid']) && ($this->session_id !== $_G     ET['sid'])))))  [/code]
[*]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 ;-).)
[/list]

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!


-----------------------------------
MWE_001
Sun 11 Sep, 2016 05:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
Informpro
Sun 11 Sep, 2016 10:53

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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.


-----------------------------------
MWE_001
Sun 11 Sep, 2016 18:37

Re: Integramod And Icy Phoenix Questions
-----------------------------------
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?  :lol: 

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!  :mricy:


-----------------------------------
MWE_001
Mon 12 Sep, 2016 19:53

Re: SOLVED Integramod And Icy Phoenix Questions
-----------------------------------
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: 

[code linenumbers=false] Fatal error: Call to a member function generate_columns() on a non-object in C:\wamp\www\littleelm\viewtopic.php on line 656
Call Stack
#	Time	Memory	Function	Location
1	0.0180	772640	{main}( )	..\viewtopic.php:0[/code]

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**

[spoiler]I switched back to the cash plugin from the download on this site and it works just fine. I'm gonna leave it at that and let you guys have at it. I don't want to spoil the upgrade post by talking cash mod issues. I can go post a Thread on it though if you would like. I will explain in exact detail .[/spoiler]

[spoiler]Not sure if it was a freak of nature or cash mod clashing with something in the upgrade. I tried a brand new icy install .17 and used the cash plugin from git and not a single problem one. I'm calling this one a fluke. No bugs.[/spoiler]


-----------------------------------
Informpro
Mon 12 Sep, 2016 22:08

Re: SOLVED Integramod And Icy Phoenix Questions
-----------------------------------
Okay, noted. I'll try to look during the week, maybe wednesday.


-----------------------------------
MWE_001
Wed 14 Sep, 2016 23:48

Re: SOLVED Integramod And Icy Phoenix Questions
-----------------------------------
Sounds good.  :mricy:


-----------------------------------
Informpro
Thu 15 Sep, 2016 08:55

Re: Integramod And Icy Phoenix Questions
-----------------------------------
Actually -- would you mind opening a new topic? I think this one has lived long enough already (...and is already marked as solved).


-----------------------------------
MWE_001
Thu 15 Sep, 2016 08:58

Re: Integramod And Icy Phoenix Questions
-----------------------------------
My thoughts exactly man. Going to bed now. It's late. I'll open one for you in the morning. =}


