[ZendTo] Unable to write to DB

[Jules]

Test a manual connection to the database using the "mysql" command with 
the credentials given in your /opt/zendto/config/preferences.php file.
Does "show tables;" list the tables you expect?

If you need to recreate the database, then this should do it:
# service mysqld start
# mysql
mysql> CREATE DATABASE zendto;
mysql> GRANT ALL PRIVILEGES ON zendto.* TO zendto at localhost
     IDENTIFIED by 'zendtopassword';
mysql> quit
where "zendtopassword" is a password of your own.
# mysql --user=zendto --password='zendtopassword' zendto < 
/opt/zendto/sql/zendto.MySQL

(where you should obviously substitute things with the correct username, 
password and database name as set in your preferences.php file).

Hope that helps,
Jules.


On 09/11/2016 18:24, Dariusz Radoszek wrote:
> I'm having the same problem after upgrading to MySQL 5.6. I'm currently
> on version 5.6.34. It was working perfectly for couple of years on 5.5.
> Trying to drop any file either from library or as an upload gives me
> this message:
>
> Upload Error
> Unable to add a dropoff record to the database, please notify the
> administrator.
>
> I can't find anything helpful after enabling MySQL query log.
>

Jules

-- 
Julian Field MEng MBCS CITP CEng

'The best and most beautiful things in life cannot be seen or even
  touched; they must be felt with the heart.' - Helen Keller

www.Zend.To
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654