#3719 - Search: unknown column 'r.id' in 'on clause'
| Identifier | #3719 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Search: unknown column 'r.id' in 'on clause' |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | search |
| Description | Unfortunately a query has failed [SELECT r.* FROM cms_galleries r LEFT JOIN cms_catalogue_entry_linkage l ON l.content_id=CAST(r.id AS CHAR(65535)) AND content_type='gallery' LEFT JOIN cms_catalogue_entries ce ON ce.id=l.catalogue_entry_id LEFT JOIN cms_catalogue_efv_short f0 ON (f0.ce_id=ce.id AND f0.cf_id=40) LEFT JOIN cms_catalogue_efv_long f1 ON (f1.ce_id=r.id AND f1.cf_id=49) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='gallery' AND m.meta_for_id=CAST(r.name AS CHAR(65535))) WHERE meta_keyword='test' AND add_date>1535599338 AND name NOT LIKE 'download\_%' AND (ce.c_name='_gallery' OR ce.c_name IS NULL)/* b49776c831ca4 */ LIMIT 10] [Unknown column 'r.id' in 'on clause'] (version: 10.0.18, PHP version: 5.6.30, URL: /site/index.php?page=search&type=results&all_defaults=0&content=test&author=&days=60&sort=relevance&direction=DESC&search_tutorials_external=1&search_galleries=1&search_images=1&search_news=1) |
| Steps to reproduce | |
| Additional information | STACK TRACE:
File '/home1/joe2209/bosslife.org/sources/failure.php' Line 974 Function 'get_html_trace' Args File '/home1/joe2209/bosslife.org/sources/global2.php' Line 1,034 Function '_fatal_exit' Args Tempcode -> ... File '/home1/joe2209/bosslife.org/sources/database/mysqli.php' Line 258 Function 'fatal_exit' Args Tempcode -> ... File '/home1/joe2209/bosslife.org/sources/database.php' Line 1,748 Function 'db_query' Class 'Database_Static_mysqli' Object O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:50:"a:2:{i:0;s:12:"joe2209_blv2";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:3;i:1;s:12:"joe2209_blv2";}s:16:"reconnected_once";b:0;} Type '->' Args 'SELECT r.* FROM cms_galleries r LEFT JOIN cms_catalogue_entry_linkage l ON l.content_id=CAST(r.id AS CHAR(65535)) AND content_type='gallery' LEFT JOIN cms_catalogue_entries ce ON ce.id=l.catalogue_entry_id LEFT JOIN cms_catalogue_efv_short f0 ON (f0.ce_id=ce.id AND f0.cf_id=40) LEFT JOIN cms_catalogue_efv_long f1 ON (f1.ce_id=r.id AND f1.cf_id=49) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='gallery' AND m.meta_for_id=CAST(r.name AS CHAR(65535))) WHERE meta_keyword='test' AND add_date>1535599338 AND name NOT LIKE 'download\\_%' AND (ce.c_name='_gallery' OR ce.c_name IS NULL)/* b49776c831ca4 */' array 10 NULL false false false false File '/home1/joe2209/bosslife.org/sources/database.php' Line 1,521 Function '_query' Class 'DatabaseConnector' Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:12:"joe2209_blv2";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:12:"joe2209_blv2";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:50:"a:2:{i:0;s:12:"joe2209_blv2";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:12:"joe2209_blv2";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:1;} Type '->' Args 'SELECT r.* FROM cms_galleries r LEFT JOIN cms_catalogue_entry_linkage l ON l.content_id=CAST(r.id AS CHAR(65535)) AND content_type='gallery' LEFT JOIN cms_catalogue_entries ce ON ce.id=l.catalogue_entry_id LEFT JOIN cms_catalogue_efv_short f0 ON (f0.ce_id=ce.id AND f0.cf_id=40) LEFT JOIN cms_catalogue_efv_long f1 ON (f1.ce_id=r.id AND f1.cf_id=49) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='gallery' AND m.meta_for_id=CAST(r.name AS CHAR(65535))) WHERE meta_keyword='test' AND add_date>1535599338 AND name NOT LIKE 'download\\_%' AND (ce.c_name='_gallery' OR ce.c_name IS NULL)' 10 NULL false false NULL '' File '/home1/joe2209/bosslife.org/sources/database_search.php' Line 1,105 Function 'query' Class 'DatabaseConnector' Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:12:"joe2209_blv2";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:12:"joe2209_blv2";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:50:"a:2:{i:0;s:12:"joe2209_blv2";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:12:"joe2209_blv2";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:1;} Type '->' Args 'SELECT r.* FROM cms_galleries r LEFT JOIN cms_catalogue_entry_linkage l ON l.content_id=CAST(r.id AS CHAR(65535)) AND content_type='gallery' LEFT JOIN cms_catalogue_entries ce ON ce.id=l.catalogue_entry_id LEFT JOIN cms_catalogue_efv_short f0 ON (f0.ce_id=ce.id AND f0.cf_id=40) LEFT JOIN cms_catalogue_efv_long f1 ON (f1.ce_id=r.id AND f1.cf_id=49) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='gallery' AND m.meta_for_id=CAST(r.name AS CHAR(65535))) WHERE meta_keyword='test' AND add_date>1535599338 AND name NOT LIKE 'download\\_%' AND (ce.c_name='_gallery' OR ce.c_name IS NULL)' 10 File '/home1/joe2209/bosslife.org/sources/hooks/modules/search/galleries.php' Line 138 Function 'get_search_rows' Args 'gallery' 'name' 'test' 0 'OR' false 'DESC' 10 0 false 'galleries r LEFT JOIN cms_catalogue_entry_linkage l ON l.content_id=CAST(r.id AS CHAR(65535)) AND content_type='gallery' LEFT JOIN cms_catalogue_entries ce ON ce.id=l.catalogue_entry_id LEFT JOIN cms_catalogue_efv_short f0 ON (f0.ce_id=ce.id AND f0.cf_id=40) LEFT JOIN cms_catalogue_efv_long f1 ON (f1.ce_id=r.id AND f1.cf_id=49)' a:3:{s:10:"r.fullname";s:20:"SHORT_TRANS__COMCODE";s:13:"r.description";s:19:"LONG_TRANS__COMCODE";s:1:"!";s:1:"!";} ' AND add_date>1535599338 AND name NOT LIKE 'download\\_%' AND (ce.c_name='_gallery' OR ce.c_name IS NULL)' 'MATCH (?) AGAINST ('test')' '' 'r.*' a:1:{i:0;s:11:"f0.cv_value";} 'galleries' 'name' true File '/home1/joe2209/bosslife.org/site/pages/modules/search.php' Line 674 Function 'run' Class 'Hook_search_galleries' Object O:21:"Hook_search_galleries":0:{} Type '->' Args 'test' false 'DESC' 10 0 false 'MATCH (?) AGAINST ('test')' '' NULL 1,535,599,338 'relevance' 10 'OR' '' '!' 0 File '/home1/joe2209/bosslife.org/site/pages/modules/search.php' Line 482 Function 'results' Class 'Module_search' Object O:13:"Module_search":3:{s:5:"title";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:33:"tcpfunc_5bd47cb10dd558.18107302_1";s:2655:"$tpl_funcs['tcpfunc_5bd47cb10dd558.18107302_1']=$KEEP_TPL_FUNCS['tcpfunc_5bd47cb10dd558.18107302_1']=recall_named_function('5bd47cb10dd668.66728226','$parameters,$cl',"extract(\$parameters,EXTR_PREFIX_ALL,'bound'); echo (isset(\$bound_ID)?(\"\\n<a id=\\\"title__\".(empty(\$bound_ID->pure_lang)?@htmlspecialchars(otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\")).\"\\\"></a>\\n\"):''),\n \"\\n\\n<h1 style=\\\"display:none;\\\" class=\\\"screen_title\\\"\",\n ((ecv_NOT(\$cl,array(),array(ecv_GET(\$cl,array(),array(\"name_set_elsewhere\"))))==\"1\")?(\" itemprop=\\\"name\\\"\"):''),\n \">\\n \",\n otp(isset(\$bound_TITLE)?\$bound_TITLE:null,\"TITLE/SCREEN_TITLE\"),\n \"\\n\\n \",\n (isset(\$bound_AWARDS)?(\"\\n \".((otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\")!='')?(\"\\n \".ecv(\$cl,array(),4,\"SET\",array(\"AWARDS_TEXT\",\"\\n <h2>Award winner</h2>\\n <p class=\\\"lonely_label\\\">\".ecv(\$cl,array(),2,\"AWARDS_WON\",array(otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\"))).\"\\n <ul>\\n \".closure_loop(array(\"AWARDS\",'vars'=>\$parameters),array(\$parameters,\$cl),\nrecall_named_function('5bd47cb10d9604.78762725','\$parameters,\$cl',\"extract(\\\$parameters,EXTR_PREFIX_ALL,'bound'); return \\\"\\\\n <li>\\\\n <strong>\\\".(empty(\\\$bound_AWARD_TYPE->pure_lang)?@htmlspecialchars(otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\")).\\\"</strong>\\\\n <span>\\\".ecv(\\\$cl,array(),2,\\\"AWARD_ON\\\",array(ecv_DATE(\\\$cl,array(1),array(\\\"1\\\",\\\"1\\\",\\\"1\\\",otp(isset(\\\$bound_AWARD_TIMESTAMP)?\\\$bound_AWARD_TIMESTAMP:null,\\\"AWARD_TIMESTAMP/SCREEN_TITLE\\\"))))).\\\"</span>\\\\n </li>\\\\n \\\";\")).\"\\n </ul>\\n \")).\"\\n <a href=\\\"\".ecv_PAGE_LINK(\$cl,array(1),array(\"_SEARCH:awards\")).\"\\\"><img onmouseover=\\\"if (typeof window.activate_tooltip!='undefined') activate_tooltip(this,event,'\".ecv_GET(\$cl,array(2,8,1),array(\"AWARDS_TEXT\")).\"','auto',null,null,false,true);\\\" title=\\\"\\\" alt=\\\"Award winner\\\" src=\\\"\".ecv_IMG(\$cl,array(1),array(\"awarded\",\"0\",\"island\")).\"\\\" /></a>\\n \"):'').\"\\n \"):''),\n \"\\n</h1>\\n\\n\",\n (isset(\$bound_SUB)?(\"\\n <div class=\\\"title_tagline\\\">\\n \".otp(isset(\$bound_SUB)?\$bound_SUB:null,\"SUB/SCREEN_TITLE\").\"\\n </div>\\n\"):''),\n \"\\n\";");";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:33:"tcpfunc_5bd47cb10dd558.18107302_1";i:1;a:3:{s:5:"_GUID";s:32:"847ffbe4823eca6d2d5eac42828ee552";s:6:"AWARDS";a:0:{}s:5:"TITLE";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:36:"do_runtime_5bd67cea4e6015.20238722_1";s:107:"$tpl_funcs['do_runtime_5bd67cea4e6015.20238722_1']="echo ecv(\$cl,array(),2,\"SEARCH_RESULTS\",array());"; ";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:36:"do_runtime_5bd67cea4e6015.20238722_1";i:1;a:0:{}i:2;i:2;i:3;s:14:"SEARCH_RESULTS";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";b:1;s:8:"codename";s:10:":container";}}i:2;i:1;i:3;s:0:"";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";N;s:8:"codename";s:12:"SCREEN_TITLE";}s:2:"ob";N;s:4:"info";N;} Type '->' Args '' '' NULL 1,535,599,338 'relevance' 'DESC' false '!' File '/home1/joe2209/bosslife.org/site/pages/modules/search.php' Line 191 Function 'form' Class 'Module_search' Object O:13:"Module_search":3:{s:5:"title";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:33:"tcpfunc_5bd47cb10dd558.18107302_1";s:2655:"$tpl_funcs['tcpfunc_5bd47cb10dd558.18107302_1']=$KEEP_TPL_FUNCS['tcpfunc_5bd47cb10dd558.18107302_1']=recall_named_function('5bd47cb10dd668.66728226','$parameters,$cl',"extract(\$parameters,EXTR_PREFIX_ALL,'bound'); echo (isset(\$bound_ID)?(\"\\n<a id=\\\"title__\".(empty(\$bound_ID->pure_lang)?@htmlspecialchars(otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\")).\"\\\"></a>\\n\"):''),\n \"\\n\\n<h1 style=\\\"display:none;\\\" class=\\\"screen_title\\\"\",\n ((ecv_NOT(\$cl,array(),array(ecv_GET(\$cl,array(),array(\"name_set_elsewhere\"))))==\"1\")?(\" itemprop=\\\"name\\\"\"):''),\n \">\\n \",\n otp(isset(\$bound_TITLE)?\$bound_TITLE:null,\"TITLE/SCREEN_TITLE\"),\n \"\\n\\n \",\n (isset(\$bound_AWARDS)?(\"\\n \".((otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\")!='')?(\"\\n \".ecv(\$cl,array(),4,\"SET\",array(\"AWARDS_TEXT\",\"\\n <h2>Award winner</h2>\\n <p class=\\\"lonely_label\\\">\".ecv(\$cl,array(),2,\"AWARDS_WON\",array(otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\"))).\"\\n <ul>\\n \".closure_loop(array(\"AWARDS\",'vars'=>\$parameters),array(\$parameters,\$cl),\nrecall_named_function('5bd47cb10d9604.78762725','\$parameters,\$cl',\"extract(\\\$parameters,EXTR_PREFIX_ALL,'bound'); return \\\"\\\\n <li>\\\\n <strong>\\\".(empty(\\\$bound_AWARD_TYPE->pure_lang)?@htmlspecialchars(otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\")).\\\"</strong>\\\\n <span>\\\".ecv(\\\$cl,array(),2,\\\"AWARD_ON\\\",array(ecv_DATE(\\\$cl,array(1),array(\\\"1\\\",\\\"1\\\",\\\"1\\\",otp(isset(\\\$bound_AWARD_TIMESTAMP)?\\\$bound_AWARD_TIMESTAMP:null,\\\"AWARD_TIMESTAMP/SCREEN_TITLE\\\"))))).\\\"</span>\\\\n </li>\\\\n \\\";\")).\"\\n </ul>\\n \")).\"\\n <a href=\\\"\".ecv_PAGE_LINK(\$cl,array(1),array(\"_SEARCH:awards\")).\"\\\"><img onmouseover=\\\"if (typeof window.activate_tooltip!='undefined') activate_tooltip(this,event,'\".ecv_GET(\$cl,array(2,8,1),array(\"AWARDS_TEXT\")).\"','auto',null,null,false,true);\\\" title=\\\"\\\" alt=\\\"Award winner\\\" src=\\\"\".ecv_IMG(\$cl,array(1),array(\"awarded\",\"0\",\"island\")).\"\\\" /></a>\\n \"):'').\"\\n \"):''),\n \"\\n</h1>\\n\\n\",\n (isset(\$bound_SUB)?(\"\\n <div class=\\\"title_tagline\\\">\\n \".otp(isset(\$bound_SUB)?\$bound_SUB:null,\"SUB/SCREEN_TITLE\").\"\\n </div>\\n\"):''),\n \"\\n\";");";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:33:"tcpfunc_5bd47cb10dd558.18107302_1";i:1;a:3:{s:5:"_GUID";s:32:"847ffbe4823eca6d2d5eac42828ee552";s:6:"AWARDS";a:0:{}s:5:"TITLE";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:36:"do_runtime_5bd67cea4e6015.20238722_1";s:107:"$tpl_funcs['do_runtime_5bd67cea4e6015.20238722_1']="echo ecv(\$cl,array(),2,\"SEARCH_RESULTS\",array());"; ";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:36:"do_runtime_5bd67cea4e6015.20238722_1";i:1;a:0:{}i:2;i:2;i:3;s:14:"SEARCH_RESULTS";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";b:1;s:8:"codename";s:10:":container";}}i:2;i:1;i:3;s:0:"";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";N;s:8:"codename";s:12:"SCREEN_TITLE";}s:2:"ob";N;s:4:"info";N;} Type '->' Args File '/home1/joe2209/bosslife.org/sources/zones.php' Line 808 Function 'run' Class 'Module_search' Object O:13:"Module_search":3:{s:5:"title";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:33:"tcpfunc_5bd47cb10dd558.18107302_1";s:2655:"$tpl_funcs['tcpfunc_5bd47cb10dd558.18107302_1']=$KEEP_TPL_FUNCS['tcpfunc_5bd47cb10dd558.18107302_1']=recall_named_function('5bd47cb10dd668.66728226','$parameters,$cl',"extract(\$parameters,EXTR_PREFIX_ALL,'bound'); echo (isset(\$bound_ID)?(\"\\n<a id=\\\"title__\".(empty(\$bound_ID->pure_lang)?@htmlspecialchars(otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\$bound_ID)?\$bound_ID:null,\"ID/SCREEN_TITLE\")).\"\\\"></a>\\n\"):''),\n \"\\n\\n<h1 style=\\\"display:none;\\\" class=\\\"screen_title\\\"\",\n ((ecv_NOT(\$cl,array(),array(ecv_GET(\$cl,array(),array(\"name_set_elsewhere\"))))==\"1\")?(\" itemprop=\\\"name\\\"\"):''),\n \">\\n \",\n otp(isset(\$bound_TITLE)?\$bound_TITLE:null,\"TITLE/SCREEN_TITLE\"),\n \"\\n\\n \",\n (isset(\$bound_AWARDS)?(\"\\n \".((otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\")!='')?(\"\\n \".ecv(\$cl,array(),4,\"SET\",array(\"AWARDS_TEXT\",\"\\n <h2>Award winner</h2>\\n <p class=\\\"lonely_label\\\">\".ecv(\$cl,array(),2,\"AWARDS_WON\",array(otp(isset(\$bound_AWARDS)?\$bound_AWARDS:null,\"AWARDS/SCREEN_TITLE\"))).\"\\n <ul>\\n \".closure_loop(array(\"AWARDS\",'vars'=>\$parameters),array(\$parameters,\$cl),\nrecall_named_function('5bd47cb10d9604.78762725','\$parameters,\$cl',\"extract(\\\$parameters,EXTR_PREFIX_ALL,'bound'); return \\\"\\\\n <li>\\\\n <strong>\\\".(empty(\\\$bound_AWARD_TYPE->pure_lang)?@htmlspecialchars(otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\"),ENT_QUOTES | ENT_SUBSTITUTE,get_charset()):otp(isset(\\\$bound_AWARD_TYPE)?\\\$bound_AWARD_TYPE:null,\\\"AWARD_TYPE/SCREEN_TITLE\\\")).\\\"</strong>\\\\n <span>\\\".ecv(\\\$cl,array(),2,\\\"AWARD_ON\\\",array(ecv_DATE(\\\$cl,array(1),array(\\\"1\\\",\\\"1\\\",\\\"1\\\",otp(isset(\\\$bound_AWARD_TIMESTAMP)?\\\$bound_AWARD_TIMESTAMP:null,\\\"AWARD_TIMESTAMP/SCREEN_TITLE\\\"))))).\\\"</span>\\\\n </li>\\\\n \\\";\")).\"\\n </ul>\\n \")).\"\\n <a href=\\\"\".ecv_PAGE_LINK(\$cl,array(1),array(\"_SEARCH:awards\")).\"\\\"><img onmouseover=\\\"if (typeof window.activate_tooltip!='undefined') activate_tooltip(this,event,'\".ecv_GET(\$cl,array(2,8,1),array(\"AWARDS_TEXT\")).\"','auto',null,null,false,true);\\\" title=\\\"\\\" alt=\\\"Award winner\\\" src=\\\"\".ecv_IMG(\$cl,array(1),array(\"awarded\",\"0\",\"island\")).\"\\\" /></a>\\n \"):'').\"\\n \"):''),\n \"\\n</h1>\\n\\n\",\n (isset(\$bound_SUB)?(\"\\n <div class=\\\"title_tagline\\\">\\n \".otp(isset(\$bound_SUB)?\$bound_SUB:null,\"SUB/SCREEN_TITLE\").\"\\n </div>\\n\"):''),\n \"\\n\";");";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:33:"tcpfunc_5bd47cb10dd558.18107302_1";i:1;a:3:{s:5:"_GUID";s:32:"847ffbe4823eca6d2d5eac42828ee552";s:6:"AWARDS";a:0:{}s:5:"TITLE";O:8:"Tempcode":5:{s:18:"code_to_preexecute";a:1:{s:36:"do_runtime_5bd67cea4e6015.20238722_1";s:107:"$tpl_funcs['do_runtime_5bd67cea4e6015.20238722_1']="echo ecv(\$cl,array(),2,\"SEARCH_RESULTS\",array());"; ";}s:9:"seq_parts";a:1:{i:0;a:1:{i:0;a:5:{i:0;s:36:"do_runtime_5bd67cea4e6015.20238722_1";i:1;a:0:{}i:2;i:2;i:3;s:14:"SEARCH_RESULTS";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";b:1;s:8:"codename";s:10:":container";}}i:2;i:1;i:3;s:0:"";i:4;s:0:"";}}}s:19:"preprocessable_bits";a:0:{}s:9:"pure_lang";N;s:8:"codename";s:12:"SCREEN_TITLE";}s:2:"ob";N;s:4:"info";N;} Type '->' Args File '/home1/joe2209/bosslife.org/sources/site.php' Line 1,218 Function 'load_module_page' Args 'site/pages/modules/search.php' 'search' Tempcode -> ... File '/home1/joe2209/bosslife.org/sources/site.php' Line 924 Function 'request_page' Args 'search' true NULL NULL false false Tempcode -> ... File '/home1/joe2209/bosslife.org/site/index.php' Line 59 Function 'do_site' Args |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".


Comments
Fixed in https://github.com/ocproducts/composr/commit/a9ac313eabd8c6e819251e9994de42acbd01de20
I'll revert back to the original files for now.
A blank site like that likely would have been caused by a corrupted PHP file, some kind of syntax error.
My white page issue was a fault of my own; something went wrong when saving the new files. I downloaded the entire 'fields' directory from git and replaced it with mine -- this has solved the white page issue.
However, now I receive a critical error every time I navigate to the search page.
Critical error – bailing out
PHP ERROR [1] Class 'FieldsSearchHook' not found in sources/hooks/modules/search/calendar.php on line 25
I'm sorry my bugs are never straight forward :/
I'm curious how you were able to change it without FTP access?