Recent content by multibam

  1. M

    SQL-processes running wild

    Thank you, but this is just making me even more confused :) | 302769 | forum_xen | localhost | forum_xen | Execute | 29278 | Sending data | SELECT xf_post., xf_thread_Thread_1., xf_forum_Forum_2., xf_node_Node_3., xf_user_User_4., xf_permission_combination_PermissionCombination_5...
  2. M

    SQL-processes running wild

    Ok, so the xenforo user is starting up a new process every 15 minutes without closing them, soon eating up all the server CPU. It looks like this: MariaDB [(none)]> show processlist...
  3. M

    Captcha for other usergroups

    Does anyone know how I can force captcha for other usergroups in xenforo 2.3?
  4. M

    Fixed xf-rebuild:search --truncate fails with out-of-memory error since XenForo 2.3.0 Final

    A quick fix would be to revert the file /cmd.php and the directory /src/XF/Job back to 2.2.X, from backup, and it will then work perfectly again. Please let me know if you need the files.
  5. M

    Duplicate 2.3 Rebuilding index requires too much memory

    CLI does not work for big boards, the script is still running out of memory.
  6. M

    Fixed xf-rebuild:search --truncate fails with out-of-memory error since XenForo 2.3.0 Final

    Unfortunately, the proposed fix did not work on our server. Our forum has more than 20 million posts, and it is kind of useless without the search engine. The PHP-script now just eats a lot of RAM before it times out. I guess more than one of the important files has been changed since 2.2.16...
  7. M

    XF 2.2 Upgrade error from CLI ( xf_post: MySQL query error [1878]: Temporary file write failure)

    I am somehow getting this error message when upgrading to 2.2.2 from CLI: Does anyone know how to fix it? All help is really appreciated :)
  8. M

    XF 1.2 Out of range value for column 'alerts_unread' at row 1

    Have anyone experience this error message when users try to post to certain forums? Mysqli statement execute error : Out of range value for column 'alerts_unread' at row 1 I'd love to access the db with a quick fix... :confused:
  9. M

    XF 1.2 Upgrade stuck at 1.2 alpha step 10

    Yes, command line upgrade is the way to go on big boards, otherwise php and/or your browser might time out...
  10. M

    Captcha for other usergroups

    Hello. Is it possible to add captcha-posting to other usergroup. I would like to add a few members to the usergroup "autoposters" to check if they pass the captcha... Thanks,
  11. M

    show ads for unregistered users

    Hello. Is there a simple way to add html/javascript advertisement to a template based on usergroup? Something like: if usergroup=2,3 in forum=8,9 show <google adsense code> end if Does anyone know if this is possible? Thanks.
Back
Top Bottom