View previous topic :: View next topic |
Author |
Message |
Dark_Dax -
Joined: 05 Sep 2006 Posts: 3
|
Posted: Tue Sep 05, 2006 5:57 am Post subject: Invision Power Board Installation |
|
|
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 |
|
|
Tom Chapman -
Joined: 09 Jul 2005 Posts: 933 Location: Australia
|
Posted: Tue Sep 05, 2006 11:00 am Post subject: |
|
|
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 |
|
|
Tim1681 -
Joined: 17 Jan 2005 Posts: 160 Location: Bristol, CT, USA
|
Posted: Tue Sep 05, 2006 2:33 pm Post subject: |
|
|
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 |
|
|
Dark_Dax -
Joined: 05 Sep 2006 Posts: 3
|
Posted: Tue Sep 05, 2006 3:23 pm Post subject: |
|
|
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 |
|
|
Tim1681 -
Joined: 17 Jan 2005 Posts: 160 Location: Bristol, CT, USA
|
Posted: Tue Sep 05, 2006 9:20 pm Post subject: |
|
|
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 |
|
|
Dark_Dax -
Joined: 05 Sep 2006 Posts: 3
|
Posted: Wed Sep 06, 2006 4:13 am Post subject: |
|
|
Thank you! The board is now up and running. :) |
|
Back to top |
|
|
|
|
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
|
|