sql error

Posts from previous Beta sessions

sql error

Postby Anthara » Sun Nov 18, 2007 1:35 am

I have this message when i want to update characters in my guild roster:

roster version 1.9.9.1432.

No problem with the previous version 1.9.9.1418

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 'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guil
SQL:
SELECT `guild_id` FROM `roster2_guild` WHERE `server` = 'Ner'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guild_name` LIKE 'guildless-%';
File: lib/dbal/mysql.php
Line: 207
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 240
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 207
          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 'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guil
                + Database Error
                + /../roster/lib/dbal/mysql.php
                + 207
                + SELECT `guild_id` FROM `roster2_guild` WHERE `server` = 'Ner'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guild_name` LIKE 'guildless-%';
    * lib/dbal/mysql.php
          o Line: 222
          o Function Called: query
          o Arguments:
                + SELECT `guild_id` FROM `roster2_guild` WHERE `server` = 'Ner'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guild_name` LIKE 'guildless-%';
    * lib/update.lib.php
          o Line: 2460
          o Function Called: query_first
          o Arguments:
                + SELECT `guild_id` FROM `roster2_guild` WHERE `server` = 'Ner'zhul' AND `region` = 'EU' AND `factionEn` = 'Alliance' AND `guild_name` LIKE 'guildless-%';
    * lib/update.lib.php
          o Line: 556
          o Function Called: remove_guild_members
          o Arguments:
                + 1
                + 1195300756
    * lib/update.lib.php
          o Line: 193
          o Function Called: processguildroster
    * pages/update.php
          o Line: 41
          o Function Called: processfiles
    * index.php
          o Line: 83
          o Function Called: require
          o Arguments:
                + /homepages/26/d145942875/htdocs/Shamerims/roster/pages/update.php
Last edited by Anthara on Sun Dec 02, 2007 5:02 pm, edited 3 times in total.
Anthara
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Apr 02, 2007 3:38 pm

sql error

Postby dreinoga » Tue Nov 20, 2007 2:29 pm

I have this error too, for "Aman'Thul" server

there was a fix for it posted for an earlier version, but it does not match up with current files........

Thanks
dreinoga
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Dec 10, 2006 11:06 pm

sql error

Postby PleegWat » Tue Nov 20, 2007 4:38 pm

Fixed SVN 1445. Usually if this error crops again it's the same bug in a different place, please report any you find.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron