help getting this error (just came on my site after someone did somin)

[Lynne]

That is really the more difficult way to go about this. And, I really have no experience in what you want to do, so I'll have to let someone else help with that.

[honcho]

ok lynne many thanx for you help may host said i could do this easyer but just need to know what files to take of server or what to replace ect ect

to go bk to 3.7.3 and reinstall all hacks that all but save userlists and posts and passwords ect ect

--------------- Added [DATE]1226963319[/DATE] at [TIME]1226963319[/TIME] ---------------

i have all msql files bked up from host bk up of a cpl oh weeks ago

so should this not store all posts and users

[SEOvB]

Well if you can't recreate the userlist table for whatever reason.

1. Reinstall vBulletin.
2. Download the Impex system from vBulletin.com/members
3. Use impex to import all the readable data from your current database into the new one.

Instructions on how to install vBulletin and use Impex can be found at http://vbulletin.com/docs they've got it explained the easiest.

[honcho]

thanx will this also do the posts as well

[Carnage]

To recreate the userlist table:

CREATE TABLE IF NOT EXISTS `phpbb_userlist` (
  `userid` int(10) unsigned NOT NULL default '0',
  `relationid` int(10) unsigned NOT NULL default '0',
  `type` enum('buddy','ignore') NOT NULL default 'buddy',
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no',
  PRIMARY KEY  (`userid`,`relationid`,`type`),
  KEY `userid` (`relationid`),
  KEY `relationid` (`relationid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[honcho]

ok tnahx guys but i think i need someone to help me do this as im pretty lost on these last 2 posts

im ok @ installintg mods ec6te ct but tyhe whole other stuff im lost unfort

[Lynne]

Originally Posted by honcho

ok tnahx guys but i think i need someone to help me do this as im pretty lost on these last 2 posts

im ok @ installintg mods ec6te ct but tyhe whole other stuff im lost unfort

You want to go to your Admin CP > Maintenance > Execute SQL Query and input the query in the code box below into the Manual Query field on that page and hit Continue. If you get No Permission, then you will need to go into your config.php file and find the line about which users have permission to perform mysql queries and add your userid into that line. Save/upload, go back and try again.

Originally Posted by Carnage-

To recreate the userlist table:

CREATE TABLE IF NOT EXISTS `phpbb_userlist` (
  `userid` int(10) unsigned NOT NULL default '0',
  `relationid` int(10) unsigned NOT NULL default '0',
  `type` enum('buddy','ignore') NOT NULL default 'buddy',
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no',
  PRIMARY KEY  (`userid`,`relationid`,`type`),
  KEY `userid` (`relationid`),
  KEY `relationid` (`relationid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[honcho]

i cant access my admin cp panel lynne it wont let me in @ all i get errors when trying access in there as i wa saying my forum is totaly fecked

[Lynne]

Then do it through phpMyAdmin or whatever your host has set up for you.

[honcho]

and i do this after the reinstall lynne yes sorry to be a real doppy person here