database

  1. CMTV

    XF 2.1 Finder limit min value is 1

    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...
  2. Diesan Romero

    XF 2.1 Database tables

    I want to know the tables for the: post that you remove from the public views private messages reports closed profile message any section in the documentation or something that I can use yo see all tables from the DB? I will appreciate your answer.
  3. Xiomera

    Changing custom thread fields values in mysql database for large number of threads (no batch option available)

    The light grey text is the background to my problem (not relevent for the MySQL question) Dear forum, 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...
  4. imno007

    Db Errors After Server Migration

    Okay, I recently moved to a new server (Litespeed/CyberPanel) and I'm seeing errors like those below a few times throughout the day. It seems to be completely random, happening when clicking whatever, even once during log-in to the site and once or twice when navigating the admin, and it's...
  5. MagicalMidge

    XF 1.5 xf_admin_permission missing entries

    I posted a while ago regarding admin permissions, when adding new admins I couldnt choose their permissions in the ACP. Long story short, I've been busy with other things and have recently revisited it. Inside the "Live" spoiler you can see what is shown on our live version, and similarly...
  6. Darmord

    Not a bug Database error

    Database error... I moved the site to another server, but something went wrong. He tried to solve it, but I could not fix it. It shows me a database error message. Incomplete tables. I do not know what to do now. My site now does not work and I do not know what else. You know someone to advise...
  7. CMTV

    XF 2.0 TO_MANY relation through many-to-many table

    Hi! The question is simple. I hope it is. I have three tables: criteria, params and criteria_params. The last one consists of two columns with criterion and param IDs. So it is a many-to-many relation between criteria and params. One criteria can have many params. One param can belong to any...
  8. tourmeister

    Questions about vB 3.8.1 database import into XF2

    Howdy, I am about to buy XF2. If I understand correctly, there is a built in database import/conversion feature that should be able to handle upgrading from vB 3.8.1. If that is the case, I am not sure about the steps involved. My plan is to do a clean install of XF2 on a Snappy 8000 VPS plan...
  9. T

    XF 2.0 Save the Input from a custom display Location

    Hello, that's a repost because @S Thomas said that my first post is simply to long to understand my problem. Since the last week I'm trying to add a new display location for some input fields in the account settings location. I want to add for example a new location for a first name. Everything...
  10. M

    XF 2.0 Issues changing database to utf8mb4

    I am trying to allow emojis on my forum. I have followed the instructions in the documentation for upgrading an existing installation (https://xenforo.com/xf2-docs/manual/unicode/). This is what gets output when I run the command using SSH: $ php cmd.php xf:convert-utf8mb4 Content-type...
  11. tmoflash

    XF 2.0 Lost permissions

    Hello, I just completed an upgrade to 2.1. However, when I go to do install it tells me I do not have admin permissions. I went into the database but I cannot find the specific user. I see xf_user, but how do I find my specific username and change to super-admin. I cannot access the admin panel.
  12. ghiboz

    db changes in v2

    hi all! i purchased time ago xenforo1 and I made some php pages to interact into xenforo db (most of them linked to the user fields).. in v2 the db is totally different or not? I also use https://github.com/VinceG/xenforo-sdk to get user info etc... is there something similar or I need to do all...
  13. Earth2Luke

    [Payment Profiles] and [User Upgrades] An unexpected database error occurred.

    I've been tinkering with the built-in Xenforo 2.0 "Payment Profiles" and "User Upgrades" however, I'm running into a small problem... At least when going through the process via PayPal. The goal: The goal is to have a $5.00 monthly subscription to allow the members to become a donor, which...
  14. Dave Stromberger

    XF 1.5 Can't Rebuild User Cache + User Edit Errors. MySQL Timeout

    Have had this issue for a while, and haven't been unable to figure it out. I first noticed it when I had users complain that they were unable to make changes to their profile... change avatar, password, etc. I tried via the Admin panel, but none of my changes would be saved on these users who...
  15. 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...
  16. S

    An unexpected database error occurred

    When I load the site I get this error. "An unexpected database error occurred. Please try again later." Could anyone help me with this. It was fine one day then the next just that. This is the site https://forums.webmastersmind.com/ Thank you
  17. TermitNeT

    Attack ( DDoS ) the database

    Is it possible to attack xenforo on a database? Heard that this is possible on pirated (not official) versions, and the license is protected from this?
  18. DarkKitarist

    XF 1.5 Installing on HostGator

    Hello, so I have a problem with installing Xenforo on HostGator. I've downloaded xenforo, uploaded it into a map, edited the permissions and started the install procedure, I created a database with a user and well... it won't allow me to continue after the "Configuration Builder" step. I get...
  19. AppleAndMango

    XF 1.5 Purge email address from bounce log

    Hello. I need to remove an email address from my bounce log, the only way I can see doing this is emptying the "bounce log" table in my forums database is there a way to remove a specific address rather than emptying the whole table? Thanks. Edit: Haha, figured it out. Mods delete/close?
  20. MagicalMidge

    XF 1.5 Users Database help Retaining ID's

    I am fully expecting you guys to advise I just do a new import, however if any of you have a deeper understanding of the database I would really appreciate some pointers... So when we finally migrate our forum, we want to keep the old forum live, and then just do a mini import of the (possibly...
Top