We got error while altering a table in mysql

The issue was due to strict mode enabled in Mysql

You can check if mysql strict mode is checked using below command

# mysql

mysql> SELECT @@sql_mode;

If you see statement

+———————————————————————————————————————–+
| @@sql_mode |
+———————————————————————————————————————–+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+———————————————————————————————————————–+
1 row in set (0.01 sec)

To disabled it

open fie /etc/my.cnf

Add in below of file sql_mode=” “

and restart mysql

This will disable strict mode in mysql

Alter command works fine now

Getting error Error: GPG check FAILED while installing any package on alma linux 8 ?

While installing a package got an error

[root@secure ~]# yum install traceroute
Last metadata expiration check: 0:43:24 ago on Saturday 23 November 2024 10:15:46 AM EST.

Dependencies resolved.

Package Architecture Version Repository Size

Installing:
traceroute x86_64 3:2.1.0-8.el8 baseos 66 k

Transaction Summary

Install 1 Package

Total download size: 66 k
Installed size: 101 k
Is this ok [y/N]: y
Downloading Packages:

traceroute-2.1.0-8.el8.x86_64.rpm 260 kB/s | 66 kB 00:00

Total 147 kB/s | 66 kB 00:00
AlmaLinux 8 – BaseOS 3.3 MB/s | 3.4 kB 00:00
Importing GPG key 0xC21AD6EA:
Userid : “AlmaLinux packager@almalinux.org“
Fingerprint: E53C F5EF 91CE B0AD 1812 ECB8 51D6 647E C21A D6EA
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-AlmaLinux
Is this ok [y/N]: y
Key imported successfully
Import of key(s) didn’t help, wrong key(s)?
Public key for traceroute-2.1.0-8.el8.x86_64.rpm is not installed. Failing package is: traceroute-3:2.1.0-8.el8.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-AlmaLinux
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing ‘yum clean packages’.
Error: GPG check FAILED

Fixed this issue by importing new repodata from Almaliux

rpm –import https://repo.almalinux.org/almalinux/RPM-GPG-KEY-AlmaLinux

This fixed my issue and was able to install any package

https://almalinux.org/blog/2023-12-20-almalinux-8-key-update/