Little help with config?

Track raids, bosskills, loot with the ct_raidtracker enhanced WoW Addon

Moderators: PoloDude, Gaxme

Little help with config?

Postby Shagrageous » Sun Dec 31, 2006 1:16 pm

I'm rather new to all of this so I'm hoping someone can help me get this working. No matter what i try i cant get this working on my roster. When I first click RaidTracker it gives me this in a window...
Invalid query result passed
Backtrace (most recent call last):

* File: /homepages/5/d173027262/htdocs/Roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /homepages/5/d173027262/htdocs/Roster/lib/wowdb.php
o line 133
o function called: die_quietly
o args: Invalid query result passed, Roster DB Layer
* File: /homepages/5/d173027262/htdocs/Roster/addons/RaidTracker/index.php
o line 78
o function called: fetch_assoc
o args:
* File: /homepages/5/d173027262/htdocs/Roster/addon.php
o line 77
o function called: include_once
o args: /homepages/5/d173027262/htdocs/Roster/addons/RaidTracker/index.php


I've setup a DB, my config file and all to my knowledge but I cant get it to work. Anyone get me going in the right direction?
Shagrageous
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Aug 16, 2006 6:32 am

Little help with config?

Postby Badious » Wed Jan 03, 2007 5:40 pm

So no one has an answer for this? It looks as though this raid tracker needs tables in the DB bu there is no setup for adding these tables? What am I doing wrong?
Badious
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Wed Jan 03, 2007 4:58 pm

Re: Little help with config?

Postby Vanterax » Wed Jan 03, 2007 8:37 pm

I have the same errors. Looks like the statements in install.php don't get executed and therefore the tables don't get created. I manually created them and was able to successfully upload RT data to the roster. However when I try to access the RT addon, it just freezes. It never returns...

Maybe RaidTracker is no longer compatible?
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

Re: Little help with config?

Postby Vanterax » Thu Jan 04, 2007 12:34 pm

Got it working now. Was missing a table.

Look at the install_db.php file. you can easily extract the SQL statements out of there to manually create the tables. Working fine for me now.
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

Re: Little help with config?

Postby Shagrageous » Fri Jan 05, 2007 10:02 am

Sorry I'm rather new to this and have no idea how you do this. Care to explain?
Shagrageous
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Aug 16, 2006 6:32 am

Little help with config?

Postby Vanterax » Fri Jan 05, 2007 12:08 pm

Are you familiar with SQL? Open up install_db.php in Notepad and you'll find the CREATE statements. They need to be changed a bit to add the prefix you set up with WoW Roster, but I don't think it's required. It's up to you.

Run those statements against your MySQL database to create the necessary tables.

Worked fine for me.
Last edited by Vanterax on Fri Jan 05, 2007 12:09 pm, edited 1 time in total.
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

Little help with config?

Postby PleegWat » Fri Jan 05, 2007 1:37 pm

This error has popped up in roster 1.7.2 because we added parameter validity checks in the database layer. Most probably in earlier versions of this mod a single database error would pop up, the mod would pick this up and install itself. Because of the new checks the mod can't pick it up since roster dies on it.

Go to the main tab of the config page, and turn off debug mode. This will disable the extra checks in the database layer. However, that will also turn off all of the error traces, so if you run into other problems we may ask you to turn debug mode back on so you can get us a trace.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: Little help with config?

Postby Shagrageous » Fri Jan 05, 2007 3:46 pm

WOOT! Is the best way I can describe it. Thanks a ton guys!
Shagrageous
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Aug 16, 2006 6:32 am

Re: Little help with config?

Postby Tarran » Thu Mar 15, 2007 2:40 am

This is the error I'm getting with debug mode turned on.

Code: Select all
Backtrace (most recent call last):

    * File: /var/www/vhosts/podwiki.net/httpdocs/roster/lib/commonfunctions.lib.php
          o line 248
          o function called: backtrace
    * File: /var/www/vhosts/podwiki.net/httpdocs/roster/lib/wowdb.php
          o line 133
          o function called: die_quietly
          o args: Invalid query result passed, Roster DB Layer
    * File: /var/www/vhosts/podwiki.net/httpdocs/roster/addons/RaidTracker/index.php
          o line 78
          o function called: fetch_assoc
          o args:
    * File: /var/www/vhosts/podwiki.net/httpdocs/roster/addon.php
          o line 77
          o function called: include_once
          o args: /var/www/vhosts/podwiki.net/httpdocs/roster/addons/RaidTracker/index.php

With debug mode turned off I only get a white screen. It seems I'm not getting the prompt to create tables with most of these mods I download, and I don't know how to do it manually.

/cry for the sql noob.
Last edited by Tarran on Thu Mar 15, 2007 2:48 am, edited 1 time in total.
User avatar
Tarran
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Mar 10, 2007 3:04 pm

Little help with config?

Postby sita » Sat Apr 14, 2007 11:43 pm

i also cant get rt to work on my site. doesnt install the db tables and i have no clue how to get them from install_dp

eror i get is :
includes/db/db.php

Code: Select all
    * CMS Warning line 75: On /WoWRosterDF/addon/roster_addon_name=RaidTracker.html While executing query "SELECT * FROM cms_wowrosterdf_roster_raids" the following error occured: Table 'vannitsenc.cms_wowrosterdf_roster_raids' doesn't exist In:/modules/WoWRosterDF/lib/wowdb.php on line: 96
sita
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Apr 03, 2007 7:31 pm
Location: Belgium

Little help with config?

Postby dhirmadi » Sun Apr 15, 2007 12:13 am

i just installed it today. here is what i did.

- uploaded the Addon
- set the configuration for item stats
- opened the roster in the browser, went to raidtracker. it told me something about missing tables and provided a link to install them
- clicked on the link and it worked as intended.
- now all that is needed is to update the language files with the Karazhan data.
User avatar
dhirmadi
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Sun Aug 06, 2006 9:01 pm


Return to RaidTracker

Who is online

Users browsing this forum: No registered users and 1 guest

cron