Problem mit der Datenbank vom My Virtual Dream Script.

RayZ · 8. Dezember 2013

Hallo...

Ich habe einmal die mvd datenbank und einmal die information_schema

Aber aus einer Datenbank werden 2 datenbänke und das script lauft denn nicht..

Wie behebe ich das?!?

http://www.imagebanana.com/view/1bns162y/DatenbankNr.2.PNG
http://www.imagebanana.com/view/wqo7juiu/DatenbankNr.1.PNG

und dann lauft das nicht das script.
Wie bring ich das zum laufen.

/e

T4125Gamer:

T4125Gamer · 8. Dezember 2013

Zitat von Azuru

Wie bring ich das zum laufen.

Was genau läuft nicht?
Sind die MySQL Daten alle richtig?

RayZ · 8. Dezember 2013

Ja... aber das sind 2 Datenbänke und so Lauft das doch nicht oder doch??!?

[MYSQL]

#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "****"
#define MYSQL_DATABASE "samp"

//Das ist der Homeserver.
[/MYSQL]

SA-MP Dedicated Server
----------------------
v0.3e-R2, (C)2005-2012 SA-MP Team

[21:16:48]
[21:16:48] Server Plugins
[21:16:48] --------------
[21:16:48] Loading plugin: mysql
[21:16:48]

> MySQL plugin R6-2 successfully loaded.

[21:16:48] Loaded.
[21:16:48] Loading plugin: sscanf
[21:16:48]

[21:16:48] ===============================

[21:16:48] sscanf plugin loaded.

[21:16:48] 0.3d-R2 500 Players "dnee"

[21:16:48] ===============================

[21:16:48] Loaded.
[21:16:48] Loading plugin: streamer
[21:16:48]

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

[21:16:48] Loaded.
[21:16:48] Loaded 3 plugins.

