HELP: how to solve this error

[Angelotus]

Code Select Expand

Unknown column 'b.id_boardNOT' in 'where clause'
File: /customers/weeklyfun.nl/weeklyfun.nl/httpd.www/forum/Sources/Recent.php
Line: 1323


I 'm getting this error on the recenttopics page. How to solve this?

[Nathaniel]

Hmm, I can't seem to duplicate this error with a clean version of SMF. If you post your Recent.php file then I may be able to isolate the issue.

Have you install any mods recently?

[Angelotus]

Here  is my recent.php
Haven't installed any mods recently.

[Nathaniel]

Okay, I fixed the error. It was being caused by the Recent posts & topics extensions mod. I have attached an edited file.

I replaced this:

Code Select Expand

         AND b.id_boardNOT IN (" . implode(', ', $exclude_boards) . ")") . (!empty($include_boards) ? "

With this:

Code Select Expand

         AND b.id_board NOT IN (" . implode(', ', $exclude_boards) . ")") . (!empty($include_boards) ? "


I have reported this bug to the mod author:
http://www.simplemachines.org/community/index.php?topic=158917.msg1661631#msg1661631

That edit should stop that error from occuring, although I am not sure if the mod will actually work anyway, you will have to check it out, to see if there are any other errors. Also note that when you uninstall the mod, that particular edit will fail because the code of that file has been changed slightly.

[Angelotus]

Very nice, it works again. It did worked before and I never changed a thing, so why the error happens just now is a riddle to me. Thanks for solving this out!