Medal MOD


  -----  
Author Message

khsjr1970
Member

Mon Dec 19, 2005 5:05 pm   Post subject: Medal MOD
hiya again Thoul.

I am installing the most recent version of medal mod along with your admin ultiility medal mod.

I am having trouble with the authors SQL, and have no recieved a response back in a few days to my questions

the insertions the author wants done is

Code:

INSERT INTO `phpbb_config` VALUES ('allow_medal_display', '0');
INSERT INTO `phpbb_config` VALUES ('medal_display_row', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_col', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_width', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_height', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_order', '');
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10');


The problem with those is that I am getting an error in phpmyadmin and that error is as follows.

Code:

#1136 - Column count doesn't match value count at row 1


I've been instructed by someone else willing to help that the problem is:
"Because there is another row of values you're missing, look at the config table and you will see a third row. Add , 0 or , 1 at the end as necessary if these are static or dynamic variables."

Any chance, you know what that tidbit of information means ?

Thanks in advance, for any and all help given over these past few weeks.
 

Thoul
Administrator

Tue Dec 20, 2005 11:16 am   Post subject: re: Medal MOD
This happens sometimes when other mods are installed (I think Attachment or Cat Hierarchy in particular), but it can also happen on a totally clean phpBB. Some versions of MySQL just don't like queries written like those. Use these queries instead and you should be fine.

Code:

INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('allow_medal_display', '0');
INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('medal_display_row', '1');
INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('medal_display_col', '1');
INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('medal_display_width', '');
INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('medal_display_height', '');
INSERT INTO `phpbb_config`(config_name, config_value) VALUES ('medal_display_order', '');
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10');
 

Page 1 of 1
Display posts from previous: