vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   vBulletin Merge Tool for v2.2.x (https://vborg.vbsupport.ru/showthread.php?t=45844)

tucklis 03-12-2003 09:43 PM

Hi,

Thanks very much for developing this hack.

I have downloaded the beta but have had some problems. After I click "start merge", it says database initialised for import and then when I click associate users it gives me the following error:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT COUNT(*) AS count FROM soccerpages.user
mysql error: select command denied to user: 'tucklis6@server84l.xtreme-support.com' for table 'user'

mysql error number: 1142

Date: Wednesday 12th of March 2003 11:35:19 PM
Script: http://yupz.com/forum/forums/importers/bbimport_vb2.php
Referer: http://yupz.com/forums/importers/bbimport_vb2.php

Does this mean it hasn't worked? My forum now seems to read 0 posts and threads :( What am I doing wrong?

Thanks for your time,
Kerry

JulianD 03-13-2003 12:06 AM

Give me some time, it's a bug and I'll fix it probably today :)

tucklis 03-13-2003 09:09 AM

Hi,

I think I may have uploaded the old version - that's maybe why I got that error. I have now uploaded the latest beta and changed the global $vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbnam e; fields to match the database I'm importing from. But now I have a new one!

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/domains/yupz.com/user/htdocs/forums/admin/db_mysql.php on line 32

Database error in vBulletin Merge Tool 2.2.9:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Thursday 13th of March 2003 11:02:12 AM
Script: http://yupz.com/forums/forums/import...p?action=start
Referer: http://yupz.com/forums/admin/bbimport.php?action=

I think this maybe because the two databases that I want to merge are both on different ips to my webspace? Do I have to include the database ip / password for both databses? Where do I edit this?

One other thing (sorry for all these questions!!), should I make all the forums names match so they merge properly?

Thanks alot,
Kerry

JulianD 03-14-2003 02:21 AM

Quote:

Today at 06:09 AM tucklis said this in Post #93
One other thing (sorry for all these questions!!), should I make all the forums names match so they merge properly?

Thanks alot,
Kerry


Hi Kerry. Please give me some time and let me come out with a solution to this problem. :) I'm busy with some tests on school right now.

About the forums, no... The forums are not "merged" but it's easy to move all the post from one forum to another using the tools you found on the admin cp.

tucklis 03-14-2003 08:03 AM

OK, Thanks very much!

tucklis 03-15-2003 05:50 PM

Any more news? Sorry to be a pest but I really need this script to work!!! I think it mat just be a small alteration that is needed...

Colon33 03-15-2003 10:38 PM

Im running vb 2.2.9.. an i get this error... I uploaded the new BBIMPORT.php but as soon as i click associate users i get the DB error.

----
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT COUNT(*) AS count FROM ndream.user
mysql error: select command denied to user: 'moguslan_mogusad@localhost' for table 'user'

mysql error number: 1142

Date: Saturday 15th of March 2003 07:31:32 PM
Script: http://www.mogusland.com/forums/foru...import_vb2.php
Referer: http://www.mogusland.com/forums/impo...import_vb2.php
---

tucklis 03-18-2003 11:42 AM

I have edited the following fields in the import script:

<?php
// vBulletin Merge Tool for v2.2.x
error_reporting(7);
require ("./../admin/bbimport.php");

function makehiddenfields() {
global $vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbnam e;
makehiddencode("DBIPADDRESS",$vbdbhostname);
makehiddencode("DBUSERNAME",$vbdbusername);
makehiddencode("DBPASSWORD",$vbdbpassword);
makehiddencode("DBNAME", $vbdbname);

Are these variables supposed to be for the database I'm trying to import or the database I'm importing the records into?

Cheers,
Kerry

JulianD 03-18-2003 11:09 PM

Ok, download this file again:

https://vborg.vbsupport.ru/attachmen...&postid=359490

Make sure you get the NEW version. The new file (uncompressed) is about 41KB, so make sure you get the new version and not a version from your local cache. If the new file is not about 41KB, clear your browser cache.

tucklis 03-19-2003 09:24 AM

Thank you very much for updating the hack. But I still have problems. When I click "start merge" it says "Database initialised for import."

When I click on step 2 it says "Database not selected! Warning! Restart application! (I always wanted to say that!) :)".

I think it may be to do with settings I have changes - please take a look as I was unsure what I should change here:

PHP Code:

<?php
// vBulletin Merge Tool for v2.2.x
error_reporting(7);
require (
"./../admin/bbimport.php");

function 
makehiddenfields() {
    global 
$vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbname;
    
makehiddencode("IPOFDBTOBEIMPORTED",$vbdbhostname);
    
makehiddencode("DBUSERNAME",$vbdbusername);
    
makehiddencode("DBPASSWORD",$vbdbpassword);
    
makehiddencode("DBNAME"$vbdbname);
    
}



// ##############################################################################
// ok you wanted it quicly fixed, it didn't work with the same db class from vb,
// so i created another one.
class DB_Sql_merge {
  var 
$database "NAMEOFEXISTINGDB";

  var 
$link_id  1;
  var 
$query_id 0;
  var 
$record   = array();

  var 
$errdesc    "";
  var 
$errno   0;
  var 
$reporterror 1;

  var 
$server   "IPOFEXISTINGDB";
  var 
$user     "USERNAME";
  var 
$password "PASSWORD";

  var 
$appname  "vBulletin";
  var 
$appshortname "vBulletin (cp)";

  function 
connect() {
    global 
$usepconnect;
    
// connect to db server

I also changed the link_id to 1. Are these settings correct? Why am I getting this error :(

Thanks Julian,

I appreciate any help you can provide!

Regs,
Kerry


All times are GMT. The time now is 11:54 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.02510 seconds
  • Memory Usage 1,757KB
  • 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)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete