Latest Discussions support

meadow

Please post any problems you are having with the latest discussions extension. Also read this discussion, as it may answer your query's.

precinct25

Hello, I am getting the following error message when running the 'Latest Discussion' add on in Internet Explorere - seems to work fine in Firefox though. Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /homepages/6/d175884017/htdocs/unacceptable/forum/extensions/LatestDiscussion/default.php on line 25 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /homepages/6/d175884017/htdocs/unacceptable/forum/extensions/LatestDiscussion/default.php on line 25 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Any help would be great. Cheers Andy

precinct25

Hi, Just realised that the error is occuring on Firefox too, it seems to be happening when I am not logged in. Andy

meadow

The script hasn't yet connected to your database for some reason, try connecting to your database at the top of the extension, by using this code:

mysql_connect('database host','database username','database password'); mysql_selelct_db('database name');

Tell me if that doesn't work.

You could also try uninstalling the extension and checking that everything else works. It works fine on my forum, so I'm currently installing another vanilla forum, and seeing if it works fine on that too, so I can maybe find out what causes this problem - as it has happened before.

UPDATE - I've set up another forum, and the same problem that you had happened, I've managed to fix the script so that it works on my forum, and have updated the link on the add-on page, hopefully it will now work.

SlashedZero

The problem seems to have been fixed now

However I ran into another one. It's not really a bug, mostly a feature, but I noticed all new discussions are displayed. I mean, if you make a post in a category restricted to a specific role, then browse the forum unauthenticated, the extension still displays the discussion. Of course, you can't actually read the discussion when you click on the link, but there's no custom message to explain you what happened. It only says the discussion can't be found, which is normal, but in my opinion a bit confusing for a first-time user.

All of this to say it would be better to make discussions appear according to each role's permissions. I think I'll change the default "discussion not found" message to something like "This discussion cannot be found, maybe you don't have the permission to access this category", it will do the trick for now. Keep up the good work

meadow

I'll add this feature to the next build, thanks for finding it.

SlashedZero

I've just noticed whispered discussions are also displayed, even if you can't access them. It's the same problem than for restricted categories.

potemkine

I concur with Ø, I've got the same remark about every topic displayed, even if the user does not belong to the category. It may display discussion titles which could be confidential. Good work anyway :)

Pol

Potemkine, check out my Latest Discussions Prime extension. It fixes this, and has some other advantages.

krush

Doesn't anyone use this anymore? Or is there a better alternative? I just installed it. Is there a way to cut off the amount of text so that each topic doesn't take up more than one line?

jimw

I've modified this to help someone. He is testing it. I call it LatestDiscussionPrimePlus. There was a discussion here where they wanted additional information about discussions to appear on the Category page. I couldn't figure out how to do that, but I was able to sort the discussion information by category and display it accordingly. It it tests out okay, I will upload it.

spode

This add-on will display whispered topics as well, which is probably not desirable. You can easily block those out by modifying the SQL query. Just checking out Prime plus instead :)