Code: Select all


1044: Access denied for user 'u1027274_dramber'@'%' to database 'db1027274_roster'
SQL:
CREATE TEMPORARY TABLE `backup_roster2_addon_config` LIKE `roster2_addon_config`
File: lib/dbal/mysql.php
Line: 203
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 236
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 203
          o Function Called: die_quietly
          o Arguments:
                + 1044: Access denied for user 'u1027274_dramber'@'%' to database 'db1027274_roster'
                + Database Error
                + /usr/local/pem/vhosts/113099/webspace/httpdocs/roster2/lib/dbal/mysql.php
                + 203
                + CREATE TEMPORARY TABLE `backup_roster2_addon_config` LIKE `roster2_addon_config`
    * lib/install.lib.php
          o Line: 235
          o Function Called: query
          o Arguments:
                + CREATE TEMPORARY TABLE `backup_roster2_addon_config` LIKE `roster2_addon_config`
    * admin/addon_install.php
          o Line: 503
          o Function Called: install
    * admin/addon_install.php
          o Line: 46
          o Function Called: processaddon
    * pages/rostercp.php
          o Line: 96
          o Function Called: require_once
          o Arguments:
                + /usr/local/pem/vhosts/113099/webspace/httpdocs/roster2/admin/addon_install.php
    * index.php
          o Line: 67
          o Function Called: require
          o Arguments:
                + /usr/local/pem/vhosts/113099/webspace/httpdocs/roster2/pages/rostercp.php


Running
Roster 2.0 Beta svn[1365]
OS: Linux
Server Software: Apache/2.0.46 (Red Hat) FrontPage/5.0.2.2635
MySQL Version: 4.1.21-Max-log

The install goes like a dream. Player data uploads fine. Just cannot install or run any of the addons.
Let me know if you need any more info or a password for the site.

Currently the addon installer requres 'CREATE TEMPORARY TABLE' rights on your db

All addons that use the default config api use the same table, this is so this table is protected from addons that do not install correctly

We are still discussing on an alternative way to handle this for those that cannot enable this permission on their db

That would explain it.
Thanks for the quick reply. Good luck!

i am running the lastest version that you guys have up there and i am hitting this issue and am unable to create temporary databases per my providers settings. Please let me know when this is fixed so i can try out the new version

Thanks

Phyre

We will, keep looking at this topic
Each build will have a change log

Roster 2.0 Beta svn[####]
http://www.wowroster.net/Forums/viewtopic/t=3929.html

I have hit this problem as well, install and upload all went fine and looks good until I try to load up the addons.

Also hit the same problem, looks like i'm going back to 1.73

This doesnt look like its going to be a quick fix, so is there anyway to work around this problem?

We will probably add a switch in RosterCP to turn off temp table backup some time down the line

Thanks for the update Zanix. I can't wait to try this out.

any update to this problem?

Yes, toggle RosterCP -> Main Settings -> Configure Main Roster -> "Use temporary tables"

niagairt wrote:any update to this problem?

NVM, I just found it in the options..........better get new glasses