MyBB Community Forums

It's kind of a long story, but my host updated the type of control panel that I have, which changed the names of my databases etc. They had done this once before and after a month they somehow fixed it. Then, about 5 weeks ago, they updated again, and nothing is loading again.

This time, it has not been fixed. So I am in the process of switching servers so I can avoid such downtime in the future.

So I assumed it was a DB connection issue, but modifying inc/config.php with the correct information doesn't seem to help. The big pain is the fact that I don't even get an error message, just a blank page:
http://www.chaos-dwarfs.com/forum/

Right now I have two servers running the site, the above link and the original, located here:
http://xandor.ca/chaos-dwarfs/forum/

I used to have the chaos-dwarfs.com using my xandor.ca webspace.

On a new server I have installed a brand new copy of myBB, then in the config.php file, I switched the database name to a copy of the database. Here is the result: http://www.chaos-dwarfs.com/forum-new/index.php

A partly working forum. I doubt the versions of the forum are compatible, because when I try to log in I get an SQL error. I can at least clear my cookies and still view the contents of the forum.

So despite my rambling, I would really like to have the forum working without using the install, that is, by using all the old files located here:
http://www.chaos-dwarfs.com/forum/

Sorry if I kind of sound like I am rambling, but I am a bit flustered. So if you could help me out that would be awesome, I can elaborate on the situation if what I said didn't make sense. I am willing to give out my FTP info and whatever else to get this working!

Help!

Have you tried making a fresh install with a fresh database then importing the backup to the new database?

What are the steps to import the database?

I can give that a try.

Inferno Wrote:Have you tried making a fresh install with a fresh database then importing the backup to the new database?

I think this would be the easiest way to get your forum work back but I'm not sure how to this.
you can search in the forum and in the wiki to learn how exactly you can do that.

Xander Wrote:What are the steps to import the database?

I can give that a try.

The easiest way would be using phpmyadmin, see if your host provides access to this.

I wouldn't say that is the easiest way. I have access to phpmyadmin and never have figured out how to import a database. Use big dump! It's very easy! http://www.ozerov.de/bigdump.php

It's quite simple, click on the database name on the left and then click import

Here's a tutorial I found.

http://www.dewahost.com/tutorials/cpanel...lfile.html

Ok, I have done this, I have imported the database:

"On a new server I have installed a brand new copy of myBB, then in the config.php file, I switched the database name to a copy of the database. Here is the result: http://www.chaos-dwarfs.com/forum-new/index.php"

That's what I meant by the above paragraph. But when I try to use this, it errors when you try to log in. It says,

Quote:MySQL error: 1054
Unknown column 'b.olddisplaygroup' in 'field list'
Query: SELECT u.*, f.*, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup, b.olddisplaygroup as banolddisplaygroup, b.oldadditionalgroups as banoldadditionalgroups FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1' LIMIT 1

:/

Is the MySQL database from an old version of MyBB?

Yes, it is. Though without being able to see the original forum, I can't recall which version it is. I installed it February of last year.

Is there anyway to update an old database?