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