[21:16:48]
[21:16:48] Ban list
[21:16:48] --------
[21:16:48] Loaded: samp.ban
[21:16:48]
[21:16:48]
[21:16:48] Filterscripts
[21:16:48] ---------------
[21:16:48] Loading filterscript 'MVD-System.amx'...
[21:16:48] [junkbuster] Loading JunkBuster...
[21:16:48]
[21:16:48] [junkbuster] Speichere/Lade MVD-System Konfiguration:
[21:16:48] [junkbuster] - WeaponHack = 0
[21:16:48] [junkbuster] - MoneyHack = 0
[21:16:48] [junkbuster] - Jetpack = 1
[21:16:48] [junkbuster] - HealthHack = 1
[21:16:48] [junkbuster] - ArmourHack = 1
[21:16:48] [junkbuster] - DriveBy = 0
[21:16:48] [junkbuster] - Spam = 0
[21:16:48] [junkbuster] - CommandSpam = 0
[21:16:48] [junkbuster] - BadWords = 0
[21:16:48] [junkbuster] - CarJackHack = 0
[21:16:48] [junkbuster] - TeleportHack = 1
[21:16:48] [junkbuster] - MaxPing = 1000
[21:16:48] [junkbuster] - SpectateHack = 0
[21:16:48] [junkbuster] - Blacklist = 0
[21:16:48] [junkbuster] - IpBans = 0
[21:16:48] [junkbuster] - TempBans = 0
[21:16:48] [junkbuster] - SpawnKill = 0
[21:16:48] [junkbuster] - CapsLock = 0
[21:16:48] [junkbuster] - 3DSpeed = 0
[21:16:48] [junkbuster] - MaxSpeed = 550
[21:16:48] [junkbuster] - AdminImmunity = 1
[21:16:48] [junkbuster] - Advertisement = 0
[21:16:48] [junkbuster] - FreezeUpdate = 0
[21:16:48] [junkbuster] - SpawnTime = 10
[21:16:48] [junkbuster] - CheckpointTeleport = 1
[21:16:48] [junkbuster] - Airbrake = 100
[21:16:48] [junkbuster] - TankMode = 1
[21:16:48] [junkbuster] - WarnPlayers = 0
[21:16:48] [junkbuster] - SingleplayerCheats = 1
[21:16:48] [junkbuster] - MinFPS = 0
[21:16:48] [junkbuster] - DisableBadWeapons = 1
[21:16:48] [junkbuster] - CBug = 0
[21:16:48] [junkbuster] - AntiBugKill = 1
[21:16:48] [junkbuster] - NoReload = 0
[21:16:48] [junkbuster] - NoReloadForSawnOff = 0
[21:16:48] [junkbuster] - ActiveGMC = 2
[21:16:48] [junkbuster] - GMCBan = 0
[21:16:48] [junkbuster] - ServerSideHealth = 1
[21:16:48] [junkbuster] - CheckVMPos = 0
[21:16:48] [junkbuster] - QuickTurn = 1
[21:16:48] [junkbuster] - VehicleTeleport = 1
[21:16:48] [junkbuster] - Wallride = 170
[21:16:48] [junkbuster] - DisplayTextDraw = 1
[21:16:48] [junkbuster] - AFK = 0
[21:16:48] [junkbuster] - PickupTeleport = 1
[21:16:48] [junkbuster] - FlyHack = 40
[21:16:48] [junkbuster] - JunkBusterChrome = 1
[21:16:48] [junkbuster] - CheckWalkAnims = 0
[21:16:48] [junkbuster] - ReportMoneyHack = 0
[21:16:48] [junkbuster] - SpeedhackAdvanced = 20
[21:16:48] [junkbuster] - Joypad = 2
[21:16:48] [junkbuster] - ArmedVehicles = 0
[21:16:48] [junkbuster] - VehicleRepair = 2
[21:16:48] [junkbuster] - TuningHack = 0
[21:16:48] [junkbuster] - PayForGuns = 0
[21:16:48] [junkbuster] - SpawnVehicles = 2
[21:16:48] [junkbuster] - MaxTotalWarnings = 0
[21:16:48] [junkbuster] - TooManyWarningsAction = 0
[21:16:48] [junkbuster] - AirbrakeDetection = 1
[21:16:48] [junkbuster] - SpeedhackDetection = 1
[21:16:48]
[21:16:48] [junkbuster] 0 IP-bans have been loaded.
[21:16:48] [junkbuster] 0 temporary bans have been loaded.
[21:16:48] [junkbuster] 0 whitelist entries have been loaded.
[21:16:48] [junkbuster] 5 blacklist entries have been loaded.
[21:16:48] [junkbuster] 41 bad words have been loaded.
[21:16:48] [junkbuster] 4 forbidden weapons have been loaded.
[21:16:48] [junkbuster] MVD-System wurde Konfiguriert.
[21:16:48] [junkbuster] JunkBuster (v11) has successfully been loaded.
[21:16:48] Loaded 1 filterscripts.

[21:16:48] Script[gamemodes/Haupt-Script.amx]: Run time error 19: "File or function is not found"
[21:16:48] Number of vehicle models: 0

SpongePups · 8. Dezember 2013

Kann es sein das wenn du die Tabellen einfügst er die Datenbank ignoriert und dann einfach eine neue erstellt?

T4125Gamer · 8. Dezember 2013

Zitat von Azuru

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

Du verwendest einen alten Streamer. Es gibt schon die Version 2.6.1
https://code.google.com/p/samp…mer-plugin/downloads/list
Downloade den und füg ihn in den Plugins Ordner ein. Wenn dann immer noch der Run time error 19 kommt downloadest du dir den Nativechecker --> http://forum.sa-mp.com/showthread.php?t=249226. Den schiebst du in den Plugins Ordner und danach schreibst du den in die server.cfg.
Wenn du das gemacht hast startest du den Server und zeigst dann erneut den Serverlog

RayZ · 8. Dezember 2013

Zitat von SpongePups

Kann es sein das wenn du die Tabellen einfügst er die Datenbank ignoriert und dann einfach eine neue erstellt?

Ka. aber bei mir lauft das script einfach nicht..
kann mir keiner so eine Datenbank mit der Info da drin erstellen villt.?!?

Möchte es grade zum laufen bekommen für mein RL Server

T4125Gamer · 8. Dezember 2013

Zitat

kann mir keiner so eine Datenbank mit der Info da drin erstellen villt.

