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
To late?
