Issue with MySQL database

Discuss everything about Xymph's Aseco flavoured server control scripts for TM Forever / classic TMN and for TM² Canyon.

Moderators: Xymph, TM-Patrol

Post Reply
gorn_z34
sunday driver
sunday driver
Posts: 54
Joined: 25 Feb 2019 17:32
Owned TM-games: TMUF

Issue with MySQL database

Post by gorn_z34 » 18 Apr 2021 05:38

I just restore backup of my xaseco mysql database because of update of AMPPS to 3.9 because it has PHP 7.3, all works fine but i noticed in the records eyepiece tables, for example local records are names with weird signs, when i reach my localhost phpmyadmin i noticed that these tables are encoded in latin1_swedish_ci, tried to change to utf8_general_ci but i get some error.

User avatar
L3cKy
smooth traffic navigator
smooth traffic navigator
Posts: 282
Joined: 05 Sep 2007 13:55
Owned TM-games: TMUF
Location: Berlin
Contact:

Re: Issue with MySQL database

Post by L3cKy » 18 Apr 2021 12:40

If you want to change the collation you have to convert every table individually with this sql statement.
Do a backup before you do this.

Code: Select all

ALTER DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
So long L3cKy
Last edited by L3cKy on 18 Apr 2021 22:36, edited 2 times in total.

gorn_z34
sunday driver
sunday driver
Posts: 54
Joined: 25 Feb 2019 17:32
Owned TM-games: TMUF

Re: Issue with MySQL database

Post by gorn_z34 » 18 Apr 2021 16:33

I get error #1067 - Incorrect default value for 'UpdatedAt' when im doing it thats why i posted it here.

Post Reply