Hi all

I'm not even sure if this script is still in use, i hope it is, i have over 350+ members i need to migrate to my eqdkp database..

Ok, i've downloaded the script, and placed it in a folder of its own, edited the conf.php file but i'm getting this error every time i run it.

Fatal error: Call to a member function GetArray() on a non-object in
importroster\sync_roster_members_with_eqdkp.php on line 28
PHP Fatal error: Call to a member function GetArray() on a non-object in \WowDKP\importroster\sync_roster_members_with_eqdkp.php on line 28

I'm using WowRoster v2 and the Latest EQDKP

Any help greatfully received.

If the script is old, it might not work with Roster 2.0
Which script is it?

I'm running script Bring_eqdkp_roster_v0.5_138_126

Its the latest version i could find in these forums.

Heres is the line it refers to
$eqdkp_classes = $rseqdkp_classes->GetArray();

Here is the section of the code.
$rseqdkp_classes = $db_eqdkp->Execute('SELECT class_id, class_name, class_min_level, class_max_level FROM '.$eqdkp_prefix.'classes');
$eqdkp_classes = $rseqdkp_classes->GetArray();
$rseqdkp_races = $db_eqdkp->Execute('SELECT race_id, race_name FROM '.$eqdkp_prefix.'races');
$eqdkp_races = $rseqdkp_races->GetArray();

From what i can gather, its just a simple database get command, which is going wrong. I've checked and rechecked the config.inc.php file and set the database details up correctly but it still fails, oddly enough, even if i put incorrect data into the config.inc.php file it still comes up with the same error message, which tells me its an issue connecting to the db, but can't see what, the only major thing i can think of, which doesn't even make sence, is that both the roster and the EQDKP occupy the same MySQL database.

Code: Select all

$rseqdkp_classes->GetArray(); 

The line above that might be having an error

Code: Select all

$rseqdkp_classes = $db_eqdkp->Execute('SELECT class_id, class_name, class_min_level, class_max_level FROM '.$eqdkp_prefix.'classes'); 

It's possible that the db layer that this script uses may be having an error on that SQL statement, but I don't know enough about this db library to help

You can try to add this line

Code: Select all

include("adodb/adodb-exceptions.inc.php"); 

Above this line

Code: Select all

include('adodb/adodb.inc.php'); 

But I'm not sure if this will give you an error display or not...

Ok, i added rge line like you geggested and got this.

[code=php]
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2003: Can't connect to MySQL server on 'localhost' (10061)] in CONNECT(, '', '****', ) ' in \bridge_eqdkp_roster\adodb\adodb-exceptions.inc.php:76 Stack trace: #0 D\bridge_eqdkp_roster\adodb\adodb.inc.php(425): adodb_throw('mysql', 'CONNECT', 2003, 'Can't connect t...', '', '', Object(ADODB_mysql)) #1 \bridge_eqdkp_roster\adodb\adodb.inc.php(451): ADOConnection->Connect(NULL, NULL, NULL, NULL, true) #2 \bridge_eqdkp_roster\sync_roster_members_with_eqdkp.php(24): ADOConnection->NConnect(NULL, NULL, NULL, NULL) #3 {main} thrown in \bridge_eqdkp_roster\adodb\adodb-exceptions.inc.php on line 76
PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2003: Can't connect to MySQL server on 'localhost' (10061)] in CONNECT(, '', '****', ) ' in \bridge_eqdkp_roster\adodb\adodb-exceptions.inc.php:76 Stack trace: #0 \bridge_eqdkp_roster\adodb\adodb.inc.php(425): adodb_throw('mysql', 'CONNECT', 2003, 'Can't connect t...', '', '', Object(ADODB_mysql)) #1 bridge_eqdkp_roster\adodb\adodb.inc.php(451): ADOConnection->Connect(NULL, NULL, NULL, NULL, true) #2 \bridge_eqdkp_roster\sync_roster_members_with_eqdkp.php(24): ADOConnection->NConnect(NULL, NULL, NULL, NULL) #3 {main} thrown in \bridge_eqdkp_roster\adodb\adodb-exceptions.inc.php on line 76

From the looks of the error, its looking for the localhost database, but the database isn't stored on the localhost, its stored on anotehr server, for which i entered in the config.php file.

If this is a major error, then perhaps someone could give me a link to the sql script itself so that i can run it directly on the database ?

Thanks in advance

ok, i'm going to dump the database and create 2 seperate db's, 1 for roster and 1 for eqdkp and see what happens, will keep you posted.

Ok, i've got somewhere, i'm still unsure why, but i had to edit the NConnects and fill the info in manually, so my new code now looks like this.

// Connect all the databases
$db_eqdkp->NConnect('myhost', 'myuser', 'mypass', 'mydb');
$db_roster->NConnect('myhost', 'myuser', 'myadmin', 'mydb');

//Grab the arrays of EQDKP
$rseqdkp_classes = $db_eqdkp->Execute('SELECT class_id, class_name, class_min_level, class_max_level FROM wowdkp_classes');
$eqdkp_classes = $rseqdkp_classes->GetArray();
$rseqdkp_races = $db_eqdkp->Execute('SELECT race_id, race_name FROM wowdkp_races');
$eqdkp_races = $rseqdkp_races->GetArray();

Ok, now i don't get the error on line such and such, but my new problem is that the page does nothing, just blank.

Any advice?

Ok, finally got it working.

I had to ditch the ocnfig file all together, and use that info in the main page itself, works a treat now

Nice