Jump to content
GIGN Forum

[amxx] Sql Error


Recommended Posts

nu gudrie prati, pasakat ka shito izlabot ?

mysql ieks moduljiem ir atkomatets

admin_sql ieks pluginiem ir atkomatets

sql konfiga noraditais juzeris nav root un tam ir parole!!!!

mysql serveris stradaa, tas ir uz tas pashas kastes tatad ip ir 127.0.0.1

mysql.sock failam ir simlinks uztaisits uz /tmp/mysql.sock

[AMXX] SQL error: can't connect: 'Access denied for user 'root'@'localhost' (using password: NO)'

man radas doma ka varbutas admin_sql plugins pats ir nokompilets uz tadu juzeri un tapec shadas problemas ?

ps nee es nelietoju amxbanus!!

izguglejos bet nekadu sakrrigo skaidrojumu nedabuju

idejas?

Link to comment
Share on other sites

mhm skaidrs, paldies, nostradaja

lai neceltu jaunu topiku, vai nevari pateikt ko kodejot pluginus nozime `%s` ? tas ir hostneims domats vai kas ?

modificeju vienu pluginu un tur ir kkadas problemas ar tabulas veidoshanu kad piekanekte

edit erors ir QueryCreateTable cik noprotu nevar izveidot tabulu

#if defined USING_SQL
PrepareTable()
{
    new query[128];
    formatex(query, sizeof(query) - 1,\
        "CREATE TABLE IF NOT EXISTS `%s` (`%s` varchar(32) NOT NULL, `%s` varchar(35) NOT NULL, `%s` int(10) NOT NULL, `%s` varchar(32) NOT NULL, `%s` varchar(128) NOT NULL, `%s` varchar(64) NOT NULL, `%s` varchar(35) NOT NULL);",\
        TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID
        );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
}

Edited by ANALGINS
Link to comment
Share on other sites

aa nu protams - doh

ja ieks plugina noradits #include <sqlx> tad tas izmantos sqlite nevis mysql, un to vaidzetu mainit uz mysql ?

ps tik stulbi jautajumi jo nekodeju katru dienu pluginus un man tas plugins nekonektee pie mysql nezinamu iemeslu del..

Edited by ANALGINS
Link to comment
Share on other sites

mhm skaidrs, es tik nesaprotu kapec plugins (defultais nemodificets) negrib lounchoties o.O

L 05/13/2010 - 18:56:47: [AMXX] Plugin ("bans_sql.amxx") is setting itself as failed.
L 05/13/2010 - 18:56:47: [AMXX] Plugin says: Could not connect to database.
L 05/13/2010 - 18:56:47: [AMXX] Displaying debug trace (plugin "bans_sql.amxx")
L 05/13/2010 - 18:56:47: [AMXX] Run time error 1: forced exit
L 05/13/2010 - 18:56:47: [AMXX]    [0] bans_sql.sma1::QueryCreateTable (line 402)

Link to comment
Share on other sites

v0.8

lasu vinju forumu, un istas atbildes nerodu kapec neceljas tas plugins >.<

sak rasties aizdomas kas nevar executot sql konfigu, to tapat japieraksta shadi pie amx konfiga? exec sql.cfg?

admin_sql plugins arrii nevar piekonekteet manam mysql serverim, kas liekas nedaudz divaini, jo izmeginaju gan defulti paredzeto juzeri prieks hlds, gan root juzeri un abiem bija vienadas problemas o.O

Edited by ANALGINS
Link to comment
Share on other sites

ir kada ideja ka to apkarot? ieshu pachekot varbutas atrodu to pluginu

edit, hmm panacu ka strada sql admins kkada veida, tagad man ir shads forsh errors no banu puses

 [ 21] Advanced Bans           0.8         Exolent           advanced_bans_s  error
( 21) Error: Query failed.

varetu ta but ka mans mysql ir jaunaks un tapec nesakrit sintakse ? (MySQL version 5.1.37 )

Edited by ANALGINS
Link to comment
Share on other sites

Bet kad tu uzliec banu vinsh to kaut kur saglaba? ...

Atcerejos vienu lietu , kad pats tos liku tad musejais progeris laboju kverija kodu jo tur tipa dokumentacija nomainijas un tapec sql nevareja atpazit to.

Link to comment
Share on other sites

nu jaa.. protams... parbaudiju vai glabaa, un konsole uzreiz izmeta ka nevar piekonektet db >.< WTF vienkarsi :huh:

konsolee (klienta) iemet info par banu, bet plugins exito pirms kas talak notiek..

Edited by ANALGINS
Link to comment
Share on other sites

es to ari izdariju, uztasiiju tabulu vis ok, izdzesu no plugina to kverija dalju kas par to atbildeja, smuki no { lidz pedejam } kas par to dalju atbildeja bet pie banoshanas vinjsh nobljaujas

L 05/13/2010 - 21:16:43: hostname <> banned test <STEAM_0:0:1431917661> || Reason: "test" || Ban Length: Permanent Ban
L 05/13/2010 - 21:16:43: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 05/13/2010 - 21:16:43: [AMXX] Plugin says: Could not connect to database.
L 05/13/2010 - 21:16:43: [AMXX] Run time error 1 (plugin "advanced_bans_sql.amxx") - forced exit

serveri un klientam konsoles paradas izdruka par banu arii chataa, un tad shis, vis apstajas un nekas nenotiek

edit atradu izlaboto sourci alied modu forumaa un tagad vis iet ka pa diedzinju, beidzot var slegt topiku :)

Edited by ANALGINS
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...