Thread: Import Database
View Single Post
  #1  
Old 12-22-2009, 10:45 AM
Fabilous Fabilous is offline
 
Join Date: Dec 2009
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Import Database

Hello Community,

Some one can tell me how to export / import user from phpMyAdmin?

My VBulletin Database have much bugs. uncountable.
for example -> Everytime if i want to edit a user the following code is coming
[spoiler]
Quote:
Originally Posted by cODE
Zitat von Fehler
Datenbankfehler Es trat ein Problem mit der Foren Datenbank auf. Versuchen Sie Folgendes:

* Laden Sie die Seite ?ber die Aktualisieren Schaltfl?che in Ihrem Browser neu.
* ?ffnen Sie die (Mein Forum) Homepage und versuchen Sie eine andere Seite zu ?ffnen.
* Klicken Sie auf Zur?ck, um einen anderen Link zu versuchen.

Der technische Administrator von (Mein Forum) wurde ?ber den Fehler informiert. Falls das Problem jedoch weiterhin auftritt, k?nnen Sie ihn auch kontaktieren.
Wir entschuldigen uns f?r die Unannehmlichkeiten.

Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
SELECT title, usergroupid FROM vb_usergroup WHERE usergroupid IN (2,n) ORDER BY title;

MySQL-Fehler : Unknown column 'n' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Wednesday, 03.12.2009 @ 19:29:48
Datum : Wednesday, 03.12.2009 @ 19:29:48
Skript : http://mein-forum.de/user.php?do=edit&u=552
Referrer : http://mein-forum.de/admincp/index.p...edit%26u%3D552
IP-Adresse : xx.xxx.xx.xxx
Benutzername : Chef
Klassenname : vB_Database
MySQL-Version : 5.1.37
[/spoiler]


now i wanted to ask, if it possible du import the threads, posts und users to a new installed database?
How? That i install vbulletin again. new. on a new database and after the installation i will import the old topics, posts and users. it it possible?

Thanks for your support.

I hope you can understand me. My English is Terrable
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01047 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete