Database Error :(

[natsu287]

I was trying to create a test environment, but in the middle of it, I accidently deleted the database that my forum was using through Webmin

My control Panel is Virtualmin/Webmin on CentOS Server

So I followed the step's in creating the database for Webmin:
http://linuxconsultant.info/tutorials/webmin-tutorial/webmin.html#mysql

Then at the end, I Imported the .sql file of my forum into the new database I created with the new user/pass

But I still get

Database error

Also after the import, I can see the Databse and tables all through PHPMYADMIN, as well, I also did not forget to edit the config.php file

what am I doing wrong?

Here is what I did
-Created a new user called "newforums with a password (for example: dbtest101)
-Set the host to localhost
-Selected All permissions

Then I am going create the database
-Called it also "newforums" and left the default settings for the resst

Then I am going to create the permission
- Selected the "newforums" database, and chose "newforums" as the user
- Set the host to localhost
- Selected all permissions

Then I selected the database, did "excecute sql", then I browed for my vb database forums, and the I waited about 2-5min, no error's.

I can then see all 208 table's and also when I log into PHPMYADMIN, I can see it all there too!

So I go into the includes\config.php, I edit the dbname, username, and password, then I save it

Then I go to my link, still database error!

I Must be doing something wrong

[Dave]

And do you know what the database error is?

[natsu287]

And do you know what the database error is?


Database Error Database error
The XXXX Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the xxxxxxxxxxx.tv home page, then try to open another page.
Click the Back button to try another link.
The xxxxxxxxxxx.tv forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[ozzy47]

You need to get the actual error from your server error logs. Of you don't know where those are, you need to contact your host.

[natsu287]

Ok I will contact my host

[natsu287]

Ok my host told me this

<!--
Database error in vBulletin 5.1.1:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_activitystream AS phrasegroup_activitystream,
phrasegroup_holiday AS phrasegroup_holiday,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_activitystream' in 'field list'
Error Number : 1054
Request Date : Monday, June 23rd 2014 @ 11:18:27 AM
Error Date : Monday, June 23rd 2014 @ 11:18:27 AM
Script : http://yourwebsite.tv/forums/
Referrer : http://yourwebsite.tv/
IP Address : 80.82.71.7
Username :
Classname : vB_Database_MySQLi
MySQL Version :

Stack Trace:

#0 vB_Database-&gt;halt() called in [path]/includes/class_core.php on line 1402
#1 vB_Database_MySQLi-&gt;execute_query() called in [path]/includes/class_core.php on line 503
#2 vB_Database-&gt;query_first() called in [path]/includes/class_core.php on line 534
#3 vB_Database-&gt;query_first_slave() called in [path]/includes/class_core.php on line 4099
#4 vB_Session-&gt;fetch_userinfo() called in [path]/includes/init.php on line 651
#5 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
#6 vB_Bootstrap-&gt;init() called in [path]/includes/class_bootstrap.php on line 72
#7 vB_Bootstrap-&gt;bootstrap() called in [path]/global.php on line 26
#8 require_once([path]/global.php) called in [path]/forum.php on line 67
#9 require([path]/forum.php) called in [path]/index.php on line 43


-->

Basically, it's missing a column "phrasegroup_activitystream"


I did a complete backup of my VB4.2.2 before it crashed, first of all why is it saying 5.1.1? Also how do I fix this please! Anyone?

[kh99]

How did you set up your test environment? Is it possible that you somehow are using vb5 files?

[natsu287]

How did you set up your test environment? Is it possible that you somehow are using vb5 files?

no my vb5 was created on a sub-server called forums.yourwebsite.tv on a sub-server and called the database "forums".

I deleted the entire sub-server "forums" which also deleted the username and database which were entitled "forums"

I then followed the steps to create a new database and I put it on the main yourwebsite.tv server (not a sub-server), and I called it forums_vb4

so I exported the forums_vb4 into a sql file (got 206 table'\s)

then as I was messing around to make test.yourwebsite.tv I actually deleted the "forums_vb4" table by accident

--------------- Added 1403572486 at 1403572486 ---------------

anyone?

[natsu287]

Anyone know how to fix this? It's urgent my forums have been down for over a week!

[Lynne]

If you are using a 4.2.2 database, then you need to upload 4.2.2 files to your site. If you uploaded 5.x files to your site (and want to upgrade to 5.x which isn't suggested unless you have already tested this on a test site), then you need to run the upgrade script.

[natsu287]

If you are using a 4.2.2 database, then you need to upload 4.2.2 files to your site. If you uploaded 5.x files to your site (and want to upgrade to 5.x which isn't suggested unless you have already tested this on a test site), then you need to run the upgrade script.

Is it possible I backed up the wrong database? Im pretty sure I backed up the 4.2.2 database

the files I currently got is 4.2.2 also, what do I do now?

[Lynne]

If you are getting the database error above that starts with "Database error in vBulletin 5.1.1:", then the database you are using is a 5.1.1 database, not a 4.2.2 database.