Error: I have protected a PDF but it is not showing on the administration system

To fix this problem you must disable the strict mode in SQL

This can either be done using a management interface such as MySQL Workbench or PHPMyAdmin or by opening the “my.ini” file within the MySQL installation directory and searching for something like:

# Set the SQL mode to strict
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Replace with:
# Set the SQL mode to strict
sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Then restart the MySql service/server.

Quick Fix: A temporary workaround is to use the command SET GLOBAL SQL_MODE=”;
Note however that this will be lost if the computer is restarted so you will need to edit the my.ini file accordingly for a more permanent change.