View Single Post
Old 05-24-2016, 12:48 PM   #1243
sasilk
Connoisseur
sasilk began at the beginning.
 
sasilk's Avatar
 
Posts: 75
Karma: 14
Join Date: Jun 2008
Location: Australia
Device: iPad Pro 12"; Kindle Paperwhite
Question COPS unable to find metadata.db

Hi,

I am trying to get COPS 1.0.0RC3 working on my hosted server. (I had an older version working, but accidentally deleted my config_local.php when preparing to upgrade.) Details are:

COPS files are in the domain root
metadata.db and ebook directories/files are in a subdirectory called ebooks which is in the domain root
config_local.php:
*****
<?php
if (!isset($config))
$config = array();

/*
* The directory containing calibre's metadata.db file, with sub-directories
* containing all the formats.
* BEWARE : it has to end with a /
*/
$config['calibre_directory'] = 'ebooks/';

/*
* Catalog's title
*/
$config['cops_title_default'] = "Test Title";

/*
* use URL rewriting for downloading of ebook in HTML catalog
* See README for more information
* 1 : enable
* 0 : disable
*/
$config['cops_use_url_rewriting'] = "0";
*****
base_opendir is set in php.ini to NULL
PHP version is 5.6.19 fastcgi
sqlite3 is installed
Both the ebooks subdirectory and metadata.db are set to 755 (and have been tested with 777)
I am the owner of the directories and files.

This configuration gets me a grey screen, with a changed title on the tab. If I change the calibre_directory to anything else, I can get the Configuration Check page, which shows everything as OK, but gives the "<path>/metadata.db not found" message.
I've reinstalled everything a couple of times and started with a clean config_local.php file (which is what I'm currently trying, as per the above).

I did once manage to get past this error (and can't remember how) and immediately ran into an error message "fetchColumn on a boolean" when checkconfig.php was trying to check that metadata.db had the required columns, so I suspect that I hadn't solved the issue but had managed to bypass it somehow.

Any suggestions welcome :-)

Stephen Silk
sasilk is offline   Reply With Quote