Započeo SrkiYT
•25. Apr. 2020.Pomoc Oko Povezivanja DB
841
pregleda
5
postova
2
Street Runner
Balkan SA:MP
SA-MP Doprinos
Balkan SA:MPSA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
11
Postovi:
3
Teme:
Pridružio se:Jan. 2018
25. Apr. 2020.
Problem(error/warning): na kucnom serveru se sve lepo spoji na db ali nmg nikako spojiti na db od hosta
Dio skripte:
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
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
6
GodfatherBalkan SA:MPSA-MP Doprinos
Balkan SA:MPSA-MP DoprinosAktivan Član
17 / 250 XP
Početnik(1)
2,272
Postovi:
76
Teme:
Pridružio se:Maj 2014
25. Apr. 2020.
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
2
Street RunnerBalkan SA:MPSA-MP Doprinos
Balkan SA:MPSA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
11
Postovi:
3
Teme:
Pridružio se:Jan. 2018
25. Apr. 2020.
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"; //1296
GodfatherBalkan SA:MPSA-MP Doprinos
Balkan SA:MPSA-MP DoprinosAktivan Član
17 / 250 XP
Početnik(1)
2,272
Postovi:
76
Teme:
Pridružio se:Maj 2014
25. Apr. 2020.
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"; //129Logicno ti je, stavio si 1 karakter, iako ih imas vise..
2
Street RunnerBalkan SA:MPSA-MP Doprinos
Balkan SA:MPSA-MP DoprinosNovi Član
90 / 100 XP
Početnik(0)
11
Postovi:
3
Teme:
Pridružio se:Jan. 2018
25. Apr. 2020.
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"; //129Logicno ti je, stavio si 1 karakter, iako ih imas vise..
Hvala .lock
Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava