Unexpected Error: MySQL 1054 (Image selector dialog unusable)
PermalinkAn unexpected error occurred.
mysql error: [1054: Unknown column 'fsfl.fsID' in 'where clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fsfl.fsID = '0' and fvIsApproved = '1' order by fvDateAdded desc limit 0,500 ")
< Back to Home
Prior to seeing this error, I deleted an old bunch of image files and file sets. The error occurs even with a fresh page. File Manager and other stuff from Dashboard seem to work fine. Just from page editing I get this error. Please HELP! In a middle of a major update, I can't fix my site now.
# concrete5 Version
5.5.2.1
# concrete5 Packages
Clearview Theme (1.5.1), Content Around Image (1.23), Dojo Supersized (1.0), Easy Accordion (1.1), Expand / Collapse (1.2.1), Extended Form (2.6), Featured Content Slider (1.0.5), Flash Gallery (2.0), Parent Link (1.0), PHP block by ND (1.0), Print Page (1.4), Redirect (1.1), Related Content Panel (1.0), Related Pages (1.1.8), Slate Theme (1.4), Studio Testimonials (1.5.0), Textile (1.0.1), Xclydes Utilities (1.0.6), Zoom Image (1.0.3).
# concrete5 Overrides
blocks/autonav, elements/header_required_modified.php, jobs/remove_old_page_versions.php, libraries/database_indexed_search.php.unnecessary, libraries/view.debug.php, models/file_list.php
# Server Software
Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.3.3
# Server API
apache2handler
# PHP Version
5.3.3
# PHP Extensions
apache2handler, bcmath, calendar, Core, ctype, curl, date, dom, ereg, exif, filter, ftp, gd, gettext, hash, imap, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, openssl, pcre, Phar, posix, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, timezonedb, tokenizer, xml, xmlreader, xmlwriter, zip, zlib.
# PHP Settings
log_errors_max_len - 1024
max_execution_time - 5
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
memory_limit - 64M
post_max_size - 2000M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 2000M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
