[Forum] I broke my Board - Database error.

[Trendri]

I just uninstalled a mod Guest Warn
and am now receiving database error, my site is not working again.

I can't access my admincp and site, am getting database error.

Please how do i fix this ? ww.naijafinder.com

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Sunday, August 19th 2012 @ 02:18:00 PM

[Andy]

Did you make a backup before installing this add-on?

[Trendri]

yes i did, i have my Backup available. Please how do i make my forum to start working again?

[Andy]

yes i did, i have my Backup available. Please how do i make my forum to start working again?

You can restore from your backup.

https://www.vbulletin.com/docs/html/main/maintenance_ssh_restore

[Trendri]

Ok thanks, i will try and restore using auto restore wizard on my Hosting Cpanel , i guess they are same function.
Thanks for your quick feedback

- - - Updated - - -

I have restore the Database but am still geting this error below and my site is not working and i can't access my admin cp.

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_showthread AS phrasegroup_showthread,
phrasegroup_inlinemod AS phrasegroup_inlinemod,
phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
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_global' in 'field list'
Error Number : 1054
Request Date : Sunday, August 19th 2012 @ 04:47:59 PM
Error Date : Sunday, August 19th 2012 @ 04:47:59 PM

You can restore from your backup.

https://www.vbulletin.com/docs/html/...ce_ssh_restore

- - - Updated - - -

please i need assistance on my database error to be fix

[Trendri]

If it doesn't work maybe i will just install fresh Vbulletin and start from scratch.
Vbulletin staff are not helping to resolve the issue at all. They rather keep asking question and nothing has been done.


It's so painful.

[Andy]

If it doesn't work maybe i will just install fresh Vbulletin and start from scratch.

This might be the best idea. A few things to consider.

1) Learn how to properly backup and restore your database using SSH.
2) Avoid installing any add-ons
3) Create a test site where you can practice backing up and restoring the database

[Lynne]

I have tried to go to your board and I don't get a database error, I get:

503 Service Unavailable

No server is available to handle this request.

It looks like you have more problems than just a database problem. You will need to get that fixed before anybody can look into your database error.

[AliMadkour]

https://www.vbulletin.com/forum/showthread.php/405054-Database-error-on-Cpanel-and-home-page-%28Site-not-showing%29

[Trendri]

Thanks for the feedback, since the error could not be fix, i will install clean Vbulletin and do away with most of these plugins that might cause Database error.

[Lynne]

I did take a look at your table and I added the field but there is still a database error. That table is whacked though - it looks like someone tried to change field names or add non-existant field names or something because there are several fields missing and several field names that have been changed (and thus will give errors). You should at least do a new install somewhere and copy that table over to get all the correct fields.

And, as already brought up, get a test site so you can break it all you want without breaking the live site.

[Trendri]

Thanks, how do i copy the table to my current Tables on my site?

[Lynne]

You would need to drop the current one, then add in the new one. You should be able to do it via phpMyAdmin. Or, you can do a compare between a new database language table and yours and manually go through and fix it. And tell whoever was in there changing field names to stay out of your database for now on.

[Trendri]

Thanks Lynne..i will do just that now

Thnaks to you all.....am doing fresh installation because i want to do away with plugins..just want to use the default Vb files.

Thanks once more