svn[1432] char-addon reinstall error messages

by **SethDeBlade** » Fri Nov 16, 2007 8:31 am

i fixed that purple square bug and then i klickt in uninstall char-addon because "patchnotes" tell a reinstall is needed.

uninstalling leads me to this beauty

Code: Select all: Database Error 1091: Can't DROP 'show_played'; check that column/key exists SQL: ALTER TABLE `beta_players` DROP `show_money`, DROP `show_played`, DROP `show_tab2`, DROP `show_tab3`, DROP `show_tab4`, DROP `show_tab5`, DROP `show_talents`, DROP `show_spellbook`, DROP `show_mail`, DROP `show_bags`, DROP `show_bank`, DROP `show_quests`, DROP `show_recipes`, DROP `show_item_bonuses`; File: lib/dbal/mysql.php Line: 207 Backtrace (most recent call last): * lib/functions.lib.php o Line: 240 o Function Called: backtrace * lib/dbal/mysql.php o Line: 207 o Function Called: die_quietly o Arguments: + 1091: Can't DROP 'show_played'; check that column/key exists + Database Error + /www/htdocs/XXXX/beta/lib/dbal/mysql.php + 207 + ALTER TABLE `beta_players` DROP `show_money`, DROP `show_played`, DROP `show_tab2`, DROP `show_tab3`, DROP `show_tab4`, DROP `show_tab5`, DROP `show_talents`, DROP `show_spellbook`, DROP `show_mail`, DROP `show_bags`, DROP `show_bank`, DROP `show_quests`, DROP `show_recipes`, DROP `show_item_bonuses`; * lib/install.lib.php o Line: 271 o Function Called: query o Arguments: + ALTER TABLE `beta_players` DROP `show_money`, DROP `show_played`, DROP `show_tab2`, DROP `show_tab3`, DROP `show_tab4`, DROP `show_tab5`, DROP `show_talents`, DROP `show_spellbook`, DROP `show_mail`, DROP `show_bags`, DROP `show_bank`, DROP `show_quests`, DROP `show_recipes`, DROP `show_item_bonuses`; * admin/addon_install.php o Line: 512 o Function Called: install * admin/addon_install.php o Line: 46 o Function Called: processAddon * pages/rostercp.php o Line: 116 o Function Called: require_once o Arguments: + /www/htdocs/XXXX/beta/admin/addon_install.php * index.php o Line: 83 o Function Called: require o Arguments: + /www/htdocs/XXXX/beta/pages/rostercp.php

but i must have worked because i could hit the install-square. doing this brings me

Code: Select all: Database Error 1060: Duplicate column name 'show_money' SQL: ALTER TABLE `beta_players` ADD `show_money` TINYINT(1) NOT NULL default '3', ADD `show_played` TINYINT(1) NOT NULL default '3', ADD `show_tab2` TINYINT(1) NOT NULL default '3', ADD `show_tab3` TINYINT(1) NOT NULL default '3', ADD `show_tab4` TINYINT(1) NOT NULL default '3', ADD `show_tab5` TINYINT(1) NOT NULL default '3', ADD `show_talents` TINYINT(1) NOT NULL default '3', ADD `show_spellbook` TINYINT(1) NOT NULL default '3', ADD `show_mail` TINYINT(1) NOT NULL default '3', ADD `show_bags` TINYINT(1) NOT NULL default '3', ADD `show_bank` TINYINT(1) NOT NULL default '3', ADD `show_quests` TINYINT(1) NOT NULL default '3', ADD `show_recipes` TINYINT(1) NOT NULL default '3', ADD `show_item_bonuses` TINYINT(1) NOT NULL default '3'; File: lib/dbal/mysql.php Line: 207 Backtrace (most recent call last): * lib/functions.lib.php o Line: 240 o Function Called: backtrace * lib/dbal/mysql.php o Line: 207 o Function Called: die_quietly o Arguments: + 1060: Duplicate column name 'show_money' + Database Error + /www/htdocs/XXXX/beta/lib/dbal/mysql.php + 207 + ALTER TABLE `beta_players` ADD `show_money` TINYINT(1) NOT NULL default '3', ADD `show_played` TINYINT(1) NOT NULL default '3', ADD `show_tab2` TINYINT(1) NOT NULL default '3', ADD `show_tab3` TINYINT(1) NOT NULL default '3', ADD `show_tab4` TINYINT(1) NOT NULL default '3', ADD `show_tab5` TINYINT(1) NOT NULL default '3', ADD `show_talents` TINYINT(1) NOT NULL default '3', ADD `show_spellbook` TINYINT(1) NOT NULL default '3', ADD `show_mail` TINYINT(1) NOT NULL default '3', ADD `show_bags` TINYINT(1) NOT NULL default '3', ADD `show_bank` TINYINT(1) NOT NULL default '3', ADD `show_quests` TINYINT(1) NOT NULL default '3', ADD `show_recipes` TINYINT(1) NOT NULL default '3', ADD `show_item_bonuses` TINYINT(1) NOT NULL default '3'; * lib/install.lib.php o Line: 271 o Function Called: query o Arguments: + ALTER TABLE `beta_players` ADD `show_money` TINYINT(1) NOT NULL default '3', ADD `show_played` TINYINT(1) NOT NULL default '3', ADD `show_tab2` TINYINT(1) NOT NULL default '3', ADD `show_tab3` TINYINT(1) NOT NULL default '3', ADD `show_tab4` TINYINT(1) NOT NULL default '3', ADD `show_tab5` TINYINT(1) NOT NULL default '3', ADD `show_talents` TINYINT(1) NOT NULL default '3', ADD `show_spellbook` TINYINT(1) NOT NULL default '3', ADD `show_mail` TINYINT(1) NOT NULL default '3', ADD `show_bags` TINYINT(1) NOT NULL default '3', ADD `show_bank` TINYINT(1) NOT NULL default '3', ADD `show_quests` TINYINT(1) NOT NULL default '3', ADD `show_recipes` TINYINT(1) NOT NULL default '3', ADD `show_item_bonuses` TINYINT(1) NOT NULL default '3'; * admin/addon_install.php o Line: 512 o Function Called: install * admin/addon_install.php o Line: 46 o Function Called: processAddon * pages/rostercp.php o Line: 116 o Function Called: require_once o Arguments: + /www/htdocs/XXXX/beta/admin/addon_install.php * index.php o Line: 83 o Function Called: require o Arguments: + /www/htdocs/XXXX/beta/pages/rostercp.php

then in char-addon administration selecting display preferences and clicking on a guilt in the dropdown menu brings up

Code: Select all: Database Error 1054: Unknown column 'show_played' in 'field list' SQL: SELECT `member_id`, `name`, `level`, `class`, `show_money`, `show_played`, `show_tab2`, `show_tab3`, `show_tab4`, `show_tab5`, `show_talents`, `show_spellbook`, `show_mail`, `show_bags`, `show_bank`, `show_quests`, `show_recipes`, `show_item_bonuses` FROM `beta_players` WHERE `guild_id` = 1 ORDER BY `name` ASC LIMIT 0, 15; File: lib/dbal/mysql.php Line: 207 Backtrace (most recent call last): * lib/functions.lib.php o Line: 240 o Function Called: backtrace * lib/dbal/mysql.php o Line: 207 o Function Called: die_quietly o Arguments: + 1054: Unknown column 'show_played' in 'field list' + Database Error + /www/htdocs/XXXX/beta/lib/dbal/mysql.php + 207 + SELECT `member_id`, `name`, `level`, `class`, `show_money`, `show_played`, `show_tab2`, `show_tab3`, `show_tab4`, `show_tab5`, `show_talents`, `show_spellbook`, `show_mail`, `show_bags`, `show_bank`, `show_quests`, `show_recipes`, `show_item_bonuses` FROM `beta_players` WHERE `guild_id` = 1 ORDER BY `name` ASC LIMIT 0, 15; * addons/info/admin/display.php o Line: 221 o Function Called: query o Arguments: + SELECT `member_id`, `name`, `level`, `class`, `show_money`, `show_played`, `show_tab2`, `show_tab3`, `show_tab4`, `show_tab5`, `show_talents`, `show_spellbook`, `show_mail`, `show_bags`, `show_bank`, `show_quests`, `show_recipes`, `show_item_bonuses` FROM `beta_players` WHERE `guild_id` = 1 ORDER BY `name` ASC LIMIT 0, 15; * addons/info/admin/display.php o Line: 74 o Function Called: getCharData * admin/addon_conf.php o Line: 62 o Function Called: include_once o Arguments: + /www/htdocs/XXXX/beta/addons/info/admin/display.php * pages/rostercp.php o Line: 116 o Function Called: require_once o Arguments: + /www/htdocs/XXXX/beta/admin/addon_conf.php * index.php o Line: 83 o Function Called: require o Arguments: + /www/htdocs/XXXX/beta/pages/rostercp.php

by **zanix** » Fri Nov 16, 2007 9:17 am

Uninstall char info
Then run this SQL

Code: Select all: ALTER TABLE `beta_players` DROP `show_money`, DROP `show_tab2`, DROP `show_tab3`, DROP `show_tab4`, DROP `show_tab5`, DROP `show_talents`, DROP `show_spellbook`, DROP `show_mail`, DROP `show_bags`, DROP `show_bank`, DROP `show_quests`, DROP `show_recipes`, DROP `show_item_bonuses`;

Then install again

by **tuigii** » Fri Nov 16, 2007 3:44 pm

Note that 'show_played' isn't being inserted back in, so

Code: Select all: addons/info/inc/header.php Notice line 57: Undefined index: show_played addons/info/inc/char.lib.php Notice line 2312: Undefined index: show_played Notice line 2325: Undefined index: show_played

Could put it back in the table (hint : with the belonging admin on/off/user code)
Or drop it al together in the upper two files.