[Forum] Importing content only...

[wmguk]

Hi Guys,

My forum has been running since 2003, has been upgraded, had addons added and removed and generally been beaten, used and abused...

I get lots of sql errors within the admin panel and silly things like the search function doesnt actually search...

My plan is to basically wipe the server and start fresh. I want a stripped clean vbulletin installation, then I want to add the forum content and users, then I'll prep the modules / addons etc so that I dont have a load of old rubbish hanging around - for example when I try to remove a plugin I get an sql error telling my the database doesnt exist. but if I just disable it then thats fine...

My question is, Can you export just the users, usergroups and forum content easily or would I be better paying a VBulletin expert to check, clean and repair my current install?

[BirdOPrey5]

There's no real SQL errors (aside from crashed/corrupt tables) that can't be fixed by disabling all modifications and uploading a fresh set of files. I don't see why you need to export/import anything.

1) Disable or uninstall all modifications from the Admin CP

2) Download a fresh set of files from the Member's Area

3) Move all your existing forum files on the server to a new directory (example: rename /forum/ to /forum_old/)

4) Upload the fresh files to the original location so there are only new files and no old files in this directory

5) copy back config.php from the old directory- also copy back avatars and/or attachments if stored in the file system in one of the affected directories

6) The forum should now be working fine- all fresh files and no modifications. Re-install any modifications you want to keep, be sure to grab the latest versions.

7) If any errors persist through the above try going back to the default style as well

[wmguk]

Hi,

When I try to uninstall ANY modifications I get this error:


Database error in vBulletin 4.2.0:





Invalid SQL:





DELETE cms_widgettype, cms_widget, cms_widgetconfig


FROM vbpackage AS package


LEFT JOIN vbcms_widgettype AS cms_widgettype


ON cms_widgettype.packageid = package.packageid


LEFT JOIN vbcms_widget AS cms_widget


ON cms_widget.widgettypeid = cms_widgettype.widgettypeid


LEFT JOIN vbcms_widgetconfig AS cms_widgetconfig


ON cms_widgetconfig.widgetid = cms_widget.widgetid


WHERE package.productid = 'glowhostspamomatic';





MySQL Error : Table 'wickedw6_forum.vbcms_widgettype' doesn't exist


Error Number : 1146


Request Date : Saturday, March 16th 2013 @ 04:08:38 PM


Error Date : Saturday, March 16th 2013 @ 04:08:38 PM


Script : http://www.digital-car.co.uk/forum/a...do=productkill


Referrer : http://www.digital-car.co.uk/forum/a...tspamomatic&s=


IP Address : 87.113.15.57


Username : Drew


Classname : vB_Database


MySQL Version : 5.0.96-community

I can disable them but not remove completely...

[wmguk]

I really need to just move users, usergroups and all posts / pms....

Any ideas how to?

======

As per above I tried:

1) Disable or uninstall all modifications from the Admin CP

COMPLETED


2) Download a fresh set of files from the Member's Area

COMPLETED


3) Move all your existing forum files on the server to a new directory (example: rename /forum/ to /forum_old/)

COMPLETED


4) Upload the fresh files to the original location so there are only new files and no old files in this directory

COMPLETED


5) copy back config.php from the old directory- also copy back avatars and/or attachments if stored in the file system in one of the affected directories

COMPLETED


6) The forum should now be working fine- all fresh files and no modifications. Re-install any modifications you want to keep, be sure to grab the latest versions.

NOPE - When accessing http://www.digital-car.co.uk/forum I see a page titled Activity Stream.... Its blank....

I click on forum and then I get:

"Could not get the request segment for the route class 'vBCms_Route_List' on line 238 in /home/wickedw6/public_html/forum/vb/route.php

#0 /home/wickedw6/public_html/forum/vb/route.php(260): vB_Route->__construct(false, false)

#1 /home/wickedw6/public_html/forum/packages/vbcms/route/list.php(92): vB_Route::create('vBCms_Route_Lis...')

#2 /home/wickedw6/public_html/forum/includes/functions.php(3810): vBCms_Route_List::getURL(Array)

#3 /home/wickedw6/public_html/forum/includes/functions_forumlist.php(314): construct_memberaction_dropdown(Array)

#4 /home/wickedw6/public_html/forum/includes/functions_forumlist.php(230): construct_forum_bit('42', 1, 0)

#5 /home/wickedw6/public_html/forum/forum.php(607): construct_forum_bit(-1)

#6 {main}





Fatal error: Could not get the request segment for the route class 'vBCms_Route_List' on line 238 in [path]/vb/route.php in [path]/vb/vb.php on line 286

#0 vb_error_handler(256, Could not get the request segment for the route class 'vBCms_Route_List' on line 238 in /home/wickedw6/public_html/forum/vb/route.php , /home/wickedw6/public_html/forum/vb/vb.php, 286, Array ([exception] => vB_Exception_Router Object ([] => ,[] => ,[] => ,[] => ,[] => ,[] => ,[] => Could not get the request segment for the route class 'vBCms_Route_List',[] => ,[] => 0,[] => /home/wickedw6/public_html/forum/vb/route.php,[] => 238,[] => Array ([0] => Array ([file] => /home/wickedw6/public_html/forum/vb/route.php,[line] => 260,[function] => __construct,[class] => vB_Route,[type] => ->,[args] => Array ([0] => ,[1] => )),[1] => Array ([file] => /home/wickedw6/public_html/forum/packages/vbcms/route/list.php,[line] => 92,[function] => create,[class] => vB_Route,[type] => ::,[args] => Array ([0] => vBCms_Route_List)),[2] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions.php,[line] => 3810,[function] => getURL,[class] => vBCms_Route_List,[type] => ::,[args] => Array ([0] => Array ([type] => author,[value] => 25294-sb123))),[3] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions_forumlist.php,[line] => 314,[function] => construct_memberaction_dropdown,[args] => Array ([0] => Array ([subscribeforumid] => ,[forumid] => 83,[lastpost] => 1333559635,[lastposter] => sb123,[lastposterid] => 25294,[lastthread] => New CarTFT FM (Automotive USB FM/RDS tuner),[lastthreadid] => 12194,[lasticonid] => 0,[threadcount] => 12,[replycount] => 105,[lastpostid] => 281925,[lastprefixid] => ,[usergroupid] => 2,[homepage] => ,[useroptions] => 45112534,[isfriend] => 0,[lastactivity] => 1351154466,[lastvisit] => 1351151867,[invisible] => 0,[styleid] => 0,[title] => Homepage Items,[title_clean] => Homepage Items,[description] => Homepage Content,[description_clean] => Homepage Content,[options] => 3506119,[displayorder] => 10,[daysprune] => -1,[newpostemail] => ,[newthreademail] => [email protected]co.uk,[parentid] => 42,[parentlist] => 83,42,-1,[password] => ,[link] => ,[childlist] => 83,-1,[importforumid] => 0,[importcategoryid] => 0,[showprivate] => 0,[defaultsortfield] => lastpost,[defaultsortorder] => desc,[imageprefix] => ,[forumiconimg] => 1home.jpg,[depth] => 1,[permissions] => Array ([4] => 655375,[6] => 134217727,[12] => 11252207,[8] => 0,[9] => 16515063,[13] => 11252207,[7] => 83623935,[17] => 733431,[2] => 11252207,[16] => 11252207,[5] => 100663295,[1] => 655375,[3] => 655375,[14] => 11252207),[lastpostdate] => 04-04-2012,[lastposttime] => 17:13,[trimthread] => New CarTFT FM (Automotive USB...,[prefix] => ,[showsignatures] => 0,[showavatars] => 1,[showimages] => 1,[coppauser] => 0,[adminemail] => 1,[showvcard] => 0,[dstauto] => 1,[dstonoff] => 1,[showemail] => 0,[showreputation] => 1,[receivepm] => 1,[emailonpm] => 1,[hasaccessmask] => 0,[vbasset_enable] => 1,[postorder] => 0,[receivepmbuddies] => 0,[noactivationmails] => 0,[pmboxwarning] => 0,[showusercss] => 1,[receivefriendemailrequest] => 1,[vm_enable] => 1,[vm_contactonly] => 0,[pmdefaultsavecopy] => 1,[userid] => 25294,[username] => sb123,[online] => offline))),[4] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions_forumlist.php,[line] => 230,[function] => construct_forum_bit,[args] => Array ([0] => 42,[1] => 1,[2] => 0)),[5] => Array ([file] => /home/wickedw6/public_html/forum/forum.php,[line] => 607,[function] => construct_forum_bit,[args] => Array ([0] => -1))),[] => ),[code] => 256)) #1 trigger_error(Could not get the request segment for the route class 'vBCms_Route_List' on line 238 in /home/wickedw6/public_html/forum/vb/route.php , 256) called at [/home/wickedw6/public_html/forum/vb/vb.php:286] #2 vB::handleException(vB_Exception_Router Object ([] => ,[] => ,[] => ,[] => ,[] => ,[] => ,[] => Could not get the request segment for the route class 'vBCms_Route_List',[] => ,[] => 0,[] => /home/wickedw6/public_html/forum/vb/route.php,[] => 238,[] => Array ([0] => Array ([file] => /home/wickedw6/public_html/forum/vb/route.php,[line] => 260,[function] => __construct,[class] => vB_Route,[type] => ->,[args] => Array ([0] => ,[1] => )),[1] => Array ([file] => /home/wickedw6/public_html/forum/packages/vbcms/route/list.php,[line] => 92,[function] => create,[class] => vB_Route,[type] => ::,[args] => Array ([0] => vBCms_Route_List)),[2] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions.php,[line] => 3810,[function] => getURL,[class] => vBCms_Route_List,[type] => ::,[args] => Array ([0] => Array ([type] => author,[value] => 25294-sb123))),[3] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions_forumlist.php,[line] => 314,[function] => construct_memberaction_dropdown,[args] => Array ([0] => Array ([subscribeforumid] => ,[forumid] => 83,[lastpost] => 1333559635,[lastposter] => sb123,[lastposterid] => 25294,[lastthread] => New CarTFT FM (Automotive USB FM/RDS tuner),[lastthreadid] => 12194,[lasticonid] => 0,[threadcount] => 12,[replycount] => 105,[lastpostid] => 281925,[lastprefixid] => ,[usergroupid] => 2,[homepage] => ,[useroptions] => 45112534,[isfriend] => 0,[lastactivity] => 1351154466,[lastvisit] => 1351151867,[invisible] => 0,[styleid] => 0,[title] => Homepage Items,[title_clean] => Homepage Items,[description] => Homepage Content,[description_clean] => Homepage Content,[options] => 3506119,[displayorder] => 10,[daysprune] => -1,[newpostemail] => ,[newthreademail] => [email protected],[parentid] => 42,[parentlist] => 83,42,-1,[password] => ,[link] => ,[childlist] => 83,-1,[importforumid] => 0,[importcategoryid] => 0,[showprivate] => 0,[defaultsortfield] => lastpost,[defaultsortorder] => desc,[imageprefix] => ,[forumiconimg] => 1home.jpg,[depth] => 1,[permissions] => Array ([4] => 655375,[6] => 134217727,[12] => 11252207,[8] => 0,[9] => 16515063,[13] => 11252207,[7] => 83623935,[17] => 733431,[2] => 11252207,[16] => 11252207,[5] => 100663295,[1] => 655375,[3] => 655375,[14] => 11252207),[lastpostdate] => 04-04-2012,[lastposttime] => 17:13,[trimthread] => New CarTFT FM (Automotive USB...,[prefix] => ,[showsignatures] => 0,[showavatars] => 1,[showimages] => 1,[coppauser] => 0,[adminemail] => 1,[showvcard] => 0,[dstauto] => 1,[dstonoff] => 1,[showemail] => 0,[showreputation] => 1,[receivepm] => 1,[emailonpm] => 1,[hasaccessmask] => 0,[vbasset_enable] => 1,[postorder] => 0,[receivepmbuddies] => 0,[noactivationmails] => 0,[pmboxwarning] => 0,[showusercss] => 1,[receivefriendemailrequest] => 1,[vm_enable] => 1,[vm_contactonly] => 0,[pmdefaultsavecopy] => 1,[userid] => 25294,[username] => sb123,[online] => offline))),[4] => Array ([file] => /home/wickedw6/public_html/forum/includes/functions_forumlist.php,[line] => 230,[function] => construct_forum_bit,[args] => Array ([0] => 42,[1] => 1,[2] => 0)),[5] => Array ([file] => /home/wickedw6/public_html/forum/forum.php,[line] => 607,[function] => construct_forum_bit,[args] => Array ([0] => -1))),[] => ))"


7) If any errors persist through the above try going back to the default style as well
Also tried that because I noticed my google adsense wasnt displaying... I have a totally standard install now but still no content viewable and no ads etc etc....

Ugh