Problem with Version 10

Displays the Guild vault introduced in WoW 2.3

Moderator: Nefuh

Problem with Version 10

Postby jimmylee7706 » Fri Feb 15, 2008 6:51 am

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
jimmylee7706
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Sat Feb 02, 2008 12:04 am

Problem with Version 10

Postby Nefuh » Fri Feb 15, 2008 8:26 am

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.
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Problem with Version 10

Postby jimmylee7706 » Fri Feb 15, 2008 9:27 pm

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.
jimmylee7706
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Sat Feb 02, 2008 12:04 am

Re: Problem with Version 10

Postby Nefuh » Fri Feb 15, 2008 9:44 pm

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
Attachments
guildvault_sql.txt
Guildvault SQL
(3.8 KiB) Downloaded 358 times
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Problem with Version 10

Postby jimmylee7706 » Sat Feb 23, 2008 9:15 pm

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
jimmylee7706
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Sat Feb 02, 2008 12:04 am

Problem with Version 10

Postby Nefuh » Sat Feb 23, 2008 11:06 pm

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
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Problem with Version 10

Postby zanix » Sat Feb 23, 2008 11:29 pm

Your mysql is probably lower than v4.1

Change
Code: Select all
ENGINE=MyISAM

To
Code: Select all
TYPE=MyISAM
Last edited by zanix on Sat Feb 23, 2008 11:29 pm, edited 1 time in total.
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Problem with Version 10

Postby jimmylee7706 » Sun Feb 24, 2008 12:25 am

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
jimmylee7706
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Sat Feb 02, 2008 12:04 am

Problem with Version 10

Postby zanix » Sun Feb 24, 2008 12:32 am

url_fopen is disabled on your server
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Problem with Version 10

Postby Nefuh » Sun Feb 24, 2008 12:46 am

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

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Problem with Version 10

Postby zanix » Sun Feb 24, 2008 1:02 am

Oh and Nefuh
TYPE= is compatible with all mysql versions
Last edited by zanix on Sun Feb 24, 2008 1:02 am, edited 1 time in total.
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Problem with Version 10

Postby Nefuh » Sun Feb 24, 2008 1:19 am

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

And add a additional check if allow_url_fopen is enabled.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany


Return to Guildvault

Who is online

Users browsing this forum: No registered users and 0 guests

cron