svn[1305] Database error uploading charactor/guild info

Posts from previous Beta sessions

svn[1305] Database error uploading charactor/guild info

Postby AxeBane » Fri Sep 07, 2007 1:55 pm

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
*******************************************************
Attachments
characterprofiler.lua
(418.27 KiB) Downloaded 233 times
Last edited by AxeBane on Sun Sep 09, 2007 1:46 am, edited 1 time in total.
AxeBane
WR.net Apprentice
WR.net Apprentice
 
Posts: 19
Joined: Tue Sep 04, 2007 10:01 am

svn[1305] Database error uploading charactor/guild info

Postby AxeBane » Fri Sep 07, 2007 2:00 pm

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
AxeBane
WR.net Apprentice
WR.net Apprentice
 
Posts: 19
Joined: Tue Sep 04, 2007 10:01 am

svn[1305] Database error uploading charactor/guild info

Postby zanix » Sun Sep 09, 2007 1:46 am

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]
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

svn[1305] Database error uploading charactor/guild info

Postby AxeBane » Sun Sep 09, 2007 1:54 am

Very nice. TY
AxeBane
WR.net Apprentice
WR.net Apprentice
 
Posts: 19
Joined: Tue Sep 04, 2007 10:01 am


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron