GTA:BLKN

[POMOC] Oko mysql upisivanja

Započeo Ciger
•5. Okt. 2016.
1,517
pregleda
15
postova
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#1
Skripta koju koristim:moja
Detaljan opis problema: Izbacuje mi erore da je predugacko, ja ga rastavim i onda nece da upisuje kad se registrujem to jest kad ukucam sifru
Dio skripte:

  			    new query, pass;
				HashingPassword(pass, sizeof (pass), inputtext);
				mysql_format(mysql, query, sizeof(query), "INSERT INTO `Accounts` ( `Username`, `Password`, `Level`, `Money`, `Exp`, `SatiIgre`, `Admin`, `Helper`, `Skin`, `PayDayPoeni`, `BankaKartica`, `BankaMoney`, `Posao`) VALUES ",query);
				mysql_format(mysql, query, sizeof(query), "%s ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",query,GetName(playerid),pass,PlayerInfo, PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo, PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo);
				mysql_tquery(mysql, query, "RegisterAccountInfo", "i", playerid);

D:\mysql server\gamemodes\RGRP.pwn(1557) : error 075: input line too long (after substitutions)
D:\mysql server\gamemodes\RGRP.pwn(1558) : error 017: undefined symbol "playeri"
D:\mysql server\gamemodes\RGRP.pwn(1559) : warning 217: loose indentation
D:\mysql server\gamemodes\RGRP.pwn(1559) : error 017: undefined symbol "d"
D:\mysql server\gamemodes\RGRP.pwn(1559) : error 029: invalid expression, assumed zero
D:\mysql server\gamemodes\RGRP.pwn(1559) : error 029: invalid expression, assumed zero
D:\mysql server\gamemodes\RGRP.pwn(1559) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase

6 Errors.

A kad ga ovako rastavim ne upisuje
				mysql_format(mysql, query, sizeof(query), "INSERT INTO `Accounts` ( `Username`, `Password`, `Level`, `Money`, `Exp`, `SatiIgre`, `Admin`, `Helper`, `Skin`, `PayDayPoeni`, `BankaKartica`, `BankaMoney`, `Posao`) VALUES ",query);
				mysql_format(mysql, query, sizeof(query), "%s ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",
				query,GetName(playerid),pass,PlayerInfo, PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo, PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo,PlayerInfo);
				mysql_tquery(mysql, query, "RegisterAccountInfo", "i", playerid);

Neke slike/video za lakse dobivanje pomoci(neobavezno):
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#2
Pozdrav,

možeš li pod ongamemodeinit staviti mysql_debug(1);

te nam dati output iz filea mysql_log.txt ?
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#3
D:\mysql server\gamemodes\RGRP.pwn(822) : warning 206: redundant test: constant expression is non-zero
D:\mysql server\gamemodes\RGRP.pwn(822) : warning 215: expression has no effect
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase

2 Warnings.


[19:29:46] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#4
Čij mysql plugin koristiš i dali imaš mysql_log.txt u server direktoriju ?
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#5
imam evo je
[19:29:46] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)


koristim BlueG
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#6
Znači ne želi ti se spojiti sa bazom podataka koliko vidim, da li si provjerio podatke i dali si napravio bazu ?
Pogledaj pod mysql_connect što je definirano za bazu podataka ako je host localhost moraš imati bazu na računalu a možeš ju kreirati putem xamppa ili drugih programa za to...
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#7
uredu je to sve bio nego sam krenuo radit poslove i kada sam dodao pPosao i pPosaoUgovor izbacilo je da je dugacak i ja rastavim i eto od onda je, ali kad ja to izbacim i vratim kako je bilo sve je normalno
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#8
Aha onda je ovo stari mysql debug ima li možda mysql.log negdje u folderu od servera? Mora izbacivati razlog zašto ne želi upisati to...
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#9
[19:37:07] CMySQLConnection::Connect - (error #1049) Unknown database 'samp_mysql'
[19:37:13] CMySQLConnection::Connect - (error #1049) Unknown database 'samp_mysql'
[19:38:27] CMySQLConnection::Connect - (error #1049) Unknown database 'mysqlbaza'
[19:38:30] CMySQLConnection::Connect - (error #1049) Unknown database 'mysqlbaza'
[09:40:18] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[09:40:24] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[09:40:27] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[00:59:51] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[01:00:51] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[10:31:21] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[11:42:30] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[15:59:04] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[19:29:30] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[19:29:46] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)

Evo ga ceo
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#10
Imaš li team viewer jer ovo definitivno pokazuje da baza ne postoji ili nešto oko nje nije uredu (ne želi se spojiti)....
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#11
http://imgur.com/a/388fV
Kazem ti sve je bilo dobro dok nisam posao ubacio
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#12
Onda log nije uredu izbriši mysql_log.txt i mysql.log pa upali server i vidi hoće li se napraviti mysql_log / mysql.log
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#13
Ne pravi ga sad evo izbacio sam i posao vratio an staro kako je bilo i nece
Ne pravi
Fico62
4
Fichoâ„¢
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#14
mysql_debug(1); ti javlja one errore gore ? kada staviš to mora se napraviti log koji će ti dati detaljnije informacije zašto ne upisuje to u bazu....
Kroni
5
Ciger
Underboss
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
5. Okt. 2016.
#15
Probacu update mysql ali ne verujem skino sam now pre nedelju dana pa ti se javim

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha