svn [1359] - Note sort in Member Log

Posts from previous Beta sessions

svn [1359] - Note sort in Member Log

Postby shaun.voysey » Thu Sep 27, 2007 1:15 am

Just tried to sort one of my guilds Member Logs by 'Note'

This came up :

1054: Unknown column 'nisnull' in 'order clause'

SQL:
SELECT *, DATE_FORMAT( `update_time`, "%a %b %D, %l:%i %p" ) AS date, UNIX_TIMESTAMP(`update_time`) AS date_stamp FROM `roster_memberlog` AS members WHERE `guild_id` = "2"ORDER BY nisnull, `note` ASC, `date_stamp` DESC LIMIT 0,25;

File: lib\dbal\mysql.php

Line: 203


Link is My beta Roster

Happy Hunting :)
Last edited by shaun.voysey on Thu Sep 27, 2007 1:39 am, edited 2 times in total.
User avatar
shaun.voysey
WR.net Apprentice
WR.net Apprentice
 
Posts: 70
Joined: Thu Aug 10, 2006 12:50 pm
Location: Berkshire, England

svn [1359] - Note sort in Member Log

Postby zanix » Thu Sep 27, 2007 1:38 am

Fixed svn[1360]
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron