Ignore Topics

[Chas Large]

Installs just fine on a fresh and a fairly modded RC5 for me so... so yes one of those mods you have already edited those files

Thanks for confirming this Spoogs, however I have done a manual search of my Recent.php file (attached) compared to the manual install details and the two failed items mentioned above are both there and are in their original state, i.e., no other mod has touched them. Can this be confirmed please?
Strike all that, I had inadvertently left the parser set to RC2. Resetting to RC5 and the mod installs OK. Sorry folks.

[Spoogs]

 

[Chas Large]

OK Installed and working but on my test forum if I click Recent unread replies I get the following error:

Code Select Expand

Database Error
Unknown column 'pi.id_topic' in 'on clause'
File: D:\EasyPHP_Site3\Sources\Recent.php
Line: 1130

[edit]
Also in the error log

Code Select Expand

http://127.0.0.1/FPF_Local/index.php?action=unreadreplies
Database Error: Unknown column 'pi.id_topic' in 'on clause'
File: D:/EasyPHP_Site3/Sources/Recent.php
Line: 1130

[Chas Large]

OK Installed and working but on my test forum if I click "New replies to your posts" I get the following error:

Code Select Expand

Database Error
Unknown column 'pi.id_topic' in 'on clause'
File: D:\EasyPHP_Site3\Sources\Recent.php
Line: 1130

[edit]
Also in the error log

Code Select Expand

http://127.0.0.1/FPF_Local/index.php?action=unreadreplies
Database Error: Unknown column 'pi.id_topic' in 'on clause'
File: D:/EasyPHP_Site3/Sources/Recent.php
Line: 1130

[edit 2] corrected above "New replies to your posts"

[ascaland]

Great to see the mod being used actively again.
Im also open for any suggestions or requests for the mod.

[Chas Large]

OK Installed and working but on my test forum if I click "new replies to your posts" I get the following error:

Code Select Expand

Database Error
Unknown column 'pi.id_topic' in 'on clause'
File: D:\EasyPHP_Site3\Sources\Recent.php
Line: 1130

[edit]
Also in the error log

Code Select Expand

http://127.0.0.1/FPF_Local/index.php?action=unreadreplies
Database Error: Unknown column 'pi.id_topic' in 'on clause'
File: D:/EasyPHP_Site3/Sources/Recent.php
Line: 1130

Further to the above I have carried out some tests.
1. Installed the mod onto a clean new test forum and it works fine, no errors.
2. Going back to the test forum, I removed all mods then reinstalled just this mod and still got the error.
3. I removed the mod and reinstalled the RC5 upgrade effectively making the forum as new with all new Source and Themes\Default files. I then reinstalled this mod and again get the error when clicking "new replies to your posts"
4. Ran all the standard dB maintenance routines and cleared the cache.

My conclusion therefore is that I have a problem with my database in some way. This database is two years old having first been a 1.1.08 version and has been upgraded through to 1.1.11 before upgrading to 2.0 RC2 then through to RC5. So something somewhere is not right with it but I don't know what to look for. When I did the RC5 upgrade I included the save backup tables so will now remove these from the dB to see if that makes any difference.

[Arantor]

No, it looks like the bug that was uncovered months ago with this mod still isn't fixed

[Chas Large]

No, it looks like the bug that was uncovered months ago with this mod still isn't fixed

Seems that way. I dropped all the backup tables from the dB then re-ran all the maintenance functions and the error is still there. Odd that it works on a new clean install though?

[ascaland]

Hmm, okay I managed to replicate the error myself I will get to it.

[ascaland]

Alright guys, test out the new package I uploaded to the mod site.

[Chas Large]

Alright guys, test out the new package I uploaded to the mod site.

No, sorry, still getting an error: I uninstalled the mod, downloaded the zip file, (btw still shows _v1 and the install shows as version 2.0 ? ) and then reinstalled it. Is the one on the mod site actually the new one? it could do with a sub version number to be sure, like 2.1 etc.

Code Select Expand

Unknown column 'pi.id_topic' in 'on clause'
File: D:\EasyPHP_Site3\Sources\Recent.php
Line: 1130

Code Select Expand

http://127.0.0.1/FPF_Local/index.php?action=unreadreplies
Database Error: Unknown column 'pi.id_topic' in 'on clause'
File: D:/EasyPHP_Site3/Sources/Recent.php
Line: 1130

[ascaland]

I thought the only problem was with this,

The problem after install of this mod is the "new" icon when clicked on child boards in the main index yields a syntax error, but when clicking on the adjacent text it works perfectly...

Which should be fixed now. But I cant seem to replicate the error you keep receiving. May I ask for the steps you take which give you this error?

And yes good idea, I will add the sub version.

[Chas Large]

I thought the only problem was with this,

The problem after install of this mod is the "new" icon when clicked on child boards in the main index yields a syntax error, but when clicking on the adjacent text it works perfectly...

Which should be fixed now. But I cant seem to replicate the error you keep receiving. May I ask for the steps you take which give you this error?

And yes good idea, I will add the sub version.

Simply I click the "show new replies to your posts" link. Using the Default curve theme, top left.

[ascaland]

Aha! I see now, I had to make some adjustments to get that error showing. Time to get back to work (what is this, the third time now? ).

[Chas Large]

Aha! I see now, I had to make some adjustments to get that error showing. Time to get back to work (what is this, the third time now? ).

Good luck

[ascaland]

Ok, reuploaded and hopefully fixed for you.

[Chas Large]

Ok, reuploaded and hopefully fixed for you.

Yep, that seems to have fixed it, well done

[Chas Large]

Sadly another error has cropped up.

From the forum index, click on an orange New indicator, in this case the Cinema board



board opens and shows "No unread topics found, click here to try all unread topics"



"Clicking here" produces this error.

Code Select Expand

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(it.id_topic, 0) = 0
AND t.id_last_msg > 116521
AND IFNULL(lt.id_m' at line 7
File: /home/fiftyplu/public_html/forum/Sources/Recent.php
Line: 821

Back to you....

[ascaland]

Thanks for the heads up Chas Large. I will get to this problem when im back home in a couple hours.
Jeez I didnt think taking over this mod would be such a task.

[Arantor]

Thanks for the heads up Chas Large. I will get to this problem when im back home in a couple hours.
Jeez I didnt think taking over this mod would be such a task.

Now you know why I made mention of the bug fixes involved I'm glad someone is interested enough to take care of this mod though.