Search found 205 matches

by chris
Sun Sep 22, 2024 3:53 pm
Forum: SQL
Topic: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'
Replies: 1
Views: 89

Re: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'

found a solution.
Apparently something went wrong or was incomplete with the latest update
to mysql Ver 15.1 Distrib 10.11.6-MariaDB

running the upgrade command solved a lot of problems:

Code: Select all

mysql_upgrade -u root -p
by chris
Sun Sep 22, 2024 3:50 pm
Forum: SQL
Topic: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'
Replies: 1
Views: 89

[ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'

Hello I get the following error in the logs of mariadb/mysql mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type e…UBLE_PREC_HB'). mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect defi...
by chris
Sat Jul 13, 2024 6:59 pm
Forum: General
Topic: SOLVED: Linux opera not playing videos
Replies: 3
Views: 20438

Re: SOLVED: Linux opera not playing videos

With the lastest version of opera (version 125.0.6422.143) (and Chromium) the last workaround doesn't work anymore. It crashes the page on youtube and doesn't play the videos in rumble.com. You can download libffmpeg.so from : https://github.com/iteufel/nwjs-ffmpeg-prebuilt/releases/ and copy over t...
by chris
Tue Jul 02, 2024 7:29 pm
Forum: MySQL
Topic: Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. P
Replies: 0
Views: 8253

Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. P

I got the message in my logs /var/log/mysql/error.log Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' So how to fix this ? On MySQL 8.0.34 through 8.3, you get this warning. After MySQL 8...
by chris
Wed Jun 12, 2024 7:25 pm
Forum: SQL
Topic: event_scheduler ?
Replies: 1
Views: 7082

Re: event_scheduler ?

The event_Scheduler is, a way to Schedule Events (in this case queries) to run in MySQL at a given time. It is simply waiting for an event to trigger it. It is enabled by default, but can be disabled by running: SET @@global.event_scheduler = 0; or add it to my.conf of /etc/mysql/mysql.conf.d/mysqld...
by chris
Mon May 20, 2024 3:37 pm
Forum: Shell
Topic: grep : binary file matches
Replies: 1
Views: 6977

Re: grep : binary file matches

Grep thinks that it is binary file for some reason,
and doesn't process it.
Maybe there are some special characters in the txt file.

You can solve it by forcing:
grep --text
grep -a
or grep --binary-files=text
by chris
Thu May 09, 2024 8:29 am
Forum: General
Topic: Solved: Linux fetchmail showing error
Replies: 2
Views: 4913

Re: Linux fetchmail showing error

The certificate on your server is part of a chain. Many time the are delivered as separated files. Something like : server.cert and server.ca-bundle For dovecot, it easier to put them 1 file (order is important ! ). And add the file in /etc/dovecot/conf.d/10-ssl.conf ssl_cert = </etc/ssl/private/cer...
by chris
Thu May 02, 2024 6:42 pm
Forum: MySQL
Topic: Update problem ?
Replies: 1
Views: 3671

Re: Update problem ?

The problem is that the key has expired.
You need to update it, but do it form a trustwordy source.

from Ubuntu

Code: Select all

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys B7B3B788A8D3785C
Or from Mysql:

Code: Select all

wget -qO - https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 | sudo apt-key add -
by chris
Mon Mar 06, 2023 8:47 pm
Forum: PHP
Topic: SOLVED: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry
Replies: 2
Views: 19466

Re: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry

You first should check why you have a duplicated key. You can use INSERT IGNORE command rather than the INSERT command. If a record doesn't duplicate an existing record, then MySQL inserts it as usual. If the record is a duplicate, then the IGNORE keyword tells MySQL to discard it silently without g...
by chris
Fri Feb 10, 2023 8:45 pm
Forum: Servers
Topic: install lighttp with php
Replies: 1
Views: 21514

Re: install lighttp with php

You can install php-fpm, best is to install the others also apt-get install php php-cli php-common php-fpm php-mysql To enable PHP support for Lighttpd. you need to modify the php.ini file nano /etc/php/7.4/fpm/php.ini Change cgi.fix_pathinfo value to 1: cgi.fix_pathinfo=1 By default, PHP-FPM listen...