Recent content by adamsmasher

  1. adamsmasher

    XF 2.2 Approval queue no longer shows moderation reason for spam phrases

    Update: we had another post show up and that one displays the spam phrase as expected. The one that does not was actually unapproved prior to the XF2.2 update.
  2. adamsmasher

    XF 2.2 Approval queue no longer shows moderation reason for spam phrases

    Prior to updating to 2.2, posts which were automatically unapproved for including a spam phrase would show this as the reason when viewing the content in the approval queue. After updating this no longer shows, so unless you happen to know what phrases are in the spam phrase list you won't...
  3. adamsmasher

    Change author [Paid]

    It seems like latest activity doesn't update to show the new author, even after a refresh.
  4. adamsmasher

    TPU: Detect and Block Spam Registrations

    We upgraded our forum to use @Xon 's addon - works great.
  5. adamsmasher

    Latest post live [Paid]

    I was wondering something similar - could it be used with the latest posts widget on /whats-new, for example.
  6. adamsmasher

    XF 2.1 Updating Phrase leads to error

    Try making a template change of some kind or backing up your database (but without dropping the table like my mysqldump command above did).
  7. adamsmasher

    XF 2.1 Updating Phrase leads to error

    If you do the steps I had above it should fix it for you, @tajhay. I would also recommend looking at your server config, since I think it's something with how MySQL, Apache, or PHP is configured that causes it to happen. We made a number of performance changes to all three so I don't know...
  8. adamsmasher

    XF 2.1 Updating Phrase leads to error

    I was able to fix it by doing the following: Close the forum Export the database sans the xf_template_phrase table with this: mysqldump -v --single-transaction --quick --default-character-set=utf8mb4 --ignore-table=database_name.xf_template_phrase database_name >...
  9. adamsmasher

    XF 2.1 Updating Phrase leads to error

    It seems like the TABLESPACE for the table still exists, so you can't create the table again. MariaDB doesn't support dropping a tablespace so you're stuck.
  10. adamsmasher

    XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

    In my case I made some MySQL/MariaDB config changes to /etc/my.cnf, nuked the db, imported our XF1.x import and upgraded again - no more error like before. This is just a guess, but I think our innodb_buffer_pool_size was too small for the size of the table. It's that or it was a timeout issue...
  11. adamsmasher

    XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

    MySQL version5.5.5 (10.2.20-MariaDB), which is interesting since I thought MariaDB was based on the newest version of MySQL. During my furious Google searching of the last day or so I read there was a bug in pre 5.6 versions of MySQL that could cause that issue with a table being stuck in use...
  12. adamsmasher

    XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

    Media Gallery, yes. I did a fresh install again using the same DB export and so far haven't got this to happen. The only add-on I didn't install this time around was "[Widget] Popular threads and posts 1.1.2". Steps from this most recent test: Create new db Import db export via shell Upgrade...
  13. adamsmasher

    XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

    This isn't our live install, fortunately. We purchased a new server so I'm doing test imports on the new server with the same .sql export I used on our current staging server and locally on my own machine. I figure something must be getting borked during the import or because of the new server...
  14. adamsmasher

    XF 2.0 XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatem

    Did you find out anything more about this, @DoogiePC ? I am seeing this happen on a new server when doing a test install and upgrade to XF 2.0. Interestingly, I did the except same upgrade on a test install on our old server and a local docker setup and this never happened with either of those...
  15. adamsmasher

    Live Content [Paid]

    Ah, ok. Feature request, then! :)
Top