count

If extra spaces or * characters are in the search it fails. Database error in vBulletin 4.2.2: Invalid SQL: SELECT COUNT(imageid) AS imagecount FROM dbtech_gallery_images WHERE instanceid = 1 && approved...

Hello. A doubt more. When this starts to count? I've installed two days ago. I put 5 credits by post. But a user with 1000 post has 0 credits, not 5000. I think just being posted two days ago, does not take into account the previous post. Is that correct? Does not consider the past, before...

Hi would be pleased if u may help with following: wanna display user xy's credit-amount for ALL users (within navbar for example) how to? and if it´s not thaaat tricky it would be great if u could answer same question how to display forum xy postcount too hopefully my english is not...

After installing from the fix you gave I have set the modification up however im unable to bid. Screenshot is below.

I haven't really delved into it as my county (city) was found in the list, but several people have said it looks like the list is by council and not by county, which affects some of them, ie one is really in county A but county D is the closest in the list to being accurate. Does that make...

Hello Need some help ... today get many database errors Database error in vBulletin 4.2.2: Invalid SQL: INSERT INTO aaggregate_temp_1398445800 SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid; MySQL Error : Incorrect file format 'attachmentviews'...

While the feedback appears to be calculating correctly, the neg feedback is not showing in the number counts.. NM the arrows under the months thingy :P PS Thank you so much for the quick work on the updates for the bugs. Ill have my people run through this update and give it a good hammering...

Please can add option Display Post ID (post count) in postbit ? This will be useful for end users to refer a particular post with postid bbcode.

Hi Fillip H., First off I wanted to say I know this is not your products error or bug, more of a can you help please post. I installed the product Cerberus from VBulletin.org (vBulletin.org Forum - View Single Post - CERBERUS: 1 vB4: runs multiple domains with custom styles, forums, universal...

Username Does not showing on Postbit. Max Postbit Users set to 5 But its show me only 4 username. EX: , seraj1988, zuricane, uranto, baluda and 417 others thanked for this post

my users are coming across a rare case where one user has a space in their name, and another user has the same first part of the name of the other user. The user without the space is getting the notifications that the first user should be getting. For example, lets say the user name is "John...

Hello, I am sorry if this already been questioned and answered I have been investigating this issue for some time after upgrade from lite version to pro version but haven't been able to fix it myself. As you can see from this image... The hidden attachment has been reset. You don't see the...

DragonByte SEO CP > Social Sharing Settings > Page Settings > Show Thread: After First Post > *set to 'Horizontal (with button count)* Rather than produce the selected social sharing buttons after the first post, it produces them after every post. Any ideas what I'm doing wrong?

We're having very similar problems to http://www.dragonbyte-tech.com/f37/absolutely-abysmal-performance-14410/ but I didn't want to hijack his thread. We've added quite a few indexes to the dbtech_thanks_entry table to get it perform acceptably, however now that we're well over 7.5 million...

We had extremely high hopes for this addon but it absolutely crippled our database. We have roughly 8 million 'thanks' in our system and upon activating this product, we went from 0% CPU usage on our DB server to 25% nearly instantly. Eventually the connections piled up and the database server...

I just had the software installed and my site is seriously broken now. Here are some of the things people are complaining about. "I get a broken link icon in place of everyone's avatar" "When I try to view my profile it says "page not found"" "Clicking on some forums yields the following...

Got this error in my logs for the arcade: ##################################### ===================================================== Database error in vBulletin 4.2.2: Invalid SQL: SELECT COUNT(*) AS plays, SUM(timefinish - timestart) AS timespent FROM theforumprefix__dbtech_vbarcade_session...

I'm getting the below error when I try to manually build the sitemap Database error in vBulletin 4.1.12: Invalid SQL: REPLACE INTO hcw_adminutil (title, text) VALUES ('sitemapsession'...

So we now have over 20 items in our classifieds and after setting the 'Default Page Limit in Classifieds' to 10 it does just that ! Great, Now how do I get to the other 10 ? There isn't any page numbers showing to get to the next 10. So I reset the limit to 0 to show everything and I get 6...

Hi Fillip H., sorry to bother you in another place but in my quest for vbseo removal I need to take care of thanks/vbseo likes. I've successfuly installed the lite version of the plugin and imported the vbseo likes. Recreated statistics and turned the plugin on. But the load on mysql server...