Installing addons erro

Posts from previous Beta sessions

Installing addons erro

Postby o0lind0o » Sun Mar 02, 2008 6:06 pm

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 ?
Last edited by o0lind0o on Sun Mar 02, 2008 6:07 pm, edited 1 time in total.
o0lind0o
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Tue Jul 11, 2006 8:46 pm

Installing addons erro

Postby zanix » Mon Mar 03, 2008 1:18 am

Post Roster 2.0 beta questions in the Beta Files forum
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Installing addons erro

Postby zanix » Mon Mar 03, 2008 1:23 am

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;
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Installing addons erro

Postby PleegWat » Mon Mar 03, 2008 3:11 am

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.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: Installing addons erro

Postby o0lind0o » Mon Mar 03, 2008 10:33 pm

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 :(
o0lind0o
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Tue Jul 11, 2006 8:46 pm

Installing addons erro

Postby zanix » Tue Mar 04, 2008 12:50 am

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron