Invision Power Board Installation

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
Dark_Dax
-


Joined: 05 Sep 2006
Posts: 3

PostPosted: Tue Sep 05, 2006 5:57 am    Post subject: Invision Power Board Installation Reply with quote

Hi, i am trying to install IPBv1.3 Final on my server. But i get this error every time i do:

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;

Being a complete and total MySQL (and PHP) n00b, i have no idea what this means, nor how to fix it. Can anyone help me? Oh, and i have PHP 5.1 and MySQL 4.1 installed on my server.
Back to top View user's profile Send private message Send e-mail
Tom Chapman
-


Joined: 09 Jul 2005
Posts: 933
Location: Australia

PostPosted: Tue Sep 05, 2006 11:00 am    Post subject: Reply with quote

SQL and PHP are fine but there an error in a feild. Being a bit of nOOb my self, thats all I can tell you.
Back to top View user's profile Send private message Visit poster's website MSN Messenger
Tim1681
-


Joined: 17 Jan 2005
Posts: 160
Location: Bristol, CT, USA

PostPosted: Tue Sep 05, 2006 2:33 pm    Post subject: Reply with quote

That version of IPB is outdated and no longer supported.

But anyways, the answer:

http://forums.invisionpower.com/lofiversion/index.php/t224088.html wrote:
change macro_set smallint(3) NOT NULL default ''
into macro_set smallint(3) NOT NULL default 0

how do you do that?
open the text file which contains the create table statements, and search for macro_set smallint(3) NOT NULL default '', replace it with macro_set smallint(3) NOT NULL default 0...

if you are using php5/mysql5 then apply these patches: http://www.ipbwiki.com/forums/index.php?showtopic=149

_________________
mysql> SELECT * FROM users WHERE clue > 0;
0 rows returned.

Back to top View user's profile Send private message AIM Address
Dark_Dax
-


Joined: 05 Sep 2006
Posts: 3

PostPosted: Tue Sep 05, 2006 3:23 pm    Post subject: Reply with quote

Thanks for the help! :)

Edit: Well, it's installed, but now I'm getting this error:

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:

Does anyone know what to do to fix that?
Back to top View user's profile Send private message Send e-mail
Tim1681
-


Joined: 17 Jan 2005
Posts: 160
Location: Bristol, CT, USA

PostPosted: Tue Sep 05, 2006 9:20 pm    Post subject: Reply with quote

http://www.internetvibes.net/forum/index.php?showtopic=3238 wrote:
Bug is described here

http://bugs.mysql.com/bug.php?id=13551

to solve

open sources/Boards.php

find buggy query

Code:

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



and make it look like the following

Code:

// FIX 5.0.15       
       $DB->query("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");




hope this helps :)


Here's a site that can help you out in the future: http://www.google.com
_________________
mysql> SELECT * FROM users WHERE clue > 0;
0 rows returned.

Back to top View user's profile Send private message AIM Address
Dark_Dax
-


Joined: 05 Sep 2006
Posts: 3

PostPosted: Wed Sep 06, 2006 4:13 am    Post subject: Reply with quote

Thank you! The board is now up and running. :)
Back to top View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group