hi all.
Installation went well, then when I click on phpRaid sync in roster
another page come up where I have to add roster PW: when I do that I get this error?

WoW Roster -> phpRaid Guild/Character Synchronization

Warning: include(addons/phpraid/db/mysql.php) [function.include]: failed to open stream: No such file or directory in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Warning: include() [function.include]: Failed opening 'addons/phpraid/db/mysql.php' for inclusion (include_path='.;C:\Program\xampp\php\pear\') in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Fatal error: Class 'sql_db' not found in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 35

...thanx...

Sahasrahla wrote:I couldn't find a reason (in the code) that you had to know the installation directory of phpRaid.

Code: Select all

include($phpraid_dir . '/db/mysql.php');

$db_phpraid = &new sql_db($phpraid_host,$phpraid_user,$phpraid_pass,$phpraid_name);


Spiffy (the original author of this addon and author of phpRaid) used his own db connecting functions and therefor this dependency exists. After the port for roster 1.7 quite a few calls to those functions were replaced with $wowdb object calls, but not the lines of code accessing the phpRaid database. It wouldn't be too difficult to recode this so it no longer depends on the phpraid but up till now I've been too lazy for that

acethecase wrote:hi all.
Installation went well, then when I click on phpRaid sync in roster
another page come up where I have to add roster PW: when I do that I get this error?

WoW Roster -> phpRaid Guild/Character Synchronization

Warning: include(addons/phpraid/db/mysql.php) [function.include]: failed to open stream: No such file or directory in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Warning: include() [function.include]: Failed opening 'addons/phpraid/db/mysql.php' for inclusion (include_path='.;C:\Program\xampp\php\pear\') in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Fatal error: Class 'sql_db' not found in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 35

...thanx...

Edit C:\Program\xampp\htdocs\roster\addons\phpRaid\conf.php and set $phpraid_dir correctly.

Another one with

"WoW Roster -> phpRaid Guild/Character Synchronization
Attempting to synchronize guilds...
Guild synchronization complete...
Attempting to synchronize characters...
Character synchronization complete...
Data synchronization complete! phpRaid characters and guilds are now synchronized with WoW Roster "

Nothing odd in the SQL debug that I can see and max.resists (latest version) has been installed. Do guildies need to re-upload the data for it to be seen in phpRaid?

Ok, looked like the problem might have been that roster and phpraid were using different databases, so I changed the config and reinstalled so that they share the same database - now I get

"WoW Roster -> phpRaid Guild/Character Synchronization<br>
<!-- SELECT * FROM roster_guild -->
Attempting to synchronize guilds...<br>

<!-- SELECT * FROM phpraid_guilds WHERE guild_name='Seeds of Glory' -->

<!-- INSERT INTO phpraid_guilds VALUES('0','None','Seeds of Glory','See') -->
Guild synchronization complete...<br>
<!-- SELECT * FROM phpraid_chars -->
Attempting to synchronize characters...<br>Character synchronization complete...<br>Data synchronization complete! phpRaid characters and guilds are now synchronized with WoW Roster
<!-- Begin Roster Footer -->"

So it now looks in the right place and finds the guild name, but then seems to be looking in the phpraid_guilds table for data - isn't this the table we're trying to populate?

OK some i must be a bit thick but could someone please tell me where to confirm the name of my phpraid.

Code: Select all

<?php
$phpraid_user = 'user';
$phpraid_pass = 'pass';
$phpraid_host = 'localhost';
$phpraid_name = 'theprop3_nuke1';
$phpraid_prefix = 'phpraid_';

// location of phpRaid directory relative to roster
// DO NOT include a trailing slash
$phpraid_dir = '../modules/phpraid';
?>

I am getting the following after entering the password

WoW Roster -> phpRaid Guild/Character Synchronization
Failed to connect to your phpRaid database. Verify the settings in conf.php

Thanks in advance and I apologise for the noob question but we all have to start somewhere. ;-)

For everyone that doesnt get any error, but also cant get it to synch, here is the solution!
Click submit instead of pressing enter........
Worked for me.