MobileRead Forums - View Single Post - Name Upper with calibre/sqlite but Lower with ls -ld under Unix

Doum · 01-11-2026, 05:24 AM

Thank you for your replies. The "quality check" is quite useful, but I'm going to use an SQLite script combined with "ls" to verify the consistency of the authors/titles with my actual file paths.
For your information, I encountered errors with the PHP function `imagecreatefromjpeg`. I passed it the path retrieved via an SQL query, but it generated a "Failed to open stream: No such file or directory" error because the actual path had a different lowercase/uppercase character. (I use it to create minicovers from the cover.jpg file in Calibre files.)

01-11-2026, 05:24 AM	#4
Doum Connoisseur Posts: 73 Karma: 10 Join Date: Jun 2020 Device: Kobo Aura HD	Thank you for your replies. The "quality check" is quite useful, but I'm going to use an SQLite script combined with "ls" to verify the consistency of the authors/titles with my actual file paths. For your information, I encountered errors with the PHP function `imagecreatefromjpeg`. I passed it the path retrieved via an SQL query, but it generated a "Failed to open stream: No such file or directory" error because the actual path had a different lowercase/uppercase character. (I use it to create minicovers from the cover.jpg file in Calibre files.) Last edited by Doum; 01-11-2026 at 05:27 AM.