mysql

I am trying to create a near duplicate custom field - that is, create a new custom user field but duplicate the all of the possible values/choices of an existing through a MySQL query, rather than manually recreating the questions (due to the number of choices this would take hours). I have a...

So I thought I was having a database crisis, long story short it doesn't appear I am. I compared table sizes for my current installation and a two week old backup. A few tables seemed to drop in size which caught my eye and I'm not sure if I should be concerned or not. Left columns contain...

For those of you who use replication with more than 1 MySQL active server or even the cluster version of MySQL with your XenForo database: How do you handle the tables in default XenForo database which use "Memory" as their table engine? We use a Galera powered replication cluster. As you know...

Hello. In my dedicated server, i notice that RAM usage builds up over time. For example 2 days ago after running for several months, RAM usage was constantly around 250 GB almost every time (i monitored using script every minute). But yesterday when i decided to upgrade my RAM (i added 128 GB...

I have added a 2nd web server to the config and need to create a database user for the 2nd web head. I do not remember the password I used for the database user. in other forums like phpbb it is stored in a config.php Where can I find that so I can create a new user with the same password?

Hi all, I am implementing a live feed on my xenforo homepage, meaning that it shows a list of recent posts, updated in real time, resulting in some heavy sql query(ies) every 1 second.. I am just testing it myself right now, so 1 user, and it's already putting the CPU under pressure, the way...

What I am basically aiming to do is to create a batch of threads from data stored in spreadsheet. I am looking for advice on whether SQL statements can be created that would create multiple threads on running them. I have the content for title and post content stored in cells of a spreadsheet. I...

I just finished a test import of ZooChat from vB3.8+PhotoPost to XenForo+XFMG, with 423K posts and 277K photos, including 2,219 galleries. My initial testing is quite positive - no major issues so far, even with large numbers of galleries. However, I've found that the Media home page is taking...

So, first off, hello! The site I am working right now has a few kinks that I need to work out. I have found some addons that help out with some of the problems, but here's a new one. I am going to start by going through the process that I want and what I currently have. Currently, when a new...

I am having trouble finding methods of connecting to a database outside of my web server box, and using data from that to display on a page. Not only do I have no clue how to do it (barely even know how with PHP) but I just need to know a method that is useable, since you cannot use PHP...

When I click a link on the forum (eg. thread, forum index page, member section, etc) it will usually load as expected but sometimes I''ll get a blank page or the page won't load at all and stay at the current page with nothing clickable. This started happening after I changed my.cnf, but I'm...

I have been using cpanel/whm on centos for years now and I would like to make a change. I'm a little tired of the apache /mysql combo as it seems to become sluggish as time goes on. Cpanel has always been nice and provides some decent tools here and there but I think it hogs too much of the...

Hello! I am able to pull IP's out of the Xenforo database using $iparray[] = long2ip(hexdec(bin2hex($row['ip']))); I want to be able to store IP addresses using my API, this uses PHP and MYSQL queries. How can I do the reverse of above to convert the IP to the correct format to store...

I finally managed to import users (testing) into the "xf_user" table via PHPMyAdmin import. I copied the entries from another user and adjusted them (new eMail, new user_id etc). It worked. So far, so good. But: When in the frontend, the user is only displayed as "guest" instead of having the...

I've finished installing Xenforo/Xenforo Gallery on a new host and everything is running fine. I have not touched anything since the install so no records exist. I have backed up my DB from my old host and it exists as a .gz file on my computer. I have the config.php file from the vB4.23/BB5.41...

I know it's possible to just update the username column in xf_user table, but doing it this way wont update any of the username references in the other tables, such as "last_post_username" in xf_thread. The only way to change the username properly in all database tables is to do it by editing...

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

I am running Xenforo on my PHP website which has its own database tables, and I'd like to be able to display information from these tables for each user when they post. Example of what I want to achieve: Please note that the info would need to come from database tables outside of Xenforo...

Hey Everyone, I'm new to Xenforo after moving away from phpBB and love it! However, I am just transferring over my customized pages across and struggling to find an answer to this question. I have searched everywhere high and low for an example but to no avail cant find a solution which I hope...

This error has been reported by other users and I have gone through the responses. Apparently this is a problem with the server hosting the forum and I agree with that. I have talked to Dreamhost and they blame plugins I must be running on my forum. They also point to most hit components on the...