CMS Made Simple Forums

Code: Select all

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE active=1' at line 5

Code: Select all

	function SearchReindex(&$module)
	{
		$db = cmsms()->GetDB();
		$query = "SELECT
								entry_id, question, answer
							FROM
								" . cms_db_prefix() . "module_gbook_entries,
							WHERE
								active=1";
		$result = $db->Execute($query);
		if ( $result && $result->RecordCount() > 0 )
		{
			while ( $row=$result->FetchRow() )
			{
				$module->AddWords($this->GetName(), $row['entry_id'], 'entry', $row['question'] . ' ' . $row['answer']);
			}
		}
		if ( !$result )
		{
			echo 'ERROR: ' . mysql_error();
			exit();
		}
	}

Code: Select all

removed by moderator