Help with SQL query error

[ormuz]

this is the query

Code Select Expand

$request = $smcFunc['db_query']('','
SELECT
b.id_board, b.name as board_name, b.redirect, ' . ($rft_hide_topics ? 'h.id_topic, h.subject,' : '') . '
g.id_group, g.group_name, c.id_cat, c.name AS cat_name
FROM {db_prefix}boards AS b
INNER JOIN {db_prefix}categories AS c
' . ($rft_hide_topics ? 'LEFT JOIN {db_prefix}messages AS h ON (h.id_topic = ({array_int:id_topics})) ' : '') . '
INNER JOIN {db_prefix}membergroups AS g
WHERE id_group > {int:admin}',
array(
'admin' => 1,
'id_topics' => $rft_hide_topics,
)
);

and this is the error:

Operand should contain 1 column(s)
Line: 677

Any ideias?

[Arantor]

bestnow, what does that post even mean?

ormuz, you need to tell MySQL how to perform the joins, it needs to be told how to join categories to boards, or groups to anything.

[ormuz]

My sql knowledge is questionable... Stackoverflow, says this:

http://stackoverflow.com/questions/14046838/mysql-operand-should-contain-1-columns

[Arantor]

What are you trying to do with this query?

I understand SQL just fine but I can't tell you how to rewrite this query without knowing more.

[ormuz]

it's from this "beta" mod...
http://www.simplemachines.org/community/index.php?topic=522114.msg3906944#msg3906944

the code says

// Grab boards, categories, hidden topics, view permissions, usergroups

but from the error I understand that the logic is wrong and can't be done this way. Also from stackoverflow:

Your subquery is selecting two columns, while you are using it to project one column (as part of the outer SELECT clause). You can only select one column from such a query in this context.

[Arantor]

The SO answer is completely unrelated since it's talking about a subselect, which is not what this is doing,but you should report this to the mod author and let them deal with it.