database error about exhen-archive HOT 4 CLOSED

Double check you've correctly set up your config.json file with the correct credentials.

As well as that ensure you've created that database in your MySQL instance and imported db.sql into it.

from exhen-archive.

I think I have set up my database and config file correctly.
Because the url like api.php?action=hasgallery&gid=1591104&key=xxx and the Archive task are working properly.

from exhen-archive.

Oh wait, apologies, that function is actually querying your Sphinx instance, and not your MySQL instance.

Based on the output of your Sphinx instance, it's failing to create the pid file, you should ensure the directory /etc/sphinxsearch exists and that the user it's being run under has permission to read and write within it.

If you're using the sphinx.conf.linux that's provided in the repo, you'll probably just want to run the following:

sudo mkdir -p /etc/sphinxsearch/log
sudo mkdir -p /var/lib/sphinxsearch/data/exhen/

from exhen-archive.

Now it works, thank you

from exhen-archive.