• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

sql

  1. szymme

    [100$ for solution] SQL Query

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

    XF 1.5 Error During Install - Laragon Apache version

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

    XF 1.5 SQL: Copying field value with conditional

    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...
  4. Michael Murguia

    XF 1.5 SQL Help - Adding Secondary Groups, and Upgrades

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

    Unmaintained Slow query logger 1.2.1

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

    Identify people who have recently added tags using PHPMyAdmin

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

    Error checking after sql queries in installer/uninstaller?

    As there is no error checking after mysql queries in any code of a development tutorial here in XenForo I just want to ask: Is it not necessary to check sql errors by yourself (and throw an exception in case there is one) because XenForo already does this all? Or would it be not a bad idea to...
  8. Stuart Wright

    XF 1.4 I have 460,000 threads to move to a different forum. Can I do an SQL statement?

    Hi folks, we've got slow queries running because our classifieds archive forum has 540,000 threads. So I want to move the older ones out to a non-public forum. At the rate it's taking the system, it will take days. Can I just run a query to change the node id of the threads? Thanks