Recent content by Mario Estrada

Thanks that worked flawlessly.

Hi, We have extended XenForo_DataWriter_DiscussionMessage_Post with the class Techspot_DataWriter_DiscussionMessage_Post which has custom functionality for _messagePostSave and _messagePreSave. Outside the XenForo environment we do something like this to save comments on news articles...

Looks like by switching to InnoDB we no longer have the slow queries issue with big threads. (y)

This is now fixed, it was an issue with one of our custom helper functions that triggered the error on only a very few users.

Thanks, our server administrator is working on migrating the backup script to mydumper. And I'll post an update if we find the problem causing this excessive load.

We have a thread that has a huge first page and it takes a long time to load and it actually triggers an entry in our mysql long query logs, taking around 4 seconds to complete the query. The affected thread *: http://www.techspot.com/...

We don't index user pages, we only allow indexing of the staff profiles which are less than 10. And if we search on Google, you can actually see that the first link there has been crawled: https://www.google.com/search?sourceid=chrome&ie=UTF-8&q=site%3Awww.techspot.com%2Fcommunity%2Fmembers%2F

1+ million posts: http://www.techspot.com/community/

We have a very big database at the TechSpot Forums but when we switched we didn't notice we had InnoDB disabled, now we want to change them to the InnoDB tables. We've looked around the forum and know that there are some tables that should use MyISAM and Memory. Repost from...

I've created a SQL script that alters only the required tables to InnoDB from MyISAM. See attached. Basically it does something like this: SET FOREIGN_KEY_CHECKS = 0; ALTER TABLE archived_import_log ENGINE=InnoDB; ALTER TABLE xf_addon ENGINE=InnoDB; ... ALTER TABLE xf_warning_definition...

Thanks that's what I used to solve it, for those interested: XenForo_Template_Helper_Core::$helperCallbacks['avatar'] = array('Techspot_Helpers', 'helperAvatarUrl'); public static function helperAvatarUrl($user, $size, $forceType = null, $canonical = false) { $url =...

In the TechSpot Forums we have the default avatars set depending on their user id if they haven't set a custom avatar. If it ends with 0, 1, ... or 9 it shows a different avatar. Currently we made the changes directly to XenForo_Template_Helper_Core but I know this is not ideal, I want to...

I think the importer stretched the images to the new sizes. I think it's a non-issue, I would have preferred users to reupload their avatars but I don't make those decisions, also current users would have complained a lot about it. @mmoore5553 the site runs on an ancient CMS called Esselbach...

Thanks, we finally finished with our migration: techspot.com/community

We had an issue were we imported our data from VB 3.8 but because of an error in setting the path of our vbattach and customavatars folder, the avatars and folders were not imported. Is there anyway we can reimport only avatars and attachments from VB?