Unknown column 'memf.ID_MEMBER' in 'where clause'

[Astarta]

Hello,

I'm using SMF1.5 with some mods installed. It used to work perfectly for a long time, but some ago I started to mention the following message in error log:

(URL)  http://rat.ru/forum/index.php?board=10.360;sort=subject
Database error: Unknown column 'memf.ID_MEMBER' in 'where clause'
file: /srv/www/rat/www/htdocs/forum/Sources/MessageIndex.php
line: 492

I tried to run repair on the database (using mysqlcheck --repair ... ), but this does not seem to be the solution.

What's the best way to fix this error instead of reinstalling the whole forum?

[Nathaniel]

Hmm, can you post your MessageIndex.php file so that I can have a look at the issue?

Have you installed any mods recently?
Also, Are you getting any other related database query errors?

[Astarta]

Hmm, can you post your MessageIndex.php file so that I can have a look at the issue?

Thanks for the response, It's really appreciated!
Attached my MessageIndex.php to this post.

Have you installed any mods recently?

No, I cant remember that these messages appear after some mod installation.

Also, Are you getting any other related database query errors?

There is no *other* database errors, I only get ' Unknown column 'memf.ID_MEMBER' in 'where clause'' error on all the boards if someone sorts topics by subject and tries to access any page but the first one.

[Nathaniel]

As far as I can tell its an error with the View Any Topic permission mod.

I would ask about it in the support topic for that mod, with a link to this topic. It seems to cause an error with one of the database queries in that file, under certain conditions.

[Astarta]

Thank you!
I'll try to temporary uninstall "View Any Topic permission" mod and see if it changes anything, and I'll certainly contact the mod author with all the results of our investigation.

[Rumbaar]

Are you sure you didn't absolutely nothing before you started getting this issue.  A mod once installed shouldn't just break if it was working and you've done nothing.

No db issues or errors before this?

[Astarta]

Hello Rumbaar,

Yes, I'm sure that I did nothing and there were no any database errors before.

Actually, after LHVWB mentioned "View Any Topic permission" mod, I remembered  that these errors appeared after installing this mod. I did not really use "View Any Topic permission" on my forum, so I completely forgot about this mod being installed and that's why I wrote in one of my previous message that the errors did not appear after some mod installation, that was my mistake, sorry:(

Recently I completely uninstalled "View Any Topic permission" and tried to reproduce "Unknown column 'memf.ID_MEMBER' in 'where clause'" errors (by sorting messages by subject and trying to access different pages in the board) - success, no database errors, nothing. Then I installed "View Any Topic permission" back (installation was successful), went to one of the forum's board, sorted messages by subject, tried to open another page and got "Unknown column 'memf.ID_MEMBER' in 'where clause'" again, so I'm pretty sure that there is some kind of incompatibility with my SMF installation and the mentioned mod.
Now I have "View Any Topic permission" uninstalled and the forum works like a charm, no database errors, clear log and etc

[Rumbaar]

There are two similar mods of similar names.  Which one did you use?

[Astarta]

It's "View Any Topic Permission Mod      1.9 "
written by "Written By: Christopher Cooke ,Contact Info: [email protected]" as it's stated in readme.txt.

Let me know if any other info is required.

[Rumbaar]

Well I take it that, that is this mod: View Any Topic permission as with any mod, it's best to contact the author via the mods comment/support thread.

But you can try this mod and see how you go:
View Topic Permissions

[Astarta]

Rumbaar, thank you for your attention.

I've already contacted the mod author  (in http://www.simplemachines.org/community/index.php?topic=156660.0), as it was suggested by LHVWB, but it appeared that the mod is no longer supported.
Also, thank you for the link to the similar mod, I'll certainly try it out