Welcome Guest ( Log In | Register )


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
Can't install IPB 1.3.1 on Apache2 / PHP5 / MySQL5
ConiKost
post Dec 30 2005, 09:59 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 30-December 05
Member No.: 194,795
IPB Version: 1.3.x
Hi There!

I just can't install IPB 1.3.1 on my Webserver sad.gif

Error:

CODE

Warning!

The following errors must be rectified before continuing!
Please go back and try again!

mySQL Error: Invalid default value for 'macro_set'
Query:CREATE TABLE ibf_macro ( macro_id smallint(3) NOT NULL auto_increment, macro_value varchar(200) default NULL, macro_replace text, can_remove tinyint(1) default '0', macro_set smallint(3) NOT NULL default '', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM;
Go to the top of the page
 
+Quote Post
FuSoYa
post Dec 30 2005, 10:05 AM
Post #2


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

Group: Members
Posts: 13,986
Joined: 5-September 03
Member No.: 40,573
IPB Version: 2.3.x
Not even IPB 2.1.3 is fully compatible with MySQL 5.x yet. IPB 1.3.1 was designed to run on older software than this.
Go to the top of the page
 
+Quote Post
Pit
post Dec 30 2005, 12:14 PM
Post #3


Invisionized
*****

Group: Members
Posts: 1,384
Joined: 11-April 03
Member No.: 498
IPB Version: 1.3.x
The solution of this problem decides whether IPB1.3 will survive in the world of board software.

I am personally very interested to solve it because I will never use IPB2.x.

If you want to get IPB1.3 installed then you have to change some sql-statements in sm_install.php. This is the easiest step:

Change the lines as shown below
QUOTE
Line 1126: rules_text text NOT NULL default '',
Line 1197: macro_set smallint(3) NOT NULL default '0',
Line 1551: sublog_date int(10) NOT NULL default '0',
Line 1553: sublog_transid int(10) NOT NULL default '0',
Line 1575: submethod_active tinyint(1) NOT NULL default '0',


Now you can install IPB1.3 without problems.

But when you try to login, nothing happens. Always the same login site. What has happened? You are using PHP5.

Step 2 (Making IPB1.3 compatible with PHP5):

Open index.php and admin.php and insert the following lines as the first statements:

CODE
//-- mod_php5 begin
    $HTTP_SERVER_VARS = isset($_SERVER)?$_SERVER:array();
    $HTTP_GET_VARS = isset($_GET)?$_GET:array();
    $HTTP_POST_VARS = isset($_POST)?$_POST:array();
    $HTTP_POST_FILES = isset($_FILES)?$_FILES:array();
    $HTTP_COOKIE_VARS = isset($_COOKIE)?$_COOKIE:array();
    $HTTP_ENV_VARS = isset($_ENV)?$_ENV:array();
    $HTTP_SESSION_VARS = isset($_SESSION)?$_SESSION:array();
//-- mod_php5 end


But now when you try to login, then the next problems appear:

mySQL error for the session data

This can be solved with a change in sm_install.php

QUOTE
Line 1447: in_forum varchar(5) NOT NULL default '',


Ok, these are only my first experiments with IPB1.3, PHP5 and mySQL5. More errrors occur.

But don't worry: I will solve these problems.

And as FuSoYa has written above: "Not even IPB 2.1.3 is fully compatible with MySQL 5.x yet."


--------------------
My Supportsite for Invisionboard 1.3
Go to the top of the page
 
+Quote Post
FuSoYa
post Dec 30 2005, 01:00 PM
Post #4


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

Group: Members
Posts: 13,986
Joined: 5-September 03
Member No.: 40,573
IPB Version: 2.3.x
If anyone's going to get this working, it'll be Pit. smile2.gif
Go to the top of the page
 
+Quote Post
DeafCheer
post Feb 13 2006, 04:32 PM
Post #5


Newbie
*

Group: Members
Posts: 9
Joined: 27-January 06
Member No.: 200,632
IPB Version: 1.3.x
It was fixed but now I have new mySQL problem. mad.gif

QUOTE
mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ibf_forums f, ibf_categories c
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position

mySQL error: Unknown column 'f.id' in 'on clause'
mySQL error code:
Go to the top of the page
 
+Quote Post
WolverineX
post Feb 14 2006, 10:15 AM
Post #6


Newbie
*

Group: Members
Posts: 15
Joined: 1-February 06
Member No.: 201,786
IPB Version: 1.2.x
Make the edits listed in the following post:

http://forums.invisionize.com/ipb-13-on-mysql-5x-t92976.html

That should fix that error and at least get you into your boards, most of the problems have to do with Mysql 5 more than PHP 5

This post has been edited by WolverineX: Feb 14 2006, 10:15 AM
Go to the top of the page
 
+Quote Post
mcm-never-dies
post Feb 15 2006, 08:42 AM
Post #7


Member
**

Group: Members
Posts: 193
Joined: 28-January 05
Member No.: 142,544
IPB Version: 1.3.x
do the edits in http://forums.invisionize.com/ipb-13-on-mysql-5x-t92976.html

else you might get some sql errors wink.gif
and the edits in

http://forums.invisionize.com/Ipb-12-13-On-Php5-mysql41-t73882.html

to fix all errors, and to improve security, do the edits in:

http://forums.invisionize.com/Official-Security-Patches-t75148.html

This post has been edited by mcm-never-dies: Feb 15 2006, 08:44 AM
Go to the top of the page
 
+Quote Post
mind_itx
post May 16 2006, 02:41 AM
Post #8


Newbie
*

Group: Members
Posts: 1
Joined: 16-May 06
Member No.: 222,604
IPB Version: 1.3.x

after upgrade from php4/mysql4 to php5/mysql5 i got the same problem with DeafCheer. so i'll try change follow from topic below and it's working (to see board again). until i try to post new topic or reply then it return error msg


mySQL query error: INSERT INTO ibf_posts (author_id,use_sig,use_emo,ip_address,post_date,icon_id,post,author_name,forum_id,topic_id,queued,attach_id,attach_hits,attach_type,attach_file) VALUES ('49','1','1','192.168.10.50','1147768254','0',' ssss ','C99LIMITED ADMIN','62','3049','0','','','','')

mySQL error: Out of range value adjusted for column 'attach_hits' at row 1
mySQL error code:
Date: Tuesday 16th 2006f May 2006 08:30:54 AM


QUOTE(mcm-never-dies @ Feb 15 2006, 10:42 PM) [snapback]1642236[/snapback]

do the edits in http://forums.invisionize.com/ipb-13-on-mysql-5x-t92976.html

else you might get some sql errors wink.gif
and the edits in

http://forums.invisionize.com/Ipb-12-13-On-Php5-mysql41-t73882.html

to fix all errors, and to improve security, do the edits in:

http://forums.invisionize.com/Official-Security-Patches-t75148.html


is there anyone had the same problem.? any idea? .or it's required a lot work to solve this problem

tq
Go to the top of the page
 
+Quote Post
sully
post May 17 2006, 07:35 AM
Post #9


Meh!
*******

Group: Members
Posts: 8,085
Joined: 11-April 03
From: Here, There, Everywhere :D
Member No.: 879
Those who are reporting errors - a solution has been posted by Pit.

Please follow his solutions to fix the problem.

All these are outlined in this post;
http://forums.invisionize.com/index.php?s=...dpost&p=1642236

Thank You.


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

Alpha IT Solutions - The IT People
Alpha Design - Professional web & graphic design.
Discover Tramore - Visiting Ireland? Discover Tramore.
Go to the top of the page
 
+Quote Post
junky
post Jun 10 2006, 04:22 PM
Post #10


Newbie
*

Group: Members
Posts: 28
Joined: 21-May 04
Member No.: 109,509
IPB Version: Not Applicable
they don't help!!

I use IPB 1.3.1 wit Php5 patch from Pit, I still try to install it under xampp-win32-1.5.3a-installer.exe (PHP Version 5.1.4) still this problem

Warning!

The following errors must be rectified before continuing!
Please go back and try again!

mySQL Error: Invalid default value for 'macro_set'
Query:CREATE TABLE ibf_macro ( macro_id smallint(3) NOT NULL auto_increment, macro_value varchar(200) default NULL, macro_replace text, can_remove tinyint(1) default '0', macro_set smallint(3) NOT NULL default '', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM;
Go to the top of the page
 
+Quote Post
mcm-never-dies
post Jun 13 2006, 05:20 AM
Post #11


Member
**

Group: Members
Posts: 193
Joined: 28-January 05
Member No.: 142,544
IPB Version: 1.3.x
if you use pit's instructions it will be fixed...
Go to the top of the page
 
+Quote Post
Kalcentral
post Jan 18 2007, 08:49 PM
Post #12


Newbie
*

Group: Members
Posts: 56
Joined: 12-August 05
Member No.: 170,694
IPB Version: Not Applicable
How can cookies become fixed?
Go to the top of the page
 
+Quote Post
Kaida
post Jan 19 2007, 10:49 AM
Post #13


Newbie
*

Group: Members
Posts: 3
Joined: 20-May 04
Member No.: 109,083
IPB Version: 1.3.x
Okay, I've done everything except for the security patches and I still can't install my board and I get this error
QUOTE
The following errors must be rectified before continuing!
Please go back and try again!

mySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM' at line 6
Query:CREATE TABLE ibf_macro ( macro_id smallint(3) NOT NULL auto_increment, macro_value varchar(200) default NULL, macro_replace text, can_remove tinyint(1) default '0', macro_set smallint(3) NOT NULL default 0 '', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM;
Go to the top of the page
 
+Quote Post
IL CHE
post Sep 18 2007, 06:45 AM
Post #14


Newbie
*

Group: Members
Posts: 2
Joined: 9-May 06
Member No.: 221,295
IPB Version: 1.3.x
Hello,
I install IPB 1.3.x on a host with PhP5 and MSQL5. I correct the problems in the file: admin.php, index.php, sm_install.php. I haven't any type of problems during the installation. Then, after the login I went to the ACP and i find a problems. Here there is an image. How can i correct this problem?
Spoiler! Rollover the box below to view the hidden text.
Go to the top of the page
 
+Quote Post
IL CHE
post Sep 19 2007, 02:30 PM
Post #15


Newbie
*

Group: Members
Posts: 2
Joined: 9-May 06
Member No.: 221,295
IPB Version: 1.3.x
Please reply me sad.gif
Go to the top of the page
 
+Quote Post
« Next Oldest · General Support · Next Newest »
 

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

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Lo-Fi Version Time is now: 2nd September 2010 - 09:09 AM

Search Engine Keywords
IPB 1.3.1 forum, IPB Forum profile statistics error, ipb 1.3 mysql5, IPB 1.3 Php MySQL 5, ipb with php 5.x version, invision power board 1.3.1 php5, IPB 1.3.1 mySQL error: Unknown column \'f.id\' in \'on clause\', IPB 1.3.1 installer php5, IPB 1.3.1 $_GET, mySQL Error: Invalid default value for \'macro_set\', mysql error invalid default value for \'macro_set\', cannot be null invision power board
Powered By IP.Board © 2010  IPS, Inc.
Licensed to: Invisionize
CommunitySEO 1.2.3 © 2010  IPB SEO Module
Invision Skins · IPB Skins