Having a problem with my MySQL

[ShadowFlame98]

I'm trying to install a forum on my host and when I put i the MySQL information it gives me this error.

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;

What does all of this mean? Did I do something wrong I created a database and everything put in my username and password and used localhost.

 

[mvmusic]

integers cannot have a string for the default value. if you can find the script that is trying to create the table, change the

macro_set smallint(3) NOT NULL default ''

to

macro_set smallint(3) NOT NULL default 0

what are you trying to install?

 

[ShadowFlame98]

I'm trying to install invison power board 1.3, I've had it for a long time and I've installed it many times and never got this kind of error before, if you say its something to do with the script I might of changed it before I uploaded it on the FTP and I'll just unzip it then.

Thought it was something to do with the sever.

 

[mvmusic]

from what it looks like, it's a problem with the sql query. if reuploading the scripts via ftp doesn't do it, redownload invision

 

[ShadowFlame98]

Alright I'm re uploading it now, I'll let you know if that fixes it or not and thanks for the help.
Edit:
Well I've re uploaded it and it installed just fine now, but when I tried to log it it then gave me 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:
Date: Friday 25th 2008f January 2008 11:01:12 PM

 

[mvmusic]

is there an id column in the f table? check in phpmyadmin. i'm not sure exactly...