cp_cronjob Hilfe

Paulo · 28. Februar 2016

Hallo, da mein Server abstürzt wenn man ein Report annimmt, habe ich das Crashdetect raufgeladen. Es kommt sowas in der Serer Log

http://www.pic-upload.de/view-29878287/Screen.png.html

Wäre echt korrekt, wenn sich jemand per PN meldet der es mir vielleicht per Teamviewer beheben kann.

Jeffry · 28. Februar 2016

Die Tabelle "tb_outstanding" existiert in deiner Datenbank nicht, lege diese entsprechend an.

In der Tabelle "cp_cronjob" fehlt eine Spalte "status". Füge diese entsprechend hinzu.

Paulo · 28. Februar 2016

Ich kann die Tabelle zwar hinzufügen, nur weiß ich nicht was ich hinzufügen muss also die ganzen Werte

Jeffry · 28. Februar 2016

Du musst die Tabelle mit den entsprechenden Spalten (findest du im Code, wenn du nach dem Tabellenname suchst) anlegen. Dazu in den Queries im Code die Spalten auslesen, die verwendet werden.
Werte musst du keine rein schreiben, ich schätze mal das macht der Code.

Paulo · 28. Februar 2016

Meinst du im Crashcode?

Jeffry · 28. Februar 2016

Daraus könntest du es auch ablesen ja, ist aber etwas aufwändiger.
Ich meinte den PAWN Code, dort stehen die Queries ja drin, die die Tabelle verwenden, also auch die Spalten dazu.

Paulo · 28. Februar 2016

Suche weiterhin jemanden, der mir hilft

Jeffry · 28. Februar 2016

Auf Nachfrage nach TeamViewer Support:
Die Gründe warum ich auf die Scripting Base verweise

Da du keine Eigeninitiative zeigst, und es nicht mal versuchst, sehe ich es zudem nicht ein, dir da über TeamViewer zu helfen.
Ich habe dir Hilfestellungen gegeben, und gesagt was du machen sollst. Versuche das doch mal.

Zu sagen, dass du da nur etwas kaputt machst ist mir unschlüssig, da du nur - dem Fehler nach zumindest - die Tabellen pflegen musst.
Mache das, und poste dann gegebenenfalls die neue Fehlermeldung.

Maxi_Waynee · 28. Februar 2016

oki laut dem Log tippe ich mal auf das LoS script das hat viele bugs das zu beheben ist schwer bei mir hat es mein scripter gemacht aber der ist verschwunden leider das war ein scripter von dem server also er kannte das script mega gut

Paulo · 28. Februar 2016

pic-upload.de/view-29881242/Screen1.png.html Das sind die jetzigen Codes.

Kann es sein, dass ich hier noch was hinzufügen muss? pic-upload.de/view-29881252/Screen3.png.html

Jeffry · 28. Februar 2016

"targetName" fehlt in der Tabelle "cp_cronjob".
Füge diese Spalte als VARCHAR hinzu.

Paulo · 28. Februar 2016

Habe ich und nun? meinst es klappt dann?

Jeffry · 28. Februar 2016

Das weiß ich nicht, da ich den Code nicht kenne.

Paulo · 28. Februar 2016

