Posts by Hectorsky

Hectorsky · Mar 6th 2020

Issue was gone after update to 5.2.3

Hectorsky · Feb 26th 2020

Quote from Woodmen

Then check your MySQL Configuration.

I've checked.

Here is the config

Code

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
character_set_server=utf8mb4
default-storage-engine=INNODB
innodb_large_prefix=ON
innodb_default_row_format=DYNAMIC
max_allowed_packet=256M
innodb_log_file_size=256M

Display More

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

Hectorsky · Feb 26th 2020

Quote from SoftCreatR

That's the important information. However, that's nothing you could fix by yourself. Your hoster has do look at it.

Hey, I'm the owner of the server.

i have full root access

Server is on CloudLinux 7.7

Hectorsky · Feb 26th 2020

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?

Code

Tue, 25 Feb 2020 17:00:47 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=067c6f7ad58cad7c350f639d3c4233613567ec00
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0
Peak Memory Usage: 11345056/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

Display More

Code

Thu, 20 Feb 2020 03:35:41 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=ac466612e02d14919ebc9548e60fe10af711ccb6
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0
Peak Memory Usage: 11345088/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
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.
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

Display More

Code

Sat, 15 Feb 2020 03:19:59 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=d88b0ed8e63524f3fc55a9857ff9ca7f052297dd
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 11345072/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/registry\/RegistryHandler.class.php","line":165,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":213,"function":"shutdown","class":"wcf\\system\\registry\\RegistryHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/registry\/RegistryHandler.class.php","line":165,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":213,"function":"shutdown","class":"wcf\\system\\registry\\RegistryHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

Display More

Hectorsky · Jan 15th 2020

Try cleaning Cache,

I know this maybe don't resolve issue but try, cause all of that references to compiled templates which should reside in cache.

Hectorsky · Jan 13th 2020

Quote from tunhj1

same bug here too

I found simple workaround.

Just create dummy file (empty) in the location.

Hectorsky · Jan 10th 2020

Hello,

Upgraded instance of 3.1.11 to 5.2 throws error on System Check in Admin CP.

This bug happend on 5.2.1 and PHP 7.3

Hectorsky · Jan 10th 2020

Hello,

When i tried update my 3.1.11 instance to 5.2.1.

I get this error.

I didn't have installed even Support Thread for files.

Hectorsky · Dec 30th 2019

Hello WoltLab,

LDAP addon have issue,

Is not find as update and it causes block to update to 5.2 when LDAP binding is installed.

EDIT: LDAP is not updated to work with 5.2

Hectorsky · Dec 27th 2019

Hello WoltLab'ers,

I got idea, it would be nice to have a Switch to artice list view between the old design(3.1) and the new one introduced in 5.2.

Thanks

Hectorsky · Jul 8th 2019

Quote from Alexander Ebert

This is the actual name of the page (Content > CMS > Pages) and not a dedicated phrase.

Thank you Alexander!

Hectorsky · Jul 8th 2019

Hello,

I've translating WoltLab to Polish Language.

And i'm searching for bit with the name.

Maybe someone know, it is translatable or no?

Hectorsky · Jul 8th 2019

Quote from TRNDSTTR

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.

Hectorsky · Jul 8th 2019

Quote from TRNDSTTR

This fixed my problem, thank you!

Great, i'm glad to help you.

Hectorsky · Jul 8th 2019

Quote from TRNDSTTR

[img]&lt;a href="https://i.imgur.com/Sm4MzbZ.png"&gt;<a href="https://i.imgur.com/Sm4MzbZ.png"><a href="https://i.imgur.com/Sm4MzbZ.png">https://i.imgur.com/Sm4MzbZ.png</a></a>&lt;/a&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.

Hectorsky · Jul 8th 2019

Quote from TRNDSTTR

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.

Hectorsky · Jul 8th 2019

Quote from TRNDSTTR

I already enabled it but i still don't have this function.

Have you tried access it directly?

Code

by /acp/index.php?trophy-list/

Hectorsky · Jul 8th 2019

First, you should enabile it,

on Modules -> Users -> Enable Trophies.

Hectorsky · Jul 5th 2019

Quote from Ramiru
You can use:
CSS
.articleImage {
    justify-content: center;
}

Haha, you are god!

Thank you, thats it!

Hectorsky · Jul 5th 2019

Quote from MysteryCode
CSS
.filebaseFileList > li {
    maxWidth: 100%,
    flex: 0 0 100%
}
taken from https://support.softcreatr.com…cer/?postID=3371#post3371

Thanks, but nice have to see that built-in to Filebase

Posts by Hectorsky

Could not begin transaction triggered by bots

Could not begin transaction triggered by bots

Could not begin transaction triggered by bots

Could not begin transaction triggered by bots

Filebase 5.2 Undefined template variable

Filebase Upgrade Bug (5.2.1)

System Check throws Error (5.2.1)

Filebase Upgrade Bug (5.2.1)

LDAP Addon prevents update to 5.2

Article List view Switcher (between 3.1.x and 5.2.x view)

What is translation bit name for this?

What is translation bit name for this?

Trophies

Trophies

Trophies

Trophies

Trophies

Trophies

How to align article image to center?

One line sorting view