Moving CMS only

[MatiasCandy]

I had a ton of CMS stuff in one database.

I want to pull it out of that Database of put into a new database.
Which DB tables hold the CMS information that I need to move to new database?

Thank you

[Lynne]

There are all the cms_* tables. If you have custom grids, then they would be in the templates table. And attachments in your articles are in the attachments/filedata tables. Comments are in the post/thread table.

I would not suggest doing what you are trying to do. It could end up a big mess.

[MatiasCandy]

Lynne,

I have a complete back up of the database and I do not mind restoring it. However my main page is completely white. I can get into everything else just not the main page.

Just playing with it to see when would be best way to get my website working again.

[Lynne]

Can you see the main site if you use a totally default style?

Create a new style with no parent:

• Styles & Templates > Style Manager > Add New Style
• Parent Style: No Parent Style
• Title: Default vBulletin
• Allow User Selection: Yes
• Save

Then browse the site using that totally default vbulletin style - do you still have the same problem?

[MatiasCandy]

No Sorry it does not.

[HMBeaty]

Please see this for all the known causes of blank or 'white' pages:

https://www.vbulletin.com/docs/html/blank_pages

[Lynne]

Originally Posted by MatiasCandy

No Sorry it does not.

It could be a grid issue, in which case you may need to make sure that the grid templates are exactly the same for your custom styles as for your default style.

[MatiasCandy]

Not sure what you mean.


I have played with it enough to know I can edit the content, I just cannot view the page published.

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

Originally Posted by HMBeaty

Please see this for all the known causes of blank or 'white' pages:

https://www.vbulletin.com/docs/html/blank_pages

tried all of this as you suggested.

This would have been done by someone during a theme design and they claim they do not know what they did to cause this.

This was first started in 4.1.5 I made a back up and put it on the shelf for a bit. Decided to dust if off and see if I could get it working. I uploaded 4.1.9 files and re-created the database from import.

Uninstalled all products / plugins that were not default
Deleted all templates but default
Ran update for 4.1.9.

imported Master Template again
created Default vBulletin as Lynne suggested
Cleared Cache

Deleted Default Style
Deleted Default vBulletin

Followed the link above and still only get white page on the content.php (CMS pages)
I can however edit the pages, just cannot view published.

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

Since I can get to editing the content I am just going to use sub directories and two installs to copy and paste from one install to the next. Wish there was an easier way.

Thanks for trying everyone.

[MatiasCandy]

Figured it out!

So I put this back on the shelf this last week and decided to take one last look at it.
Installed a fresh copy and compared everything, I took out the custom widgets from the layout and everything came back!

So nice to know it was simple, thanks to you Lynne for pointing me in the right direction!