Sign in to follow this  
TheRake1993

Problema Mysql

13 posts in this topic

Buna ziua ,azi mi-am luat un GM de la Edison acel Burned si nu merge sa ma loghez..intru pe server pun parola si imi zice ca parola este gresita

 

Logs

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[13:00:27] 
[13:00:27] Server Plugins
[13:00:27] --------------
[13:00:27]  Loading plugin: crashdetect.so
[13:00:27]   CrashDetect v4.15.1 is OK.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: nativechecker.so
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: sscanf.so
[13:00:27] 

[13:00:27]  ===============================

[13:00:27]       sscanf plugin loaded.     

[13:00:27]          Version:  2.8.1        

[13:00:27]    (c) 2012 Alex "Y_Less" Cole  

[13:00:27]  ===============================

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql.so
[13:00:27]  >> plugin.mysql: R34 successfully loaded.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: streamer.so
[13:00:27] 

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

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql_static.so
[13:00:27]   Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)
[13:00:27]  Loaded 5 plugins.

[13:00:27] 
[13:00:27] Filterscripts
[13:00:27] ---------------
[13:00:27]   Loaded 0 filterscripts.

[13:00:28]    Error: Function not registered: 'cache_get_row_count'
[13:00:28]    Error: Function not registered: 'cache_get_field_content'
[13:00:28]    Error: Function not registered: 'cache_get_field_count'
[13:00:28]    Error: Function not registered: 'cache_get_row'
[13:00:28]    Error: Function not registered: 'CreateDynamicRectangle'
[13:00:28]    Error: Function not registered: 'SSCANF_Init'
[13:00:28]    Error: Function not registered: 'SSCANF_IsConnected'
[13:00:28]    Error: Function not registered: 'SSCANF_Join'
[13:00:28]    Error: Function not registered: 'SSCANF_Leave'
[13:00:28]    Error: Function not registered: 'mysql_query'
[13:00:28]    Error: Function not registered: 'CreateDynamicObject'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterial'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterialText'
[13:00:28]    Error: Function not registered: 'CreateDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'CreateDynamicMapIcon'
[13:00:28]    Error: Function not registered: 'CreateDynamicPickup'
[13:00:28]    Error: Function not registered: 'mysql_close'
[13:00:28]    Error: Function not registered: 'mysql_log'
[13:00:28]    Error: Function not registered: 'mysql_connect'
[13:00:28]    Error: Function not registered: 'cache_delete'
[13:00:28]    Error: Function not registered: 'DestroyDynamicObject'
[13:00:28]    Error: Function not registered: 'mysql_format'
[13:00:28]    Error: Function not registered: 'mysql_tquery'
[13:00:28]    Error: Function not registered: 'cache_insert_id'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectPos'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectRot'
[13:00:28]    Error: Function not registered: 'AttachDynamicObjectToVehicle'
[13:00:28]    Error: Function not registered: 'MoveDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamicPickup'
[13:00:28]    Error: Function not registered: 'sscanf'
[13:00:28]    Error: Function not registered: 'EditDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'mysql_escape_string'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_int'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_float'
[13:00:28]    Error: Function not registered: 'mysql_unprocessed_queries'
[13:00:28]    Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[13:00:28]  
[13:00:28]  
[13:00:28]  
[13:00:28]  ======================================= 
[13:00:28]  |                                     | 
[13:00:28]  |        YSI version 3.09.0684        | 
[13:00:28]  |        By Alex "Y_Less" Cole        | 
[13:00:28]  |                                     | 
[13:00:28]  ======================================= 
[13:00:28]  
[13:00:28] Server: hosted
[13:00:28] Server vehicles: 0
[13:00:28] Safezones: 0
[13:00:28] Houses: 0
[13:00:28] Clans: 0
[13:00:28] Clan zones: 0
[13:00:28] Bussines: 0
[13:00:28] Turfs: 0
[13:00:28] Factions: 0
[13:00:28] Jobs: 0
[13:00:28] Furnitures: 0
[13:00:28] Stuff Loaded
[13:00:28] Safes: 0
[13:00:28] Number of vehicle models: 18
[13:00:28] ====================================================================
[13:00:28] Error ID: 2006, Error: MySQL server has gone away
[13:00:28] Callback: LoadDSVeh
[13:00:28] gQuery: SELECT * FROM `dsveh`
[13:00:28] ====================================================================

iar aici server.cfg

Quote

echo Executing Server Config...
lanmode 0
rcon_password movdDtdone
maxplayers 50
bind 89.79.15.129
port 7777
hostname This server is managed with GameCP
gamemode0 wa-rpg
plugins crashdetect.so nativechecker.so sscanf.so mysql.so streamer.so mysql_static.so
announce 0 
query 1
weburl $WEBSITE
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000

Putin ajutor va rog !

Share this post


Link to post
Share on other sites
7 minutes ago, TheRake1993 said:

Buna ziua ,azi mi-am luat un GM de la Edison acel Burned si nu merge sa ma loghez..intru pe server pun parola si imi zice ca parola este gresita

 

Logs

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[13:00:27] 
[13:00:27] Server Plugins
[13:00:27] --------------
[13:00:27]  Loading plugin: crashdetect.so
[13:00:27]   CrashDetect v4.15.1 is OK.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: nativechecker.so
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: sscanf.so
[13:00:27] 

[13:00:27]  ===============================

[13:00:27]       sscanf plugin loaded.     

[13:00:27]          Version:  2.8.1        

[13:00:27]    (c) 2012 Alex "Y_Less" Cole  

[13:00:27]  ===============================

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql.so
[13:00:27]  >> plugin.mysql: R34 successfully loaded.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: streamer.so
[13:00:27] 

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

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql_static.so
[13:00:27]   Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)
[13:00:27]  Loaded 5 plugins.

[13:00:27] 
[13:00:27] Filterscripts
[13:00:27] ---------------
[13:00:27]   Loaded 0 filterscripts.

[13:00:28]    Error: Function not registered: 'cache_get_row_count'
[13:00:28]    Error: Function not registered: 'cache_get_field_content'
[13:00:28]    Error: Function not registered: 'cache_get_field_count'
[13:00:28]    Error: Function not registered: 'cache_get_row'
[13:00:28]    Error: Function not registered: 'CreateDynamicRectangle'
[13:00:28]    Error: Function not registered: 'SSCANF_Init'
[13:00:28]    Error: Function not registered: 'SSCANF_IsConnected'
[13:00:28]    Error: Function not registered: 'SSCANF_Join'
[13:00:28]    Error: Function not registered: 'SSCANF_Leave'
[13:00:28]    Error: Function not registered: 'mysql_query'
[13:00:28]    Error: Function not registered: 'CreateDynamicObject'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterial'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterialText'
[13:00:28]    Error: Function not registered: 'CreateDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'CreateDynamicMapIcon'
[13:00:28]    Error: Function not registered: 'CreateDynamicPickup'
[13:00:28]    Error: Function not registered: 'mysql_close'
[13:00:28]    Error: Function not registered: 'mysql_log'
[13:00:28]    Error: Function not registered: 'mysql_connect'
[13:00:28]    Error: Function not registered: 'cache_delete'
[13:00:28]    Error: Function not registered: 'DestroyDynamicObject'
[13:00:28]    Error: Function not registered: 'mysql_format'
[13:00:28]    Error: Function not registered: 'mysql_tquery'
[13:00:28]    Error: Function not registered: 'cache_insert_id'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectPos'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectRot'
[13:00:28]    Error: Function not registered: 'AttachDynamicObjectToVehicle'
[13:00:28]    Error: Function not registered: 'MoveDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamicPickup'
[13:00:28]    Error: Function not registered: 'sscanf'
[13:00:28]    Error: Function not registered: 'EditDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'mysql_escape_string'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_int'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_float'
[13:00:28]    Error: Function not registered: 'mysql_unprocessed_queries'
[13:00:28]    Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[13:00:28]  
[13:00:28]  
[13:00:28]  
[13:00:28]  ======================================= 
[13:00:28]  |                                     | 
[13:00:28]  |        YSI version 3.09.0684        | 
[13:00:28]  |        By Alex "Y_Less" Cole        | 
[13:00:28]  |                                     | 
[13:00:28]  ======================================= 
[13:00:28]  
[13:00:28] Server: hosted
[13:00:28] Server vehicles: 0
[13:00:28] Safezones: 0
[13:00:28] Houses: 0
[13:00:28] Clans: 0
[13:00:28] Clan zones: 0
[13:00:28] Bussines: 0
[13:00:28] Turfs: 0
[13:00:28] Factions: 0
[13:00:28] Jobs: 0
[13:00:28] Furnitures: 0
[13:00:28] Stuff Loaded
[13:00:28] Safes: 0
[13:00:28] Number of vehicle models: 18
[13:00:28] ====================================================================
[13:00:28] Error ID: 2006, Error: MySQL server has gone away
[13:00:28] Callback: LoadDSVeh
[13:00:28] gQuery: SELECT * FROM `dsveh`
[13:00:28] ====================================================================

