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

Threaded Mode
problem in mysql or gamemode !
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#1

17.06.2014, 18:27
salut guys

this my problem guys

i cant login player in server the server tell me this account is registered but am not register !
this problem in gamemode or mysql

i use mysql r5 in server ubuntu

all include 0.3z

Код:
> mysql_query( Connection handle: 1 )
[00:19:22] CMySQLHandler::Query(SELECT * FROM `Bans` WHERE `Username`='sam' LIMIT 1) - An error has occured. (Error ID: 1146, Table 're.Bans' doesn't exist)
[00:19:22] >> mysql_store_result( Connection handle: 1 )
[00:19:22] CMySQLHandler::StoreResult() - No data to store.
[00:19:22] >> mysql_num_rows( Connection handle: 1 )
[00:19:22] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(BanID) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Admin) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Time) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Reason) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Minutes) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Hours) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Days) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_fetch_field_row( Connection handle: 1 )
[00:19:22] CMySQLHandler::FetchField(Unix) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[00:19:22] >> mysql_free_result( Connection handle: 1 )
[00:19:22] CMySQLHandler::FreeResult() - The result is already empty.
[00:19:22] >> mysql_query( Connection handle: 1 )
[00:19:22] CMySQLHandler::Query(DELETE FROM `Bans` WHERE `BanID`='0') - An error has occured. (Error ID: 1146, Table 're.Bans' doesn't exist)
[00:19:22] >> mysql_query( Connection handle: 1 )
[00:19:22] CMySQLHandler::Query(SELECT * FROM `Accounts` WHERE `Username`='sam' LIMIT 1) - An error has occured. (Error ID: 1146, Table 're.Accounts' doesn't exist)
[00:19:22] >> mysql_store_result( Connection handle: 1 )
[00:19:22] CMySQLHandler::StoreResult() - No data to store.
[00:19:22] >> mysql_num_rows( Connection handle: 1 )
[00:19:22] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[00:19:22] >> mysql_free_result( Connection handle: 1 )
[00:19:22] CMySQLHandler::FreeResult() - The result is already empty.
[00:19:22] >> mysql_query( Connection handle: 1 )
[00:19:22] CMySQLHandler::Query(INSERT INTO `Connections` (`Username`, `UserIP`, `Type`, `Success`) VALUES ('sam', '125.22.155.110', 'Just connected', 'N/A')) - An error has occured. (Error ID: 1146, Table 're.Connections' doesn't exist)
[00:19:31] >> mysql_query( Connection handle: 1 )
[00:19:31] CMySQLHandler::Query(UPDATE `Accounts` SET `Admin`='0', `Score`='0', `Money`='0', `Kills`='0', `Deaths`='0' WHERE `Username`='sam') - An error has occured. (Error ID: 1146, Table 're.Accounts' doesn't exist)
[00:25:51] >> mysql_close( Connection handle: 1 )
[00:25:51] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[00:25:51] CMySQLHandler::FreeResult() - The result is already empty.
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#2

17.06.2014, 18:44
salut ******
how to fix !
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#3

17.06.2014, 18:51
How and where start
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#4

17.06.2014, 18:57
mysql is correct bro

not have error here
Код:
public OnPlayerConnect(playerid)
{
    Spectating[playerid] = -1;
    OnPlayerBanCheck(playerid);
	new query[200], string[200];
	gPlayerLogged[playerid] = 0;
	gPlayerAdminLogged[playerid] = 0;
	GetPlayerName(playerid, sendername, sizeof(sendername));
	GetPlayerIp(playerid, senderip, sizeof(senderip));
	format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Username`='%s' LIMIT 1", sendername);
	mysql_query(query);
	mysql_store_result();
	new rows = mysql_num_rows();
    if(!rows)
    {
		format(string, sizeof(string), "Welcome %s, you are not registered on this server, to register an account please type /register [password].", sendername);
		SendClientMessage(playerid, COLOR_WHITE, string);
		format(string, sizeof(string), "You don't have to register an account to play, but if you do, it brings a whole lot of new features and is highly recommended.");
		SendClientMessage(playerid, COLOR_WHITE, string);
		gPlayerRegistered[playerid] = 0;
		mysql_free_result();
	}
	else
	{
	    format(string, sizeof(string), "Welcome back %s, this account is registered on this server, you can log in by typing /login [password].", sendername);
		SendClientMessage(playerid, COLOR_WHITE, string);
		format(string, sizeof(string), "If you are not %s, please quit the game and choose a different name to play with.", sendername);
		SendClientMessage(playerid, COLOR_WHITE, string);
		gPlayerRegistered[playerid] = 1;
		mysql_free_result();
	}
	format(query, sizeof(query), "INSERT INTO `Connections` (`Username`, `UserIP`, `Type`, `Success`) VALUES ('%s', '%s', 'Just connected', 'N/A')", sendername, senderip);
	mysql_query(query);
	format(string, sizeof(string), "{AFAFAF}%s (%d) has just connected.", sendername, playerid);
	SendClientMessageToAll(COLOR_WHITE, string);
	SetPlayerColor(playerid, COLOR_GREY);
	gSpawned[playerid] = 0;
	UpdateSpeed[playerid] = false;
    SpdObj[playerid][0] = INVALID_OBJECT_ID;
    SpdObj[playerid][1] = INVALID_OBJECT_ID;
    gAdminOnDuty[playerid] = 0;
    gWarns[playerid] = 0;
    PlayerVehicle[playerid] = 0;
    UsingPersonalSkin[playerid] = 0;
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#5

17.06.2014, 19:15
so this all error came from connection mysql !

how to test my mysql connected or no

and Knowing that everything is connected (plugins and nativecheaker etc ..)


Код:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[00:17:42] filterscripts = ""  (string)
[00:17:42] 
[00:17:42] Server Plugins
[00:17:42] --------------
[00:17:42]  Loading plugin: streamer.so
[00:17:42] 

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[00:17:42]   Loaded.
[00:17:42]  Loading plugin: sscanf.so
[00:17:42] 

[00:17:42]  ===============================

[00:17:42]       sscanf plugin loaded.     

[00:17:42]          Version:  2.8.1        

[00:17:42]    © 2012 Alex "******" Cole  

[00:17:42]  ===============================

[00:17:42]   Loaded.
[00:17:42]  Loading plugin: mysql.so
[00:17:42] 

  > MySQL plugin R5 successfully loaded.

[00:17:42]   Loaded.
[00:17:42]  Loading plugin: nativechecker.so
[00:17:42]   Loaded.
[00:17:42]  Loading plugin: crashdetect.so
[00:17:42]   CrashDetect v4.13.1 is OK.
[00:17:42]   Loaded.
[00:17:42]  Loaded 5 plugins.

[00:17:42] 
[00:17:42] Filterscripts
[00:17:42] ---------------
[00:17:42]   Loaded 0 filterscripts.

[00:17:42] OnGameo
[00:17:42]  
[00:17:42]  
[00:17:42]  
[00:17:42]  ======================================= 
[00:17:42]  |                                     | 
[00:17:42]  |        YSI version 1.06.0002        | 
[00:17:42]  |        By Alex "******" Cole        | 
[00:17:42]  |                                     | 
[00:17:42]  ======================================= 
[00:17:42]  
[00:17:42]  
[00:17:42]  
[00:17:43] 
----------------------------------
[00:17:43]  Gaming ----- Team Deathmatch
[00:17:43] -----------By DanishHaq------------

[00:17:43] Number of vehicle models: 24
[00:17:43]  
[00:17:43]  ========================================== 
[00:17:43]  |                                        | 
[00:17:43]  |  A new version (v3.09.0684) of YSI is  | 
[00:17:43]  |            available from:             | 
[00:17:43]  |                                        | 
[00:17:43]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[00:17:43]  |                                        | 
[00:17:43]  | Changelog:                             | 
[00:17:43]  |                                        | 
[00:17:43]  |   3.00.0000:                           | 
[00:17:43]  |                                        | 
[00:17:43]  |   YSI 3.0 released!  Now includes the  | 
[00:17:43]  | "y_text" library for better messages,  | 
[00:17:43]  | and a reworked "y_classes" library.    | 
[00:17:43]  | Largely documented here                | 
[00:17:43]  | "http://forum.sa-mp.com/showthread.php | 
[00:17:43]  | ?t=321092".                            | 
[00:17:43]  |                                        | 
[00:17:43]  |   3.01.0002:                           | 
[00:17:43]  |                                        | 
[00:17:43]  |   Small fixes to "y_text" and          | 
[00:17:43]  | "y_classes".                           | 
[00:17:43]  |                                        | 
[00:17:43]  |   3.09.0684:                           | 
[00:17:43]  |                                        | 
[00:17:43]  |   Reverted to old download location.   | 
[00:17:43]  | Improved (and fixed) version checks;   | 
[00:17:43]  | added y_bitmap, y_areas, y_races,      | 
[00:17:43]  | y_zonenames, better documentation;     | 
[00:17:43]  | MANY other bug fixes - see the github  | 
[00:17:43]  | repository for more details:           | 
[00:17:43]  |                                        | 
[00:17:43]  ==========================================
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

17.06.2014, 19:46
Read the errors in the mysql log, they're self-explanatory:

An error has occured. (Error ID: 1146, Table 're.Bans' doesn't exist)
An error has occured. (Error ID: 1146, Table 're.Accounts' doesn't exist)
An error has occured. (Error ID: 1146, Table 're.Connections' doesn't exist)

Create the necessary tables and fields for the database.
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#7

17.06.2014, 19:50
tables and fields is created but Empty

why get error !
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#8

17.06.2014, 20:37
salut ******

i think problem in plugin mysql not compatible with ubuntu 10.04

plz i need plugin mysql r5 compatible with ubuntu 10.04
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#9

17.06.2014, 20:48
to compatible with gm
give me last version worked with ubuntu 10.04
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#10

17.06.2014, 21:09
now i cant upgrade version

help me to run plugin mysql on 10.04

give me the version plugin mysql that works with 10.04
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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