vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX) (https://vborg.vbsupport.ru/showthread.php?t=233310)

starman? 07-26-2011 04:35 PM

working just fine and dandy in 4.15 beta! Thanks Walter!!!

Scalemotorcars 08-27-2011 01:53 PM

Working but is there a way to add the results to subnav on cms pages?

Drache 08-29-2011 05:49 PM

Does this use a lot server resource or slow server down?

Valter 09-02-2011 07:30 PM

It depends on your server, number of active users, product settings.

Try and see.

I believe it will work with no problems.

Quest2be1 09-03-2011 09:17 PM

Hi, I am using VBulletin 4.1.5 and I have installed the latest version of this mod 3.0.2. Basically, when I click on the advanced new posts icon it continues to show me "View New Posts in..." When in fact there are no more new posts to view. Can you please point me in the right direction to resolve this issue? Is SSM the problem and I have to disable it? Thanks in advance for the help.

misericorde 10-16-2011 08:27 PM

Thank you

Nice

Installed and nominated

RSNF 12-10-2011 07:25 PM

The mod worked fine for a while and now the following error occurs can anyone help?

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@redsoxnationfans.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Successfulsteps 01-10-2012 12:15 AM

Anyone having problems in 4.1.9? I would love to see this working on that upgrade!

Valter 01-10-2012 07:03 AM

Works with no problems with 4.1.9.

garybrun 01-11-2012 12:35 AM

Its working on my forum 4.1.9a

Valter...
Greetings from Norway and thanks for some excellent hacks.

http://www.minelabowners.com

Emeralda 02-11-2012 04:36 PM

It works on 4.1.10, at least with it's basic functionality, I haven't gotten deeper yet. But it doesn't show properly here:

http://img860.imageshack.us/img860/2...ca1ab11c15.png

Any ideas on how I could get it to work with What's New tab?

depalaza 02-24-2012 06:21 AM

Quote:

Originally Posted by Valter (Post 2177119)
Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

i have same problem and i have do
-forum manager and saving the display.
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information


but still error

Invalid SQL: SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid FROM post as post LEFT JOIN thread AS thread ON (thread.threadid = post.threadid) WHERE post.visible = '1' AND thread.forumid NOT IN(3,10,57,64,79,80,81,73,48,74,87,62,75,71,) AND post.dateline >= 1330064830 GROUP BY post.threadid;

MySQL Error : 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 ') AND post.dateline >= 1330064830 GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, February 23rd 2012 @ 10:52:17 PM
Error Date : Thursday, February 23rd 2012 @ 10:52:18 PM
Script : http://www.blackgamerz.net/misc.php?...saanp_newposts
Referrer : http://www.blackgamerz.net/forum.php
Classname : vB_Database
MySQL Version :

Valter 02-24-2012 07:25 AM

You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

Nirjonadda 02-24-2012 12:17 PM

Working on my forum 4.1.10

depalaza 02-27-2012 12:33 PM

Quote:

Originally Posted by Valter (Post 2302903)
You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

hmm excluded forum ? where i can find it ? and that message not shown at admin usergroup so it only shown to other usergroup

Valter 05-21-2012 04:05 PM

v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

Gemma 05-21-2012 04:12 PM

Thanks for the update :)

FTG LIQUID CL 05-22-2012 01:39 AM

Works like it says,updates fine.Great work as always Valter. Thank you

jdeveaux 05-27-2012 12:52 AM

I'm testing with 4.2 and getting the same MySQLi error, below:

Note - I've noticed that it only happens if a user logs out or comes to the site and does not have cached login credentials. Once they log-in everything appears to be ok.


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM vb_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb_thread as thread USING (threadid)
INNER JOIN vb_forum AS forum USING (forumid)
LEFT JOIN vb_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 0)
LEFT JOIN vb_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 0)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(7,16,24,8,33,21,136,127,115,138,5,110,25,28,29, 42,80,3,12,134,139,36,131,130,30,99,91,32,82,69,31 ,20,27,26,117,)
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND post.dateline > 1338082997 AND thread.lastpost > 1338082997
GROUP BY post.threadid;

MySQL Error : 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 ')
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadre' at line 8 Error Number : 1064 Request Date : Saturday, May 26th 2012 @ 08:44:21 PM
Error Date : Saturday, May 26th 2012 @ 08:44:22 PM
Script : http://site/misc.php?show=vsaanp_newposts
Referrer : http://site/login.php?do=logout&logo...6f538d64af7e12
IP Address :
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Regards,

John

Valter 05-27-2012 06:38 AM

At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.

Honk0815 05-27-2012 09:19 AM

Can I use the addon with vbcms?
I have only in Forum Advanced 'New Posts' (AJAX) and i need this in cms too

jdeveaux 05-27-2012 12:24 PM

Quote:

Originally Posted by Valter (Post 2333406)
At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

CAG CheechDogg 06-11-2012 10:13 AM

