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

database

  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. 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
  3. 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?
  4. 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...
  5. 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?
  6. 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...
  7. Sim

    EXIF cache very large

    After migrating 280,000 photos into XFMG for our ZooChat migration last week, I rebuilt the EXIF data and was a bit alarmed to find that the xengallery_media table was now very large. Before I rebuilt the data, the table was around 60MB for 280,000 photos, but now it's 1.9GB according to...
  8. Mystinen Metsätyömies

    XF 1.5 One forum post changed to uneditable

    I wonder if there is a limit, how many times a forum post can be edited? After our forum migration I wrote a post describing what will still change in the near future. Almost every day I have updated that post, perhaps over 40 times or so. Now the post has suddendly changed to uneditable...
  9. ryladine

    XF 1.5 Remote User Modifications - API or Database?

    I was wondering where everyone else stood on the matter, I'm about to build a "panic" system for my community that will allow immediate removal of a user from all systems, and I'm planning how I want to integrate Xenforo. I could do it by directly modifying the database, but I've also seen a...
  10. G

    Using Xenforo member DB for another site/app

    I'm planning to make an phone app and want to have the same user database for my xneforo site and the app. I want users to be able to set up profiles on both places created in the same database and usable on both app and site. Is this viable?
  11. P

    Add-on Permissions and Database for Log-In System

    Dear Community, I'm looking forward to have the following Resource/Add-On: 1. I can write a software like a "Log-In Desktop System" with name and password. 1.1 This name and password checks if the user exist in my xenforo board (data base) and checks with which current permissions, like: "Vip...
  12. X

    Deadlock Avoidance by Xon 1.0.18

    XenForo's Datawriters have a _postSaveAfterTransaction() method. This method is intended to run after a database transaction is finished, but if a DataWriter is called from with-in another DataWriter, this does not happen. This incurs the risk that various notification actions will pull in...
  13. F

    wiki style forums. Can anyone provide examples?

    Hi, this is my first post over here. I have an idea for a wiki page and I'm thinking about hosting it on a forum basis. Does anyone know forums based on this kind of concept? Thanks.
  14. dotpro

    XF 1.5 Database size grows by x25 after import?

    Hi, I did a test run of small forum migration from vb 3.8 to xenforo and photopost 8.5 (107k pics, over 4500 categories) and database size went from 90MB (for vb) and 40MB (for photopost) to 2350MB. I read some threads about size increasing due to search index... but with just 18000 posts...
  15. M

    XF 1.5 An unexpected database error occurred. Please try again later.

    I'm having a problem with Xenoforo. When I go onto my website the only thing on my screen is this error message: "An unexpected database error occurred. Please try again later." I did some research on this and I found a couple problems that could of been why it wasn't working. I think the main...
  16. abdfahim

    XF 1.5 Renaming database

    Hi, I have to rename my database, no change in hosting/db etc. So is it enough to change library/config.php only as per below link? I just want to double check because i want minimal outage in between. Thanks. https://xenforo.com/community/threads/changing-mysql-db-name-user.29700/
  17. dougdirac

    XF 1.5 custom table prefixes?

    In vB and WordPress I have the option to set a custom table prefix in the database. For example I have a couple WordPress installations (that serve specific functions) on the same database. During installation I can select a custom table prefix for all the tables that installation creates in...
  18. electrogypsy

    XF 1.4 i have a user in moderation i can't remove?

    not sure how it happened, but one of the spam accounts that got created on my forum can't be deleted. it's in the moderated users list, but when i tick the reject radio button and click process users i get a 'The requested user could not be found.' error. it's just this one particular user, all...
  19. rbharathi

    XF 1.5 Unexpeted Database Error after migrating to New VPS

    Hi After migrating to New VPS , I am getting unexpected database error data base looks fine and correctly migrated. Any clue ?? An unexpected database error occurred. Please try again later.
  20. Y

    XF 1.3 How to clean my XF Database ?

    Hi, Before, excuse me for my bad English, I will try to speak to the best. I try to improve my english myself everyday. My actually problem with my forum, it is with database : Actually totally size (only xf) : With ranking from size (with big more databases) : My site is too long to...