Not displaying keys...

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Not displaying keys...

Postby Zarnek » Fri Aug 25, 2006 10:37 pm

http://righthandofgod.org/v2/modules.ph ... =indexinst

I do not understand, it will not display what keys my character has. I have even downloaded the newest version of Character Profiler and uploaded my profile... no luck. But it is showing other characters... ???
Zarnek
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Mon Aug 21, 2006 3:48 am

Not displaying keys...

Postby zanix » Sat Aug 26, 2006 1:20 am

Well, you are using the nuke port of roster which isn't supported by us

Please post in that forum for support


With that said, I'll try to help

First of all, I need the character's name in question
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

Re: Not displaying keys...

Postby Zarnek » Mon Aug 28, 2006 2:44 pm

awesome cuz i'm not getting help in the other forum lol...

the character is Zarnek. the first character added to the roster (my character). i noticed he's put in the database twice, once as null and once as id 36 i believe... i was wondering if that caused the problem but... i'm not sure.

the other weird thing i noticed, is even in the database it says aug 25th (well last i checked) it says dec ... ?
Zarnek
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Mon Aug 21, 2006 3:48 am

Not displaying keys...

Postby Zarnek » Mon Aug 28, 2006 8:58 pm

Nevermind I figured it out! lol . I just backed up my database and crossed my fingers...

I had redundant characters, one that had all my info and another that was all 0's and Null's. So i deleted the empty and and POOF! everything appeared and my update date was corrected :D

but in case anyone has the same problem... i'm going to leave this :D
Zarnek
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Mon Aug 21, 2006 3:48 am

Not displaying keys...

Postby zanix » Tue Aug 29, 2006 11:23 am

Yep, that would do it!

Glad it's working now
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

Not displaying keys...

Postby capock » Tue Aug 29, 2006 7:35 pm

I can't see my keys but no caracters are twice there...

Warning: Invalid argument supplied for foreach() in /data/members/paid/p/a/passtemps.com/htdocs/catharsis/webroster/membersinst.php on line 184

followed by :

1064: 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 ') GROUP BY members.name' at line 1

File: membersinst.php
Line: 208

What can i do ?
capock
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Aug 17, 2006 2:00 pm

Not displaying keys...

Postby zanix » Wed Aug 30, 2006 8:59 am

capock wrote:I can't see my keys but no caracters are twice there...

Warning: Invalid argument supplied for foreach() in /data/members/paid/p/a/passtemps.com/htdocs/catharsis/webroster/membersinst.php on line 184

followed by :

1064: 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 ') GROUP BY members.name' at line 1

File: membersinst.php
Line: 208

What can i do ?

I know why this happens and I'll post a solution in the FAQ section as soon as I have time to look at the code
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

Not displaying keys...

Postby RainRider » Mon Sep 04, 2006 1:02 pm

Have the same problem as described above. Keys would not display.

Hier ist the Link

Thank you in advance for posting the solution
Cheers
RainRider
RainRider
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Jul 20, 2006 11:47 pm

Not displaying keys...

Postby scottelsdon » Thu Sep 14, 2006 12:10 pm

I seem to have the same problem, any advancement in the solution ? pretty please

Here's my site's link

http://www.portsmouthshotokan.com/wowro ... exinst.php

Thanks in advance
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Thu Sep 14, 2006 12:40 pm

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

Not displaying keys...

Postby scottelsdon » Thu Sep 14, 2006 12:59 pm

Mmmm, I've applied the fixed files included within the Zip file from your lnk, now I dont get any return, but it goes stright to the SQL error,

gulp
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Thu Sep 14, 2006 1:02 pm

Did you do all the fixes?

Try the attatched files
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

Not displaying keys...

Postby scottelsdon » Thu Sep 14, 2006 1:19 pm

I didint apply the edited fixes, I downloaded the zip file and uploaded the three fixed php files to the site overwriting the originals.

Did I do wrong ?

I've been back to the remote server, deleted the three files in th etwo locations and uploaded again the three new files, ziltch, same result

gulp gulp
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby scottelsdon » Thu Sep 14, 2006 2:42 pm

major updating happening with our guild so 100 plus people are currently uploading their data, I think maybe there has been some data corruption somewhere on the submitted data, so the SQL fetch isnt getting the right return and failing,

I've restored the original three files, and if you click on the link in my first post, you'll see it returns around 40 peoples keys before failing.
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Thu Sep 14, 2006 2:53 pm

What are all the locales you have in your guild?
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

Next

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron