View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 2612 | Composr | search | public | 2016-05-19 18:34 | 2016-05-20 02:22 |
| Reporter | Machiavelis Constantine | Assigned To | Chris Graham | ||
| Priority | normal | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Summary | 2612: member search with facebook addon crash | ||||
| Description | I install a brand new version of composr on a new database. I upgrade it to the latest version (RC9), add Facebook addons, files the infos in. I try to find a member, got a crash. An error has occurred Unfortunately a query has failed [SELECT COUNT(*) FROM (SELECT 1 FROM cms_f_members r JOIN cms_f_member_custom_fields a ON r.id=a.mf_member_id WHERE r.id IS NOT NULL AND ((MATCH (m_username) AGAINST ('machiavelis') OR MATCH (field_3) AGAINST ('machiavelis') OR MATCH (field_5) AGAINST ('machiavelis') OR MATCH (field_6) AGAINST ('machiavelis') OR MATCH (field_7) AGAINST ('machiavelis') OR MATCH (field_8) AGAINST ('machiavelis') OR MATCH (field_9) AGAINST ('machiavelis') OR MATCH (field_10) AGAINST ('machiavelis') OR MATCH (field_11) AGAINST ('machiavelis') OR MATCH (field_12) AGAINST ('machiavelis') OR MATCH (field_13) AGAINST ('machiavelis') OR MATCH (field_14) AGAINST ('machiavelis') OR MATCH (field_15) AGAINST ('machiavelis') OR MATCH (field_16) AGAINST ('machiavelis') OR MATCH (field_17) AGAINST ('machiavelis') OR MATCH (field_34) AGAINST ('machiavelis') OR MATCH (m_signature) AGAINST ('machiavelis') OR MATCH (field_1) AGAINST ('machiavelis') OR MATCH (field_2) AGAINST ('machiavelis') OR MATCH (field_4) AGAINST ('machiavelis'))) LIMIT 1000) counter/* c1bba5c3c0005 */ LIMIT 1] [Can't find FULLTEXT index matching the column list] (version: 10 RC9, PHP version: 5.4.44, URL: /composr/data/iframe.php?page=search&type=results&content=machiavelis&all_defaults=1&author=&days=-1&sort=relevance&direction=DESC&only_titles=0&only_search_meta=0&boolean_search=0&conjunctive_operator=AND&ajax=1&zone=&page=search&type=results&content=machiavelis&only_titles=&author=&days=-1&sort=relevance&direction=DESC&search_catalogue_categories=&search_cns_members=1&search_news=1&search_comcode_pages=&search_cns_posts=&utheme=Diablus_com&keep_session=c1bba5c3c0005) Here is the stack trace: Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information. We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly. | ||||
| Steps To Reproduce | 1) Install facebook add-on 2) fill in the info for the facebook syndication 3) do a search 4) search for an existing user 5) check "members" in the search windows 6) press search 7) Crash | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
I think I've fixed this in https://github.com/ocproducts/composr/commit/b35afc4a963263b22b2a83eba1d612e07422c53f |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-05-19 18:34 | Machiavelis Constantine | New Issue | |
| 2016-05-20 02:22 | Chris Graham | Note Added: 0003946 | |
| 2016-05-20 02:22 | Chris Graham | Status | Not Assigned => Resolved |
| 2016-05-20 02:22 | Chris Graham | Resolution | open => fixed |
| 2016-05-20 02:22 | Chris Graham | Assigned To | => Chris Graham |
