Recent content by Ghan_04

  1. Ghan_04

    XenForo Redirects for vBulletin

    The manual says that if XenForo's URL path is the same as vB's, then there is nothing extra needed to make the addon work. If they are not the same path, then there is extra work required where you create the directory structure and copy some files there so XenForo can pick up the requested path...
  2. Ghan_04

    XenForo Redirects for vBulletin

    Our board URL and home page URL are both the root domain already.
  3. Ghan_04

    XenForo Redirects for vBulletin

    We have no route filters. I fear that if we disable friendly URLs, not only would things be less friendly, but current links might break.
  4. Ghan_04

    XenForo Redirects for vBulletin

    I've installed this addon and successfully pointed it to the import table we have from vBulletin (originally imported to XenForo 1 back in the day) but the redirects are not working and I'm not sure why. The only relevant log entry right now is from nginx showing a 404 from the request: "GET...
  5. Ghan_04

    An unexpected database error occurred. Please try again later.

    MySQL query error [1062]: Duplicate entry '1484' for key 'xf_ip.PRIMARY' This seems to indicate something is trying to insert a row into the xf_ip table that has the same primary key (in this case, it's the "ip_id" column) as an existing entry. That's very odd because the primary key is set to...
  6. Ghan_04

    SMTP Error From SwiftMailer

    We use Amazon SES for our mail sending service. Generally functions fine, but we get tons of errors every day in our error log of this form: Swift_TransportException: Email to <some email> from <some email> failed: Expected response code 250 but got code "451", with message "451 4.4.2 Timeout...
  7. Ghan_04

    XF 2.2 Scheduled Jobs Outstanding

    This alert frequently appears in the admin CP about jobs not being run correctly. "There are scheduled jobs outstanding which have not run. Jobs may not be getting triggered when expected." We're using server-based cron for running jobs. This is the command, running every minute: php...
  8. Ghan_04

    Query Performance Profiling

    I'm not sure that will help much as the list is rather long, but I've added it to the first post.
  9. Ghan_04

    Query Performance Profiling

    I've noticed lately that our board is pushing about 6,000 queries per second and the database is taking up around 50-60% of the CPU (there are 2 cores on this VM). We typically have somewhere between 500 and 1000 users online at a time so it's consistent traffic, but this seems high. I've looked...
  10. Ghan_04

    Opcache enabled on Wordpress, disabled on XenForo

    What .ini file is being loaded for each site? At the top of the PHP config page, there will be a line for "Loaded Configuration File" - is this different between the two sites?
  11. Ghan_04

    Opcache enabled on Wordpress, disabled on XenForo

    Check the PHP configuration for the source php.ini file that is loaded for each site. It sounds like they may be different. With Litespeed, you should be able to control this via the External App configuration for your vhosts if I recall correctly.
  12. Ghan_04

    help nginx: [emerg] "location" directive is not allowed here in /www/server/nginx/conf/nginx.conf:96

    Location directives need to be inside a server block. Your server block is closed at line 89, which is probably where your issue is.
  13. Ghan_04

    XF 2.1 Auditing Attachments

    Is there any good way to audit which attachments are still valid on the board compared with what is in the filesystem? When I query for the sum of attachments sizes of all entries in the database and compare that to what is in the attachments folder on the filesystem, I'm seeing about a 60 GB...
  14. Ghan_04

    Question about MySQL / MariaDB

    I ran MariaDB for quite a while and it was great. Not running it now only because I've upgraded to MariaDB 10.3. :)
  15. Ghan_04

    Fixed Infinite HTTP requests : running AJAX job.php

    We're also having this issue again. Other than once again purging the jobs table in the database, I don't know what to do about it. I know very little about the inner workings of xenForo, and there is no documentation on how the jobs manager works, so I would have an incredibly difficult time...