Problem mit MySQL

FunkySimonp · 12. Mai 2015

Hey Leute,
Ich brauche dringend eure Hilfe. Ich habe einen Server und die Datenbank des Servers läuft über MySQL also PhpmyAdmin.
Ich bin schon seit 2 Tagen nach dem Fehler am suchen ich habe auch schon alles gegooglet aber ich finde nichts, was mein Problem behebt.
Wenn mir jemand helfen könnte wäre ich wirklich sehr dankbar.
Hier sende ich euch ein Ausschnitt von dem Log:

Code

[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 6 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] Zone: 7 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
[22:24:47] Lade Häuser..
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[22:24:47] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).

Alles anzeigen

Beavis · 12. Mai 2015

Die MySQL Daten stimmen nicht

FunkySimonp · 12. Mai 2015

Doch die stimmen ich habe ALLES überprüft ehrlich jetzt alles.

Beavis · 12. Mai 2015

Scheint das es das strickenkid MySQL Plugin ist.
Da ist zu beachten das der MySQL Benutzer ein Passwort hat. Ansonsten kommt der Fehler das das passwort ungültig sei

Jeffry · 13. Mai 2015

Der Fehler kann mehrere Gründe haben angefangen dort, dass der User in der Datenbank nicht existiert und aufgehört dort, dass du die Daten nur falsch eingetippt hast.

Prüfe mal Folgendes:
1.) Ändere localhost zu 127.0.0.1 bzw. andersherum. Geht es dann?
2.) Falls nicht, prüfe ob du manuell auf die Datenbank kommst (NaviCat / phpMyAdmin / ...), falls ja, stimmen diese Logindaten mit denen im Code überein?
3.) Ist das Passwort leer? Wenn ja, ändere über NaviCat/phpMyAdmin das root-Passwort zu etwas nicht-leerem und gebe das Passwort dann in deinem Code ein.
4.) Hast du möglicherweise keine Berechtigungen vergeben, dass man auf die Datenbank zugreifen kann?

Falls nichts davon hilft, schaue im Log nach was dort als Fehler kommt, wenn du die Verbindung zur Datenbank aufbauen willst.

Blackshadowscript · 13. Mai 2015

Jeffry ich hab den sein Fehler gesehen.

Er hat sich kein Passwort gemacht.

Das standart Passwort müsste glaube ich auf root root sein falls ich mich vertuhe bitte bescheid sagen

Jeffry · 13. Mai 2015

Zitat von Blackshadowscript

Das standart Passwort müsste glaube ich auf root root sein falls ich mich vertuhe bitte bescheid sagen

Das Standard Passwort vom root ist keines, steht in phpMyAdmin auch als Warnung unten dran, wenn man sich so anmeldet.

FunkySimonp · 15. Mai 2015

Hey Leute,
Erstmal Danke für die Hilfe. Es lag am Mysql Plugin und nicht am Passwort. Ich habe es geupdatet und bekomme nun diesen Log:
[log]SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[13:53:21]
[13:53:21] Server Plugins
[13:53:21] --------------
[13:53:21] Loading plugin: mysql
[13:53:21]

> MySQL plugin R5 successfully loaded.

[13:53:21] Loaded.
[13:53:21] Loading plugin: streamer
[13:53:21]

*** Streamer Plugin v2.7 by Incognito loaded ***

[13:53:21] Loaded.
[13:53:21] Loading plugin: sscanf
[13:53:21]

[13:53:21] ===============================

[13:53:21] sscanf plugin loaded.

[13:53:21] ===============================

[13:53:21] Loaded.
[13:53:21] Loading plugin: nativechecker
[13:53:21] Loaded.
[13:53:21] Loaded 4 plugins.

