mysql

Source: https://stackoverflow.com/questions/659970/why-is-it-not-advisable-to-have-the-database-and-web-server-on-the-same-machine 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...

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

My forum's database has reached 2GB... but lately it is increasing at an alarming pace where as i have not noticed any significant jump in activity over a long period of time... Is there a way to see, what comprises of the database... like how much is the size of the images etc. Is there a...

Hello. I'm trying to connect my installation to an external MySQL database which is using SSL. Connecting to the database from my local machine or the VPS running Xenforo when the database server is setup to accept SSL connections only works, however when using the same credentials in the...