SMF Support > PostgreSQL and SQLite Support

Forum search with SMF 2.0RC1 and SQLite

(1/3) > >>

stomic:
Hi,

Did anybody test forum search with 2.0RC1?
I'm getting the following error:

--- Code: ---Wrong value type sent to the database. Array of integers expected. (message_list)

--- End code ---

karlbenson:
Search has been tested with sqlite.

Did i read in the other topic that you have converted to smf.
If so that is likely to cause issues.

In Settings.php where it says database type, have you changed it to say mysql instead of sqlite?
In Admin > Search > Search Method

What search method are you using?
If using fulltext or custom you might want to drop the index, and rebuild it.

greyknight17:
stomic, is this issue resolved now?

stomic:
Hi, I'm sorry for not responding earlier, I didn't have "reply notification" turned on and I didn't know that there was a response.

So OK, I've been trying to figure out the real cause and haven't been able to do anything yet. I've manually built some missing indexes in the database as I thought that might be the cause.

I'm going to post now the scenarios I have tried.

In the attachment of this post is the first configuration which gives the following message on search:

Database Error
SQL logic error or missing database
near "RLIKE": syntax error
File: /home/othersid/public_html/recnik/forum/Sources/SearchAPI-Custom.php
Line: 219

stomic:
second configuration: force search index use

Error:
An Error Has Occurred!
Wrong value type sent to the database. Array of integers expected. (message_list)

Navigation

[0] Message Index

[#] Next page