[13:53:21]
[13:53:21] Ban list
[13:53:21] --------
[13:53:21] Loaded: samp.ban
[13:53:21]
[13:53:21]
[13:53:21] Filterscripts
[13:53:21] ---------------
[13:53:21] Loading filterscript 'objects-server.amx'...
[13:53:21] *** Streamer Plugin: Warning: Include file version (0x27201) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[13:53:21] Server Objecte werden geladen
[13:53:21] *** Streamer_SetFloatData: Invalid ID specified
[13:53:21] 1064 Gemappte Objecte Geladen
[13:53:21] Loading filterscript 'dubstepgun.amx'...
[13:53:21]
--------------------------------------
[13:53:21] -----Dubstep Gun System by RenovanZ-----
[13:53:21] Dance with your Song!
[13:53:21] --------------------------------------

[13:53:21] Loading filterscript 'neon.amx'...
[13:53:21]
--------------------------------------
[13:53:21] Neon System By AlexzzPro
[13:53:21] --------------------------------------

[13:53:21] Loading filterscript 'Minievent.amx'...
[13:53:21]
--------------------------------------
[13:53:21] Mini-Events by Jafet Macario
[13:53:21] --------------------------------------

[13:53:21] Loading filterscript 'lotto.amx'...
[13:53:21] Loading filterscript 'BSystem.amx'...
[13:53:21]
[13:53:21]
--------------------------------
[13:53:21] Adil's [NPC]LS Bus System.
[13:53:21] --------------------------------

[13:53:21]
[13:53:21] Loading filterscript 'autowaesche.amx'...
[13:53:21]
-----------------------------------------------
[13:53:21] ---=== Car Wash Filterscript by Angeleno ===---
[13:53:21] -------------- Copyright -- 2011 --------------

[13:53:21] Loading filterscript 'spawner.amx'...
[13:53:21] Loading filterscript 'cameditor.amx'...
[13:53:21]
--------------------------------------
[13:53:21] CamEditor by Drebin
[13:53:21] --------------------------------------

[13:53:21] Loaded 9 filterscripts.

[13:53:21] Error: Function not registered: 'mysql_fetch_row'
[13:53:21] Error: Function not registered: 'mysql_init'
[13:53:21] Script[gamemodes/Roleplay.amx]: Run time error 19: "File or function is not found"
[13:53:21] Number of vehicle models: 1
[13:53:21] Incoming connection: 127.0.0.1:60776
[13:53:21] Incoming connection: 127.0.0.1:60777
[13:53:21] [npc:join] BlueBusDriver has joined the server (0:127.0.0.1)
[13:53:21] [npc:join] BlackBusDriver has joined the server (1:127.0.0.1)

[/log]

Jeffry · 15. Mai 2015

Ändere in dem Code: mysql_fetch_row zu mysql_fetch_row_format und mysql_init zu mysql_connect.
Siehe hier: http://forum.sa-mp.com/showthread.php?t=56564

FunkySimonp · 15. Mai 2015

Nun bekomme ich dies von Pawno:
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12085) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12091) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12097) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12103) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12346) : error 035: argument type mismatch (argument 1)
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(12346) : warning 213: tag mismatch
C:\Users\Simon\Desktop\SAMP Server\gamemodes\Roleplay.pwn(46552) : error 017: undefined symbol "mysql_fetch_row_format"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

6 Errors.

Jeffry · 15. Mai 2015

Du musst die Include des MySQL Plugins auch aktualisieren (bzw. die Include für das R5 Plugin nutzen).
Siehe Anhang.

FunkySimonp · 15. Mai 2015

Hab ich getan,jedoch immernoch die selben Errors. Könntest du mal über TV nachgucken ? Ich wäre dir sehr dankbar, da ich schon seit 3 Tagen an dem Problem sitze.

Jeffry · 15. Mai 2015

Versuche es bitte erst mal selbst.

Steht oben bei den Includes bei dir auch
#include <a_mysql>
oder steht da was anderes? Falls was anderes, ändere es.

Hast du die Include in /pawno/includes/ gelegt? Wenn ja, öffne im /pawno/ Ordner die pawno.exe und wähle dort den Code aus, dann kompiliere ihn erneut, wenn du sicher bist, dass oben im Code die richtige (a_mysql) Include eingetragen ist.

