From what I understand the initial login is Default and password is changeme?

I get the error

DEBUG: ERROR: Table 'efaeguil_roster.uniadmin_users' doesn't exist
select * from `uniadmin_users` where `name` like 'Default'

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/efaeguil/public_html/uniadmin/login.php on line 33

Make sure you have the "table prefix" set correctly in uniadmin/config.php

The prefix is correct still get the error.

Here are the steps I took.

1. I had the WoWRoster up and going well before getting the UniAdmin, if that matters.

2. I uploaded all the UniAdmin files

3. I created a DB called UniAdmin and ran the .sql file that came with the UniAdmin download.

4. Possible error: when configuring the config.php file am I using the DB info for WoWRoster or should I make a new user for UniAdmin and use that info?

The make sure yo have the correct info for db_name

Looks like it may be

Code: Select all

efaeguil_UniAdmin

What about the DB prefix/username/password
Should if be the info for the DB that I made for the WoWRoster?

Or should I create a username for the UniAdmin DB and use that?

Rusky wrote:What about the DB prefix/username/password
Should if be the info for the DB that I made for the WoWRoster?

The user name needs access to the new db you created

Rusky wrote:Or should I create a username for the UniAdmin DB and use that?

You could do this as well

Ugg still no luck

Error:

DEBUG: ERROR: Table 'efaeguil_UniAdmin.roster_users' doesn't exist
select * from `roster_users` where `name` like 'efaeguil_roster'

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/efaeguil/public_html/UniAdmin/login.php on line 33

Here is my config file with a few things editted out:
For the username/password I added the the user from WoWRoster DB to the UniAdmin DB.

Code: Select all

<?php
$config['host'] =       'localhost';         // dbase host
$config['username'] =    '<Same username as WoWRoster DB>';   // dbase username
$config['password'] =    '<Same password as WoWRoster DB>';   // dbase password
$config['database'] =    'efaeguil_UniAdmin';      // dbase name

//////////////// DO NOT TOUCH ANYTHING AFTER THIS LINE ////////////
ini_set('display_errors','1');
error_reporting(E_WARNING);
///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';
$config['db_tables_addons'] =    $config['db_prefix'].'addons';
$config['db_tables_files'] =       $config['db_prefix'].'files';
$config['db_tables_logos'] =       $config['db_prefix'].'logos';
$config['db_tables_settings'] =    $config['db_prefix'].'settings';
$config['db_tables_stats'] =       $config['db_prefix'].'stats';
$config['db_tables_users'] =       $config['db_prefix'].'users';
$config['db_tables_svlist'] =    $config['db_prefix'].'svlist';
//////////////////////// FOLDER SETTINGS //////////////////////////
$config['addon_folder'] =       'addon_zips';
$config['temp_analyze_folder'] =    'addon_temp';
$config['logo_folder'] =       'logos';
////////////////////////// OTHER STUFF ////////////////////////////
$config['ziplibsupport'] =      false;
$config['UAVer'] =          'Beta 0.6.1';
$config['debugSetting'] =      true;
$url = explode('/','http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']);
array_pop($url);
$url = implode('/',$url).'/';
$config['URL'] =               $url;
$config['IntLocation'] =          $config['URL'].'interface.php';
$dblink=mysql_connect($config['host'],$config['username'],$config['password']);
mysql_select_db($config['database'],$dblink);
include('debug.php');
include('MySqlCheck.php');
include('css.php');
include('cookieFunctions.php');

if (!$interface){
   include('login.php');
   include('header.php');
   include('EchoPage.php');
}
?>

Woah, hey:

Code: Select all

///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';

Um, for uniadmin, you'd want that to be "uniadmin_". Your uniadmin right now is trying to look for a table called roster_users, but such does not exist. I bet uniadmin_users does, though.

Rihlsul wrote:Woah, hey:

Code: Select all

///////////////////////// DATABASE ////////////////////////////////
$config['db_prefix'] =          'roster_';

Um, for uniadmin, you'd want that to be "uniadmin_". Your uniadmin right now is trying to look for a table called roster_users, but such does not exist. I bet uniadmin_users does, though.

The reason I have it set to roster_ is because that is the prefix to my WoWRoster DB. But I'll give uniadmin_ a try though.

EDIT:

It worked!!!
Thanks very much to zanix and for the finishing blow to Rihlsul.

You guys rock!