Search results for query: *

Thanks. TBH I wasn't really looking forward to trying to explain how our code edited and pushed out to all 12 servers, since we don't use FTP :)

We found the issue. or, at least a work-around. From one of our moderators: I edited the dbtech_thanks_postbit_entries_actionbit to this: <span class="dbtech-thanks-button-control"<if condition="!$show['_cannotseeclicks']"> data-contenttype="$contenttype" data-button="$button[varname]"...

I reverted the templates, same problem. (they just hide some headers and boxes we didn't care for).

Update: The integration through Tapatalk does work. I was able to successfully "like" a post using it. I wonder if this is some javascript issue with vB 3.8.11...

Sorry, should have been more clear. I receive no errors or warnings in the php error log when the button is clicked. The same thing happens with "compact" style.

"Thanks" clicks not working after vB Upgrade (3.8.11) and PHP upgrade (to 7.1) Upgraded PHP to 5.6 on the forums, and the forum software to vB 3.8.11 (beta). I also went ahead and upgraded the "Thanks" addon to 3.6.3. The upgrade itself crashed due to a modification of the...

I noticed in your announcement about Cookie Control that you were working on a version for 3.x, Do you have any ideas as to when that's going to be available? Google has a firm compliance date of September 30, 2015 for adsense, and I need to have something in place by then. Thanks!

ok, after a day of running, everything is looking good. I haven't seen any queries related to to the addon in the slow query log in the last day, which is good news! :)

Ok, apparently something went wrong with the initial build on entrycache. I thought it was a little weird that every row had the same BLOB size of 6 bytes, and all it contained was: a:0:{} I didn't quite notice it at first because I was so focused on sorting out the queries. A few users...

that worked! Thank you!

Yep, that ran just fine. 0.00 sec with SQL_NO_CACHE mysql> explain SELECT SQL_NO_CACHE contentid, contenttype, data FROM dbtech_thanks_entrycache WHERE contentid IN(31375124, 31375490, 31384856, 31386816, 31429366, 31430728, 31442868, 31444234, 31787740, 32130814, 32134788, 32156708, 32157978...

Nope, didn't seem to help at all. HOWEVER! All the numbers are integers! I put quotes around all the integers like so: explain select contentid, data FROM dbtech_thanks_entrycache WHERE contentid IN('', '31375124', '31375490', '31384856', '31386816', '31429366', '31430728', '31442868'...

3,621,997 rows in entrycache. The table was created as innodb. I converted it to MyISAM on a whim, but that didn't help. I tried throwing a few example queries (like the one above) at it, and they still aren't using the index, even if I tried to force it to use the index. We're running...

10 days is about 275k for us. :) What are the chances something like that can be cached in memcached with vboptimise? Thanks for all the hard work you're doing to help out the bigger forums! Hey, one more question: What are the chances of changing the mysql query to using mysql_slave...

dbtech_thanks_statistics: # User@Host: USER[USER] @ [192.168.128.88] # Thread_id: 87737136 Schema: DBNAME Last_errno: 0 Killed: 0 # Query_time: 7.465718 Lock_time: 0.000338 Rows_sent: 20 Rows_examined: 158 Rows_affected: 0 Rows_read: 158 # Bytes_sent: 59445 SET timestamp=1395444520...

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

The inserts aren't an issue (yet). Most of the indexes I added were in response to slower queries, and they made a remarkable increase in speed once they were added. It's on my list of things to test though, Thanks!

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

Also, the default post icon. We have nothing filled out for it (as we don't have a default post icon), when turning the CDN online, it comes up as a blank image with just the url: http://cdn.skyscrapercity.com.s3.amazonaws.com/ Do I perhaps need to put a 1-pixel transparent icon in there? or...

Is there a place to set the bucket URL? Because by default, when I enable AWS and toggle the CDN online, vboptimise links http://cdn.skyscrapercity.com.s3.amazonaws.com instead of http://cdn.skyscrapercity.com/ Here, I'll walk you through what I do: 1. select Amazon S3 from the CDN...