Bug in update.lib.php

Posts from previous Beta sessions

Bug in update.lib.php

Postby poetter » Thu Sep 27, 2007 6:46 am

Hi,

line 2390
Code: Select all
$querystr = "UPDATE `" . $roster->db->table('players') . "` SET " . $this->assignstr . " WHERE `member_id` IN ($inClause)';";


On single quote to much at the end leads to:

Code: Select all
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 ''' at line 1
SQL:
UPDATE `roster_players` SET `guild_id` = '0' WHERE `member_id` IN (579)';
File: lib\dbal\mysql.php
Line: 202
Backtrace (most recent call last):

    * lib\functions.lib.php
          o Line: 236
          o Function Called: backtrace
    * lib\dbal\mysql.php
          o Line: 202
          o Function Called: die_quietly
          o Arguments:
                + 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 ''' at line 1
                + Database Error
                + D:\xampp\roster.com\htdocs\lib\dbal\mysql.php
                + 202
                + UPDATE `roster_players` SET `guild_id` = '0' WHERE `member_id` IN (579)';
    * lib\update.lib.php
          o Line: 2391
          o Function Called: query
          o Arguments:
                + UPDATE `roster_players` SET `guild_id` = '0' WHERE `member_id` IN (579)';
    * lib\update.lib.php
          o Line: 539
          o Function Called: remove_guild_members
          o Arguments:
                + 5
                + 1190925636
    * addons\armorysync\inc\armorysync.class.php
          o Line: 108
          o Function Called: processGuildRoster
    * addons\armorysync\inc\armorysyncjob.class.php
          o Line: 647
          o Function Called: synchGuildByID
          o Arguments:
                + Aegwynn
                + 
    * addons\armorysync\inc\armorysyncjob.class.php
          o Line: 149
          o Function Called: _update_statusMemberlist
    * addons\armorysync\inc\armorysyncjob.class.php
          o Line: 94
          o Function Called: _startSyncing
    * addons\armorysync\guild\memberlist.php
          o Line: 25
          o Function Called: start
    * index.php
          o Line: 112
          o Function Called: require
          o Arguments:
                + D:\xampp\roster.com\htdocs\addons\armorysync\guild\memberlist.php


:D To late?
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Bug in update.lib.php

Postby zanix » Thu Sep 27, 2007 11:33 am

Function svn[1361]
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