FunkySimonp · 15. Mai 2015

Also im Script stand nicht a_mysql da stand nur Mysql. Habe a_mysql nun hinzugefügt und mysql auch da gelassen.
Das sieht nun so aus
#include <a_samp>
#include <core>
#include <float>
#include <time>
#include <file>
#include <utils>
#include <morphinc>
#include <mysql>
#include <a_mysql>
#include <M-Zones>
#include <streamer>
#include <sscanf>
#include <foreach>
#include <feuerwehr>

und ich bekomme trotzdem diese Errors:
D:\SAMP Server\pawno\include\a_mysql.inc(28) : error 021: symbol already defined: "mysql_affected_rows"
D:\SAMP Server\pawno\include\a_mysql.inc(29) : error 021: symbol already defined: "mysql_close"
D:\SAMP Server\pawno\include\a_mysql.inc(30) : error 021: symbol already defined: "mysql_connect"
D:\SAMP Server\pawno\include\a_mysql.inc(30) : error 025: function heading differs from prototype
D:\SAMP Server\pawno\include\a_mysql.inc(30) : error 025: function heading differs from prototype
D:\SAMP Server\pawno\include\a_mysql.inc(30) : fatal error 107: too many error messages on one line

6 Errors.

Edit:
Ich habe a_mysql nun an erster Stelle gesetzt und es sind nurnoch 4 Errors:
D:\SAMP Server\pawno\include\mysql.inc(124) : error 021: symbol already defined: "mysql_connect"
D:\SAMP Server\pawno\include\mysql.inc(124) : error 025: function heading differs from prototype
D:\SAMP Server\pawno\include\mysql.inc(124) : error 025: function heading differs from prototype
D:\SAMP Server\pawno\include\mysql.inc(124) : fatal error 107: too many error messages on one line

4 Errors.

Jeffry · 15. Mai 2015

Mach das
#include <mysql>
ganz weg. Das ist die Include für das andere Plugin, beide zusammen vertragen sich nicht.

FunkySimonp · 15. Mai 2015

Habe es getan nun sieht es so aus:
D:\SAMP Server\gamemodes\Roleplay.pwn(11986) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(11989) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(11991) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12050) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12053) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12056) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12059) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12062) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12065) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12068) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12071) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12160) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12163) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12166) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12169) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12172) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12175) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12178) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12181) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12184) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12187) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12190) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12193) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12196) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12199) : error 035: argument type mismatch (argument 1)
D:\SAMP Server\gamemodes\Roleplay.pwn(12201) : error 035: argument type mismatch (argument 1)

26 Errors.

Jeffry · 15. Mai 2015

Zeige bitte ein-zwei Beispiele aus den Zeilen mit den Errors. Das dürfte relativ leicht zu beheben sein, das liegt da dran, dass du ein neues Plugin verwendest, und da die Funktionen etwas anders in der Parameter-Reihenfolge sind.

FunkySimonp · 15. Mai 2015

Ich weiß nicht genau was du mit Beispielen meinst. Bei den 26 Errors finde ich keine Beispiele. Falls du das andere meinst hier ein Beispiel:
public OnGameModeInit()
{

mysql = mysql_connect(LOG_ALL);// Hier bestimmt ihr , dass ihr alles was mit mysql zu tun habt logt
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DATABASE, mysql);

Jeffry · 15. Mai 2015

public OnGameModeInit()
{
mysql_log(LOG_ALL);// Hier bestimmt ihr , dass ihr alles was mit mysql zu tun habt logt
mysql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASS);

Das muss so aussehen.

Zwecks den Beispielen:
Ich meinte jeweils den Code aus einer solchen Fehlerzeile. Davon ein paar.

FunkySimonp · 15. Mai 2015

Ich hab den ersten Code (11986) aus der Fehlerzeile genommen und mit Pawno gesucht. Pawno findet dazu keine Zeilen im Script