I want to write a query on xenforo that will have both operator AND , OR .
If i use $item->where() then it will use only AND .. but if use $item->where()->whereOr(). Then it will wrap all OR condition in AND .
Is there anyway i can write something like that .
Select * from zyx where...
The following URL will result in a 404 with MariaDB but an exception with MySQL 8.0.x: https://xenforo.com/community/help/%c0a Furthermore, the exception may fail to log to the database and third-party monitoring services (in our case, Datadog).
This tends to be triggered often by...
Our forum got pretty large and with 160k+ posts it takes quite a long time to backup the database.
Is there any guide or tips for improving the database backup speed for XenForo?
We are using XF 2.2 with MariaDB 10.1.
We need to custom build a template to list all the forums a user has access to Post. Need help in the following areas,
1. What should be the query to get the details and which table will have the post permission and forums mapping
2. we are aware of building the template with static content or...
I've got an error in my admin CP that indicates the mysql user must have a DROP table command available. Before I activate that I want to make sure this requirement is a legit part of maintaining the forums and not some script kiddie trying to ruin my life.
Thanks for your help...
I am attempting to migrate to a new hosting provider, thus mysqldump on the source for DB backup and mysql import on the target.
On disk, my MySQL 5.7 source DB is 5.0GB and the mysqldump file is 3GB, thus importing the 3GB .sql into the target server with MariaDB 10.6
i am facing strange issue on pagination if am i getting record without limit with order then i am getting all record but if i am doing pagination 100 in one page
then there is 2 record missing that is really strange why record is missing please someone guide me
I have Xenforo running on a Centos Cpanel server with MySQL 5.6. I would like to update to MySQL 5.7 but I am wondering if I should consider anything or if there can be any problem updating MySQL for an existing Xenforo forum.
Here at XenForo, we like to keep our development environments up-to-date and as useful as possible, and from time to time we include some of our findings in our online documentation.
Recently, we've published an easy setup guide for a Windows-based development environment and now we've added...
Did a staff member accidentally send out a bulk private conversation to the forum membership? That happened with us. As a result, we had over 39,000 private conversations all originating from one user, not only clogging up his inbox, but getting into the inboxes of all the forum members who...
Lately I'm getting these max_user_connections exceeded messages from MySQL.
I asked my hosting provider if they could raise the limit.
However, they told me that only in very rare situations you would need 30+ connections.
Even for extremely busy sites, 30 should be more than enough.
This was found on a StackOverflow post.
Right now, I'm connecting with root to my MySQL server so it would only take 1 more step for someone to mess everything up...
After a few days I get an error xf_session_activity is full and then the forum isn't working.
Maybe because I set the parameter $config['pageCache']['recordSessionActivity'] = true; in config.php?
If I restart MySQL it solve the problem for few days.
The light grey text is the background to my problem (not relevent for the MySQL question)
my basic intention is to change the field type of an custom thread field from "check boxes" to "radio buttons" (only 1 option should be selectable). Since this change is not possible directly...
Not a huge deal because I already worked through it, but might save you guys a support issue down the road. While the SQL query build is fancy and big, not all storage engines support multiple commands in a single SQL statement.
From the Limitations of NDB online operations section here...
Sometimes I have a white screen with the following error :
Fatal error: Uncaught XF\Db\Exception: MySQL query error : Prepared statement needs to be re-prepared in /homepages/17/my_db/htdocs/XenForo/src/XF/Db/AbstractStatement.php:212 Stack trace:
This error appeared out of "thin air". I got to bed and woke up to this error. I have to say I'm on a fully managed server, so somebody most likely did something (they claim they didn't - until now).
It's somehow related to the image proxy setting. You only see broken images in the threads, but...