2011-03-10, 03:08 PM
I am running a MyBB 1.6.2 installation, with data merged from an SMF 2 board. All is running well, but I want to add a search box in the header (just like on the MyBB site), which is causing this SQL error. I placed the following code in the header template:
When I search using this form, I get this error:
SQL Error:
1054 - Unknown column 'Array' in 'where clause'
Query:
SELECT pid, tid FROM mybb_posts WHERE pid IN(Array) AND visible=1 ORDER BY dateline DESC
Strange thing is, this error shows up for most searches, but not all (if I search for "test", for example, I don't get the error). But for the searches that generate the error, I can use the regular search page which works fine with no errors at all.
I tried "file verification" in the tools menu, but no errors show up. Is there anything else I can try? Btw, I started out with a 1.6 board (I did not upgrade from 1.4).
<form id="search_form" style="margin: 0;" action="search.php" method="post">
<input type="text" name="keywords" value="Search..." class="text" />
<select name="action" id="search_focus">
<option value="do_search">site</option>
</select>
<input type="submit" value="Search" class="button_submit" name="submit" />
</form>
When I search using this form, I get this error:
SQL Error:
1054 - Unknown column 'Array' in 'where clause'
Query:
SELECT pid, tid FROM mybb_posts WHERE pid IN(Array) AND visible=1 ORDER BY dateline DESC
Strange thing is, this error shows up for most searches, but not all (if I search for "test", for example, I don't get the error). But for the searches that generate the error, I can use the regular search page which works fine with no errors at all.
I tried "file verification" in the tools menu, but no errors show up. Is there anything else I can try? Btw, I started out with a 1.6 board (I did not upgrade from 1.4).