mhh ok habe grade noch was angefügt hatte im tutorial die CfgRemoteExec Einträge vergessen
das kommt mir jetzt komisch vor
[Tutorial 4.4R4+] Verwahrungsstelle nach Impounden
-
- Altis Life
-
br1zey -
25. Juni 2016 um 00:18
-
Ja, mir allerdings auch, immerhin wird die update table ja nur einmal ausgeführt... Seltsamerweise setzt sich mein "Typ" wo ich als Verfahrungsstelle definiert habe auch ganz wo anders hin, auf der Map selber steht er aber am richtigen Ort... Sehr seltsam! Quasi habe ich den im Editor wo hin gesetzt, und ingame auf dem Server ist er dann wo anders, und zwar deutlich weiter weg.
-
Nein nein, er läuft nicht! er steht da, und macht nix! "enableSimulation false" hab ich ja mit in die init gegeben. Ich kann es mir auch nicht erklären..
-
Nur das, was du reingeschrieben hast
-
Ich werde gerade nicht schlau aus dem Error der extDB2:
Spoiler anzeigen
[12:09:03:672083 +02:00] [Thread 12552] extDB2: Database Type: MySQL
[12:09:03:675083 +02:00] [Thread 12552] extDB2: Database Session Pool Started
[12:09:03:676083 +02:00] [Thread 12552] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[12:11:59:066115 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:11:59:066115 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:12:23:755527 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:12:23:755527 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:08:513087 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198101954416', '1','1','"[[],0]"', '8', '965650', '0', '"[]"')
[12:13:08:513087 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198101954416', '1','1','"[[],0]"', '8', '965650', '0', '"[]"')
[12:13:23:876966 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: UPDATE vehicles SET active='0',impound='1', inventory='[[],0]', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561198101954416' AND plate='965650'
[12:13:23:876966 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE vehicles SET active='0',impound='1', inventory='[[],0]', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561198101954416' AND plate='965650'
[12:13:39:099836 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:39:100836 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:43:460086 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:43:460086 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:48:000345 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:48:001345 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:51:801563 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:51:801563 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:55:101751 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:55:101751 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:59:140983 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:59:141983 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:27:55:689830 +02:00] [Thread 12552] extDB2: Stopping ...Narf
-
Alles anzeigen
Ich werde gerade nicht schlau aus dem Error der extDB2:
Spoiler anzeigen
[12:09:03:672083 +02:00] [Thread 12552] extDB2: Database Type: MySQL
[12:09:03:675083 +02:00] [Thread 12552] extDB2: Database Session Pool Started
[12:09:03:676083 +02:00] [Thread 12552] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[12:11:59:066115 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:11:59:066115 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:12:23:755527 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:12:23:755527 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:08:513087 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198101954416', '1','1','"[[],0]"', '8', '965650', '0', '"[]"')
[12:13:08:513087 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198101954416', '1','1','"[[],0]"', '8', '965650', '0', '"[]"')
[12:13:23:876966 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: UPDATE vehicles SET active='0',impound='1', inventory='[[],0]', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561198101954416' AND plate='965650'
[12:13:23:876966 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE vehicles SET active='0',impound='1', inventory='[[],0]', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561198101954416' AND plate='965650'
[12:13:39:099836 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:39:100836 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:43:460086 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:43:460086 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:48:000345 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:48:001345 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:51:801563 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:51:801563 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='1' AND side='civ' AND type='Car'
[12:13:55:101751 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:55:101751 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:59:140983 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'impound' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:13:59:141983 +02:00] [Thread 16284] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='76561198101954416' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'
[12:27:55:689830 +02:00] [Thread 12552] extDB2: stopping ...Narf
Spalte impound in Datenbank wie im Tut beschrieben eingefügt?
-
Aye, hatte ich gemacht, gerade nochmal nachgeschaut und jepp, tabelle ist drinn
-
DB-Fehler konnte ich begheben...
-
Sollte doch eigentlich nur eine Spalte "impound" in der Tabelle "vehicles" erstellen und nicht gleich eine ganze Tabelle..
-
DB-Fehler konnte ich begheben...
Woran lag es denn bei dir wenn ich fragen darf?
-
Ach frag lieber nicht, aber...
John Hannibal, ich kann jetzt mit erfolg sagen, dass es bei mir läuft. Endlich..., allerdings kann ich nicht mehr nachvollziehen was ich jetzt anders gemacht habe aber im ganzen stimmt das tut wie es brizey im TUT beschrieben hat. musste es halt nur an meinen eigenen Sachen anpassen. -
Ach frag lieber nicht, aber...
John Hannibal, ich kann jetzt mit erfolg sagen, dass es bei mir läuft. Endlich..., allerdings kann ich nicht mehr nachvollziehen was ich jetzt anders gemacht habe aber im ganzen stimmt das tut wie es brizey im TUT beschrieben hat. musste es halt nur an meinen eigenen Sachen anpassen.Hm mist. Wie oben schon beschrieben, aus irgend einem Grund portet es mir den Typen in der Gegend herum... war das bei dir auch so?
-
neee, kopier dir mal nen vorhandenen tankstellenwart und dann copy paste die INIT beim NPC.
-
Hab ich schon gemacht, war der erste Lösungsansatz von mir... auch der wird geportet
-
das ist sehr sehr merkwürdig, dass die NPC`s sich selbstständig machen, ne Quanten-CPU hast nicht zufällig drinn? *Lach*
-
das habe ich auch noch nicht erlebt bis auf seit dem 3D editor hatt ich was vergessen und die sind rumgelaufen
aber bei dir Steht der ja an einer ganz anderen stelle und noch mal zu info habe das tutorial grade noch mal überprüft bzw in eine clean Altis Life Mission eingebaut und geht wunderbar
-
jepp, kann ich so bestätigen, in einer Clean Life Mission sollte es so funktionieren, musste es bei nur etwas anpassen, dann lief es auch. Also vorsicht bei Copy Paste und Prüfen ob man es so direkt übernehmen kann, dann sollte es auch gehen.