Roster 1.7.3 - Memberlist upload?

CharacterProfiler.lua file uploading issues

Roster 1.7.3 - Memberlist upload?

Postby ybf_tover » Wed Nov 14, 2007 10:41 pm

-> German answers prefered, english is an alt language. ;)

Issue:
1. Clean new install
2. DB tables were created.
3. Uploading charprof... results with:
Parsing files

* Parsed CharacterProfiler in 0.03 seconds


Gilde nicht in der Datenbank gefunden. Bitte lade zunächst die Mitgliederliste hoch.

Means as much as: Guild not found, please upload memberlist.

Now, the guildname entered in the config was copied from the lua file itself. Why doesnt it upload?

Steps to solve issue:
I've uploaded the roster twice now.
Alle files are 100% completley uploaded.
Server has php 5.x apache 2.x, whatever, the roster page said server req's are met.

trying to find the config part:
how to allow 'my guild' to upload their lua files?

Uploading guildprofiler.lue results in :"Did not accept GuildProfiler.lua"

anyone got an idea?

thanks alot.
ybf_tover
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Nov 14, 2007 10:25 pm

Roster 1.7.3 - Memberlist upload?

Postby PleegWat » Wed Nov 14, 2007 10:46 pm

Wrong officer pass.
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

Roster 1.7.3 - Memberlist upload?

Postby ybf_tover » Thu Nov 15, 2007 12:12 am

EDIT: -->
with officer pass you talk about the only password you have to enter during installation?
<--

odd, i re-entred the exact same password (actualy copied from a textfile), result:

[pre]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 's%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS am' at line 1
SQL:
SELECT IF(`note` LIKE '%Twink's%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
File: menu.php
Line: 55
Backtrace (most recent call last):

* File: /home/webysdbm/www.ysera-bluefire.de/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/webysdbm/www.ysera-bluefire.de/roster/lib/menu.php
o line 55
o function called: die_quietly
o args: 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 's%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS am' at line 1, Database Error, menu.php, 55, SELECT IF(`note` LIKE '%Twink's%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
* File: /home/webysdbm/www.ysera-bluefire.de/roster/update.php
o line 514
o function called: include_once
o args: /home/webysdbm/www.ysera-bluefire.de/roster/lib/menu.php
[/pre]

As you might guess, i'm neither php nor mysql crack...

EDIT 2:
correction, the error result is now always, i cannot even get on the main page of the roster... :(
Last edited by ybf_tover on Thu Nov 15, 2007 12:17 am, edited 2 times in total.
ybf_tover
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Nov 14, 2007 10:25 pm

Roster 1.7.3 - Memberlist upload?

Postby ybf_tover » Thu Nov 15, 2007 2:07 am

ok, the error occoured because of the twink 'labeling'.
guilds internal delcaration is "twink's" which obviously caused the error..

anyhow, thanks PleegWat, it was that simple :)
very odd though, because the password was copied (both times) out of a textfile...

Thanks again and greets
Tover
ybf_tover
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Nov 14, 2007 10:25 pm


Return to Uploading

Who is online

Users browsing this forum: No registered users and 0 guests

cron