Using ImPex to Clean my Forum [Archive]

View Full Version : Using ImPex to Clean my Forum

Black Snow

10-22-2012, 01:52 PM

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.

Lynne

10-22-2012, 02:52 PM

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.

Black Snow

10-22-2012, 02:56 PM

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.

Lynne

10-22-2012, 03:01 PM

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...
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.

Black Snow

10-22-2012, 03:03 PM

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 1350923878 at 1350923878 ---------------

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

--------------- Added 1350923947 at 1350923947 ---------------

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.

Upgrading to 4.2.0

Press the button below to run the Blog Upgrade step

Lynne

10-22-2012, 04:21 PM

You cannot uninstall the blog either. If you run the upgrade script, it will install it again.

Black Snow

10-22-2012, 06:05 PM

Do I need to remove the same db entries as the CMS?

--------------- Added 1350934514 at 1350934514 ---------------

Getting this error now:
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 1350934958 at 1350934958 ---------------

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 1350935521 at 1350935521 ---------------

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

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&token=3d4099bdec217982 978913d90583e773&js_frame=right&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

Lynne

10-22-2012, 10:31 PM

Please reupload all the default vbulletin files making sure they all get uploaded completely.