vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Database Editing? (https://vborg.vbsupport.ru/showthread.php?t=214984)

spillage 05-31-2009 12:20 PM

Database Editing?
 
Can site content (posts) be edited within the database directly?

What software do you recommend for database editing?
I've seen RazorSQL, Navicat, dbForge, iSQL-Viewer, to mention a few.

The reason I ask is, I have a small sub forum (less than 100 posts) on an old Drupal site that didn't import, and I want to recover the posts and merge them into the new vB forum.

No matter what I tried, IMPEX did not get the sub forum and it's content that is 3 deep (Category/Forum/Sub Forum).

Dismounted 06-01-2009 05:16 AM

You shouldn't directly edit tables, as there may be other things you need to do (i.e. add entry in thread table, refresh cache, etc.).

You can create a PHP script that inserts threads with build_new_post(), or the data manager.

spillage 08-22-2009 03:31 PM

This request is not really to insert the posts, as I can do that manually by making a new post and changing the user name.
What I want to do is recover the post text directly from the old database, as the Drupal forum has died and is not accessible, even as an Admin.


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

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.01046 seconds
  • Memory Usage 1,708KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete