Rating mod

[HelpClaSs]

Am incercat sa instalez 'Rating mod' de aici: http://www.phpbb.com/phpBB/viewtopic.ph ... ight=topic

L-am instalat manual, fiecare fisier si modificare. Totul a mers perfect dar cand am intrat in Panoul adm. si am facut click pe Rating system, am primit eroarea asta:
phpBB : Critical Error

Could not query rating configuration information

DEBUG MODE

SQL Error : 1146 Table 'helpclass_bro_ro.phpbb___rating_config' doesn't exist

SELECT config_id, label, num_value, text_value, input_type FROM phpbb___rating_config ORDER BY list_order

Line : 506
File : admin_rating.php

Eu am phpbb___ nu phpbb_ asa ca am inlocuit tot ce era phpbb_ cu phpbb___ si tot nu merge. Ce sa fac ca sa mearga ?

[seelview]

Tu ai helpclass_bro_ro.phpbb___ nu phpbb___ asa k inlocuieste asa.

[HelpClaSs]

Nu inteleg... Uite ce trebuie sa adaug:

Cod: Selectaţi tot

#-----[ SQL ]--------
# Note: replace phpbb_ with any custom table prefix you have
ALTER TABLE phpbb_users ADD rating_status tinyint unsigned NOT NULL;
ALTER TABLE phpbb_topics ADD rating_rank_id smallint unsigned not null;
ALTER TABLE phpbb_topics ADD KEY topics_ratingrankid(rating_rank_id);
ALTER TABLE phpbb_posts ADD rating_rank_id smallint unsigned not null;
ALTER TABLE phpbb_posts ADD KEY posts_ratingrankid(rating_rank_id);

CREATE TABLE phpbb_rating_config (
  label varchar(100) default NULL,
  num_value int unsigned NOT NULL default '0',
  text_value varchar(255) default NULL,
  config_id int unsigned NOT NULL default '0',
  input_type tinyint unsigned NOT NULL default '0',
  list_order smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (config_id)
) ;

# Note: you can change these settings via the admin system after installation
INSERT INTO phpbb_rating_config VALUES ('Rating system active',0,NULL,1,3,100);
INSERT INTO phpbb_rating_config VALUES ('Weighting method',1,NULL,3,3,300);
INSERT INTO phpbb_rating_config VALUES ('Users can change ratings',1,NULL,4,3,400);
INSERT INTO phpbb_rating_config VALUES ('Max daily ratings (0=unlimited)',10,NULL,5,2,500);
INSERT INTO phpbb_rating_config VALUES ('Show who rated',1,NULL,6,3,600);
INSERT INTO phpbb_rating_config VALUES ('Allow users to hide name',1,NULL,7,3,700);
INSERT INTO phpbb_rating_config VALUES ('Rate first post only',0,NULL,2,3,200);
INSERT INTO phpbb_rating_config VALUES ('Overall ranking method: posts',1,NULL,8,3,800);
INSERT INTO phpbb_rating_config VALUES ('Overall ranking method: topics',1,NULL,9,3,900);
INSERT INTO phpbb_rating_config VALUES ('Overall ranking method: users',1,NULL,10,3,1000);
INSERT INTO phpbb_rating_config VALUES ('Max daily ratings per user',1,NULL,13,2,550);
INSERT INTO phpbb_rating_config VALUES ('Open in new window',1,NULL,14,3,1400);
INSERT INTO phpbb_rating_config VALUES ('Min. post count',5,NULL,15,2,240);
INSERT INTO phpbb_rating_config VALUES ('Min. days registered',7,NULL,16,2,250);
INSERT INTO phpbb_rating_config VALUES ('Bias system active',1,NULL,11,3,1100);
INSERT INTO phpbb_rating_config VALUES ('Show bias usernames?',1,NULL,17,3,1150);
INSERT INTO phpbb_rating_config VALUES ('Show dropdown in viewtopic?',1,NULL,18,3,1800);
INSERT INTO phpbb_rating_config VALUES ('Show dropdown in viewforum?',0,NULL,19,3,1900);

CREATE TABLE phpbb_rating_option (
  option_id smallint unsigned NOT NULL auto_increment,
  points tinyint NOT NULL default '0',
  label varchar(100) default NULL,
  weighting smallint unsigned NOT NULL default '0',
  user_type tinyint unsigned NOT NULL default '0',
  PRIMARY KEY  (option_id),
  KEY ratingoption_rating (points),
  KEY ratingoption_weighting (weighting)
) ;

# These are suggested options. You could replace them with your own now, or via the admin system after installation
INSERT INTO phpbb_rating_option VALUES (1,2,'Highly recommended',5,1);
INSERT INTO phpbb_rating_option VALUES (2,1,'Recommended',0,1);
INSERT INTO phpbb_rating_option VALUES (3,5,'Moderator-recommended',0,3); 

CREATE TABLE phpbb_rating_rank (
  rating_rank_id smallint unsigned NOT NULL auto_increment,
  type tinyint unsigned NOT NULL default '0',
  average_threshold tinyint NOT NULL default '0',
  sum_threshold int NOT NULL default '0',
  label varchar(100) default NULL,
  icon varchar(255) default NULL,
  user_rank int unsigned NOT NULL,
  PRIMARY KEY  (rating_rank_id),
  KEY ratingrank_type (type)
) ;

# These are suggested options. You could replace them with your own now, or via the admin system after installation
INSERT INTO phpbb_rating_rank VALUES (2,5,2,5,'Worth a look','2star_green.gif',0);
INSERT INTO phpbb_rating_rank VALUES (3,5,4,20,'Impressive','4star_green.gif',0);
INSERT INTO phpbb_rating_rank VALUES (6,5,1,1,'Acknowledged','1star_green.gif',0);
INSERT INTO phpbb_rating_rank VALUES (7,5,3,10,'Quality','3star_green.gif',0);
INSERT INTO phpbb_rating_rank VALUES (8,5,5,40,'Inspired','5star_green.gif',0);
INSERT INTO phpbb_rating_rank VALUES (11,4,1,2,'Acknowledged','1star_cyan.gif',0);
INSERT INTO phpbb_rating_rank VALUES (12,4,2,10,'Worth a look','2star_cyan.gif',0);
INSERT INTO phpbb_rating_rank VALUES (13,4,3,20,'Quality','3star_cyan.gif',0);
INSERT INTO phpbb_rating_rank VALUES (14,4,4,40,'Impressive','4star_cyan.gif',0);
INSERT INTO phpbb_rating_rank VALUES (15,4,5,80,'Inspired','5star_cyan.gif',0);

CREATE TABLE phpbb_rating (
  post_id int unsigned NOT NULL default '0',
  user_id int unsigned NOT NULL default '0',
  rating_time int unsigned NOT NULL default '0',
  option_id smallint unsigned NOT NULL default '0',
  KEY rating_postid (post_id),
  KEY rating_userid (user_id),
  KEY rating_ratingoptionid (option_id)
) ;

CREATE TABLE phpbb_rating_bias (
  bias_id int unsigned NOT NULL auto_increment,
  user_id int unsigned NOT NULL default '0',
  target_user int unsigned NOT NULL default '0',
  bias_status tinyint unsigned NOT NULL default '0',
  bias_time int unsigned NOT NULL default '0',
  post_id int unsigned NOT NULL default '0',
  option_id smallint unsigned NOT NULL default '0',
  PRIMARY KEY (bias_id),
  KEY ratingbias_userid_targetuser (user_id,target_user),
  KEY ratingbias_targetuser (target_user),
  KEY ratingbias_postid (post_id),
  KEY ratingbias_optionid (option_id)
) ;

# Note: MySQL users might want to create following table as 'heap' type (put TYPE=HEAP before ;)
CREATE TABLE phpbb_rating_temp (
  topic_id int unsigned not null, 
  points tinyint not null,
  KEY ratingtemp_topicid(topic_id)
);

Poti tu, te rog, sa modifici cum ar trebui sa fie ? eu am incercat si mereu imi da o eroare cum ca deja exista masa respectiva sau ca nu e corect. Merci!

[dorin]

acolo unde scrie CREATE sau ALTER TABLE si este "_" mai pui un "_" , (daca asa ai vrut sa definesti tabelele) sa fie "__".

[HelpClaSs]

---EDITED---
Am incercat in mai multe feluri si se pare ca acum merge bine. merci!
(daca m-am inselat, o sa revin )