Das Problem scheint nicht die Datenbank zu sein, sondern die Plugins machen die Probleme. Mach das was ich dir oben geschrieben habe.

RayZ · 8. Dezember 2013

SA-MP Dedicated Server
----------------------
v0.3e-R2, (C)2005-2012 SA-MP Team

[21:48:22] filterscripts = "" (string)
[21:48:22]
[21:48:22] Server Plugins
[21:48:22] --------------
[21:48:22] Loading plugin: mysql
[21:48:22]

> MySQL plugin R6-2 successfully loaded.

[21:48:22] Loaded.
[21:48:22] Loading plugin: sscanf
[21:48:22]

[21:48:22] ===============================

[21:48:22] sscanf plugin loaded.

[21:48:22] 0.3d-R2 500 Players "dnee"

[21:48:22] ===============================

[21:48:22] Loaded.
[21:48:22] Loading plugin: streamer
[21:48:22]

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

[21:48:22] Loaded.
[21:48:22] Loading plugin: nativechecker
[21:48:22] Loaded.
[21:48:22] Loaded 4 plugins.

[21:48:22]
[21:48:22] Ban list
[21:48:22] --------
[21:48:22] Loaded: samp.ban
[21:48:22]
[21:48:22]
[21:48:22] Filterscripts
[21:48:22] ---------------
[21:48:22] Loaded 0 filterscripts.

[21:48:22] Error: Function not registered: 'PlayerTextDrawSetPreviewModel'
[21:48:22] Error: Function not registered: 'PlayerTextDrawSetPreviewRot'
[21:48:22] Script[gamemodes/MVDRoleplay.amx]: Run time error 19: "File or function is not found"
[21:48:22] Number of vehicle models: 0

T4125Gamer: Immer noch der Fehler

T4125Gamer · 8. Dezember 2013

Zitat von Azuru

[21:48:22] Error: Function not registered: 'PlayerTextDrawSetPreviewModel'
[21:48:22] Error: Function not registered: 'PlayerTextDrawSetPreviewRot'

Dieser Funktionen wurden erst mit der Version 0.3x beigefügt.
Update deinen Server auf die 0.3x Version. Download link: http://www.sa-mp.com/download.php

RayZ · 8. Dezember 2013

Danke es Klappt.
Ich kanns dann morgen Hochladen. aufm Server...

/e text..

Hallo..

Ich habe das mal aufm Root gepackt jetzt.
Da es ja auf meinem Home server funktioniert hat..
und jetzt aufm root geht garnix mehr.

[23:10:12] Error: Function not registered: 'mysql_query'
[23:10:12] Error: Function not registered: 'mysql_store_result'
[23:10:12] Error: Function not registered: 'mysql_free_result'
[23:10:12] Error: Function not registered: 'mysql_retrieve_row'
[23:10:12] Error: Function not registered: 'mysql_num_rows'
[23:10:12] Error: Function not registered: 'mysql_real_escape_string'
[23:10:12] Error: Function not registered: 'mysql_fetch_field_row'
[23:10:12] Error: Function not registered: 'mysql_fetch_int'
[23:10:12] Error: Function not registered: 'mysql_connect'
[23:10:12] Error: Function not registered: 'mysql_pi[size=10]ng'[/size]
[23:10:12] Error: Function not registered: 'mysql_fetch_row_format'
[23:10:12] Script[gamemodes/MVDRoleplay.amx]: Run time error 19: "File or function is not found"
[23:10:12] Number of vehicle models: 0

Was ist der fehler?!?

T4125Gamer: Wo ist da jetzt der fehler.....

T4125Gamer · 9. Dezember 2013

@Azuru:

Lässt du denn das MySQL Plugin laden?

ZeWa · 9. Dezember 2013

Sieht stark nach dem falschen MySQL plugin aus

RayZ · 9. Dezember 2013

SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team

[23:10:12]
[23:10:12] Server Plugins
[23:10:12] --------------
[23:10:12] Loading plugin: mysql.so
[23:10:12] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/mysql.so))
[23:10:12] Loading plugin: sscanf.so
[23:10:12]

[23:10:12] ===============================

[23:10:12] sscanf plugin loaded.