[22:17:06] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:07] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:08] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:08] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:08] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:09] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:09] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:09] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:09] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:09] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:10] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:11] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:11] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:11] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:12] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:12] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:13] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:13] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:13] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:13] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:14] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:14] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:14] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:14] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:15] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:15] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:15] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:15] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:16] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:16] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:16] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:16] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:16] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:17] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:17] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:17] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:17] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:17] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:18] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:18] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:18] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:18] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:18] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:19] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:19] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 9|[22:17:19] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:20] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:21] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:21] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 9|[22:17:21] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:21] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:22] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:22] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:23] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:23] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:23] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:24] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:24] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:24] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:25] TimePublic[22:17:25] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:25] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:25] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:25] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:25] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:25] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:26] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:27] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:28] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:29] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 0|[22:17:29] [connection] 79.232.252.5:64839 requests connection cookie.[22:17:29] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:29] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:29] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:30] [connection] incoming connection: 79.232.252.5:64839 id: 1[22:17:30] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:30] [join] JasoN_CruZe has joined the server (1:79.232.252.5)[22:17:30] OnPlayerConnect 0 | Name: JasoN_CruZe[22:17:30] OnPlayerConnect 1 Name: JasoN_CruZe[22:17:30] OnPlayerConnect 2[22:17:30] OnPlayerConnect 3[22:17:30] OnPlayerConnect 4[22:17:30] OnPlayerConnect 5[22:17:30] OnPlayerConnect 6[22:17:30] OnPlayerConnect 7[22:17:30] WantedLevelBesse[22:17:30] OnPlayerConnect 8[22:17:30] OnPlayerConnect 9[22:17:30] OnPlayerConnect 10[22:17:30] OnPlayerConnect 11[22:17:30] OnPlayerConnect 12[22:17:30] ConnectDDTexte[22:17:30] OnPlayerConnect 13[22:17:30] ConnectPlayer 1 | Name: JasoN_CruZe[22:17:30] ConnectPlayer 2 | Name: JasoN_CruZe[22:17:30] ConnectPlayer 3 | Name: JasoN_CruZe[22:17:30] ConnectPlayer 4 | Name: JasoN_CruZe[22:17:30] CheckLoginExecute 1[22:17:30] CheckLoginExecute 2[22:17:30] OnTurfConnect[22:17:30] CheckLoginExecute 4[22:17:31] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:32] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:32] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:32] checkBan 1 | Name: JasoN_CruZe[22:17:32] checkBan 2 | Name: JasoN_CruZe[22:17:32] Error-ID: 1146 | Error: Table 'Danny_1493.view_bans' doesn't exist | Callback: checkBanExecute | Query: SELECT * FROM view_bans WHERE user LIKE 'JasoN_CruZe'[22:17:32] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:33] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:33] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:33] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:33] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:33] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:34] CheckLOSName 1[22:17:34] checktimeban 1 | Name: JasoN_CruZe[22:17:34] Error-ID: 1054 | Error: Unknown column 'usr_name' in 'where clause' | Callback: CheckTimebans | Query: SELECT * FROM tb_outstanding WHERE usr_name LIKE 'JasoN_CruZe' AND status = '0' ORDER BY id ASC LIMIT 1[22:17:34] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:34] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:35] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:35] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:35] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:35] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:36] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:36] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:36] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:37] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:37] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:37] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:38] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:38] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:38] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:39] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:39] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:39] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:40] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:41] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:41] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 9|[22:17:41] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:41] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:41] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 9|[22:17:42] OnDialogResponse (1,100,1,-1,^^^^^^^^^^^^^^^^^12mama12)[22:17:42] LoginPlayer[22:17:42] LoginPlayer2[22:17:42] LoginPlayer2[22:17:42] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:42] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:42] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:43] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:44] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:44] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:44] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:44] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:44] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:45] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:46] OnDialogResponse (1,100,1,-1,12mama12)[22:17:46] LoginPlayer[22:17:46] LoginPlayer2[22:17:46] LoginPlayer3[22:17:46] LoginPlayer4[22:17:46] LoginPlayer5[22:17:46] LoginPlayer6[22:17:46] LoginPlayer7[22:17:46] LoginPlayer8[22:17:46] Log00[22:17:46] LoginPlayer9[22:17:46] Log01[22:17:46] Log1[22:17:46] OnTurfConnect[22:17:46] WantedLevelBesse[22:17:46] AutoLoad1[22:17:46] AutoLoad3[22:17:46] AutoLoad5[22:17:46] AutoLoad6[22:17:46] ShowTicketSystem[22:17:46] AutoLoad7[22:17:46] AutoLoad8[22:17:46] LoginPlayer2[22:17:46] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:46] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:46] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:46] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:47] OnPlayerStateChange| PLAYERID: 1, STATE_NEW: 8| STATE_OLD: 0| VEH-ID: 0[22:17:47] OnPlayerStateChange 1[22:17:47] OnPlayerStateChange5 | PLAYERID: 1[22:17:47] OnPlayerStateChange14 | PLAYERID: 1[22:17:47] OnPlayerSpawn[22:17:47] ShowTicketSystem[22:17:47] SpielerSpawnen[22:17:47] SpielerSpawnen 2[22:17:47] SpielerSpawnen 3[22:17:47] SpielerSpawnen 4[22:17:47] SpielerSpawnen 5[22:17:47] SpielerSpawnen 6[22:17:47] SpielerSpawnen 7[22:17:47] SpielerSpawnen 8[22:17:47] OnPlayerStateChange| PLAYERID: 1, STATE_NEW: 1| STATE_OLD: 8| VEH-ID: 0[22:17:47] OnPlayerStateChange 1[22:17:47] OnPlayerStateChange5 | PLAYERID: 1[22:17:47] OnPlayerStateChange13 | PLAYERID: 1[22:17:47] OnPlayerStateChange14 | PLAYERID: 1[22:17:47] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:47] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:48] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:48] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 40|[22:17:48] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:48] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:49] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:49] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:49] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:50] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:50] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:51] [connection] 37.201.195.232:30056 requests connection cookie.[22:17:51] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:17:51] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:51] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:52] [connection] incoming connection: 37.201.195.232:30056 id: 2[22:17:52] [join] Martin has joined the server (2:37.201.195.232)[22:17:52] OnPlayerConnect 0 | Name: Martin[22:17:52] OnPlayerConnect 1 Name: Martin[22:17:52] OnPlayerConnect 2[22:17:52] OnPlayerConnect 3[22:17:52] OnPlayerConnect 4[22:17:52] OnPlayerConnect 5[22:17:52] OnPlayerConnect 6[22:17:52] OnPlayerConnect 7[22:17:52] WantedLevelBesse[22:17:52] OnPlayerConnect 8[22:17:52] OnPlayerConnect 9[22:17:52] OnPlayerConnect 10[22:17:52] OnPlayerConnect 11[22:17:52] OnPlayerConnect 12[22:17:52] ConnectDDTexte[22:17:52] OnPlayerConnect 13[22:17:52] ConnectPlayer 1 | Name: Martin[22:17:52] ConnectPlayer 2 | Name: Martin[22:17:52] ConnectPlayer 3 | Name: Martin[22:17:52] ConnectPlayer 4 | Name: Martin[22:17:52] CheckLoginExecute 1[22:17:52] CheckLoginExecute 3[22:17:52] OnTurfConnect[22:17:52] CheckLoginExecute 4[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 8|[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 8|[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 32|[22:17:52] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 8|[22:17:52] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:52] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:53] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:17:53] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 32|[22:17:53] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 8|[22:17:53] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:53] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:54] checkBan 1 | Name: Martin[22:17:54] checkBan 2 | Name: Martin[22:17:54] Error-ID: 1146 | Error: Table 'Danny_1493.view_bans' doesn't exist | Callback: checkBanExecute | Query: SELECT * FROM view_bans WHERE user LIKE 'Martin'[22:17:54] RCON (In-Game): Player #0 (Danny_Costo) has logged in.[22:17:54] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:54] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:55] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 0|[22:17:55] CheckLOSName 1[22:17:55] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:55] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:56] checktimeban 1 | Name: Martin[22:17:56] Error-ID: 1054 | Error: Unknown column 'usr_name' in 'where clause' | Callback: CheckTimebans | Query: SELECT * FROM tb_outstanding WHERE usr_name LIKE 'Martin' AND status = '0' ORDER BY id ASC LIMIT 1[22:17:56] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 8|[22:17:56] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:56] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:57] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:57] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:58] OnPlayerCommandText (ID: 1)(/support )[22:17:58] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 0|[22:17:59] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:17:59] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:17:59] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys (| oldkeys: 8|[22:17:59] OnPlayerCommandText (ID: 1)(/support ffcf)[22:17:59] ShowTicketSystem[22:17:59] JasoN_CruZe(ID: 1) erstellt ein neues Ticket. Grund "ffcf"[22:17:59] OnPlayerKeyStateChange| PLAYERID: 0, PLAYERNAME Danny_Costo, newkeys | oldkeys: 40|[22:18:00] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:18:00] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:18:00] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:18:00] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 8|[22:18:00] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 32|[22:18:00] OnPlayerKeyStateChange| PLAYERID: 1, PLAYERNAME JasoN_CruZe, newkeys | oldkeys: 0|[22:18:00] OnPlayerCommandText (ID: 0)(/att 1)[22:18:00] ShowTicketSystem[22:18:01] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353955' OR targetName = 'Danny_Costo');[22:18:01] Error-ID: 1054 | Error: Unknown column 'targetName' in 'where clause' | Callback: OnExecuteCronjob | Query: SELECT * FROM cp_cronjob WHERE status = 0 AND (targetID = '353963' OR targetName = 'JasoN_CruZe');[22:18:01] [chat] [Danny_Costo]: t[22:18:01] OnPlayerText[22:18:01] OnPlayerText 1[22:18:01] OnPlayerText 2[22:18:01] OnPlayerText 3

