[SAMMELTHREAD] Kleine Scripting Fragen

LoRiX · 12. Dezember 2019

Zitat von LoRiX

Kann mir jemand erklären warum meine Mysql_Log mir ganze Zeit das hier sagt, obwohl die Verbindung zur Datenbank hergestellt ist?

Code

[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:40:58] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:41:28] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:51:30] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[01:52:01] [ERROR] CMySQLQuery::Execute[] - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)

Alles anzeigen

Code

01:38:17] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!

Habe immernoch den Fehler

Exclusive FiveM Scripts · 12. Dezember 2019

Schreibe 127.0.0.1 anstatt localhost

LoRiX · 12. Dezember 2019

Zitat von Rocky

Schreibe 127.0.0.1 anstatt localhost

Bringt leider nichts, mir ist heute aber auch aufgefallen das ich in den MySQL nicht rein komme.

Gestern ging alles heute alles tot

Exclusive FiveM Scripts · 12. Dezember 2019

Dann musst du dich an deinen Hoster wenden

LoRiX · 16. Dezember 2019

Kann mir jemand helfen meine Mysql Log zeigt ganze zeit nen Error an denn ich nicht wirklich verstehen kann.

Es geht um das Adventskalender System..

Code

[16:34:49] [ERROR] cache_get_row_int - invalid datatype
[16:34:49] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('152')
[16:34:49] [ERROR] cache_get_row_int - invalid datatype
[16:34:49] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('154')

Whice · 16. Dezember 2019

Zitat von LoRiX

Es geht um das Adventskalender System..

Ich kenn zwar "das Adventskalender System" nicht, allerdings ist es genau das was dort steht.

Du greifst wohl auf einen Datensatz zu, der nicht existiert. (Also die Reihe 0)

Kaliber · 16. Dezember 2019

Zitat von LoRiX

Es geht um das Adventskalender System..

Dann zeig doch mal das Adventssystem...

Tabellen-Aufbau und wie du darauf zugreifst...

Offensichtlich nutzt du da falsche Cache-Typen...(du musst z.B. float oder String nutzen, wo du int nutzt)

LoRiX · 16. Dezember 2019

Code

//LoadPlayer
            Spieler[playerid][pAdventDay] = cache_get_row_int(0,151,connectionHandle);
            Spieler[playerid][pAdventMin] = cache_get_row_int(0,152,connectionHandle);

Wie sie in der .SQL Eingetragen sind

  `AdventDay` int(11) NOT NULL DEFAULT '0',
  `AdventMin` int(11) NOT NULL DEFAULT '0',

Kaliber · 16. Dezember 2019

Zitat von LoRiX

cache_get_row_int(0,151,connectionHandle);

Wie zur Hölle kommst auf die 151?

Mach mal:

Code

Spieler[playerid][pAdventDay] = cache_get_field_content_int(0,"AdventDay",connectionHandle);
Spieler[playerid][pAdventMin] = cache_get_field_content_int(0,"AdventMin",connectionHandle);

GUCCI · 16. Dezember 2019

Code

Test/main.inc(31) : error 017: undefined symbol "playerInfo"
Test/main.inc(31) : error 017: undefined symbol "SendErrorMessage"
Test/main.inc(32) : error 017: undefined symbol "playerInfo"
Test/main.inc(34) : error 017: undefined symbol "MAX_GANGWAR_ZONES"
Test/main.inc(36) : error 017: undefined symbol "gangZoneInfo"
Test/main.inc(37) : error 017: undefined symbol "gangZoneInfo"
Test/main.inc(40) : error 017: undefined symbol "gangZoneInfo"
Test/main.inc(40) : error 029: invalid expression, assumed zero
Test/main.inc(40) : warning 215: expression has no effect
Test/main.inc(40) : error 001: expected token: ";", but found "]"
Test/main.inc(40) : fatal error 107: too many error messages on one line

Alles anzeigen

Verstehe grad irgendwie nicht was ich verkackt habe, habe eigentlich nichts an den Includes verändert.

Auch im Skript ganz normal Includiert.

Boi hat wer n Tipp?

Kaliber · 16. Dezember 2019

Vermutlich definierst du das Include über deinen Deklarationen im Gamemode.

Somit inkludiere das Include weiter unten im Gamemode

GUCCI · 16. Dezember 2019

nichts gebracht, boi.

Whice · 16. Dezember 2019

Zitat von GUCCI

nichts gebracht, boi.

kann das sein das du einfach nen Klammerfehler irgendwo hast?

GUCCI · 16. Dezember 2019

Das kann natürlich wahrsteinern,

gibt es noch diese seite um klammerfehler zu finden ?

Whice · 17. Dezember 2019

Zitat von Kaliber

I wrote a website for this.
http://klammerfehler.bplaced.net/
Paste your code there, and you'll get the line.
It's on German, so i hope you can use ****** translate

GUCCI · 17. Dezember 2019

Allerdings kein Klammerfehler..

Whice · 17. Dezember 2019

Zitat von GUCCI

Allerdings kein Klammerfehler..

sehr strange, hast du dir sonst mal das include neu rundergeladen bzw. benutzt du das richtige pawno?

[SAMMELTHREAD] Kleine Scripting Fragen

Beitrag von Dr. Frauenarzt (16. Dezember 2019)

Beitrag von Apokrate (16. Dezember 2019)

Beitrag von Kaliber (16. Dezember 2019)