when i try to install any addons on my roster it says like this

Code: Select all

]1146: Table 'web94040.roster_addon_config' doesn't exist
SQL:
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '1' ORDER BY `id` ASC;
File: lib/dbal/mysql.php
Line: 235
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 189
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 235
          o Function Called: die_quietly
          o Arguments:
                + 1146: Table 'web94040.roster_addon_config' doesn't exist
                + Database Error
                + /usr/home/web/web94040/guildroster/lib/dbal/mysql.php
                + 235
                + SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '1' ORDER BY `id` ASC;
    * lib/functions.lib.php
          o Line: 940
          o Function Called: query
          o Arguments:
                + SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '1' ORDER BY `id` ASC;
    * pages/rostercp.php
          o Line: 135
          o Function Called: getaddon
          o Arguments:
                + guildinfo
    * index.php
          o Line: 86
          o Function Called: require
          o Arguments:
                + /usr/home/web/web94040/guildroster/pages/rostercp.php

any know what the problem is and how i fix it ?

Post Roster 2.0 beta questions in the Beta Files forum

Somehow the roster_addon_config table was deleted

Either delete conf.php and reinstall roster

Or using phpmyadmin (or any other mysql db manager) enter this SQL

Code: Select all

DROP TABLE IF EXISTS `roster_addon_config`;
CREATE TABLE `roster_addon_config` (
  `addon_id` int(11) NOT NULL default '0',
  `id` int(11) unsigned NOT NULL,
  `config_name` varchar(255) default NULL,
  `config_value` tinytext,
  `form_type` mediumtext,
  `config_type` varchar(255) default NULL,
  PRIMARY KEY  (`id`,`addon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I've seen this bug before. It results from a failed addon install when temporary table usage is on, but not supported by the host.

I have since implemented a proper check in SVN [I'm too lazy to look up the revision number], but I don't think that one's been packaged in the beta release topic yet.

zanix wrote:Somehow the roster_addon_config table was deleted

Either delete conf.php and reinstall roster

Or using phpmyadmin (or any other mysql db manager) enter this SQL

Code: Select all

DROP TABLE IF EXISTS `roster_addon_config`;
CREATE TABLE `roster_addon_config` (
  `addon_id` int(11) NOT NULL default '0',
  `id` int(11) unsigned NOT NULL,
  `config_name` varchar(255) default NULL,
  `config_value` tinytext,
  `form_type` mediumtext,
  `config_type` varchar(255) default NULL,
  PRIMARY KEY  (`id`,`addon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

thanks mate that worked even tho i have to use it after every addon i install. and sorry about posting the wrong place

You shouldn't have to use it after each install
In fact, you will not get any of the config options for each of the installed addons

Uninstall all your addons, set "Use Temporary Table" to "no" in RosterCP and re-install the addons