We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Error in moderator panel | Forum
Vitaly
Mar 20 '11
Then I try see listing of flags in Links or Groups plugins, links: http://site.my/base/flags/index/type/group/ and http://site.my/base/flags/index/type/link/ cause error.
Vitaly
Mar 20 '11
Update. Then I delete line " ORDER BY offenceC + illegalC + spamC DESC" in /home/r/reasonator/oxwall/public_html/ow_system_plugins/base/bol/flag_dao.php error was gone.
Tell me the correct solution, please.
update. "ORDER BY 'offenceC' + 'illegalC' + 'spamC' DESC" works too.
Tell me the correct solution, please.
update. "ORDER BY 'offenceC' + 'illegalC' + 'spamC' DESC" works too.
The Forum post is edited by Vitaly Mar 21 '11
Team Den
Mar 21 '11
Hi
This part of query order subselect's result by number of reports. I suggest you to don't delete this code and find out why your mysql doesn't see subselect's results.
These fields 'offenceC', 'illegalC', 'spamC' are results of subselect. When you quoted them, you will get order by string :) not by field.
This part of query order subselect's result by number of reports. I suggest you to don't delete this code and find out why your mysql doesn't see subselect's results.
These fields 'offenceC', 'illegalC', 'spamC' are results of subselect. When you quoted them, you will get order by string :) not by field.
Vitaly
Mar 21 '11
Hi
These fields 'offenceC', 'illegalC', 'spamC' are results of subselect. When you quoted them, you will get order by string :) not by field.
Yes, I'am noob in MySQL syntax. But what is the reason for this error? As I understand it there is not at all.
up. 'ORDER BY spamC DESC' works too. ) original code 'ORDER BY offenceC + illegalC + spamC DESC' not work.
The Forum post is edited by Vitaly Mar 21 '11
Team Den
Mar 22 '11
Hmm… would you send me your FTp/phpmyadmin/Site admin details? Our dev team will check it.
