ElkArte Community

Project Support => Support => Topic started by: gevv on May 31, 2015, 03:33:11 am

Title: Mentions error wrong value
Post by: gevv on May 31, 2015, 03:33:11 am
Hi,

Too many members have this problem 

Quotewrong value type sent to the database. Array of integers expected. (board_list)


Have a solution?

(http://s2.postimg.org/nx2fwsoo9/i2206bp3okl.png) (http://postimage.org/)
Title: Re: Mentions error wrong value
Post by: emanuele on May 31, 2015, 07:33:02 am
That's odd.
What page are you accessing? action=mentions ?
Can you check in the error log if there is a more detailed error message?
If not, could you try to think if you have member groups that are restricted somehow?
I may be out of track, but the only place I think this could happen in relation to the mentions is some permissions check, but it doesn't make a lot of sense, unless some very specific combination of conditions that nobody thought of is present.
Title: Re: Mentions error wrong value
Post by: gevv on May 31, 2015, 09:03:13 am
hi,

yes  "action=mentions"  page error

forum log;

Type of error: Critical
Apply Filter: Only show the errors with the same message Wrong value type sent to the database. Array of integers expected. (board_list)
Function: accessibleBoards 

added to the server log file
Title: Re: Mentions error wrong value
Post by: emanuele on May 31, 2015, 10:01:16 am
It may be related to the conversion again...
Can you send me a copy of the tables: elkarte_boards and elkarte_log_mentions? And elkarte_log_likes may be handy as well.
Title: Re: Mentions error wrong value
Post by: emanuele on May 31, 2015, 10:15:43 am
Even better if you can send me the elkarte_messages and elkarte_topics tables as well.
Title: Re: Mentions error wrong value
Post by: gevv on May 31, 2015, 10:38:33 am
Hi,

I send files

thanks
Title: Re: Mentions error wrong value
Post by: emanuele on May 31, 2015, 11:16:44 am
Found it!
It is a sort of bug due to the conversion.

To quickly regain access to the page, try opening the file /sources/subs/Mentions.subs.php and then, search:
Code: [Select]
		WHERE mtn.id_member = {int:current_user}
AND mtn.status IN ({array_int:status})' . (empty($type) ? '' : (is_array($type) ? '
and replace it with:
Code: [Select]
		WHERE mtn.id_member = {int:current_user}
AND m.id_board IS NOT NULL
AND mtn.status IN ({array_int:status})' . (empty($type) ? '' : (is_array($type) ? '

The counter will still be wrong, but at least the page will work...
I'll look into fix it "properly" before 1.0.4 release. :)

The problem is that if a message is (permanently) deleted, ElkArte takes care of removing mentions too, Wedge not.
So, when moved to Elk, all the mentions/alerts pointing to a deleted message, were adding empty boards to the query leading to the error.
The best solution would be not to add those entries at all, so I'll fix the importer, though, it may be worth do something in Elk as well. What do you think @Spuds ?
Title: Re: Mentions error wrong value
Post by: Spuds on May 31, 2015, 12:26:14 pm
Do you mean just add a check in place for that condition?  It might make sense to help with conversions glitches.  Seems to get more and more complex with all the features for the various forums.
Title: Re: Mentions error wrong value
Post by: gevv on June 09, 2015, 01:55:23 pm
Quote from: emanuele –
The counter will still be wrong, but at least the page will work...
I'll look into fix it "properly" before 1.0.4 release. :)


Hi,

yes less problematic counter :)

Some members of the counter is not reset  

a video posted by forum members   (notice page empty counter 7)

https://www.youtube.com/watch?v=bBC_K39wGb4
Title: Re: Mentions error wrong value
Post by: emanuele on June 09, 2015, 04:53:06 pm
This is the fix I think should cover most of the problems with less of the issues:
https://github.com/emanuele45/Dialogo/commit/2b1785de95b332901d4512b387dafa9a9e36a5d4
it will be in 1.0.4.
Title: Re: Mentions error wrong value
Post by: gevv on July 19, 2015, 04:12:28 pm
Hi,

@emanuele  update my forum 1.0.4  counter problems continue
Title: Re: Mentions error wrong value
Post by: emanuele on July 20, 2015, 02:41:20 pm
Yep, as I wrote above the fix should fix the errors, but not all the counters (at least not immediately).