Welcome Guest ( Log In | Register )

UploadScript

Check out the FREE chatroom mod for IPB 3.x

> IPB Help

IMPORTANT DISCLAIMER - PLEASE READ

You are currently in an unofficial IPB help forum where members assist other members with Invision Power Board. While you may receive help with your Invision Power Board questions in this forum it is important to note the following:

Note: Let us state again that support provided in IPB Help is provided by the kindness of others. The staff of Invisionize do not officially provide support for Invision Power Board. If you would like official support from Invision Power Services, please open a new support ticket from your Invision Power Services Customer Area page.

2 Pages V   1 2 >  
Reply to this topicStart new topic
Ipb 1.2/1.3 On Php5/mysql4.1
FuSoYa
post Apr 23 2005, 09:20 AM
Post #1


IZE's lightning rod of hate
*******

Group: Members
Posts: 13,986
Joined: 5-September 03
Member No.: 40,573
IPB Version: 2.3.x



IPB 1.2 and 1.3 are still used by a lot of folks because they are still free. But the problem is, the coding for them isn't 100% compatible with the latest versions of PHP and MySQL, and a lot of web hosts are moving to these versions. This article is a collection of all of the changes you need to make to your files to make IPB 1.2 or 1.3 work with PHP5 & MySQL 4.1.

Symptoms of this problem
  • Blank 'My Controls' page
  • Blank 'Profile' page
  • MySQL errors when reporting post
  • MySQL errors on 'The Moderating Team' page
Files affected
  • sources/Profile.php
  • sources/Usercp.php
  • sources/misc/contact_member.php
  • sources/misc/stats.php
Step 1
Open sources/Profile.php
Find:
CODE
   var $parser;

Change To:
CODE
   //var $parser;

Save and upload sources/Profile.php

Step 2
Open sources/Usercp.php
Find:
CODE
   var $parser;

Change To:
CODE
   //var $parser;

Save and upload sources/Usercp.php

Step 3
Open sources/misc/contact_member.php
Find:
CODE
   var $email     = "";
   var $forum     = "";
   var $email     = "";

Change To:
CODE
   //var $email     = "";
   var $forum     = "";
   var $email     = "";

Find:
CODE
 $DB->query("SELECT m.name, m.email, mod.member_id FROM ibf_moderators mod, ibf_members m WHERE mod.forum_id='$fid' and mod.member_id=m.id");

Change To:
CODE
 $DB->query("SELECT m.name, m.email, moder.member_id FROM ibf_moderators moder, ibf_members m WHERE moder.forum_id='$fid' and moder.member_id=m.id");

Save and upload sources/misc/contact_member.php

