Shinobi Legends Forum - Shinobi Legends Game Site

Please login or register.

Login with username, password and session length
Advanced search  

News:

Please report outages in the thread "messages/server outages", Thanks.

Pages: 1 [2]

Author Topic: No more SL????  (Read 5356 times)

Asadi

  • Site Staff (Game Master)
  • Hero Member
  • ****
  • Karma: +6/-1
  • Offline Offline
  • Posts: 608
    • View Profile
Re: No more SL????
« Reply #15 on: July 11, 2012, 05:19:12 PM »

SELECT name,CAST((goldinbank+gold+round((((rand()*10)-5)/100)*(goldinbank+gold))) as signed) AS data1 FROM accounts WHERE (locked=0 AND (superuser & 526817) = 0) ORDER BY data1 DESC, level DESC, experience DESC, acctid DESC LIMIT 0,50

BIGINT UNSIGNED value is out of range in '(`naruto`.`accounts`.`goldinbank` + `naruto`.`accounts`.`gold`)'
Call Stack:
1: db_query("SELECT name,CAST((goldinb...") called from /var/www/html/naruto/hof.php on line 108
2: display_table("The richest warriors in t...", "SELECT name,CAST((goldinb...", false, "(Gold Amount is accurate ...", Array(

    0=>"Estimated Gold"

), Array(

    0=>"gold"

)) called from on line
3: call_user_func_array("display_table", Array(

    0=>"The richest warriors in t...", 1=>"SELECT name,CAST((goldinb...", 2=>false, 3=>"(Gold Amount is accurate ...", 4=>Array(

        0=>"Estimated Gold"

    ), 5=>Array(

        0=>"gold"

    )

)) called from /var/www/html/naruto/hof.php on line 232
Logged

Neji

  • Administrator
  • Hero Member
  • *****
  • Karma: +459/-86
  • Offline Offline
  • Posts: 7113
    • View Profile
Re: No more SL????
« Reply #16 on: July 12, 2012, 12:49:45 PM »

Thanks, nice catch.

Mysql 5.5 is stricter than 5.1 in some queries ;)
Logged
Never judge a cow by its udder.
Pages: 1 [2]
 

Page created in 0.038 seconds with 19 queries.