Das waren jz die Codes, als ich den Report angenommen habe ist der Server wieder direkt abgeschmiert

@Jeffry

Jeffry · 29. Februar 2016

targetName fehlt weiterhin in der cp_cronjob Tabelle (siehe letzte Zeile).

Paulo · 29. Februar 2016

Ist doch drinnen,

http://www.pic-upload.de/view-29892198/Screen4.png.html

Jeffry · 29. Februar 2016

Nein, du hast es in der falschen Tabelle hinzugefügt.

Erstelle erst mal die cp_cronjob Tabelle. Dort fügst du dann das targetName Feld hinzu.

Paulo · 29. Februar 2016

Soll ich die als Varchar hinzufügen oder normal lassen?

Jeffry · 29. Februar 2016

Das targetName Feld musst du als VARCHAR anlegen.

Paulo · 29. Februar 2016

[21:32:51] Error-ID: 1146 | Error: Table 'Danny_1493.view_bans' doesn't exist | Callback: checkBanExecute | Query: SELECT * FROM view_bans WHERE user LIKE 'Danny_Costo'
[21:32:52] CheckLOSName 1
[21:32:53] checktimeban 1 | Name: Danny_Costo
[21:32:53] Error-ID: 1054 | Error: Unknown column 'usr_name' in 'where clause' | Callback: CheckTimebans | Query: SELECT * FROM tb_outstanding WHERE usr_name LIKE 'Danny_Costo' AND status = '0' ORDER BY id ASC LIMIT 1
[21:32:56] OnDialogResponse (1,100,1,-1,passwort123)