Medal MOD
-----
| Author | Message | |
|---|---|---|
|
khsjr1970 |
||
| 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 |
||
| 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