MyBB Community Forums

Heya everyone...

I hope I'm putting this in the right place. I have a forum that I converted from SMF 1.1.X and everything moved over including the international fonts! Very happy.

The only problem I've found is the search function. It is really not working at all...it acts like it wants to work a couple of times and then it just errors out. Here's what it gives me:

SQL Error:
   1054 - Unknown column 'Array' in 'where clause'
Query:
   SELECT pid, tid FROM mybb_posts WHERE pid IN(Array) AND visible >=
0 ORDER BY dateline DESC

URL is: http://unity-linux.org/mybb/index.php

I've found this when searching for: XFCE, Gnome, KDE, computer, Unity

Just random phrases. Anyone think they can take a look at this and help? This is only a test install so I can bust it up if we need to.

Can you get the SID of the search from the URL (it's the long string of random characters), then in phpMyAdmin, run this query:

SELECT `posts` FROM `mybb_searchlog` WHERE `sid` = 'sid goes here';

Where do I find that?

phpMyAdmin will be somewhere in your host control panel.

(2010-03-05, 12:19 PM)MattRogowski Wrote: [ -> ]phpMyAdmin will be somewhere in your host control panel.

I redid the merge and this problem has been solved. Must have just been a problem with the first try


Everything looks good now.