Savepos mysql error?

[muppet922]

Hello,

L 10/17/2023 - 00:39:16: [MySQL] Invalid info tuple handle: 0
L 10/17/2023 - 00:39:16: [AMXX] Displaying debug trace (plugin "kz/kz_sql_savepos.amxx", version "10/17/2023")
L 10/17/2023 - 00:39:16: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 10/17/2023 - 00:39:16: [AMXX]    [0] kz_sql_savepos.sma::kz_sql_data_recv (line 68)

[Theggv]

This error makes no sence, because kz_sql_data_recv can only be called from kz_sql_core if tuple is valid in the first place.
If it appears once in a month just ignore it.

[muppet922]

Hello,

I use SQL-TOP not the web version. There are more database errors, sadly I wiped logs due to changing host. I will gather more and inform you about them, like savepos issue was spamming one time if i remember correctly.

L 10/16/2023 - 20:50:01: Log file started (file "cstrike/addons/amxmodx/logs/kz_db_log/main.log") (game "cstrike") (amx "1.9.0.5294")
L 10/16/2023 - 20:50:01: [ERROR][dummyHandler] [1062] Duplicate entry '' for key 'steam_id' (0.55 sec)
L 10/16/2023 - 22:07:51: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (9.99 sec)
L 10/16/2023 - 22:07:51: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (8.95 sec)

[muppet922]

L 10/18/2023 - 21:08:38: [MySQL] Invalid info tuple handle: 0

L 10/18/2023 - 21:08:38: [AMXX] Displaying debug trace (plugin "kz/kz_sql_savepos.amxx", version "10/17/2023")

L 10/18/2023 - 21:08:38: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")

L 10/18/2023 - 21:08:38: [AMXX]    [0] kz_sql_savepos.sma::kz_sql_data_recv (line 68)

L 10/18/2023 - 21:08:45: [MySQL] Invalid info tuple handle: 0

L 10/18/2023 - 21:08:45: [AMXX] Displaying debug trace (plugin "kz/kz_sql_savepos.amxx", version "10/17/2023")

L 10/18/2023 - 21:08:45: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")

L 10/18/2023 - 21:08:45: [AMXX]    [0] kz_sql_savepos.sma::kz_sql_data_recv (line 68)

L 10/18/2023 - 21:25:07: Client index 3 is invalid

---

L 10/18/2023 - 16:08:26: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (4.59 sec)

L 10/18/2023 - 18:01:32: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (3.35 sec)

L 10/18/2023 - 18:19:54: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (2.32 sec)

L 10/18/2023 - 18:41:44: [ERROR][dummyHandler] [1062] Duplicate entry '' for key 'steam_id' (0.56 sec)

L 10/18/2023 - 19:03:27: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (40.63 sec)

L 10/18/2023 - 19:15:53: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `kz_uid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (12.00 sec)

L 10/18/2023 - 21:25:08: [ERROR][dummyHandler] [1062] Duplicate entry '' for key 'steam_id' (0.53 sec)

first error sometimes spam console

LATEST EDIT:

L 10/19/2023 - 16:17:30: [ERROR][dummyHandler] [1452] Cannot add or update a child row: a foreign key constraint fails (`s1506_kreedz`.`kz_start_pos`, CONSTRAINT `kz_start_pos_ibfk_2` FOREIGN KEY (`map_id`) REFERENCES `kz_maps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) (15.61 sec)