Please help me ugrent

[funarule]

Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;
MySQL Error : Table 'talaltah_vb.settinggroup' doesn't exist
Error Number : 1146
Date : Sunday, December 24th 2006 @ 02:04:37 PM
Script : http://www.***********.com/forum/adm...ons.php?null=0
Referrer : http://www.***********com/forum/admincp/index.php?do=nav
IP Address : ************
Username : ME
Classname : vb_database

I was just droping raw from settinggroup, But by mistake I drop settinggroup table
Please give me the solution.

[Paul M]

Restore it from your last backup.

[funarule]

But I have no backup.

[Paul M]

Then you just learned why you should have. There is no excuse for not having backups.

You're slightly lucky in that you can probably recreate this table with a bit of work - install a fresh copy of vb into a test database and then copy the table from there to your live database - you will then need to reinstall any products that have settings.

If it were a more important table then you would have been screwed.

[funarule]

yeah, u r saying right. Today, I learned importance of backups.

Please guide me how to copy settinggroup table from another forum database and paste in mine ?

[feldon23]

Create a new database.

Install a fresh copy of vBulletin pointing to the new database. Complete the installation.

Using a tool like phpMyAdmin, pick your test forum's database and export the settinggroup table to an SQL file.

In phpMyAdmin, switch to your current running forum and import the SQL file you just exported.

[funarule]

When i click on export, This error is coming up
Internet Explorer cannot display the webpage

[funarule]

thnX guYs. I done it !!