Posts by Hectorsky

    The simplest method without creating a plugin is a just copy registerButtonDashboardBox class and template and edit it.


    Then add in table wcf_dashboardboxes next entry binding to just wcf with new classname.

    Then check your MySQL Configuration.

    I've checked.


    Here is the config

    On the same database server, works also Jira and everything is fine, only WoltLab spits in.

    About the error, it appears just periodicaly. mostly at night

    Hello everyone,


    I found weird issue with what i need some advice.



    I often receive these codes on my WoltLab site, mostly it's triggered by bots, maybe someone had this type of issue?

    Requested URL
    /index.php?ajax-proxy/&t=067c6f7ad58cad7c350f639d3c4233613567ec00
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)


    Requested URL
    /index.php?ajax-proxy/&t=ac466612e02d14919ebc9548e60fe10af711ccb6
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)


    Requested URL
    /index.php?ajax-proxy/&t=d88b0ed8e63524f3fc55a9857ff9ca7f052297dd
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)

    Hectorsky one more thing, do i need a plugin so people can see the trophies in the sidebar?


    if not, how do i enable it?

    No, i'ts built in.

    Users can enable earned trophies in Own General, User Panel Settings.


    Also if your users don't see the trophies, check Users group permissions.

    There also you can specify how many special trophies user can have.

    [img]&amp;lt;a href="https://i.imgur.com/Sm4MzbZ.png"&amp;gt;&lt;a href="https://i.imgur.com/Sm4MzbZ.png"&gt;<a href="https://i.imgur.com/Sm4MzbZ.png">https://i.imgur.com/Sm4MzbZ.png</a>&lt;/a&gt;&amp;lt;/a&amp;gt;[/img]


    It already is

    Okey, then we back to basics.


    Please check your main group permissions, it allows to access trophies page?

    It's in Administrator Permissions.

    Yes i did, it tells me this:


    "Unfortunately, you are not allowed access to this site. You do not have the necessary access rights to access this page."

    Okey, check in your options.inc.php located in root installation, you should have

    Code
    if (!defined('MODULE_TROPHY')) define('MODULE_TROPHY', 1);
    if (!defined('MESSAGE_SIDEBAR_ENABLE_TROPHY_POINTS')) define('MESSAGE_SIDEBAR_ENABLE_TROPHY_POINTS', 1);

    If you have 0 then change to 1.