Error....

[SeeK]

I installed D-Toplist on my forums and got this error...

IBplanet is down....

///////////////////////////////////////

mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.allow_anon, m.allow_rep, m.rep, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.view_topsite, m.add_topsites, m.vote_topsites, m.recommend_topsites, m.rate_topsites, m.comment_topsites , m.viewstats_topsites, m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.points, m.deposited, m.auto_collect, m.last_collect, m.extra_intrest, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1

mySQL error: Unknown column 'm.view_topsite' in 'field list'
mySQL error code:
Date: Thursday 06th of May 2004 12:46:01 PM

/////////////////////////

Please help me....

MSN: seek@seek-design.com

[Ed]

Try redoing your Topics.php file edits.

[SeeK]

But i didnt edit Topics.php when i installed it....

[Ed]

Functions.php then.

[dscripting]

No, did you get the install ran?

[SeeK]

I did step one and tehn i got a mysql error:

/////////////////////////////////

mySQL query error:
CREATE TABLE `ibf_topsites` (
`id` int(11) NOT NULL auto_increment,
`mail` text NOT NULL,
`name` text NOT NULL,
`title` text NOT NULL,
`banner` text NOT NULL,
`upload` varchar(200) NOT NULL default '',
`url` text NOT NULL,
`hitsin` int(11) NOT NULL default '0',
`hitsout` int(11) NOT NULL default '0',
`hitstoday` varchar(21) NOT NULL default '',
`hitstotal` int(11) NOT NULL default '0',
`uid` varchar(150) NOT NULL default '',
`accepted` char(1) NOT NULL default '0',
`description` text NOT NULL,
`rates` int(7) NOT NULL default '0',
`votes` int(7) NOT NULL default '0',
`register_date` date NOT NULL default '0000-00-00',
`recommends` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `click_in` (`hitsin`)
) TYPE=MyISAM


mySQL error: Table 'ibf_topsites' already exists
mySQL error code: 0
Date: Thursday 06th of May 2004 02:43:56 P

/////////////////////////////////////////

[Ed]

Then you have to delete ONLY the D-Toplist MySql Tables.

Nothing Else!

[MikeC]

your best bet would be to drop all the tables in your mysql database and try the install again as it seems to be saying that you already have sections within your tables. (mySQL error: Table 'ibf_topsites' already exists)

Hope this helps.

[SeeK]

I did that....now i got this from the installer:

///////////////////////////////

mySQL query error:
ALTER TABLE ibf_groups
ADD g_add_topsites tinyint(1) default '1' AFTER g_view_topsite,
ADD g_vote_topsites tinyint(1) default '1' AFTER g_add_topsites,
ADD g_recommend_topsites tinyint(1) default '1' AFTER g_vote_topsites,
ADD g_rate_topsites tinyint(1) default '1' AFTER g_recommend_topsites,
ADD g_comment_topsites tinyint(1) default '1' AFTER g_rate_topsites,
ADD g_viewstats_topsites tinyint(1) default '1' AFTER g_comment_topsites


mySQL error: Unknown column 'g_view_topsite' in 'ibf_groups'
mySQL error code: 0
Date: Thursday 06th of May 2004 02:57:54 PM

//////////////////////////////////

<_<

[SeeK]

Heres my forum btw: http://www.seek-design.com/forum/