vb.org Archive
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   help getting this error (just came on my site after someone did somin) (https://vborg.vbsupport.ru/showthread.php?t=196363)

Lynne 11-17-2008 08:34 PM
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 11-17-2008 08:47 PM
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 11-17-2008 09:49 PM
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 11-18-2008 07:53 AM
thanx will this also do the posts as well

Carnage 11-18-2008 09:22 AM
To recreate the userlist table:

Code:

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 11-18-2008 12:49 PM
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 11-18-2008 01:39 PM
Quote:
Originally Posted by honcho (Post 1668045)
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.



Quote:
Originally Posted by Carnage- (Post 1667989)
To recreate the userlist table:

Code:

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 11-18-2008 03:53 PM
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 11-18-2008 03:58 PM
Then do it through phpMyAdmin or whatever your host has set up for you.

honcho 11-18-2008 04:12 PM
and i do this after the reinstall lynne yes sorry to be a real doppy person here


All times are GMT. The time now is 12:38 PM.
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01124 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete