Recent content by Nicky Vermeersch

  1. Nicky Vermeersch

    Fixed v2.3.5 Upgrade Error on Step 8 Data too long for column 'provider_metadata'

    Yeah I can setup an environment for debugging, there is a backup of the exact moment where the upgrade process got stuck. I'll set that up later this weekend and update the support ticket.
  2. Nicky Vermeersch

    Fixed v2.3.5 Upgrade Error on Step 8 Data too long for column 'provider_metadata'

    A very radical fix for me was: Drop xf_purchase_request table Run the cmd.php xf:repair-db command which recreate the table This will continue the install process, but all the data in that table is lost, what does this have as consequences?
  3. Nicky Vermeersch

    Duplicate Upgrade to 2.3.5

    Fix with this query does not work for me
  4. Nicky Vermeersch

    Fixed v2.3.5 Upgrade Error on Step 8 Data too long for column 'provider_metadata'

    Despite running the query and having the latest version manually uploaded and deployed, I still get the error? I already have data in the provider_metadata columns, not sure if that's an issue?
  5. Nicky Vermeersch

    XF 2.3 Two Cloudflare turnstyle verifications?

    Indeed, I thought this was a Xenforo feature, but it comes from an addon.
  6. Nicky Vermeersch

    XF 2.3 Two Cloudflare turnstyle verifications?

    Whenever I go to the Admin CP I get presented two turnstyle verifications, is this normal or a template issue?
  7. Nicky Vermeersch

    XF 2.2 anyone managed to add discord as a link + show username in profile?

    So you are trying to get the username instead of the user's numerical identifier to show up as text?
  8. Nicky Vermeersch

    XF 2.3 Image optimization, enhanced image resizing, and more!

    I think he is asking for the image to be adjusted to the post max-width, possibly scaling down the dimensions even further?
  9. Nicky Vermeersch

    XF 2.2 Full Unicode support has been enabled in config.php MariaDB 10.6.3

    I had this issue today as well when upgrading from Ubuntu 20 LTS to 22. PHP updated to 8.1 and Mariadb updated to 10.6.7. For some weird reason, the collation of all the tables went to utf8mb3 and running the cmd.php xf:convert-utf8mb4 had no effect and returned that no convertable tables were...
  10. Nicky Vermeersch

    XF 2.2 xf_mail_queue made system run out of disk space and crash

    It seems the issue is related to the automatic bounce handler. I was using an email address set as default for board notifications, and I set up an email address dedicated to just bounced mails (as indicated in the instructions). When I disabled the automatic bounce handler, the errors stopped...
  11. Nicky Vermeersch

    XF 2.2 Errors popping up loading site...

    Not sure how to do that on Safari, but in Firefox/Chrome you can enable a 'Developer Mode' to see the network requests or javascript errors when loading the page. This could help you get a better idea of what the problem is. 'Protocol error' is pretty vague. (http2? ssl? udp/tcp?)
  12. Nicky Vermeersch

    XF 2.2 xf_mail_queue made system run out of disk space and crash

    Interestingly enough, once the table was recreated and I checked a few hours later, the mail queue had already thousands of mails waiting in the queue. All the mails in the queue were destined to the same user (using a @gmail.com account). There seems to be a logic loop somewhere that keeps...
  13. Nicky Vermeersch

    XF 2.2 xf_mail_queue made system run out of disk space and crash

    For posterity, I was able to view and copy the blank table from a previous backup. In order to recreate the xf_mail_queue table, the following sql query has to be run: SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF...
  14. Nicky Vermeersch

    XF 2.2 xf_mail_queue made system run out of disk space and crash

    Hello, recently I noticed the VPS we use for our forums crashed and upon investigation the system had no disk space whatsoever. xf_mail_queue somehow used all the remaining disk space and caused mariadb to crash and the webserver. I couldn't truncate the xf_mail_queue table as that requires the...
  15. Nicky Vermeersch

    XF 2.1 Error on mailing

    It seems the issue returned, I assumed it worked since the errors were not appearing anymore. I tried reinstalling Sendmail but that didnt work, and I also tried Postfix, but I keep getting errors 'Unable to send mail'. edit: It also looks like there are only 2 users who are generating a...
Back
Top Bottom