GTA:BLKN
PRIJAVA REGISTRACIJA

Pomoc Oko Povezivanja DB

Započeo SrkiYT
• pre 5 godina
741
pregleda
5
postova
SrkiYT
SrkiYT
Street Runner
pre 5 godina
#1
Problem(error/warning): na kucnom serveru se sve lepo spoji na db ali nmg nikako spojiti na db od hosta
Dio skripte: 
const MYSQL_STATE = 						(0);

#if MYSQL_STATE == 0
	static const MYSQL_HOST =			"localhost";
	static const MYSQL_USER =			"root";
	static const MYSQL_PASS =			"";
	static const MYSQL_DB =				"v_db";
#else
 	static const MYSQL_HOST =			"localhost";
	static const MYSQL_USER =			"srv_1087733_JhQ";
	static const MYSQL_DB =				"srv_1087733_JhQ";
	static const MYSQL_PASS =			"na0Gv24FGd0azlQe";
#endif

new mSQL;

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [ code ][10:13:51 04/25/20] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: NO)
[10:15:03 04/25/20] mysql_format - invalid connection handle (id: 0)
[10:15:03 04/25/20] mysql_tquery - invalid connection handle (id: 0)[ /code ]
Slika/video ingame problema(obavezno ako je ingame problem):https://prntscr.com/s4sujp
Skrilew
V01D
Godfather
pre 5 godina
#2 
const MYSQL_STATE = 						(0);


Vidis da je stavljeno na 0, pritom je constanta tako da se njena vrednost ne moze promeniti. Kada koristis bazu od nekog VPS-a, stavi vrednost na 1
SrkiYT
SrkiYT
Street Runner
pre 5 godina
#3
V01D wrote on April 25, 2020, 11:23 am:
const MYSQL_STATE = 						(0);


Vidis da je stavljeno na 0, pritom je constanta tako da se njena vrednost ne moze promeniti. Kada koristis bazu od nekog VPS-a, stavi vrednost na 1

onda dobijam ove errore
C:\Users\srdja\Desktop\V-RP\gamemode\gamemodes\v_Script.pwn(126) : error 018: initialization data exceeds declared size
C:\Users\srdja\Desktop\V-RP\gamemode\gamemodes\v_Script.pwn(127) : error 018: initialization data exceeds declared size
C:\Users\srdja\Desktop\V-RP\gamemode\gamemodes\v_Script.pwn(12😎 : error 018: initialization data exceeds declared size
C:\Users\srdja\Desktop\V-RP\gamemode\gamemodes\v_Script.pwn(129) : error 018: initialization data exceeds declared size
Pawn compiler 3.10.4 Copyright (c) 1997-2006, ITB CompuPhase

4 Errors.
 	static const MYSQL_HOST =			"localhost"; //126
	static const MYSQL_USER =			"srv_1087733_JhQ"; //127
	static const MYSQL_DB =				"srv_1087733_JhQ"; //128
	static const MYSQL_PASS =			"na0Gv24FGd0azlQe"; //129
Skrilew
V01D
Godfather
pre 5 godina
#4 
static const MYSQL_HOST =			"localhost"; //126
	static const MYSQL_USER =			"srv_1087733_JhQ"; //127
	static const MYSQL_DB =				"srv_1087733_JhQ"; //128
	static const MYSQL_PASS =			"na0Gv24FGd0azlQe"; //129


Logicno ti je, stavio si 1 karakter, iako ih imas vise..
SrkiYT
SrkiYT
Street Runner
pre 5 godina
#5
V01D wrote on April 25, 2020, 12:17 pm:
static const MYSQL_HOST =			"localhost"; //126
	static const MYSQL_USER =			"srv_1087733_JhQ"; //127
	static const MYSQL_DB =				"srv_1087733_JhQ"; //128
	static const MYSQL_PASS =			"na0Gv24FGd0azlQe"; //129


Logicno ti je, stavio si 1 karakter, iako ih imas vise..

Hvala .lock

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava