Hi.

I removed my 1.7.0 install and made a fresh 1.7.1 install and new database.

I go in and update guild name and server, nothing else.

I go and upload CharacterProfiler.lua and get the following 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 '10 AS levelgroup, COUNT(`level`) AS amount, SUM(`level`)

SQL:
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt', `level` DIV 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
------------

This exact lua file worked in 1.7.0.

I use CharacterProfiler 1.6.3 and GuildProfiler 1.6.0

Ok, I found the error. The sql keyword DIV is new in MySQL 4.1.0. I use 4.0.16. So using 4.1.0 or higher seem to be a requirement for 1.7.1 but wasn't for 1.7.0.

As a workaround u can change the incompatible sql code to the following:

Code: Select all

   $guildstat_query = "SELECT IF(`".$roster_conf['alt_location']."` LIKE '%".$roster_conf['alt_type']."%',1,0) AS 'isalt',
      `level`,
      COUNT(`level`) AS amount,
      SUM(`level`) AS sum
      FROM `".ROSTER_MEMBERSTABLE."`
      GROUP BY isalt
      ORDER BY isalt ASC";
   $result_menu = $wowdb->query($guildstat_query);

It works for our Guild http://www.stormwinds-stolz.de, but i havent fully tested what this change may "break". It may disable the Main/Twink Functionallity, i fear...

This disables the member count for each level

And actually, having MySQL 4.1.x is a requirement, but none of the code up until now actually required it

Note that when Roster 1.8 comes out, you will most defiantly need MySQL 4.1.x or higher

Yea I upgraded to 4.1.21 and it works now

During the install though, wowroster says it requires 4.04 or higher so might want to change that info screen.

Loots of good stuff in 1.7.1, nice work.

Ah, thanks for the catch

I'll be sure to fix that