HOW TO FIX?: Getting MySQL Error [1054: unknown column 'ak_photos' in 'where clause']
Permalink
Running 5.5.1
Hi, i was just about done with the site. I installed a basic search page. Went to test the search function. and got this database error.
anyone have any ideas how i fix it?
MySQL Error [1054: unknown column 'ak_photos' in 'where clause'] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PageTypes pt on (pt.ctID = p1.ctID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (psi.cName like '%deep%' or psi.cDescription like '%deep%' or psi.content like '%deep%' OR ak_event_multidate like '%deep%' OR ak_event_section like '%deep%' OR ak_event_category like '%deep%' OR ak_category_color like '%deep%' OR ak_event_tag like '%deep%' OR ak_event_thru like '%deep%' OR ak_start_time like '%deep%' OR ak_end_time like '%deep%' OR ak_event_recur like '%deep%' OR ak_photos like '%deep%' OR ak_info like '%deep%' OR ak_listing_address like '%deep%' OR ak_description like '%deep%' ) and (ak_exclude_search_index = 0 or ak_exclude_search_index is null) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and (((select count(cID) from PagePermissions pp1 where pp1.cID = p1.cInheritPermissionsFromCID and pp1.cgPermissions like 'r%' and (pp1.gID in (1) or pp1.uID = -1))) > 0 or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by cDatePublic desc limit 0,10 ")
Hi, i was just about done with the site. I installed a basic search page. Went to test the search function. and got this database error.
anyone have any ideas how i fix it?
MySQL Error [1054: unknown column 'ak_photos' in 'where clause'] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PageTypes pt on (pt.ctID = p1.ctID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (psi.cName like '%deep%' or psi.cDescription like '%deep%' or psi.content like '%deep%' OR ak_event_multidate like '%deep%' OR ak_event_section like '%deep%' OR ak_event_category like '%deep%' OR ak_category_color like '%deep%' OR ak_event_tag like '%deep%' OR ak_event_thru like '%deep%' OR ak_start_time like '%deep%' OR ak_end_time like '%deep%' OR ak_event_recur like '%deep%' OR ak_photos like '%deep%' OR ak_info like '%deep%' OR ak_listing_address like '%deep%' OR ak_description like '%deep%' ) and (ak_exclude_search_index = 0 or ak_exclude_search_index is null) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and (((select count(cID) from PagePermissions pp1 where pp1.cID = p1.cInheritPermissionsFromCID and pp1.cgPermissions like 'r%' and (pp1.gID in (1) or pp1.uID = -1))) > 0 or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by cDatePublic desc limit 0,10 ")
What add-on's do you have installed?
I have several add-ons... any ideas would be greatly appricated
Here are the Environment Settings
# concrete5 Version
5.5.1
# concrete5 Packages
AddThis (1.0), Bounce Box (1.0.2), Breadcrumbs (2.0), ChadStrat's Live Search (1.0.2), Database Backup (1.0), Designer Content (2.1), Facebook Like Button (1.1), Font Scaler (1.1.0), Google Map (Premium) (2.0.1), Last Updated (1.2), Mail Monkey (2.0.0), Multi-File Attribute (1.0), ProEvents (5.5.3), ProPhoto Browser (2.09), Roundabout Gallery (2.0), Scrapbook Tabs (1.2), Social Share (1.6.0.3), Social Icons (1.1), Space Designs Spacer (1.2), Real Estate (2.03), Wham Menu (1.0.4), YouTube Pro (1.0.5).
# concrete5 Overrides
blocks/test, blocks/testimonal, blocks/whambio, single_pages/login.php, single_pages/wham_small.png, single_pages/dashboard, single_pages/wham.png, themes/WHAM AUCTIONS
# Server Software
LiteSpeed
# Server API
litespeed
# PHP Version
5.2.17
# PHP Extensions
bcmath, calendar, ctype, curl, date, dom, exif, ffmpeg, filter, ftp, gd, gettext, hash, iconv, imap, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, mhash, mime_magic, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, posix, Reflection, session, SimpleXML, snmp, soap, sockets, SourceGuardian, SPL, SQLite, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Optimizer, 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 - 600
memory_limit - 256M
post_max_size - 200M
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 - 200M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
Here are the Environment Settings
# concrete5 Version
5.5.1
# concrete5 Packages
AddThis (1.0), Bounce Box (1.0.2), Breadcrumbs (2.0), ChadStrat's Live Search (1.0.2), Database Backup (1.0), Designer Content (2.1), Facebook Like Button (1.1), Font Scaler (1.1.0), Google Map (Premium) (2.0.1), Last Updated (1.2), Mail Monkey (2.0.0), Multi-File Attribute (1.0), ProEvents (5.5.3), ProPhoto Browser (2.09), Roundabout Gallery (2.0), Scrapbook Tabs (1.2), Social Share (1.6.0.3), Social Icons (1.1), Space Designs Spacer (1.2), Real Estate (2.03), Wham Menu (1.0.4), YouTube Pro (1.0.5).
# concrete5 Overrides
blocks/test, blocks/testimonal, blocks/whambio, single_pages/login.php, single_pages/wham_small.png, single_pages/dashboard, single_pages/wham.png, themes/WHAM AUCTIONS
# Server Software
LiteSpeed
# Server API
litespeed
# PHP Version
5.2.17
# PHP Extensions
bcmath, calendar, ctype, curl, date, dom, exif, ffmpeg, filter, ftp, gd, gettext, hash, iconv, imap, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, mhash, mime_magic, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, posix, Reflection, session, SimpleXML, snmp, soap, sockets, SourceGuardian, SPL, SQLite, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Optimizer, 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 - 600
memory_limit - 256M
post_max_size - 200M
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 - 200M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
did you get any resolution to this issue?
I have the same problem.
I did a search for a file and it returned the same error
and now i can not get to my file manager at all?
I have the same problem.
I did a search for a file and it returned the same error
and now i can not get to my file manager at all?
