Icy Phoenix

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

So, you managed to convert the DB? :D

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.