1. Mr. Jinx

    max_user_connections (30) exceeded messages

    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. Most...
  2. J

    XF 2.0 MySQL high CPU usage since upgrade

    Since upgrading to the latest release, MySQL has been pegged at 100%. Anyone else?
  3. frm

    Forum on one server + MySQL on another

    Source: 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...
  4. developr

    XF 2.1 xf_session_activity is full

    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.
  5. 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...
  6. digitalpoint

    Won't fix 2.1.0 Alpha step 33 SQL error during upgrade

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

    XF 2.0 Fatal error: Uncaught XF\Db\Exception: MySQL query error [1615]

    Hello, Sometimes I have a white screen with the following error : Fatal error: Uncaught XF\Db\Exception: MySQL query error [1615]: Prepared statement needs to be re-prepared in /homepages/17/my_db/htdocs/XenForo/src/XF/Db/AbstractStatement.php:212 Stack trace: #0...
  8. C

    XF 1.5 Fatal error. Mysqli statement execute error : Out of range value for column 'referrer_id' at row 1

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

    XF 2.0 ->whereIds(...) Use IDs array order

    Hi! I have an ordered array of IDs gathered from complex SELECT query. Now I need to get entities with IDs from my array but in the order they are listed in IDs array! It can be done with this query: SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6); But the porblem...
  10. gforce

    XF 2.0 MSQL Error

    Team, I really tried to do as much research as I could (2 days of forums, googling and etc). I went into phpadmin and tried to hunt this down, but cannot find it. I'm use to VB so the learning curb has been quite difficult. Would you have any idea on where to start? XF\Db\Exception: MySQL...
  11. hutch2323

    XF 2.0 Passing values from a textbox to .php function

    Hello again! I'm attempting to build a custom query page whereby a user (for admin use only) can enter a username into a textbox, click a search button, and retrieve the stored information connected to the username. Currently, I have blocks of code, but I'm not entirely sure how to combine it...
  12. TML

    XF 1.5 Support for mysqlnd_ms within XenForo? (Master Slave Databases)

    Hello, I've recently deployed the mysqlnd_ms PHP module which provides replication and load balancing support to all PHP MySQL extensions that use mysqlnd. This means that we are able to load balance all database traffic according to a specified central configuration. The plugin itself routes...
  13. Anhava

    Addon that add's hundreds of new forums from JSON-file

    Hello! I'm using list of all (over 1900) cryptocurrencies in other script which is not any kind of XF made, it makes own pages for every crypto to my main website. Is it possible to import forums from JSON file or at maybe MySQL db? So I have JSON file which contains those informations...
  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. AppleAndMango

    MySQL vs MariaDB

    Hey. So I've been reading around and I've noticed that MariaDB is generally suggested more than MySQL as a database server, I've Googled and I can't seem to find a clear answer to my question of what's the difference and why do people prefer MariaDB over MySQL. Anyone feel like explaining...
  16. T

    xenforo expert needed for customisation and mods

    We are looking for xenForo Developer to add 5-6 new mods to our forums. Here is what I need to be done for reference: - Custom New Thread Options - Reputaion System - Points System - Vote up & Vote Down for particular thread - Member Ranking System Also I want front page for my...
  17. Earl

    XF 1.5 Attached files importing failed

    I've been performing an import from vB 3.8. Everything was going smoothly until I click the "Import Attachments" button, and I got this error: I skipped importing "content tags" step because I don't want tags from previous vBulletin site. Was that the problem? I don't think so. And got...
  18. Chernabog

    xenForo Resources - Purchased but do not know how to change pre-fix

    So I just purchased and installed xenForo resources. It looks nice, but I do not know how to edit the example category that displays. I do not seem to have the administrator ability to change that - so any help would be appreciated.
  19. kbarg

    Posting Forum news on PHP page

    Can anyone, anyone show me what I need to do to pull, "date, author, title, avatar, and message body" from my news forum posts and post them on my non-cms website. I do not use wordpress, and everything on my site is coded by hand. I would prefer to keep it that way. I know there will need to...
  20. Matt C.

    MySQL server has gone away

    Before I begin, I'm fully aware that this is a server issue and not a XenForo issue. However, I've tried everything by searching the Xenforo forums, google, etc and nothing seems to work. Hopefully someone can help me out. :) Whenever I try to install addons I always get this error part way...