[23:10:12] 0.3d-R2 500 Players "dnee"

[23:10:12] ===============================

[23:10:12] Loaded.
[23:10:12] Loading plugin: streamer.so
[23:10:12]

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

[23:10:12] Loaded.
[23:10:12] Loading plugin: nativechecker.so
[23:10:12] Loaded.
[23:10:12] Loaded 3 plugins.

[23:10:12]
[23:10:12] Ban list
[23:10:12] --------
[23:10:12] Loaded: samp.ban
[23:10:12]
[23:10:12]
[23:10:12] Filterscripts
[23:10:12] ---------------
[23:10:12] Loading filterscript 'MVD-System.amx'...
[23:10:12] [junkbuster] Loading JunkBuster...
[23:10:12]
[23:10:12] [junkbuster] Speichere/Lade MVD-System Konfiguration:
[23:10:12] [junkbuster] - WeaponHack = 0
[23:10:12] [junkbuster] - MoneyHack = 0
[23:10:12] [junkbuster] - Jetpack = 1
[23:10:12] [junkbuster] - HealthHack = 1
[23:10:12] [junkbuster] - ArmourHack = 1
[23:10:12] [junkbuster] - DriveBy = 0
[23:10:12] [junkbuster] - Spam = 0
[23:10:12] [junkbuster] - CommandSpam = 0
[23:10:12] [junkbuster] - BadWords = 0
[23:10:12] [junkbuster] - CarJackHack = 0
[23:10:12] [junkbuster] - TeleportHack = 1
[23:10:12] [junkbuster] - MaxPing = 1000
[23:10:12] [junkbuster] - SpectateHack = 0
[23:10:12] [junkbuster] - Blacklist = 0
[23:10:12] [junkbuster] - IpBans = 0
[23:10:12] [junkbuster] - TempBans = 0
[23:10:12] [junkbuster] - SpawnKill = 0
[23:10:12] [junkbuster] - CapsLock = 0
[23:10:12] [junkbuster] - 3DSpeed = 0
[23:10:12] [junkbuster] - MaxSpeed = 550
[23:10:12] [junkbuster] - AdminImmunity = 1
[23:10:12] [junkbuster] - Advertisement = 0
[23:10:12] [junkbuster] - FreezeUpdate = 0
[23:10:12] [junkbuster] - SpawnTime = 10
[23:10:12] [junkbuster] - CheckpointTeleport = 1
[23:10:12] [junkbuster] - Airbrake = 100
[23:10:12] [junkbuster] - TankMode = 1
[23:10:12] [junkbuster] - WarnPlayers = 0
[23:10:12] [junkbuster] - SingleplayerCheats = 1
[23:10:12] [junkbuster] - MinFPS = 0
[23:10:12] [junkbuster] - DisableBadWeapons = 1
[23:10:12] [junkbuster] - CBug = 0
[23:10:12] [junkbuster] - AntiBugKill = 1
[23:10:12] [junkbuster] - NoReload = 0
[23:10:12] [junkbuster] - NoReloadForSawnOff = 0
[23:10:12] [junkbuster] - ActiveGMC = 2
[23:10:12] [junkbuster] - GMCBan = 0
[23:10:12] [junkbuster] - ServerSideHealth = 1
[23:10:12] [junkbuster] - CheckVMPos = 0
[23:10:12] [junkbuster] - QuickTurn = 1
[23:10:12] [junkbuster] - VehicleTeleport = 1
[23:10:12] [junkbuster] - Wallride = 170
[23:10:12] [junkbuster] - DisplayTextDraw = 1
[23:10:12] [junkbuster] - AFK = 0
[23:10:12] [junkbuster] - PickupTeleport = 1
[23:10:12] [junkbuster] - FlyHack = 40
[23:10:12] [junkbuster] - JunkBusterChrome = 1
[23:10:12] [junkbuster] - CheckWalkAnims = 0
[23:10:12] [junkbuster] - ReportMoneyHack = 0
[23:10:12] [junkbuster] - SpeedhackAdvanced = 20
[23:10:12] [junkbuster] - Joypad = 2
[23:10:12] [junkbuster] - ArmedVehicles = 0
[23:10:12] [junkbuster] - VehicleRepair = 2
[23:10:12] [junkbuster] - TuningHack = 0
[23:10:12] [junkbuster] - PayForGuns = 0
[23:10:12] [junkbuster] - SpawnVehicles = 2
[23:10:12] [junkbuster] - MaxTotalWarnings = 0
[23:10:12] [junkbuster] - TooManyWarningsAction = 0
[23:10:12] [junkbuster] - AirbrakeDetection = 1
[23:10:12] [junkbuster] - SpeedhackDetection = 1
[23:10:12]
[23:10:12] [junkbuster] 0 IP-bans have been loaded.
[23:10:12] [junkbuster] 0 temporary bans have been loaded.
[23:10:12] [junkbuster] 0 whitelist entries have been loaded.
[23:10:12] [junkbuster] 5 blacklist entries have been loaded.
[23:10:12] [junkbuster] 41 bad words have been loaded.
[23:10:12] [junkbuster] 4 forbidden weapons have been loaded.
[23:10:12] [junkbuster] MVD-System wurde Konfiguriert.
[23:10:12] [junkbuster] JunkBuster (v11) has successfully been loaded.
[23:10:12] Loaded 1 filterscripts.

