I completly removed the older version and put the new one in, and when I click the button to load the vault i get

Invalid query result passed
Backtrace (most recent call last):
File: /home/prettypl/public_html/wow/apps/roster/lib/commonfunctions.lib.php
line 248
function called: backtrace
File: /home/prettypl/public_html/wow/apps/roster/lib/wowdb.php
line 196
function called: die_quietly
args: Invalid query result passed, Roster DB Layer
File: /home/prettypl/public_html/wow/apps/roster/addons/guildvault/includes/functions.lib.php
line 281
function called: num_rows
args:
File: /home/prettypl/public_html/wow/apps/roster/addons/guildvault/includes/functions.lib.php
line 62
function called: load_addon_config
File: /home/prettypl/public_html/wow/apps/roster/addons/guildvault/includes/functions.lib.php
line 55
function called: addon_checklogin
File: /home/prettypl/public_html/wow/apps/roster/addons/guildvault/index.php
line 41
function called: addonlogin
args: addon.php?roster_addon_name=guildvault, Array ( [0] => Array ( [type] => hidden [name] => task [value] => default ) )
File: /home/prettypl/public_html/wow/apps/roster/addon.php
line 77
function called: include_once
args: /home/prettypl/public_html/wow/apps/roster/addons/guildvault/index.php

Oh

seems that there´s a problem that the configuration isn´t inserted into your Database. Can you post a link to your roster, so i can directly take a look? And when possible please active all debug functions.

So i can show what queries will be done. On first load the addon should insert all needed data into the database.

http://prettyplate.net/wow/apps/roster/
here is the link to my roster

As far as I can tell all the debug options are turned on.

Hey,

i looked at your roster and must say i didn´t understand why it wouldn´t work.

I tested it now on 3 Systems (WAMP normal and DragonFly and on Suse Linux 10) without any problems.

The message that appears on your site, say that the load_addon_config function, will load the latest configuration from the database and returns an invalid result. So i think the needed tables will not created and / or no data will be inserted.

I attached all needed SQL commands for guildvault. So you can insert it manually, with PHPMyAdmin. On my testsystems the addon will do this automaticly, but i don´t know why didn´t do this in your roster.

What about a guild update? Normaly the addon checked even on a guildupdate if all tables exists. Have you tried this?

Nefuh

This is what happens when i try to add the text file manually.

Database prettypl_wow running on localhost
Error

SQL-query :

CREATE TABLE IF NOT EXISTS `roster_guildvault_addonconfig` (

`config_id` int( 5 ) NOT NULL auto_increment,
`config_name` varchar( 255 ) NOT NULL default '',
`config_value` varchar( 255 ) NOT NULL default '',
`config_form_type` mediumtext NOT NULL ,
PRIMARY KEY ( `config_id` ) ,
KEY `config_name` ( `config_name` )
)ENGINE = MYISAM

MySQL said:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 8
Back

I´ve tested it but can´t find any failure.

I ´ve copied the whole text file and paste it in the SQL window in PHPMyAdmin an it creates all tables and inserts all data.

You also can create the tables manually with PHPMyAdmin if nothing else worked. But i don´t really know why it would not worked.

Nefuh

Your mysql is probably lower than v4.1

Change

Code: Select all

ENGINE=MyISAM

To

Code: Select all

TYPE=MyISAM

Thanks that got past the sql errors, once i got the database fixed i uploaded guild information again with the password, no errors, when i click on guildvault i get

Warning: fopen() [function.fopen]: URL file-access is disabled in the server configuration in /home/prettypl/public_html/wow/apps/roster/addons/guildvault/includes/functions.lib.php on line 2273

Warning: fopen(http://wow.allakhazam.com/cluster/item- ... ource=live) [function.fopen]: failed to open stream: no suitable wrapper could be found in /home/prettypl/public_html/wow/apps/roster/addons/guildvault/includes/functions.lib.php on line 2273
unable to open XML

url_fopen is disabled on your server

Try to disable in the addon configuration the optiion: "Show Itemprices from Allakhazam".

Nefuh

Oh and Nefuh
TYPE= is compatible with all mysql versions

Ok thanks for info i will correct all "Create Table" queries.

And add a additional check if allow_url_fopen is enabled.

Nefuh