Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
Reload this Page Using ImPex to Clean my Forum
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2012, 01:52 PM
Black Snow Black Snow is offline
 
Join Date: Jul 2012
Location: Scotland
Posts: 471
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Using ImPex to Clean my Forum
Hi,

I am wanting to use a fresh install of 4.2.0. I want to keep ALL my threads, posts, members etc. I am wondering if I use impex, will this be possible?

I want to remove all mods, styles etc I have installed and start fresh but keep all my data. Does anyone know if this is possible?

Or is there another way to do this? I was running a suite but now i'm running just the forum. I want all CMS & Blog tables to be deleted.
Reply With Quote
  #2  
Old 10-22-2012, 02:52 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I would NOT delete the CMS or Blogs. It WILL cause issues! And, every time you upgrade, it will get installed again (perhaps with problems since you tried to delete them).

If you use ImpEx, all your users will get renumbered, as will all your posts and threads. If anyone linked to a thread, that link will no longer work, or rather, it will no longer go to the correct thread.
Reply With Quote
  #3  
Old 10-22-2012, 02:56 PM
Black Snow Black Snow is offline
 
Join Date: Jul 2012
Location: Scotland
Posts: 471
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Is there any way to do what I want? I am having issues with removing mods as found here: https://vborg.vbsupport.ru/showthread.php?t=287449

I still have no idea what is wrong or how to solve it.

If I run the upgrade.php script again, will this cause me any errors if it doesn't install the table(s) that are missing.
Reply With Quote
  #4  
Old 10-22-2012, 03:01 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Your issue is because you tried to remove the CMS. As I specified already, you WILL have problems on your forum is you try to remove the CMS. The only way to fix the issue is through the database now.

These are my notes from having to fix this issue for other users so many times...
Code:
Make sure all cms tables are gone.
Check package table to make sure no vbcms.
Check product table to make sure no vbcms productid.
Check productcode table to make sure no vbcms productid.
Check productdependancy to make sure no vbcms productid.
Check upgradelog and remove all vbcms script rows.

Then run upgrade.php script again.
Do NOT do those steps on a live site first. You should ALWAYS do queries on a test database first to make sure you don't break something.
Reply With Quote
Благодарность от:
CAG CheechDogg
  #5  
Old 10-22-2012, 03:03 PM
Black Snow Black Snow is offline
 
Join Date: Jul 2012
Location: Scotland
Posts: 471
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks Lynne. I will abckup my database before I try this so I can restore it if things go wrong.

I will report back if this works.

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

I will I know what ones are vbcms script rows? They only show numbers and not names...

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

I also have the blog installed, do I follow the same procedure as for the CMS? I am trying but it's still asking me to upgrade the blog.

Quote:
Upgrading to 4.2.0

Press the button below to run the Blog Upgrade step
Reply With Quote
  #6  
Old 10-22-2012, 04:21 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You cannot uninstall the blog either. If you run the upgrade script, it will install it again.
Reply With Quote
  #7  
Old 10-22-2012, 06:05 PM
Black Snow Black Snow is offline
 
Join Date: Jul 2012
Location: Scotland
Posts: 471
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Do I need to remove the same db entries as the CMS?

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

Getting this error now:
Code:
An error has occurred. Please contact vBulletin Support for assistance.

Module: vbcms, Step 1 Error.

XML Error: no element found at Line 0
The Blog installed OK, but now I get this.

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

I deleted everything in the upgradelog and ran the upgrade.php script. This seems to have solved the issuewith uninstalling mods. But I now have another error.

MySQL Error : Table 'xxx_xxx.xxx_blog_user' doesn't exist

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

I deleted my database and I'm now trying to upload the backup I made but I'm getting this:

Code:
Error

SQL query:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=3d4099bdec217982978913d90583e773&amp;js_frame=right&amp;nocache=5347969715" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1329568005" type="text/javascript"></script> <script src="./js/jquery/jquery-1.4.4.js?ts=1329568[...]

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w' at line 1
Reply With Quote
  #8  
Old 10-22-2012, 10:31 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Please reupload all the default vbulletin files making sure they all get uploaded completely.
Reply With Quote
Благодарность от:
Black Snow
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:52 AM.

Contact Us - Archive - Top

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.06806 seconds
  • Memory Usage 2,241KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (2)post_thanks_box_bit
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete