CMS MADE SIMPLE FORGE

FAQ

 

[#10414] Reindex in Search module gives SQL error

avatar
Created By: Finn Lovenkrands (webform)
Date Submitted: Thu Feb 12 11:16:09 -0500 2015

Assigned To: Jos (josvd)
Version: 2.0
CMSMS Version: 1.11.12
Severity: None
Resolution: Fixed
State: Closed
Summary:
Reindex in Search module gives SQL error
Detailed Description:
I've changed in FAQ.module.php

Code:

      $query = "SELECT
                        entry_id, question, answer
                     FROM
                        " . cms_db_prefix() . "module_gbook_entries,
                     WHERE
                        active=1";


to

Code:

$query = "SELECT entry_id, question, answer FROM " . cms_db_prefix() .
"module_faq_entries WHERE active=1";


It was a wrong call to table module_gbook_entries and stray comma giving a SQL
error when reindexing in Search Module.


History

Comments
avatar
Date: 2015-03-29 17:50
Posted By: Jos (josvd)

thanks for reporting!
fixed in svn, will be released in version 2.0.1
      
avatar
Date: 2015-10-14 16:35
Posted By: Jos (josvd)

fixed in release 2.0.1
      
Updates

Updated: 2015-10-14 16:35
resolution_id: 6 => 7
state: Open => Closed

Updated: 2015-03-29 17:50
resolution_id: => 6