How do you exclude certain forums?

dlewisr 06-12-2012 09:28 AM

Nice one. Works with 4.2.0. Does exactly what it says on the tin.

Cheers

jdeveaux 06-18-2012 06:36 PM

Quote:

Originally Posted by jdeveaux (Post 2333471)
I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

By chance I've discovered that this issue is caused by installing a combination of VSA Hacks... now the new question is which one :confused:

I'm going through and testing one by one but thus far I haven't found the smoking gun. Installed by itself it works great.

root2012 11-05-2012 01:43 PM

I have a problem after install

Code:

Datenbankfehler in vBulletin 4.1.0:

Invalid SQL:

                                        SELECT COUNT(*) AS posts, post.threadid
                                        FROM post as post /*FORCE INDEX (dateline)*/
                                        INNER JOIN thread as thread USING (threadid)
                                        INNER JOIN forum AS forum USING (forumid)
                                        LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 67)
                                        LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 67)
                                        WHERE thread.visible IN (1)
                                        AND thread.forumid NOT IN(106,107,108,109,110,99,100,)
                                        AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
                                        AND thread.lastpost > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
                                        AND post.dateline > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
                                        AND thread.lastpost > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
                                        AND post.dateline > 1352086208 AND thread.lastpost > 1352086208
                                        GROUP BY post.threadid;

MySQL-Fehler  : 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 ')
                                        AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadre' at line 8
Fehler-Nr.    : 1064
Fehler-Zeit  : Monday, November 5th 2012 @ 03:27:08 PM
Datum        : Monday, November 5th 2012 @ 03:27:09 PM
Skript        : http://new/vb4/misc.php?show=vsaanp_newposts
Referrer      : http://new/vb4/forum.php


emperatour 12-19-2012 01:42 PM

Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

HTML Code:

<div id="pagetitle">
                <h1>
                        <vb:if condition="$search_back_url">
                                <a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
                        <vb:else />
                                <strong>{vb:rawphrase search}:</strong>
                        </vb:if>
                </h1>
                <p class="description">
                        {vb:raw criteriaDisplay}               
                </p>
        </div>

I appreciate your work.

Amaury 02-08-2013 05:36 PM

So, under New Posts in your screenshot, what does 3 | 2 mean?

Dwarden 03-16-2013 09:26 AM

Quote:

Originally Posted by Valter (Post 2331298)
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

well I tried update from 3.0.2 to 3.0.3 and the post counter is gone on 4.2.x forum
reverting to 3.0.2 fixes it

Quote:

Originally Posted by emperatour (Post 2391652)
Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

HTML Code:

<div id="pagetitle">
                <h1>
                        <vb:if condition="$search_back_url">
                                <a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
                        <vb:else />
                                <strong>{vb:rawphrase search}:</strong>
                        </vb:if>
                </h1>
                <p class="description">
                        {vb:raw criteriaDisplay}               
                </p>
        </div>

I appreciate your work.

where this goes to please ?

NoMatt3r 08-30-2013 02:57 PM

Installed on 4.2.1 and working great!

But it still shows 4 | 6 altough i've already read the new posts/threads. And the SSM shows forums although the usergroup doesn't have permissions.

Bubble #5 09-10-2013 04:12 PM

1 Attachment(s)
Found what appears to be a major bug with this mod (4.2.1).

When you close the forum, AND also try to log into it, the amount of new posts turns into your forum closed message. If you are not logged in and the forum is closed the message does not appear. Here is a screenshot;

Could not fix the bug noted above.

Deleted hack. Shame, it had lots of nice features.

Dwarden 10-29-2013 09:39 PM

seems like there are problems with 4.2.2 (both 3.0.2 and 3.0.3) ...

[] [error] [client] PHP Fatal error: Nesting level too deep - recursive dependency? in Unknown on line 0, referer: http://forums.somewhere.com/showthre...somepage/page5

and indication of 500 error leading to the /misc.php?show=vsaanp_newposts

whole forum goes to stall and needs server restart

anyone have tips how resolve it ?
and is there anyone who runs runs 3.0.3 on vB 4.2.2 ?

GamerUnguided 02-10-2014 07:48 PM

So has anybody had any luck with this not appearing on certain themes? is there some template edit i can add to make it show?

root2012 06-16-2014 01:29 PM

Any ideas on how I could get it to work with What's New tab?

Gierade 01-27-2017 11:18 AM

Plugin stopped working after updating to 4.2.3 PL 2 forum PHP version 5.4.45 - any ideas how to fix it?
Does not display the counter of new threads.

roiarthur 05-12-2017 10:41 AM

The mod is malfunctioning with Vbulletin 4.2.5

roiarthur 05-14-2017 10:53 AM

The stats will not refresh after viewing the new messages, someone can help to fix it please?


All times are GMT. The time now is 01:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01537 seconds
  • Memory Usage 1,834KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_html_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (37)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete