MySQL server has gone away - Invalid query

[gloobus]

CodeIgniter v3 + CodeIgniter-Ion-Auth
PHP 7.4
MariaDB 5.5.68

CodeIgniter log:

ERROR - 2022-02-02 08:55:59 --> Query error: MySQL server has gone away - Invalid query: SELECT t_users.*, t_users.id as id, t_users.id as user_id
FROM t_users
WHERE t_users.id = '546'
ORDER BY t_users.id DESC
LIMIT 1

The problem was solved in the following way, Ion_auth_model.php:

$this->db->select([
$this->tables['users'].'.*',
// $this->tables['users'].'.id as id',
$this->tables['users'].'.id as user_id'
]);

CodeIgniter-Ion-Auth/models/Ion_auth_model.php

Line 1400 in dc05585

// default selects

Why is ID as ID displayed in this SELECT?
ID from the user table is still returned through <*>.
After I removed the $this->tables['users'].'.id as id' output, the errors stopped

[benedmunds]

"MySQL server has gone away" is usually a connection error. Truthfully I don't remember the reason for this, I think it was to account for custom selects.

This code has been here for over 10 years though so my best guess is that it's a coincidence that this fixed it and there was a connection error. It is possible that a newer MySQL version is failing on this though.