Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vbb and several databases do not work? Details »»
vbb and several databases do not work?
Version: , by triden triden is offline
Developer Last Online: Mar 2007 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 12-18-2002 Last Update: Never Installs: 0
 
No support by the author.

Hi there,

i user 4 databases. in 1 database are all the data for vbulletin.
in the other 3 are relevant data for my project.

within my application i have to switch between the 4 databases, so i created a base db_mysql where i create db_sql_base1, db_sql_base2, db_sql_base3 and db_sql_base4.
within the application i have no problems at all.
unfortunally it seems that vbulletin is not able to "stay" at the database "base1" because it tries to use the database which is be used at the moment it want to write.
for example:

the lastactivity want to be written in base1. actually the source is working in base3. (vbulletin is still using the original db_mysql with the DB_sql_vb in the original directory).
in this case i get a email with the errormessage "table base3.user" doesnt exist. i can sove it by creating a table by the name user, but offcourse it is the wring solution.

my question, how can i tell vbulletin, or where is it written, that he allway should use the database from ./admin/db_mysql.php

all databases have their own strukture. alle have there own includes (not for the db_mysql) and their own config file where $DB_site-> will be declared.

i hope it was enough information. i am a little desperate, search for the problem over one week very intensiv...

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 12-19-2002, 04:14 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try in vBulletin the include_once() function, instead of require().
What database you have in config.php?
Reply With Quote
  #3  
Old 12-19-2002, 06:32 AM
triden triden is offline
 
Join Date: Dec 2002
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks for reply.

well the strukture is based on standalone modules.
that means that i want to be able to take out one module and make it a stand alone feature. ´vbb ist always using the SB_mysql_vb funktion but every module with his directory schedule has his own configuration. also the config.php
except of the db_mysql_alldb (with is lokated in the base modul, all modules use this db to open the 4 dbs) and the db_mysql of the forum strukture. this is used by the forum.

in the config (for example base 1) i open DB_site = new DB_sql_vb AND DB_base1 = new DB_sql_base1

in the config (for example base 2) i open DB_site = new DB_sql_vb AND DB_base2 = new DB_sql_base2

therefor it must be garanteed, that vbb use his own database and should make all chanches to DB_site-> in the correct db.
but it seems that DB_site-> is not using the db opend with DB_sql_vb. i checked toe complte vbb software. i can´t find the problem.

should it be better to use only one config.php? open all dbs in there? it meens i have to change complete strukture but if it works

ps. in the config located in ./admin/ the base1 (correct) db is opend.
Reply With Quote
Reply


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 10:21 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07700 seconds
  • Memory Usage 2,204KB
  • Queries Executed 16 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)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
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete