![]() |
You must post all the error text.
|
Database error in vBulletin 3.7.0:
Invalid SQL: SELECT COUNT(dateline) AS rcount FROM reputation WHERE userid = 2 AND dateline >; 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 '' at line 4 Error Number : 1064 Request Date : Saturday, May 3rd 2008 @ 03:08:24 PM Error Date : Saturday, May 3rd 2008 @ 03:08:27 PM Script : http://www.mysite.com/forums/ Referrer : IP Address : edited Username : AtotheC Classname : vB_Database MySQL Version : 4.1.22-standard |
You are missing a value for lastrepcheck - I suggest you uninstall this and then re-install it.
|
Quote:
|
Quote:
i forgot all about the issue with ultimate navbar, working again thanks ! |
Hmm. Well, I upgraded my forum to 7.0 last night and I'm having trouble getting this new version to work for me. It shows the "unread posts" portion, but not the reputation part.
I previously had your 6x version installed (loved it btw), upgraded forum to 3.7.0, uninstalled 6x version in the product manager, installed the new one successfully, but I can only get the "unread posts" part to show up. Everything seemed to go perfectly, no errors. During the forum upgrade, and before the mod install, I reverted back all templates and I just verified they are unaltered and up to date. It almost seems to me like it just needs to be turned on, but I verified in vB Options that the bullet for "display new reputation comments" is set to yes. I saw your warning: Quote:
Any idea what could be wrong? Thanks a bunch and I love this hack, when I can get it to work. :) |
no additional template modifications are necessary, right? all i did was install the xml in the product manager.
|
OH, ugh, nm, got it. It doesn't show up unless there is a new rep comment, otherwise the line doesn't appear at all, which is different than the 6x version. But it's fine! :)
Thanks again, great hack. |
Quote:
|
:confused:
I installed it but it does not appear in the navbar. why??? |
if you have ultimate navbar u need to go read that thread again.
|
Quote:
And since I am new with VB what do you mean ultimate navbar?? Can you explain in more details?? Thanks, John. |
thankx nice mod
|
Quote:
When I am selecting "Use Last Visit Date" displays "No Unread Posts since your last visit." so far so good... When I am selecting "Count All Posts Marked as Unread" displays "Display Unread Posts" even if I have or not unread Posts. Shouldn't display ... Code:
You Have <strong>No <a href="{1}search.php?do=getnew{2}">Unread Posts</a></strong> Code:
You Have <strong>{1} <a href="{3}search.php?do=getnew{4}">Unread {2}</a></strong> :confused: |
Actually I wasnt sure what you meant to start with, but now I've read it again I see.
This will happen if you use the "Count All Posts Marked as Unread" option, and you have set your "Database Read Marking Limit" higher than the "Maximum Cutoff Limit" in this mod. The cutoff needs to be equal to or greater than the marking limit. |
Is there an addon like this that displays unread posts without using database marking? I know there used to be for 3.6
|
Quote:
I'm new to this and have no clue what to make it, any help please? |
Assuming its the site in your signature, you shouldnt need to set it to anything.
|
Quote:
The rep part works and I can get the unread post to work but then the new post is off. Not sure what is wrong there so I have the unread post turned off at the moment. |
I just installed this mod for vB 3.7 (have been using the previous version for awhile) and it works great! Thanks again for an excellent mod. :)
|
Quote:
I dont understand what you mean by that. |
Okay, so if I set the new reputation comment to be normal, legacy mode, it works fine.
However, if I set it to be like a notification, when clicking it, it doesn't work. It doesn't add the /forums/ inbetween my URL and usercp.php, like it does when it's not a notification. Any thoughts? |
Hmm, could be a bug, I'll take a look tonight.
|
Quote:
|
Quote:
That was the problem !!! :up: |
Quote:
When there actually is new reputation, the link doesn't work. However, if there is no new reputation (but some other new notification), the link works from the dropdown. Just trying to help! |
It was a small bug in the notification code, it wasnt applying the links path. Fixed in 3.7.005.
|
I've installed it but I don't see it :(
|
It works for me :D
|
Any reputation comments in postbit hack Paul?
|
Not from me, I dont know if one exists at all.
|
I uploaded the file in the admin, checked the settings, and I still don't see it. :(
|
Are you actually using the database thread marking system ?
|
I'm using the database thread marking system and I don't see the unread posts. I can see the new rep comments. (I set it under notifications)
|
Sorry but I cannot help you without admin access to your forum.
|
Thanks for that great and another "that should be vbulletin default" modification.
Best |
It didn't work for my 3.7.0 Gold ! nothing appears, it was working on 3.6 with last version.
|
See post #115 :)
|
I have this installed and it works great, but I'm having an issue on my site with "database errors" that the host is saying is caused by too many queries at once... so I'm trying to track that down.
Does this modification add to the queries significantly? |
Ask your host what they mean exactly by "too many queries" - and what exactly are the database errors you get.
This adds one select query for each function (unread posts, rep comments). |
All times are GMT. The time now is 11:57 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|