iar aici server.cfg

Putin ajutor va rog !

Ai controlat daca ai conectat bine baza de date in pawno sau sau daca tabelele corespund?

Share this post


Link to post
Share on other sites
Posted (edited)
Quote

public OnGameModeExit() {
    if(SERVER_HOSTSTATUS == 1) {
        mysql_query(SQL, "UPDATE `users` SET `Status` = '0' WHERE `Status` = '1'");
        mysql_close(SQL);
    }
    DestroyActor(SpawnActor);
    return 1;
}

public OnGameModeInit()
{
    mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    
    if(SERVER_HOSTSTATUS == 1) SQL = mysql_connect("89.59.53.129", "samp1", "samp1", "TEST"), print("Server: hosted"

Tin sa retin ca este pe host acest server

Acesta este in pawn

Edited by TheRake1993
Am uitat sa mentionez ca e in pawn

Share this post


Link to post
Share on other sites
26 minutes ago, TheRake1993 said:

Tin sa retin ca este pe host acest server

Acesta este in pawn

Ma refer datele bazei, sunt bine trecuta? IP, Hostname,  Password, acele date ce le pui cand te loghiezi  pe PHPMyAdmin

Share this post


Link to post
Share on other sites

Da sunt bune , de 2 zile ma chinui cu el si nimic , nu inteleg care este problema.

Share this post


Link to post
Share on other sites
1 minute ago, TheRake1993 said:

Da sunt bune , de 2 zile ma chinui cu el si nimic , nu inteleg care este problema.

Daca sunt bine asigura-te ca tabelele sunt exact ca in GM. De exemplu: "UPDATE`users` SET `Status` = '0' WHERE sa nu ai tu tabelul numit Players in loc de users

Share this post


Link to post
Share on other sites
Posted (edited)

Am verificat si este users

Vad ca totul este in ordine..nu inteleg problema..

Edited by TheRake1993
PS

Share this post


Link to post
Share on other sites

Ce rol are asta? 

 

SERVER_HOSTSTATUS

Share this post


Link to post
Share on other sites

#define NORMAL 1
#define LOCALHOST 2
new SERVER_HOSTSTATUS = NORMAL;
 Asta

Share this post


Link to post
Share on other sites

Acuma vad, ce cauta asta:

 

 if(SERVER_HOSTSTATUS == 1) SQL = mysql_connect("89.59.53.129", "samp1", "samp1", "TEST"), print("Server: hosted"

 

 

In OnGameModeExit??

trebue sa fie in OnGameModeInit

Share this post


Link to post
Share on other sites
Posted (edited)

public OnGameModeInit() {
    if(SERVER_HOSTSTATUS == 1) {
        mysql_query(SQL, "UPDATE `users` SET `Status` = '0' WHERE `Status` = '1'");
        mysql_close(SQL);
    }
    DestroyActor(SpawnActor);
    return 1;
}

public OnGameModeInit()
{
    mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    
    if(SERVER_HOSTSTATUS == 1) SQL = mysql_connect("89.39.13.129", "samp_4907", "samp_4907", "SatuMare1793.daus1tr3imici"), print("Server: hosted");
 

unde mai exact ?

 

Sunt 2 OnGameInit

Edited by TheRake1993
PS

Share this post


Link to post
Share on other sites

Aici sta problema, sunt 2.... trebue sa fie 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.