SQL error after upgrade.

Installation issues with WoWRoster

SQL error after upgrade.

Postby Trokko » Sun Oct 22, 2006 5:16 pm

I downloaded the update today and since then Im getting the following SQL error:
Code: Select all
1064You have an error in your SQL syntaxCheck 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(`guild_title` LIKE '
%Alt%',1,0) AS 'isalt, `levelDIV 10 AS levelgroupCOUNT(`level`) AS amountSUM(`level`) AS sum FROM `roster_membersGROUP BY isaltlevelgroup ORDER BY isalt ASClevelgroup DESC 
File
menu.php 
Line
55


I even tried installing the roster from scratch (after making a backup of the old one of course) but I still get this error. Anyone else got this problem? Any pointers on what's wrong?
Trokko
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Jul 08, 2006 5:20 pm

SQL error after upgrade.

Postby PleegWat » Sun Oct 22, 2006 5:20 pm

Replace
Code: Select all
`level` DIV 10
by
Code: Select all
FLOOR(`level`/10)
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

SQL error after upgrade.

Postby zanix » Sun Oct 22, 2006 5:20 pm

Roster requires mysql 4.1.x or higher, just like it always has

We have just implemented core code that now absolutely requires at least 4.1.0
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: SQL error after upgrade.

Postby Trokko » Sun Oct 22, 2006 5:38 pm

PleegWat wrote:Replace
Code: Select all
`level` DIV 10
by
Code: Select all
FLOOR(`level`/10)


Thanks, worked like a charm. :thumright:
Trokko
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Jul 08, 2006 5:20 pm

SQL error after upgrade.

Postby zanix » Sun Oct 22, 2006 7:13 pm

Re-download the file, it's fixed now
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 Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron