Menu
▾
▴
#93 SQLAlchemy Version Issue
On a new build of CentOS 7, MariaDB 10.1, Python 2.7.5 and Filelocker 2.6.1 I couldn't get the admin page to load. The gui error was not descriptive, but the Filelocker error log had many entries associated with clicking on the admin link. The last 3 lines are shown below, which led me to SQLAlchemy. The INSTALL.txt readme indicates SQLAlchemy 0.5.8+ is supported. By default version 1.1.9 is installed. Once I removed 1.1.9, installed 0.5.8 and restarted Filelocker the admin page loaded and worked fine.
File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/sqltypes.py", line 2605, in _resolve_value_to_type
"Object %r is not legal as a SQL literal value" % value)
ArgumentError: Object <lib.Models.User object="" at="" 0x7f30944aed90=""> is not legal as a SQL literal value
Note that after switching to 0.5.8 I had to edit the variable tools.SATransaction.dburi in <filelocker root="">/etc/Filelocker.conf by removing "+mysqldb", and then restart Filelocker for the changes to be effective.