EXTDB3 Log wird vollgespamt

TheFireRunner Felix

Hey ihr

Aus einem Grund denn ich mir nicht erklären kann wird unser EXTDB3 Log vollgespamt...

DATEN:

Altis Life 4.4

EXTDB3

LOGS:

EXTDB3 Log: 16-6-12.log

Arma 3 Log: arma3server_x64_2018-06-11_16-05-33.rpt

Datenbank: Datenbank.zip

Hoffe jemand hat ein Grund dafür

LG

cat24max

Code

SQL: Error MariaDBQueryException: Unknown column 'pid' in 'where clause'

TheFireRunner Felix

Vorher stand da playerid. Ich habe es zu pid geändert aber es hat nix gebracht deswegen habe ich es wieder zu playerid zurückgemacht aber der Error besteht immer noch

cat24max

Du mischt anscheinend irgendwie die beiden Namen. Die müssen natürlich überall einheitlich heißen.

nox

Zitat von cat24max

Du mischt anscheinend irgendwie die beiden Namen. Die müssen natürlich überall einheitlich heißen.

Korrekt, offensichtlich eine falsche DB eingespielt, von einer älteren oder neueren Version. Achte darauf dass entweder pid oder playerid, bzw überall die gleiche Bezeichnung verwendet wird. Such mal in der @life_server danach, dort solltest du etwas finden

TheFireRunner Felix

Es kann sein das ich die normale Altis Life Version 4.4 benutze aber ich benutze das Skript Pack von HDTeam und dort ist eine andere Datenbank

Marius1773

Da gilt man sollte sich besser auskennen mit den Sachen die man benutzt.
Und außerdem Skript Packs sind sowieso nicht zu empfehlen aber naja...

Wie sieht die DB aus bzw. die SQL

TheFireRunner Felix

Datenbanken.zip Biddö

Marius1773

Wuut?
2 SQL?
Wir aber von Extdb nur eine Benutzt?

Marius1773

nevermind.

Ehm.. Ja muss in einem Script bzw. Datenbank Abfrage Dateien wie updatepartial etc. sein hmm.. Was hast denn daran verändert?

nox

Zitat von TheFireRunner

Es kann sein das ich die normale Altis Life Version 4.4 benutze aber ich benutze das Skript Pack von HDTeam und dort ist eine andere Datenbank

Kombinier halt nicht irgendwelche Scriptpacks mit irgendwelchen Datenbanken die nicht dazu gehören, andersherum ebenfalls ._.

TheFireRunner Felix

Also ich verändert folgendes:

Füge Message für MYSQL Handy hinzu
Erweitere Cop & Medic Level auf 17 Ränge
Füge impound hinzu wegen Verwahrungstelle
Füge bei der Tabelle in Vehicles eine neues Feld hinzu wegen VIS

Habe das mal mit dem Skriptpack Datenbank Ding probiert aber jetzt kommt:

SQL

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.027
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[18:10:54:814450 +02:00] [Thread 5064] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[18:10:54:815426 +02:00] [Thread 5064] extDB3: SQL: Initialized: NULL = ""
[18:10:54:815532 +02:00] [Thread 5064] extDB3: Locked
[18:12:28:376003 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:28:376323 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:024604 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:024658 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:339386 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:339437 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:642978 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:643018 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:361177 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:361244 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:638205 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:638249 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:902021 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:902062 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:207003 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:207075 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:480013 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:480053 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:712959 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:713015 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:969318 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:969362 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:232197 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:232236 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:735352 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:735393 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:998584 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:998614 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')

Alles anzeigen

nox

Zitat von TheFireRunner

Also ich verändert folgendes:

Füge Message für MYSQL Handy hinzu
Erweitere Cop & Medic Level auf 17 Ränge
Füge impound hinzu wegen Verwahrungstelle
Füge bei der Tabelle in Vehicles eine neues Feld hinzu mit wegen VIS

Habe das mal mit dem Skriptpack Datenbank Ding probiert aber jetzt kommt:

SQL

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.027
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[18:10:54:814450 +02:00] [Thread 5064] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[18:10:54:815426 +02:00] [Thread 5064] extDB3: SQL: Initialized: NULL = ""
[18:10:54:815532 +02:00] [Thread 5064] extDB3: Locked
[18:12:28:376003 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:28:376323 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:024604 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:024658 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:339386 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:339437 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:29:642978 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:29:643018 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:361177 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:361244 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:638205 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:638249 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:31:902021 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:31:902062 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:207003 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:207075 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:480013 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:480053 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:712959 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:713015 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:32:969318 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:32:969362 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:232197 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:232236 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:735352 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:735393 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[18:12:33:998584 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1
[18:12:33:998614 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198061631265', '[PP66] Felix Korn', '0', '2500000000', '"[`[PP66] Felix Korn`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')

Alles anzeigen

N' bisschen viel Geld auf'm Konto, wa? Maximal 9 stellen wen nich mich recht erinnere...

Marius1773

Code

[18:12:28:376003 +02:00] [Thread 1268] extDB3: SQL: Error MariaDBQueryException: Out of range value for column 'bankacc' at row 1

Da ist das Problem zuviel Geld

TheFireRunner Felix

Wie ?? Ist halt nen Funserver und da.. also xDDDDDD lol

TheFireRunner Felix

Also darf man nur 100.000.000$ auf dem Konto haben? -_-

Marius1773

Naja du hast 2.5 Millarden aufm Konto.

nox

Zitat von TheFireRunner

Also darf man nur 100.000.000$ auf dem Konto haben? -_-

Ich meine man kann dort maximal 999999999$ auf dem Konto haben

shoXy

Stell doch das Startgeld auf 1 Milliarde und verteile dann Paychecks von Millionen

TheFireRunner Felix

Das wäre ne Idee

Benutzer online in diesem Thema