roster 1.7.0 table problem

Installation issues with WoWRoster

roster 1.7.0 table problem

Postby figarotic » Tue Jul 11, 2006 12:52 pm

Not the big problem, though i have had to reinstall once again, after 20 members had added their info.
When i make a newly fresh install of roster 1.7.0, i have an error which can be listed from the diag:

DB Error, could not list tables
MySQL Error: 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 'To Hurt You' at line 1

Then after some time, i get a broken key table, where guildies have their keys for instances listed, just stops showing all the keys, reporting another mysql table error, which i havent written down. I made a new install onto it, since phpmyadmin couldn't fix this.

BTW: we have a german player uploading a german datafile too. This made trouble by not getting his avatar, i had to make it manually.
Adds a lot of german categories which only himself will understand.

OS Windows NT
Server Software Apache/2.0.58 (Win32) PHP/5.1.4
MySQL Version 5.0.22-community-nt

PHP Settings phpinfo() page
PHP Version 5.1.4
PHP API Type apache2handler
safe_mode Off
open_basedir Off
allow_url_fopen On
file_uploads On
upload_max_filesize 2M

GD Support
GD Status On
GD Version bundled (2.0.28 compatible)
FreeType Support Yes
FreeType Linkage with freetype
T1Lib Support Yes
GIF Read Support Yes
GIF Create Support Yes
JPG Support Yes
PNG Support Yes
WBMP Support Yes
XPM Support No
XBM Support Yes
JIS-mapped Japanese Font Support No

Config Values Show Entire $roster_conf array
version 1.7.0
db_version 2
db_name Love To Hurt You
db_host localhost
db_prefix lthy_
sqldebug On
roster_lang enUS
roster_dir /lua/roster
img_url img/
interface_url img/
img_suffix jpg
server_name_comp Off
guild_name Love To Hurt You
server_name Terenas
use_update_triggers On
realmstatus Uses server_name
rs_mode On

I have my own webserver and domain, whith Apache/2.0.58 (Win32) PHP/5.1.4 Server at

Changed domain name to
Last edited by figarotic on Wed Sep 27, 2006 7:57 am, edited 3 times in total.
User avatar
figarotic Apprentice Apprentice
Posts: 15
Joined: Sun Jul 09, 2006 4:31 am
Location: copenhagen, Denmark

roster 1.7.0 table problem

Postby zanix » Tue Jul 11, 2006 1:03 pm

Moved to WoWRoster General help and support form
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
Admin Dev Team Dev Team
UA/UU Developer
UA/UU Developer
Posts: 5544
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests