Today i found the same problem and saw the solution but im my mp3 file some has written in the field "year" the string "60s", which i think the creator of the mp3 tag fills in, because he/she didn't know the correct entry.
I am using:
Ubuntu 22.04
PHP 8.1.2-1ubuntu2.10
mysql Ver 15.1 Distrib 10.6.11-MariaDB
Apache
Server version: Apache/2.4.52 (Ubuntu)
Server built: 2023-01-23T18:34:42
Hello OMPD community!
Today i found the same problem and saw the solution but im my mp3 file some has written in the field "year" the string "60s", which i think the creator of the mp3 tag fills in, because he/she didn't know the correct entry.
With this file info and the new update.php you get the follwing error: PHP Fatal Error Uncaught mysqli_sql_exception: Unknown column '60s' in 'field list' in /var/www/ompd/update.php:1342 Stack trace: #0 /var/www/ompd/update.php(1342): mysqli_query() https://github.com/ArturSierzant/OMPD/issues/1 /var/www/ompd/update.php(1213): fileInfo() https://github.com/ArturSierzant/OMPD/pull/2 /var/www/ompd/update.php(401): fileInfoLoop() https://github.com/ArturSierzant/OMPD/issues/3 /var/www/ompd/update.php(78): update() https://github.com/ArturSierzant/OMPD/issues/4 {main} thrown File: /var/www/ompd/update.php Line: 1342
See my solution under https://github.com/ArturSierzant/OMPD/issues/157#issuecomment-1424534184
I am using: Ubuntu 22.04 PHP 8.1.2-1ubuntu2.10 mysql Ver 15.1 Distrib 10.6.11-MariaDB Apache Server version: Apache/2.4.52 (Ubuntu) Server built: 2023-01-23T18:34:42
Greetings