[23:10:12] Error: Function not registered: 'mysql_query'
[23:10:12] Error: Function not registered: 'mysql_store_result'
[23:10:12] Error: Function not registered: 'mysql_free_result'
[23:10:12] Error: Function not registered: 'mysql_retrieve_row'
[23:10:12] Error: Function not registered: 'mysql_num_rows'
[23:10:12] Error: Function not registered: 'mysql_real_escape_string'
[23:10:12] Error: Function not registered: 'mysql_fetch_field_row'
[23:10:12] Error: Function not registered: 'mysql_fetch_int'
[23:10:12] Error: Function not registered: 'mysql_connect'
[23:10:12] Error: Function not registered: 'mysql_ping'
[23:10:12] Error: Function not registered: 'mysql_fetch_row_format'
[23:10:12] Script[gamemodes/MVDRoleplay.amx]: Run time error 19: "File or function is not found"
[23:10:12] Number of vehicle models: 0

Wo ist da der fehler

T4125Gamer:
ZeWa:
Atrox:

Montero · 9. Dezember 2013

Dein MySQL Plugin ist in der server.cfg nicht eingetragen, bzw wird nicht geladen.

RayZ · 9. Dezember 2013

Montero:

Hier mal ein Bild....
http://www.imagebanana.com/view/fovba09i/Plugins.PNG

Bluescreen · 9. Dezember 2013

Das erklärt doch alles oder nicht?

Code

[23:10:12] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/mysql.so))

RayZ · 9. Dezember 2013

Zitat von Bluescreen
Das erklärt doch alles oder nicht?
Code
[23:10:12] Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/mysql.so))

Was soll das bitte Heißen..
Das ich z.b das falsche Plugin habe..?

Bluescreen · 9. Dezember 2013

Nein dir fehlt die "/usr/lib/libstdc++.so.6" Datei mit der Version "GLIBCXX_3.4.11" einfach mal Suchen und dann einfügen. Mehr kann ich dir da nicht helfen da ich das Problem bisher nicht hatte.

RayZ · 9. Dezember 2013

Zitat von Bluescreen

libstdc++.so.6

Also damit meinste..
das mir eine datei fehlt?!?
kann man die villt so downloaden.
also nur die datei..
libstdc++.so.6

@T4125Gamer:
Atrox:
Azure:

/e Anpienen.

T4125Gamer: Können sie mir bitte weiter helfen

T4125Gamer · 9. Dezember 2013

Zitat von ColorHost-Kevin

Here is something that will help:

Download file: http://www.sendspace.com/file/1chhyq

Instructions:

download and copy the file libstdc++.so.6.0.9 in /usr/lib/ ( with permission mode 755)
step 1: $> cd /usr/lib/
step 2: $> unlink libstdc++.so.6
step 3: $> ln -s libstdc++.so.6.0.9 libstdc++.so.6
step 4: $> /sbin/ldconfig

Then you should be good to go.

Alles anzeigen

Hier ist die Lösung