Skip to main content ↑ ↓
Topic: Mentions error wrong value (Read 3256 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Mentions error wrong value

Hi,

Too many members have this problem 

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


Have a solution?


sorry for my bad english

Re: Mentions error wrong value

Reply #1 –

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.
Bugs creator.
Features destroyer.
Template killer.

Re: Mentions error wrong value

Reply #2 –

hi,

yes  "action=mentions"  page error

forum log;

Code: [Select]
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
sorry for my bad english

Re: Mentions error wrong value

Reply #3 –

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.
Bugs creator.
Features destroyer.
Template killer.

Re: Mentions error wrong value

Reply #4 –

Even better if you can send me the elkarte_messages and elkarte_topics tables as well.
Bugs creator.
Features destroyer.
Template killer.

Re: Mentions error wrong value

Reply #5 –

Hi,

I send files

thanks
sorry for my bad english

Re: Mentions error wrong value

Reply #6 –

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 ?
Bugs creator.
Features destroyer.
Template killer.

Re: Mentions error wrong value

Reply #7 –

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.

Re: Mentions error wrong value

Reply #8 –

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
sorry for my bad english

Re: Mentions error wrong value

Reply #10 –

Hi,

@emanuele  update my forum 1.0.4  counter problems continue
sorry for my bad english

Re: Mentions error wrong value

Reply #11 –

Yep, as I wrote above the fix should fix the errors, but not all the counters (at least not immediately).
Bugs creator.
Features destroyer.
Template killer.