Demon of Darkness wrote:DROP TABLE `phpbb_reputations` (
`rep_id` mediumint(8) NOT NULL auto_increment,
`rep_from` mediumint(8) NOT NULL,
`rep_to` mediumint(8) NOT NULL,
`rep_time` int(11) NOT NULL,
`rep_post_id` mediumint(8) NOT NULL,
`rep_point` int(11) NOT NULL,
`rep_comment` mediumtext NOT NULL,
`bbcode_uid` varchar(8) NOT NULL,
`bbcode_bitfield` varchar(255) NOT NULL,
`enable_bbcode` tinyint(1) unsigned NOT NULL,
`enable_smilies` tinyint(1) unsigned NOT NULL,
`enable_urls` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`rep_id`)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
DROP TABLE `phpbb_reputations_ranks` (
`rank_id` mediumint(8) unsigned NOT NULL auto_increment,
`rank_title` varchar(255) collate utf8_bin NOT NULL,
`rank_points` int(11) NOT NULL default '0',
PRIMARY KEY (`rank_id`)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
And then goto the other tables and drop them.
`phpbb_users` - `user_reputation` INT( 11 ) NOT NULL DEFAULT '0';
`phpbb_users` - `user_hide_reputation` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
`phpbb_groups` - `group_reputation_power` TINYINT( 4 ) NOT NULL DEFAULT '0';
Then just get rid of the values. And your done.
DROP TABLE `phpbb_reputations` (
`rep_id` mediumint(8) NOT NULL auto_increment,
`rep_from` mediumint(8) NOT NULL,
`rep_to` mediumint(8) NOT NULL,
`rep_time` int(11) NOT NULL,
`rep_post_id` mediumint(8) NOT NULL,
`rep_point` int(11) NOT NULL,
`rep_comment` mediumtext NOT NULL,
`bbcode_uid` varchar(8) NOT NULL,
`bbcode_bitfield` varchar(255) NOT NULL,
`enable_bbcode` tinyint(1) unsigned NOT NULL,
`enable_smilies` tinyint(1) unsigned NOT NULL,
`enable_urls` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`rep_id`)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
DROP TABLE `phpbb_reputations_ranks` (
`rank_id` mediumint(8) unsigned NOT NULL auto_increment,
`rank_title` varchar(255) collate utf8_bin NOT NULL,
`rank_points` int(11) NOT NULL default '0',
PRIMARY KEY (`rank_id`)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
I ran above querry but i am getting this error
Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
`rep_id` mediumint(8) NOT NULL auto_increment,
`rep_from` mediumint(8) N' at line 1
should i just select phpbb_reputations_ranks and phpbb_reputations in phpmyadmin an ddrp[ them manually?? I wonder why i am getting teh error since the mos works fine in my forum
.. i am using 0.2.version btw