1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
server hangs during mysql query
DetoNater
Huge Clucker
****
Posts: 253
Threads: 65
Joined: Feb 2013
Reputation: 0
#1

29.06.2015, 13:20
This is my error when I create a clan, the server hangs in the middle!! I dunno whether the query
is bugged or my code is bugged!


Код:
Mysql Log:
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
[19:05:44] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "[BS]"
[19:05:44] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 10
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#2

29.06.2015, 14:01
Please show your code.
Find
Reply
DetoNater
Huge Clucker
****
Posts: 253
Threads: 65
Joined: Feb 2013
Reputation: 0
#3

29.06.2015, 18:47
Код:
case 2002: //add clan
	    {
	        if(response)
	        {
	            new query[300];
	            mysql_query(mysql,"SELECT * FROM `clans`");//,true,"","");
	            if(cache_num_rows() >= 30) return SendLangMessage(playerid,0xFF0000FF,"Es kцnnen nur 30 Clans existieren!","There can be only 30 Clans!","Solo puede haber 30 clanes!");
	            new length = strlen(inputtext);
	            if(length < 3 || length > 7) return SendLangMessage(playerid,0xFF0000FF,"Der Tag muss zwischen 3 und 6 Buchstaben haben. Beispiel: [TAG]","Tag must be between 3 and 6 characters. Example: [TAG]","La etiqueta debe tener entre 3 y 6 caracteres. Ejemplo: [TAG]");
	            if(strcmp(inputtext[0], "[", true, 1) || strcmp(inputtext[length-1], "]", true, 1)) return SendLangMessage(playerid,0xFF0000FF,"Der Tag muss geschlossen sein in Klammern. Beispiel: [TAG]","Tag must be inclosed in brackets. Example: [TAG]","La etiqueta debe ir entre corchetes. Ejemplo: [TAG]");
	            if(strfind(inputtext, " ", true) != -1) return SendLangMessage(playerid,0xFF0000FF,"Der Tag kann nicht Leerrдume besitzen!","Tag can not contain spaces!","La etiqueta no puede contener espacios!");
                if(cache_num_rows() > 0) return SendLangMessage(playerid,0xFF0000FF,"Dieser Clan existiert bereits!","This Clan already exists!","Este clan ya existe!");
			    mysql_format(mysql,query,sizeof(query),"SELECT * FROM `clans` WHERE `clan` = '%s'",inputtext);
	            mysql_query(mysql,query);//,true,"","");
				mysql_format(mysql,query,sizeof(query),"INSERT INTO `clans` (`clan`,`Clanscore`,`Tempscore`,`Info`,`Clanowner`,`Permission1`,`Permission2`,`Permission3`,`Permission4`,`Permission5`,`Permission6`,`woncws`,`lostcws`) VALUES ('%s',0,0,'No Info',0,5,5,5,5,5,5,0,0)",inputtext);
	            mysql_query(mysql,query);//,false,"","");
 				createClanDialog(playerid);
	        }
	        else
	        {
	            createClanDialog(playerid);
	        }
			return 1;
		}
Find
Reply
[DOG]irinel1996
High-roller
*****
Posts: 1,469
Threads: 62
Joined: Jan 2010
Reputation: 0
#4

29.06.2015, 19:02
You have to improve your MySQL definetly... check this.
Find
Reply
Younes44
Gangsta
*****
Posts: 763
Threads: 31
Joined: Oct 2013
Reputation: 0
#5

30.06.2015, 08:40
Quote:
Originally Posted by DetoNater
Посмотреть сообщение
Код:
case 2002: //add clan
	    {
	        if(response)
	        {
	            new query[300];
	            mysql_query(mysql,"SELECT * FROM `clans`");//,true,"","");
	            if(cache_num_rows() >= 30) return SendLangMessage(playerid,0xFF0000FF,"Es kцnnen nur 30 Clans existieren!","There can be only 30 Clans!","Solo puede haber 30 clanes!");
	            new length = strlen(inputtext);
	            if(length < 3 || length > 7) return SendLangMessage(playerid,0xFF0000FF,"Der Tag muss zwischen 3 und 6 Buchstaben haben. Beispiel: [TAG]","Tag must be between 3 and 6 characters. Example: [TAG]","La etiqueta debe tener entre 3 y 6 caracteres. Ejemplo: [TAG]");
	            if(strcmp(inputtext[0], "[", true, 1) || strcmp(inputtext[length-1], "]", true, 1)) return SendLangMessage(playerid,0xFF0000FF,"Der Tag muss geschlossen sein in Klammern. Beispiel: [TAG]","Tag must be inclosed in brackets. Example: [TAG]","La etiqueta debe ir entre corchetes. Ejemplo: [TAG]");
	            if(strfind(inputtext, " ", true) != -1) return SendLangMessage(playerid,0xFF0000FF,"Der Tag kann nicht Leerrдume besitzen!","Tag can not contain spaces!","La etiqueta no puede contener espacios!");
                if(cache_num_rows() > 0) return SendLangMessage(playerid,0xFF0000FF,"Dieser Clan existiert bereits!","This Clan already exists!","Este clan ya existe!");
			    mysql_format(mysql,query,sizeof(query),"SELECT * FROM `clans` WHERE `clan` = '%s'",inputtext);
	            mysql_query(mysql,query);//,true,"","");
				mysql_format(mysql,query,sizeof(query),"INSERT INTO `clans` (`clan`,`Clanscore`,`Tempscore`,`Info`,`Clanowner`,`Permission1`,`Permission2`,`Permission3`,`Permission4`,`Permission5`,`Permission6`,`woncws`,`lostcws`) VALUES ('%s',0,0,'No Info',0,5,5,5,5,5,5,0,0)",inputtext);
	            mysql_query(mysql,query);//,false,"","");
 				createClanDialog(playerid);
	        }
	        else
	        {
	            createClanDialog(playerid);
	        }
			return 1;
		}
is this the full code ??
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help