Die Logindaten sind richtig und eigentlich ist es keine veraltete Version.
Hab es schon versucht zu updaten und es war alles auf dem aktuellen stand
Beiträge von Marschl
-
-
Hallo,
ich hab ein Problem und zwar:
wenn ich versuche meinen Server zu startet startet das MySQL Plugin nicht.Im Serverlog steht das irgendwas nicht gefunden wird.
Ich habe bereits danach gegoogelt und auch mehrere Sachen auf dem vServer installiert:
Der Serverlog:Code
Alles anzeigen---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, (C)2005-2015 SA-MP Team [09:06:38] [09:06:38] Server Plugins [09:06:38] -------------- [09:06:38] Loading plugin: crashdetect.so [09:06:38] CrashDetect v4.18.1 is OK. [09:06:38] Loaded. [09:06:38] Loading plugin: mysql.so [09:06:38] Failed (/usr/lib/i386-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.19' not found (required by plugins/mysql.so)) [09:06:38] Loading plugin: sscanf.so [09:06:38] [09:06:38] =============================== [09:06:38] sscanf plugin loaded. [09:06:38] Version: 2.8.2 [09:06:38] (c) 2012 Alex "Y_Less" Cole [09:06:38] =============================== [09:06:38] Loaded. [09:06:38] Loaded 2 plugins. [09:06:38] [09:06:38] Filterscripts [09:06:38] --------------- [09:06:38] Loading filterscript 'Maps.amx'... [09:06:38] Loaded 1 filterscripts. [09:06:38] [debug] Run time error 19: "File or function is not found" [09:06:38] [debug] mysql_close [09:06:38] [debug] mysql_format [09:06:38] [debug] mysql_pquery [09:06:38] [debug] cache_get_row_count [09:06:38] [debug] cache_insert_id [09:06:38] [debug] cache_get_value_name_int [09:06:38] [debug] cache_get_value_name [09:06:38] [debug] mysql_log [09:06:38] [debug] mysql_connect [09:06:38] [debug] mysql_errno [09:06:38] [debug] Run time error 19: "File or function is not found" [09:06:38] [debug] mysql_close [09:06:38] [debug] mysql_format [09:06:38] [debug] mysql_pquery [09:06:38] [debug] cache_get_row_count [09:06:38] [debug] cache_insert_id [09:06:38] [debug] cache_get_value_name_int [09:06:38] [debug] cache_get_value_name [09:06:38] [debug] mysql_log [09:06:38] [debug] mysql_connect [09:06:38] [debug] mysql_errno [09:06:38] Script[gamemodes/YVL.amx]: Run time error 19: "File or function is not found" [09:06:38] Number of vehicle models: 0 [09:06:44] [debug] Server received interrupt signal [09:06:44] [debug] Server crashed due to an unknown error [09:06:44] [debug] Server received interrupt signal
-
Und wie?
-
Hallo,
wäre es möglich InGame im Chat mit einem Befehl z.B /tr einen Taschenrechner zu haben?
Hoffe ihr könnt mir helfen
Grüße -
Schonmal unter OnUserCheck printen lassen ob es überhaupt aufgerufen wird?
-
Warum wird die Datenbank nicht erstellt?
MySQL Log spruckt nix aus.Code
Alles anzeigenstock CreateAccountTabelle() { new query[2048], query2[256]; format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `"SQL_DTAG"accounts` ("); format(query, sizeof(query), "%s `ID` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Spielername` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Passwort` varchar(65) NOT NULL,", query); format(query, sizeof(query), "%s `Geschlecht` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Geburtsdatum` varchar(11) NOT NULL,,", query); format(query, sizeof(query), "%s `Tutorial` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Level` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Geld` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `SpawnChange` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Skin` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Admin` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Perso` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Fraktion` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `FraktionRang` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `LastIP` varchar(16) NOT NULL", query); format(query, sizeof(query), "%s ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;", query); mysql_pquery(handle, query); format(query2, sizeof(query2), "ALTER TABLE `"SQL_DTAG"accounts`"); format(query2, sizeof(query2), "%s ADD PRIMARY KEY (`ID`);", query2); mysql_pquery(handle, query2); return 1; }
CreateAccountTabelle steht unter OnGameModeInit
-
Server schon mehrmals neugestartet...
ich hab eigentlich nicht wirklich was als letztes gemacht. Ich hab bei meinem Script was in die Datenbank eintragen lassen wollte dann schauen und konnte nichtmehr bei phpmyadmin einloggen. -
Code
Alles anzeigen170413 11:24:29 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:29 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:29 InnoDB: The InnoDB memory heap is disabled 170413 11:24:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:29 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:29 InnoDB: Using Linux native AIO 170413 11:24:29 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:29 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 170413 11:24:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 170413 11:24:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 170413 11:24:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 170413 11:24:29 InnoDB: Waiting for the background threads to start 170413 11:24:30 InnoDB: 5.5.54 started; log sequence number 0 170413 11:24:30 InnoDB: Starting shutdown... 170413 11:24:31 InnoDB: Shutdown completed; log sequence number 1595675 170413 11:24:31 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:31 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:31 InnoDB: The InnoDB memory heap is disabled 170413 11:24:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:31 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:31 InnoDB: Using Linux native AIO 170413 11:24:31 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:31 InnoDB: Completed initialization of buffer pool 170413 11:24:31 InnoDB: highest supported file format is Barracuda. 170413 11:24:31 InnoDB: Waiting for the background threads to start 170413 11:24:32 InnoDB: 5.5.54 started; log sequence number 1595675 170413 11:24:32 InnoDB: Starting shutdown... 170413 11:24:33 InnoDB: Shutdown completed; log sequence number 1595675 170413 11:24:33 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:33 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:33 InnoDB: The InnoDB memory heap is disabled 170413 11:24:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:33 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:33 InnoDB: Using Linux native AIO 170413 11:24:33 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:33 InnoDB: Completed initialization of buffer pool 170413 11:24:33 InnoDB: highest supported file format is Barracuda. 170413 11:24:33 InnoDB: Waiting for the background threads to start 170413 11:24:34 InnoDB: 5.5.54 started; log sequence number 1595675 ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1 170413 11:24:34 [ERROR] Aborting 170413 11:24:34 InnoDB: Starting shutdown... 170413 11:24:35 InnoDB: Shutdown completed; log sequence number 1595675 170413 11:24:35 [Note] /usr/sbin/mysqld: Shutdown complete 170413 11:24:35 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:35 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:35 InnoDB: The InnoDB memory heap is disabled 170413 11:24:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:35 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:35 InnoDB: Using Linux native AIO 170413 11:24:35 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:35 InnoDB: Completed initialization of buffer pool 170413 11:24:35 InnoDB: highest supported file format is Barracuda. 170413 11:24:35 InnoDB: Waiting for the background threads to start 170413 11:24:36 InnoDB: 5.5.54 started; log sequence number 1595675 170413 11:24:36 InnoDB: Starting shutdown... 170413 11:24:37 InnoDB: Shutdown completed; log sequence number 1595675 170413 11:24:37 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:37 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:37 InnoDB: The InnoDB memory heap is disabled 170413 11:24:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:37 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:37 InnoDB: Using Linux native AIO 170413 11:24:37 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:37 InnoDB: Completed initialization of buffer pool 170413 11:24:37 InnoDB: highest supported file format is Barracuda. 170413 11:24:37 InnoDB: Waiting for the background threads to start 170413 11:24:38 InnoDB: 5.5.54 started; log sequence number 1595675 ERROR: 1050 Table 'plugin' already exists 170413 11:24:38 [ERROR] Aborting 170413 11:24:38 InnoDB: Starting shutdown... 170413 11:24:39 InnoDB: Shutdown completed; log sequence number 1595675 170413 11:24:39 [Note] /usr/sbin/mysqld: Shutdown complete 170413 11:24:39 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 170413 11:24:39 [Note] Plugin 'FEDERATED' is disabled. 170413 11:24:39 InnoDB: The InnoDB memory heap is disabled 170413 11:24:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 11:24:39 InnoDB: Compressed tables use zlib 1.2.8 170413 11:24:39 InnoDB: Using Linux native AIO 170413 11:24:39 InnoDB: Initializing buffer pool, size = 128.0M 170413 11:24:39 InnoDB: Completed initialization of buffer pool 170413 11:24:39 InnoDB: highest supported file format is Barracuda. 170413 11:24:39 InnoDB: Waiting for the background threads to start 170413 11:24:40 InnoDB: 5.5.54 started; log sequence number 1595675 170413 11:24:40 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 170413 11:24:40 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 170413 11:24:40 [Note] Server socket created on IP: '127.0.0.1'. 170413 11:24:40 [Note] Event Scheduler: Loaded 0 events 170413 11:24:40 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.54-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) 170414 8:55:19 [Note] /usr/sbin/mysqld: Normal shutdown 170414 8:55:19 [Note] Event Scheduler: Purging the queue. 0 events 170414 8:55:21 [Warning] /usr/sbin/mysqld: Forcing close of thread 578 user: 'root' 170414 8:55:21 [Warning] /usr/sbin/mysqld: Forcing close of thread 577 user: 'root' 170414 8:55:21 [Warning] /usr/sbin/mysqld: Forcing close of thread 576 user: 'root' 170414 8:55:21 [Warning] /usr/sbin/mysqld: Forcing close of thread 575 user: 'root' 170414 8:55:22 InnoDB: Starting shutdown... 170414 8:55:23 InnoDB: Shutdown completed; log sequence number 1793762 170414 8:55:24 [Note] /usr/sbin/mysqld: Shutdown complete
-
Hallo,
woran kann es liegen dass ich auf meinem vServer MySQL nichtmehr starten kann?
Hoffe ihr könnt mir helfen
Grüße -
Hab mein Fehler gefunden
hab ein return vergessen
-
Heyy, ich hätte noch eine Frage. Und zwar warum wird in die Tabelle nix eingetragen?
Code
Alles anzeigenstock CreateFraktionTabelle() { new query[1024]; format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `"SQL_DTAG"fraktionen` ("); format(query, sizeof(query), "%s `ID` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Kasse` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `SafeWaffenteile` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `SafeDrogen` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `SafeSpice` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `Rang0` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang1` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang2` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang3` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang4` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang5` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Rang6` varchar(32) NOT NULL,", query); format(query, sizeof(query), "%s `Member` int(11) NOT NULL,", query); format(query, sizeof(query), "%s `MaxMember` int(11) NOT NULL", query); format(query, sizeof(query), "%s) ENGINE=InnoDB DEFAULT CHARSET=latin1;", query); mysql_pquery(handle, query); CreateFraktionData(); return 1; } stock CreateFraktionData() { new query[2048]; format(query, sizeof(query), "INSERT INTO `"SQL_DTAG"fraktionen` (`ID`, `Kasse`, `SafeWaffenteile`, `SafeDrogen`, `SafeSpice`, `Rang0`, `Rang1`, `Rang2`, `Rang3`, `Rang4`, `Rang5`, `Rang6`, `Member`, `MaxMember`) VALUES"); format(query, sizeof(query), "%s (0, 0, 0, 0, 0, '', '', '', '', '', '', '', 0, 1000000),", query); format(query, sizeof(query), "%s (1, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (2, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (3, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'Vize Präsident', 'Präsident', 0, 12),", query); format(query, sizeof(query), "%s (4, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'Arzt', 'Oberarzt', 0, 12),", query); format(query, sizeof(query), "%s (5, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (6, 1000000, 0, 0, 0, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (7, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (8, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (9, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (10, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (11, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (12, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (13, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (14, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12),", query); format(query, sizeof(query), "%s (15, 500000, 20000, 500, 1000, 'Rang0', 'Rang1', 'Rang2', 'Rang3', 'Ausbilder', 'CoLeader', 'Leader', 0, 12);", query); mysql_pquery(handle, query); }
Die Tabelle wird jedoch erstellt. Aber nix eingetragenIm MySQL Log steht nix
-
ja natürlich, das ist schwachsinn. Jeder Spieler hat in seinem Enum bool:pAdminDuty also jeder Spieler wird dann als Admin aufgelistet der nicht im Dienst ist.
Enum:
enum SpielerDaten {
p_ID,
pName[MAX_PLAYER_NAME],
pPasswort[65],
pGeschlecht,
pGeburtsdatum[11],
pTutorial,
pLevel,
pBarGeld,
pSpawnChange,
pSkin,
pAdmin,
pPerso,
pFraktion,
pFraktionRang,bool:pLoggedIn,
bool:pPersoBeantragt,
bool:pPersoAbholbar,
bool:pAdminDuty,
}; -
Aber dann werden doch auch die Spieler aufgelistet die keinen Adminrang haben
-
Warum stehe ich doppelt und dreifach in der Liste?
Code
Alles anzeigenocmd:admins(playerid, params[]) { new d_info[512]; for(new i;i<MAX_PLAYERS; i++) { for(new a;a<sI[i][pAdmin] >= 1; a++) { if(sI[i][pAdminDuty] == true) { format(d_info, sizeof(d_info), "%s"HTML_ROT"%s ( %s ) \n",d_info, sI[i][pName], GetAdminRangName(sI[i][pAdmin])); } else if(sI[i][pAdminDuty] == false) { format(d_info, sizeof(d_info), "%s"HTML_WEIS"%s ( %s ) \n",d_info, sI[i][pName], GetAdminRangName(sI[i][pAdmin])); } } ShowPlayerDialog(playerid, D_USER_ADMINLIST, DIALOG_STYLE_MSGBOX, ""SERVER_HTML""SERVER_TAG""HTML_WEIS": Adminliste", d_info, "Schliesen", ""); } return 1; }
-
Wie gesagt du musst autohotkey ansi-32 installieren
-
Vllt Nachts um 3:30 Uhr die falsche Uhrzeit.
Vielleicht eine Flasche Sekt oder so -
Okay, ich will aber auch die Admins auflisten die nicht im Admin Dienst sind
-
Ich habe das bis jetzt bin mir aber nicht genau sicher wie ich abfrage wer Duty ist und wer nicht. Ebenfalls nicht wie die Admins auflisten lassen soll
-
Heii,
ich möchte ein Dialog im MSGBox Style machen indem alle Admin aufgelistet werden die Online sind.
Und es sollen die Admin Rot sein die gerade online sind. Wie stellt man sowas an?
Grüße -
Wie sieht die Funktion zum Laden der Statistiken aus, und wie das enum dazu?
Hat sich erledigt. Auf meinem anderen Root geht es ohne Probleme. Auf dem alten hatte ich probleme mit dem MySQL Server. der ist immer abgestürzt. Lag warscheinlich iwie daran oder so.
Funktioniert danke!