sql

How should I use the XF finder with an sql query left joining 3 tables (I can join only 2 of them if it's simpler...)? I'm working on adding API endpoints to an existing add-on (I've already succeeded in doing it for another add-on) but have had a problem: I have 3 tables. One has events, the...

I set up a new Windows Server 2019 install on a home server. I have php 8.x.x (the latest available download) and MySQL server/databases. Everything is working as expected until I put my upload folder in my wwwroot directory. It will not let me access the files/pages for some reason. I get an...

I've been using this query for years to get the number of posts made by myself in the past 365 days. It works great: $res = $db->query(' SELECT COUNT(*) AS total FROM xf_post AS post WHERE user_id = 1 AND (post.post_date >= UNIX_TIMESTAMP(CURDATE() - INTERVAL 8760 HOUR))...

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196 XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77 XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79 XF\Db\AbstractAdapter->query() in...

Replacements it performs: % -> \% _ -> \_ However, it neglects to perform: \ -> \\ This means input such as this: \% Will become: \\% Which MySQL/MariaDB will interpret as a literal backslash followed by a LIKE wildcard. While this could theoretically result in security vulnerabilities in...

Hello. Is it possible to add extra select sql to xenforo Finder query? For example, I have XF finder query like this: $BuyerFinder = \XF::finder('MK\Store:Buyer') ->with('Thread', true) ->with('User', true) ->where('stage', 'active') ->fetch($limit, $offset); I need to improve...

Hello, I like to count the likes from each user in 2021. In recent years, I used the SQL string below, which works fine. But this year, I get an error message "#1146 - Table 'wa9301_db18.xf_liked_content' doesn't exist". Was there any change from XF 2.1 to XF 2.2? Any idea or tips? Thank you...

Hi Guys! I want to create a forum with two subgroups ( let's say group1 is "clients" and group2 is "partners"). I want them to have the same privivileges but group2 be able to access a different forum on different page. What's the best way to do it? I read about it so I have a lot of different...

Hi, I’m TheLifeGamingY, and I’ve been considering buying XenForo for my forum. I read that it supports two step verification, but I wanted just a clarification: with my previous free forum, I had two step verification issues, because I didn’t save the backup codes, so the only way to access the...

Hi ! I want to know if is possible to put a new installation of XenForo in SQL server ? I have a system, created in SQL server, so I want to put the existent users table in a new installation of XenForo. This is possible ?

Hi! AbstractAdapter class, line 560: public function limit($query, $amount, $offset = 0) { $offset = max(0, intval($offset)); if ($amount === null) { if (!$offset) { // no limit return $query; } // no amount limit, but...

I'm currently running Xenforo 1.5 with PHP 5.4 and SQL 5.6. I am testing an upgrade to 2.1 on the same server which recommends PHP 7.2. I'm happy to upgrade but don't want to break the production site if it is not compatible with the latest PHP version. What is the latest PHP version that is...

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...

Generates an error log entry when a slow query is detected. No configuration required. Once it has been running and reporting issues, I recommend disabling the add-on until you have pushed out fixes or understood why the previous logged queries are occurring. It is not recommended to leave...

Hello, I need help. I need a .php file which is asking for a costum user field and a user group. Like ........\check.php?Account=4711 4711 must be filled in the custom user field ID 123456 AND be part of user group X. The output is a echo with OK or WRONG. I would be so happy if anybody...

Using Laragon instead of XAMPP as it has built in support for composer etc and been working great for test installs for many different packages: flarum, wordpress, laverel But trying to install xenforo i'm getting the following error: for ref: php-7.1.1-Win32-VC14-x86

Hey guys, as most of us I´ve migrated from vBulletin to XenForo. In vBulletin we had a custom field in the db and I need those values now inserted into another field in the xf_user_profile (affected users: roundabout 40.000). I know that it´s totally out of the scope of a normal support...

Hi All! First, thank you in advance for your help! Below, the specific question is highlighted in blue! I think I am about half way through this project, and would love some help completing the task. Part 1 Adding a secondary group via SQL using an email list works fine like this: UPDATE...

Generates an error log entry when a slow query is detected. No configuration required. Once it has been running and reporting issues, I recommend disabling the add-on until you have pushed out fixes or understood why the previous logged queries are occurring. It is not recommended to leave...

ForestForTrees submitted a new resource: SQL to identify recent taggers - Use PHPMyAdmin to identify your most active recent taggers Read more about this resource...