Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Topics Filter v3.0

Started by M-DVD, October 10, 2007, 06:57:55 PM

Previous topic - Next topic


All the 1.1.x versions should work for 1.1.3

I have however updated the parser I host to work for 1.1.4 and the smf 2.0 betas


Erro na base de dados: Unknown column 'mf.subject' in 'where clause'
Ficheiro: /home/nemigue/public_html/Sources/MessageIndex.php
Linha: 619


Are you using v2.4?
Can you attach your MessageIndex.php please.

How often do you get it?  Every page? or is it caused in certain conditions?


I don't know, he appears in the Forum Error Log, I use Topics Filter 2.0, but with the modifications that you have been suggesting...


Several bugs were fixed in 2.4.

I would recommend uninstalling the version you have, then installing 2.4


it won't be easy to uninstall, because it already suffered some alterations...


Sorry to hear about that.

Of course its upto you.

But in order to fix that bug, you would need to use the latest version.


Hey ho, i've installed this mod manually yesterday by using the "show what you need to edit"-Function here and also the PackageParser one.

I've never used this one before.

The Problem could be a missing DB_column, but i dont know how to get this infos.

The Error (on every board, subboard or message link):

Unknown column 'b.filter_alphanum' in 'field list'

I just need to know the modifications for DB. Please let me know. :-)

//edit:  I've executed the SQL statements by hand ... know the pages stay plain white, if I use a link to a board, subboard etc. :-) it's friday, it kills me  :D

//edit: The problem are these variables:


I can't put them where they should be, because the place is right _within_ of a sql-query. Not a good place to do it there. I've attached my MessageIndex.php. Would be cool if someone could help me.


They need to right in the middle of the query as per the edit.

Each represents extra 'query' conditions which are built a little earlier.
If that particular query isn't set, then it will be set as blank.


Quote from: karlbenson on March 03, 2008, 09:17:24 PM
All the 1.1.x versions should work for 1.1.3

I have however updated the parser I host to work for 1.1.4 and the smf 2.0 betas

i tryed but not worked this mod with smf 2.0 beta 3

can you take this mod campatible ? thank you !


This mod will not work for SMF 2.0 yet.

i haven't yet updated it.  I plan too. But with all mods, its a case of when i get around to it.


Quote from: karlbenson on April 30, 2008, 05:44:19 PM
This mod will not work for SMF 2.0 yet.

i haven't yet updated it.  I plan too. But with all mods, its a case of when i get around to it.

ok.. i will waiting for new version ;)


Hi, karlbenson!
I from Russia and i want use your great mod. SMF ver. 1.1.4. I download v. 2.4 and install this. No error found. I cut code from Modifications.english.php and paste it to Modifications.russian.php. I translated all $txt and i can post it, if you need it for russian mod:)
2 troubles: 1) it not works & 2) we have another alphabet: not a-z (а-я).
Can you help me with my troubles?
Sorry my english.   


It will not work with other letters.


Hi Karl :)

Taking your advice from my other topic that I had posted requesting help for that error "Unknown column 'mf.subject' in 'where clause'". I went to uninstall my current version of this mod (2.4) and I am getting a MESS of errors...

1. Execute Modification ./Sources/Load.php Test failed
2. Execute Modification ./Sources/ManageBoards.php Test failed
3. Execute Modification ./Sources/Subs-Boards.php Test failed
4. Execute Modification ./Themes/default/ManageBoards.template.php Test successful
5. Execute Modification ./Sources/MessageIndex.php Test successful
6. Execute Modification ./Sources/Load.php Test successful
7. Execute Modification ./Themes/default/MessageIndex.template.php Test successful
8. Execute Modification ./Themes/default/languages/Modifications.english.php Test failed
9. Execute Modification ./Themes/default/languages/Modifications.english-utf8.php Skipping file
10. Execute Modification ./Themes/default/languages/Modifications.english_british.php Skipping file
11. Execute Modification ./Themes/default/languages/Modifications.english_british-utf8.php Skipping file
12. Execute Modification ./Themes/default/languages/Modifications.turkish.php Skipping file
13. Execute Modification ./Themes/default/languages/Modifications.turkish-utf8.php Skipping file
14. Execute Modification ./Themes/default/languages/Modifications.portuguese.php Skipping file
15. Execute Modification ./Themes/default/languages/Modifications.portuguese-utf8.php Skipping file

I know you dont have alot of time on your hands, so when you have time, could you give me some advice on this? (it would be greatly appreciated). Right now I am only getting that error on two specific pages when someone is using the filter. Is there a way I can just "manually" edit some of the code to fix this specific error since its the only problem I am having with it? I am not very good at manualy installing mods (thank goodness with the theme I use, I dont have to, they all install fine thru package manager). I will probably screw it up if I have to manually uninstall everything and then reinstall the whole mod manually again.  :-[



Put the mod through a package parser

And manually install the mod.


Quote from: karlbenson on May 17, 2008, 01:17:01 PM
Put the mod through a package parser

And manually install the mod.

Those above "test failed's" are happening when I try to "un"install the current mod I have not when I try to install the newer version of the mod

Are you saying I just need to run the updated mod thru the package parser and change any code I need to change so it matches the new updated mod code?


Sorry if i was unclear.

Basically the most common reason for edits failing is that another mod has preceeded to alter the same areas of code after it.
[Normal] Use a package parser to provide you with the edits so you can work backwards and UNINSTALL.
Then when you've finished uninstalling, install the new one.

[Advanced] Alternatively if you have a suitable program you could do a 'diff' between the new install.xml and the old install.xml.
(and then make the adjustments accordingly)


ah..ok I understand now..thanks :)

Im thinking the advanced way is going to be easier for several reasons - mostly because there is less to do, which will leave less room for human error. Ive found a few programs that will let you compare 2 xml files so I am going to try that and see how it goes.

Edit - Unfortuntely, I am not going to be able to do either option. I do not have the original mod on my pc (in zip form), and you no longer have it on the download page for me to redownload and compare the xml files. (which means I cant even do a full manual uninstall). My backup drive died a few days ago and I had to nix it. All the mods - in zipped form - were stored on it

Any new suggestions?  lol


What version were you using?
I might have still have a copy.

Note for future reference you NEED to keep a copy in order to uninstall the mod.  You can't uninstall your version with the latest version.