Error in enabling database

[badguyp]

Expected behavior

Actual behavior

Steps to reproduce the behavior

1.Download the project code
2.Create database
3.Turn on ENABLE_DATABASE(define('ENABLE_DATABASE', TRUE);)
My php version 7.3
My mysql version 5.7
If you can hope for a reply, thank you

[johnnymast]

Hi badguyp,

I have noticed and fixed this bug in version 1.5. But I will try to release a fix for you today.

[johnnymast]

Update: Inserts for private chat and public chat have manually been tested.

[johnnymast]

A new release is out. Could you reimport the database table (I updated the import file) and verify it works now for you?
Once verified I close the issue. Thanks in advance @badguyp

[badguyp]

Hi johnnymast,
I have seen the repaired version and it is very good
I also tried to simply repair the Database.php file.
public function insert(
$to_id = 0,
$from_id = 0,
$message = '',
$ip_address = ''
): void {
$statement = $this->prepare(
"INSERT INTO chat_interactions
SET
to_id = :to_id,
from_id = :from_id,
message = :message,
ip_address = :ip_address"
);

    $statement->execute(
        [
        'to_id' => isset($to_id->id)?$to_id->id:$to_id,
        'from_id' => $from_id,
        'message' => $message,
        'ip_address' => $ip_address
        ]
    );
}

Thank you again for your answer to my question, and at the end, please forgive me for my poor English.

[johnnymast]

Hello badguyp,

I think in newer php versions (7 and up) this style of code could also be fixed with the following line.

$statement->execute(
            [
                'to_id' => $to_id ?? null,
                'from_id' => $from_id,
                'message' => $message,
                'ip_address' => $ip_address
            ]
        );

PS: Your English is good enough for me. I hope you enjoy your update, I am still working on a 1.5 update that will bring SSL and docker support for the project.

[badguyp]

Hello johnnymast,
Version 1.5 is too timely, this must be a great project

[johnnymast]

That is true but i also have 97 repos to take care of :)