svn[1305] Database error uploading charactor/guild info

Went through guild listing adding Alt-name to each of the player's notes. re-saved guild and charactor info. Exit game. Parsed file manually from site upload page.

Recieved the following database error. New info did partially parse
*************************************
Database Error1366: Incorrect integer value: '' for column 'guild_rank' at row 15
SQL:
UPDATE `roster_members` SET `guild_id` = '0', `note` = '', `guild_rank` = '', `guild_title` = '', `officer_note` = '' WHERE `guild_id` = '2' AND `active` = '0'
File: lib\dbal\mysql.php
Line: 203
Backtrace (most recent call last):
lib\functions.lib.php
Line: 236
Function Called: backtrace
lib\dbal\mysql.php
Line: 203
Function Called: die_quietly
Arguments:
1366: Incorrect integer value: '' for column 'guild_rank' at row 15
Database Error
C:\Inetpub\CLWHosting\3924 - thedarkexalted\3924_01 - thedarkexalted.com\Roster\lib\dbal\mysql.php
203
UPDATE `roster_members` SET `guild_id` = '0', `note` = '', `guild_rank` = '', `guild_title` = '', `officer_note` = '' WHERE `guild_id` = '2' AND `active` = '0'
lib\update.lib.php
Line: 2378
Function Called: query
Arguments:
UPDATE `roster_members` SET `guild_id` = '0', `note` = '', `guild_rank` = '', `guild_title` = '', `officer_note` = '' WHERE `guild_id` = '2' AND `active` = '0'
lib\update.lib.php
Line: 539
Function Called: remove_guild_members
Arguments:
2
1189160939
lib\update.lib.php
Line: 188
Function Called: processGuildRoster
pages\update.php
Line: 44
Function Called: processFiles
index.php
Line: 67
Function Called: require
Arguments:
C:\Inetpub\CLWHosting\3924 - thedarkexalted\3924_01 - thedarkexalted.com\Roster\pages\update.php
*******************************************************

Deleted charactorprofiler.lua, renenterd game, resaved. Exited. Same error. rpgo-CharacterProfiler v2.1.1 rpgo-GuildProfiler v2.1.0 No previous versions of gp/cp install prior

File lib/update.lib.php
Line 2373
Change

Code: Select all

$this->add_value('guild_rank','');

To

Code: Select all

$this->add_value('guild_rank',0);

Fixed svn[1315]

Very nice. TY