dbtech_thanks_entry

When trying to view a post I'm receiving the following error message: Database error in vBulletin 4.2.3: Invalid SQL: ( SELECT COUNT(*) AS count, varname FROM dbtech_thanks_entry AS entry, ( SELECT postid...

Hey, we got a vbulletin 5 forum and are working on importing the old forum which is running vbulletin 4. We couldn't import the thanks stats from the old forum over to the new one, and bought the pro version hoping that would let us import everything from our vbulletin 4 forum. Weird thing is...

Upon importing the latest version of the mod, i received the following message: Database error in vBulletin 4.2.2: Invalid SQL: ### INSERT QUERY GENERATED BY fetch_query_sql() ### INSERT IGNORE INTO dbtech_thanks_recententry (`entryid`, `varname`, `userid`, `contenttype`, `contentid`...

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...

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...

Parse error: syntax error, unexpected $end in /home2/public_html/forum/dbtech/thanks/actions/admin/search.php on line 55 Line 55 is a blank line... I am testing this on my local host before I move to my production board.

| 3684129 | forum_vb42 | localhost | forum_vb42 | Query | 0 | Sending data | SELECT * FROM dbtech_thanks_entry AS entry WHERE contentid IN...

Hi I've set it so that if you like you cannot dislike and vice versa but when a user edits the source they're able to bypass the restriction. I've had numerous users abuse this within 24 hours. By deleting the following line , it allows users to like / dislike.

Hello. I ran abe thanks modification on my board as a likes system (changed the phrases). Is it possible to store the thanks from that mod as Likes in your mod? Or when they are imported are they only listed as thanks? If not, is there a query where I can move the "thanks" stored in advanced...

We've got a pretty large forum. After about 4 months of having the thanks hack installed (and trimmed down so it's basically a "like" button for posts), we have about 1.45 million rows in our dbtech_thanks_entry table. I've had to add quite a few indexes to keep things speedy, but I have one...

I'm still having problems with the Thanks mod and slow queries. I tried changing the dbtech_thanks_entry table to Innodb and the query time went from 1 - 2 seconds to 9 - 10 seconds. Any idea why this happened? What tables can be changed to innodb for this mod that will help with the slow queries?

We are having issues with sql queries from dbtech_thanks_entry taking much time and getting db response slow and load on server. I have attached few queries to show the queries taking up much time to execute. Kindly let us know how this can be fixed asap - And also we had upgraded to better...

Enabling the forum sideblock halts the whole site with the following database error: Invalid SQL: SELECT entry.*, user.* ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS...

In the admincp -> DBTech - Post Thanks -> Maintenance -> Clean Up (1000) When I run that, it starts to work, then a database errors comes up.

Been getting a lot of hangs on the website for the last few months - so I've been collecting data in the slowqueries log. A few crop up, however nothing really serious except this one: # Query_time: 61.015625 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 139036 SET timestamp=1331681918...

I was just wondering if there was a way to integrate this with other mods? For example, I use vBaDynamics to run a downloads section, but there's no way for other members to thank the creators of the downloads. vBaDynamics is in a folder of my forums, e.g. mysite.com/forum/downloads, which I...

hey I have a MAJOR problem.... app. 160 times a day i certain query is being called and it returns more than 500.000 results each time... its literally killing my entire DB - everything STOPS meanwhile... i have an avg of 59 sec. 160 times a day where the forum is useless.. i need to know...

Hi, My hoster has been defacing of a mass on one of his servers , and now the hack thank do not work, I uninstalled and reinstalled but it don't appear in my admincp but only in manage products and settings/options but not in the frame thx

We have a user at our forums who has decided to abuse the like/dislike system. He's gone on a disliking spree hitting over 600 posts in a short span of time. I have since banned the user, but now I'm still left with all these useless dislike entries. I see that I can go in and delete the...

I imported 370,000k in thanks last night from Abes mod Took a long time but they all appear to be on your thanks table now. When it stopped importing it gave me this error... Database error in vBulletin 4.1.1: Invalid SQL: SELECT entryid, varname...