Step 4
Open sources/misc/stats.php
Find:
CODE
 //--------------------------------------------
    // Do we have any moderators? NORMAL MODS 1st
    //--------------------------------------------
   
    $DB->query("SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
                       f.id as forum_id, f.read_perms, f.name as forum_name, c.state
                FROM ibf_moderators mod
                  LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
                  LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
                  LEFT JOIN ibf_members m2 ON (mod.member_id=m2.id)
                ");

Change To:
CODE
 //--------------------------------------------
    // Do we have any moderators? NORMAL MODS 1st
    //--------------------------------------------
   
    $DB->query("SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
                       f.id as forum_id, f.read_perms, f.name as forum_name, c.state
                FROM ibf_moderators moder
                  LEFT JOIN ibf_forums f ON(f.id=moder.forum_id)
                  LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
                  LEFT JOIN ibf_members m2 ON (moder.member_id=m2.id)
                ");

Find: (this edit doesn't show up in 1.2, so if that's your version then you should be able to skip this step)
CODE
    //--------------------------------------------
    // Do we have any moderators? GROUP MODS 1st
    //--------------------------------------------
   
    $DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number,
                       f.id as forum_id, f.read_perms, f.name as forum_name, c.state
                FROM ibf_moderators mod
                  LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
                  LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
                  LEFT JOIN ibf_members m ON ((mod.is_group=1 and mod.group_id=m.mgroup))
                ");

Change To:
CODE
    //--------------------------------------------
    // Do we have any moderators? GROUP MODS 1st
    //--------------------------------------------
   
    $DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number,
                       f.id as forum_id, f.read_perms, f.name as forum_name, c.state
                FROM ibf_moderators moder
                  LEFT JOIN ibf_forums f ON(f.id=moder.forum_id)
                  LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
                  LEFT JOIN ibf_members m ON ((moder.is_group=1 and moder.group_id=m.mgroup))
                ");

Save and upload sources/misc/stats.php
Go to the top of the page
 
+Quote Post
Humbe
post Feb 16 2007, 12:27 AM
Post #2


Newbie
*

Group: Members
Posts: 25
Joined: 29-August 05
Member No.: 172,971
IPB Version: 2.0.x



Awesome dude,

I had this problem until now, thanks god you are here to help us...

All problems solved.

God Bless You.
Go to the top of the page
 
+Quote Post
Mutilated1
post Feb 16 2007, 04:19 PM
Post #3


Death Walking Terror
******

Group: Members
Posts: 5,505
Joined: 24-February 04
From: Behind You With An Axe!
Member No.: 86,630
IPB Version: 1.2.x



Once again Fusoya saves the day. He should get an award for this topic.


--------------------
My Favorite Cannibal Corpse Website | Discuss Marketing, Search Engines, Programming, and Good Site Practices
Its easy to get a link to your site from me - ask me how!
QUOTE(Seyeko @ Mar 7 2007, 08:38 AM) [snapback]1791116[/snapback]
Who gives a crap really. its a darn Os and no one uses it but you and a few other people, its kinda like your forum.
Go to the top of the page
 
+Quote Post
@lien
post Feb 23 2007, 09:45 AM
Post #4


Newbie
*

Group: Members
Posts: 2
Joined: 23-February 07
Member No.: 272,609
IPB Version: 1.3.x



Thank you!!! I was really interested in solving of this problems!
Go to the top of the page
 
+Quote Post
a2td
post Mar 15 2007, 10:39 PM
Post #5


Newbie
*

Group: Members
Posts: 27
Joined: 25-September 04
Member No.: 126,305
IPB Version: 1.3.x



Thank you so much, been waiting for this for 4months lol. Thanks!
Go to the top of the page
 
+Quote Post
Hidetora
post Jul 27 2007, 12:29 PM
Post #6


Newbie
*

Group: Members
Posts: 1
Joined: 2-April 06
Member No.: 213,940
IPB Version: Not Applicable



Gr8! Thx 4 mods!
Go to the top of the page
 
+Quote Post
NiCk445
post Sep 9 2007, 02:18 PM
Post #7


Advanced Member
***

Group: Members
Posts: 344
Joined: 30-December 06
From: seattle washington
Member No.: 263,404
IPB Version: 1.3.x



thx bro <33333333
Go to the top of the page
 
+Quote Post
intelliot
post Sep 10 2007, 11:46 PM
Post #8


Newbie
*

Group: Members
Posts: 1
Joined: 10-June 04
Member No.: 113,763
IPB Version: 1.3.x



Thanks smile2.gif
Go to the top of the page
 
+Quote Post
pwais
post Sep 14 2007, 11:48 PM
Post #9


Newbie
*

Group: Members
Posts: 1
Joined: 14-September 07
Member No.: 301,976
IPB Version: 1.2.x



dear ipb 1.2.x wizards,

Thanks for the patches!! I was wondering if anybody else may have some other migration tips, though...

I'm having some trouble running ipb 1.2 on php 5.0.4 and mysql 4.1.20. Specifically, I can't log in. Not as me, not as anybody else... I type in my login info, hit enter, and then I just get the default forum page, as if I never typed anything at all. None of the links on the main page work either... it's almost as if POST and GET variables aren't being passed at all. I used to run on a PHP 4 box, and I think I'm just forgetting something about the changes between PHP4 and PHP5... does anybody have any ideas? I've tried turning safe mode off, (and I'm trying to get error logs working but I've yet to wrestle any further info out of Plesk). I've also tried setting everything on the board to chmod 777, or at least giving execute privs to all files... with no luck sad.gif

Sorry to bother everybody with what is probably such a N00b question! I love ibp and if I can get this working it would make a lot of people very happy...

Thanks forum!
-Paul
Go to the top of the page
 
+Quote Post
Jadenv4
post Oct 6 2007, 06:22 AM
Post #10


Newbie
*

Group: Members
Posts: 2
Joined: 6-October 07
Member No.: 304,797
IPB Version: Not Applicable



Great, but theres one prob.... I cant get into my admin cp... it says when i try log in:

Your current IP address does not match the one in our records

And when i actually DO log in, the page is blank....
Go to the top of the page
 
+Quote Post
Buffalo
post Oct 16 2007, 02:25 PM
Post #11


Newbie
*

Group: Members
Posts: 6
Joined: 11-October 04
Member No.: 128,330
IPB Version: 1.3.x



Good stuff.

I've been looking for a simple way, and i've found it.

Most hosts will run php4 & php5

The cure,

Add this line in the htaccess file in public_html

AddHandler application/x-httpd-php4 .php

that's it,

very simple, works 100%

All best from Barry Buffalo

Go to the top of the page
 
+Quote Post
Ip.zone
post Oct 16 2007, 02:45 PM
Post #12


Member
**

Group: Members
Posts: 188
Joined: 26-September 07
From: edmonton,alberta,canada
Member No.: 303,555
IPB Version: Pre 1.0.x



thx man it helps alot smile2.gif


--------------------
Your signature was way too big. Please read the guidelines on signature size. http://forums.invisionize.com/boardrules.html - item 10.
Go to the top of the page
 
+Quote Post
deirdre
post Dec 21 2007, 11:27 AM
Post #13


Newbie
*

Group: Members
Posts: 1
Joined: 27-June 03
Member No.: 23,040



QUOTE(Buffalo @ Oct 16 2007, 08:25 PM) *
Good stuff.

I've been looking for a simple way, and i've found it.

Most hosts will run php4 & php5

The cure,

Add this line in the htaccess file in public_html

AddHandler application/x-httpd-php4 .php

that's it,

very simple, works 100%

All best from Barry Buffalo


Exactly what I did, too!
Go to the top of the page
 
+Quote Post
atholon
post Jan 30 2008, 06:59 AM
Post #14


Member
**

Group: Members
Posts: 116
Joined: 26-November 04
Member No.: 134,221
IPB Version: 1.3.x



If that doesn`t work give this a shot. Should work Perfectly

Download


--------------------

DigitalHelpFiles - Computer Video, Graphic and Audio help site, Reviews, Tutorials and more!
"...if a person pays three times as much for a computer, he has to be proud of it, because he paid for it. He can't call himself stupid. " -Jack Tramiel, founder of Commodore Business Machines
Go to the top of the page
 
+Quote Post
TheSidewinder
post May 3 2008, 09:28 PM
Post #15


Newbie
*

Group: Members
Posts: 28
Joined: 19-March 08
Member No.: 323,864
IPB Version: 2.3.x



Hot diggity darn!!!

Hostgator updated to PHP 5.2.5 and sure enough, the 1.3.1 Forum on which I'm an Admin was broken as above (blank "My Controls" page).

Adding that one line to .htaccess SEEMS to have solved all the problems, but I'm having users test all features of their accounts to be sure.

Man, am I glad for Community Support! smile2.gif

RV

This post has been edited by TheSidewinder: May 3 2008, 09:28 PM
Go to the top of the page
 
+Quote Post

2 Pages V   1 2 >
Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 18th March 2010 - 09:49 AM

Search Engine Keywords
Invision Skins · IPB Skins