Too many columns, discarding last 1 column [Solved]

[Oceanid 1]

I made a script to look up a players account information but it only works when I type in my own character name. For anyone else the map server displays the "Too many columns, discarding last 1 column" error. It can't seem to find the account id so it defaults to 0 and can't pull any of the account information. Anyone know why this is?

 

This is the bit of code that checks for a matching account id in the db:

 

if(!query_sql("SELECT `account_id` FROM `login` WHERE `account_id` ='"+getcharid( 3,.@name$ )+"'")) {
		mes "[Account Manager]";
		mes "There is no character matching " +.@name$+ ".";
		mes "Would you like to re-enter the name?";
		switch(select("Yes:No")) {
			case 1:
				callsub CHARACTER;
				next;
			case 2:
				close;
		}
	}

 

Edited April 14, 2016 by Oceanid

[Sephus 203]

query_sql requires you to pass variables for every coloumn that you want selected. so try 

if(!query_sql("SELECT account_id ...",.@accountId)) { // parse };