Resource icon

vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

No permission to buy ($150.00)
Overview Updates (9) Reviews (3) History Discussion
I have a question before I do a test import of our db - when running this, is there an option to NOT import certain fields? I don't want to hit go and have it suddenly import everything and have hundreds of paid subscribers wonder why they are getting membership expiration notices from the testing board.
 
elsparkodiablo said:
I have a question before I do a test import of our db - when running this, is there an option to NOT import certain fields? I don't want to hit go and have it suddenly import everything and have hundreds of paid subscribers wonder why they are getting membership expiration notices from the testing board.
Click to expand...

Just dont import those tables in the import script.
 
Is there a way to make the attachments import run faster? I'm trying to import 50G worth of attachments but its taking days to complete, the server isn't that powerful but regardless, is there a setting, or method to make the attachments import run faster?

Thanks.
 
RBenard said:
Is there a way to make the attachments import run faster? I'm trying to import 50G worth of attachments but its taking days to complete, the server isn't that powerful but regardless, is there a setting, or method to make the attachments import run faster?

Thanks.
Click to expand...

Nope.
 
What's the cause of this? I saw this on the XF server error logs:
ErrorException: Use of undefined constant yes - assumed 'yes' - Export.php:1881
Generated By: Unknown Account, 11 minutes ago
Stack Trace
#0 /var/www/xenforo/Export.php(1881): XenForo_Application::handlePhpError(8, 'Use of undefine...', '/var/www/...', 1881, Array)
#1 {main}
Request State
array(3) {
["url"] => string(7) "http://"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Hey there,

I'm getting this error:

updating attachment view countAn unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: Unknown column 'attachment.attachmentid' in 'on clause'

What can I do?

Thanks
 
Btw, I got this on the server error log
Code: 
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'attachment.attachmentid' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 17 minutes ago
Stack Trace
#0 /var/www/xenforo2/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tUPDATE xf_...')
#1 /var/www/xenforo2/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tUPDATE xf_...')
#2 /var/www/xenforo2/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tUPDATE xf_...')
#3 /var/www/xenforo2/Export.php(1450): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tUPDATE xf_...')
#4 /var/www/xenforo2/Export.php(1900): DigitalPointExporter->attachments()
#5 {main}
Request State
array(3) {
  ["url"] => string(7) "http://"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
ANY kind of answer or help is welcome.

I know that support is provided on best effort, but if you could just point me in the right direction and I can take it from there or lookup for help if needed. Just look on the posibilities based on your best judgement and I can fix or investigate accordly.

Thanks.
 
RBenard said:
Btw, I got this on the server error log
Code: 
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'attachment.attachmentid' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 17 minutes ago
Stack Trace
#0 /var/www/xenforo2/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tUPDATE xf_...')
#1 /var/www/xenforo2/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tUPDATE xf_...')
#2 /var/www/xenforo2/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tUPDATE xf_...')
#3 /var/www/xenforo2/Export.php(1450): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tUPDATE xf_...')
#4 /var/www/xenforo2/Export.php(1900): DigitalPointExporter->attachments()
#5 {main}
Request State
array(3) {
  ["url"] => string(7) "http://"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...

Looks like a bug.

Find this code in Export.php and add the red code:

Rich (BB code): 
		$this->db->query('
			UPDATE xf_attachment
				LEFT JOIN ' . $this->sourceDb . '.' . self::$tablePrefix . 'attachment AS attachment ON (attachment.attachmentid = xf_attachment.attachment_id)
			SET xf_attachment.view_count = attachment.counter
		');
 
RBenard said:
What's the cause of this? I saw this on the XF server error logs:
ErrorException: Use of undefined constant yes - assumed 'yes' - Export.php:1881
Generated By: Unknown Account, 11 minutes ago
Stack Trace
#0 /var/www/xenforo/Export.php(1881): XenForo_Application::handlePhpError(8, 'Use of undefine...', '/var/www/...', 1881, Array)
#1 {main}
Request State
array(3) {
["url"] => string(7) "http://"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
Click to expand...

Hmm. I am not sure about this one.

Can you paste the code around line 1881 in Export.php? When I look at my copy I don't see anything relevant. Maybe your file is different.
 
Jake Bunce said:
Hmm. I am not sure about this one.

Can you paste the code around line 1881 in Export.php? When I look at my copy I don't see anything relevant. Maybe your file is different.
Click to expand...

I have this:

$exporter = new DigitalPointExporter();

I think it was an issue with the path at vB, but it's good now.

Jake Bunce said:
Looks like a bug.

Find this code in Export.php and add the red code:

Rich (BB code): 
        $this->db->query('
            UPDATE xf_attachment
                LEFT JOIN ' . $this->sourceDb . '.' . self::$tablePrefix . 'attachment AS attachment ON (attachment.attachmentid = xf_attachment.attachment_id)
            SET xf_attachment.view_count = attachment.counter
        ');
Click to expand...

That did it, thanks.

Looking good so far, we'll see on the import side. BTW, is the import faster than export?
 
@Jake B look at this while importing:

xf_post.ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

Is that an issue with my MySQL?

What should I do next? Should I reinstall XF and run the import there or is there a fix for it?
 
RBenard said:
Looking good so far, we'll see on the import side. BTW, is the import faster than export?
Click to expand...

Yes it should be faster since the data files are already prepared at that point. But the ending cache stuff can take a while, such as "updating post like cache".
 
RBenard said:
@Jake B look at this while importing:

xf_post.ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

Is that an issue with my MySQL?

What should I do next? Should I reinstall XF and run the import there or is there a fix for it?
Click to expand...

Does the error log give a more detailed error? What version of MySQL?

I am guessing it is complaining about the LOAD DATA INFILE stuff. This thread has some useful info:

http://stackoverflow.com/questions/10762239/mysql-enable-load-data-local-infile
 
You must log in or register to reply here.

Similar threads

M
  • Question Question
XF 2.2 XF2 CLI import vs vBulletin Big Board Importer
Replies
1
Views
527
Slavik
Slavik
Slavik
vBulletin Big Board Importer for XenForo 2 [vBulletin 3 & vBulletin 4] [Deleted]
Replies
1
Views
810
Slavik
Slavik
Steffen
vBulletin 3/4 Moderator Log Import Command
Replies
0
Views
964
Steffen
Steffen
Kier
  • Question Question
XF 2.0 vBulletin 4 with Blog importer - known issue
Replies
8
Views
17K
Universal4
U
Mr Lucky
  • Question Question
XF 1.5 Redirect from vBulletin 3 and vBulletin 4
Replies
1
Views
489
Mr Lucky
Mr Lucky
Back
Top Bottom