On a clean install of Roster 1579 i get the following error when clicking on keys under guild

Code: Select all

Database 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 ') GROUP BY `members`.`name`' at line 1
SQL:
SELECT `members`.`name` FROM `roster_items` AS items LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `items`.`member_id` WHERE `items`.`member_id` = '353' AND () GROUP BY `members`.`name`;
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):
lib/functions.lib.php
Line: 240
Function Called: backtrace
lib/dbal/mysql.php
Line: 207
Function Called: die_quietly
Arguments:
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
Database Error
/homepages/35/d114412699/htdocs/sboj/roster/lib/dbal/mysql.php
207
SELECT `members`.`name` FROM `roster_items` AS items LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `items`.`member_id` WHERE `items`.`member_id` = '353' AND () GROUP BY `members`.`name`;
addons/keys/guild/index.php
Line: 218
Function Called: query
Arguments:
SELECT `members`.`name` FROM `roster_items` AS items LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `items`.`member_id` WHERE `items`.`member_id` = '353' AND () GROUP BY `members`.`name`;
index.php
Line: 153
Function Called: require
Arguments:
/homepages/35/d114412699/htdocs/sboj/roster/addons/keys/guild/index.php
 


The PHP Errors are

Code: Select all

PHP Errors
addons/keys/guild/index.php
  Notice line 173: Undefined offset: 0
  Warning line 175: Invalid argument supplied for foreach()
  Warning line 195: Invalid argument supplied for foreach()


My Roster install is at The Short Bus

Basic Server Info
OS Linux
Server Software Apache/1.3.33 (Unix)
MySQL Version 5.0.51-log

PHP Settings
PHP Version 5.2.4
PHP API Type cgi
safe_mode Off
open_basedir Off
allow_url_fopen On
file_uploads On
upload_max_filesize 20M

Config Values Show Entire $roster->config array
version 1.9.9.1579
db_version 6
db_prefix roster_
debug_mode On
roster_lang enUS
img_url img/
interface_url img/
img_suffix jpg
use_update_triggers On
rs_mode On


Let me know if you need more information

cwpc wrote:....Let me know if you need more information

Yep : I need to know ONE thing more : the one you didn't mention : You have a H2 Guild (the site link gave me that answer)

Knowing that : your case is solved, because :
Read This : Localization frFR svn [x] keys addon
and this post bring you here : Minor ArmorySync 2.6 beta svn[x] database fields issue

Read the part that's being marked : Next issue.

Edit the addons/keys/locale/enUS.php file (and all the others if needed) and you're done.

If you used the Armory to init your roster (and you did ) read also the first part in this post.

Always nice to see that Allies can help H2 ones in a while - I'll thing about that when entering JcJ...

[Dev's, I should have to check if this was corrected in SVN - I presume you did ]

what do you mean by a H2 Guild?

Also wqill i need to re-upload the character profile for my own character once i have made the PHP corrections?

Since upgrate to SVN 1634 the Keys-Page is empty. Keys-BC works fine but clicking on Azeroth Keys the result is empty and we only see the headers of the table but no entries.

Any hint what went wrong?
Holgi

Holgiranemsi wrote:Any hint what went wrong?
Holgi

One thing : you seem to have missed this Keys addon: Accepting translations and extra definitions.

The esES is already donwloadble, the frFR en deDE are still on the designing table, meaning: the new format has to be used to build the tables.
It's nothing more then a small compare a match job, but one has to have acces to all the French named keys, faction and other needed expressions.

A hard job