Can't upload in 1.7.1

CharacterProfiler.lua file uploading issues

Can't upload in 1.7.1

Postby Erzian » Sun Oct 22, 2006 2:57 pm

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
Erzian
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sun Oct 22, 2006 2:44 pm

Can't upload in 1.7.1

Postby Erzian » Sun Oct 22, 2006 3:02 pm

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.
Erzian
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sun Oct 22, 2006 2:44 pm

Can't upload in 1.7.1

Postby AbrahamLincoln » Sun Oct 22, 2006 3:52 pm

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...
AbrahamLincoln
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Fri Aug 04, 2006 1:15 am

Can't upload in 1.7.1

Postby zanix » Sun Oct 22, 2006 3:56 pm

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
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Can't upload in 1.7.1

Postby Erzian » Sun Oct 22, 2006 4:03 pm

Yea I upgraded to 4.1.21 and it works now :thumright:

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.
Last edited by Erzian on Sun Oct 22, 2006 4:04 pm, edited 1 time in total.
Erzian
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Sun Oct 22, 2006 2:44 pm

Can't upload in 1.7.1

Postby zanix » Sun Oct 22, 2006 4:37 pm

Ah, thanks for the catch

I'll be sure to fix that
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Uploading

Who is online

Users browsing this forum: No registered users and 1 guest