Recent content by PrinceReborn

  1. PrinceReborn

    XF 1.4 MySQL lag every 24 hours.

    If I recall correctly this was unrelated to Xenforo and to do with our own software application running on the server which did a very inefficient SQL query. I could be wrong though as this was a long time ago. If a moderator wants to close this thread feel free.
  2. PrinceReborn

    Lack of interest Option: Count likes made in this forum towards user total

    It is somewhat common for boards to have a spam/testing section to allow forum members to mess around and it is great that we have the ability to not count posts made in these sections by using the setting in Forum Options for the node. What I would like to suggest is that there be an...
  3. PrinceReborn

    Fixed MariaDB 10.1.x - Incorrect integer value: '' for column 'content_id' at row 1

    Issue has been resolved. The problem was regarding disk space on the partition being higher than 90% and ElasticSearch doing some funky stuff with shards. Freeing up space fixed the issue.
  4. PrinceReborn

    Fixed MariaDB 10.1.x - Incorrect integer value: '' for column 'content_id' at row 1

    Sorry to bump this thread but this is the only one I could see relating to this issue. We are currently getting this issue about 90% of the time when trying to delete posts. Both soft delete and permanent deleting often fails and shows the error pasted below. We are using Xenforo 1.5.10...
  5. PrinceReborn

    XF 1.5 1.5.10 Upgrade Didn't Upgrade

    Resolved. Thank you for your help.
  6. PrinceReborn

    XF 1.5 1.5.10 Upgrade Didn't Upgrade

    Good call on the caching. It could very well be that as we do use Incapsula CDN. By upgrade files I meant the upgrade package from the customer area. I will disable caching and get back with further updates. Thanks a lot.
  7. PrinceReborn

    XF 1.5 1.5.10 Upgrade Didn't Upgrade

    I downloaded the 1.5.10 upgrade files to patch my 1.5.9 board, however after uploading and overwriting existing files I noticed that it did not take the forum offline for upgrades, and going to /forum/install still shows 1.5.9. I have tried rebuilding the master templates but there was no...
  8. PrinceReborn

    XF 1.5 SQL Queries 'Writing to Net'

    We are caching everything at the moment. However, just realised the issue, and it is network related. Asking my host to reconfigure the private network as ping times between the web server and sql server are fluctuating like crazy.
  9. PrinceReborn

    XF 1.5 SQL Queries 'Writing to Net'

    Here is a screenshot showing the query taking the longest, which is always 'writing to net' using xf_session_activity table query, followed by a waiting for table level lock INSERT INTO xf_session_activity table query, followed by multiple SELECT xf_session_activity table queries. I can now...
  10. PrinceReborn

    XF 1.5 SQL Queries 'Writing to Net'

    I cannot see any networking issues between the web server and MySQL server. However, these types of queries seem to have disappeared now, maybe I ran the processlist at a time when nothing much was showing. What is odd is that before we formatted the web server, we did not experience any...
  11. PrinceReborn

    XF 1.5 SQL Queries 'Writing to Net'

    We've recently just wiped our hard drive, reinstalled CentOS 7, Apache2, all the Xenforo requirements and restored our website/forum files. Only to discover that any pages using SQL are incredibly slow, sometimes taking over 10 seconds to load. Whereas pages that don't use SQL are loading...
  12. PrinceReborn

    I was looking to find some archived posts on GZN recently, and realised it was gone completely...

    I was looking to find some archived posts on GZN recently, and realised it was gone completely. Are the archives anywhere? or is there a new site?
  13. PrinceReborn

    TaigaChat Pro - Realtime chat/shoutbox [Deleted]

    Is is possible to disallow a user group from being able to use BBCode to change their text color? I'm aware that the 'Persistent Color' permission shows or hides the color picker button, but even with this disabled they can still use coloured text with a BBCode.
  14. PrinceReborn

    Search stops working after a while

    The issue was resolved by upgrading to the latest ElasticSearch. It seems that a shellshock vulnerability was causing this issue and was potentially using the server as a zombie to DDoS. Thanks for the reply though. I urge anyone using 1.4.2 or lower to upgrade to the latest 1.4.5+
  15. PrinceReborn

    Search stops working after a while

    Hi, Hopefully somebody can help me out, I use enhanced search and have elasticsearch installed. And searching has been working fine but after a while I start getting the message "The search could not be completed. Please try again later." when trying to do searches. These are the error messages...
Back
Top Bottom