Better Blogs [Deleted]

Thanks Rigel -

Permissions all seem to be OK? If it helps - these blogs were imported from vBulletin 3.8.

/xfa-blog-home "Recent Entries" remains blank for guests. I just created a new test blog post, and that post now shows up for regular users (but none of the recent imported posts), and does not show up for guests.

This is the paid version if that makes a difference?
 
robart said:
Thanks Rigel -

Permissions all seem to be OK? If it helps - these blogs were imported from vBulletin 3.8.

/xfa-blog-home "Recent Entries" remains blank for guests. I just created a new test blog post, and that post now shows up for regular users (but none of the recent imported posts), and does not show up for guests.

This is the paid version if that makes a difference?
Click to expand...
On the blog's account (whichever blog you want to be visible), what do you have the blog privacy options set to?
Screen Shot 2014-08-20 at 9.19.02 AM.webp Screen Shot 2014-08-20 at 9.19.18 AM.webp
 
Yup - same setting.

I'm testing using a blog I created:

My blog post can be viewed by a guest, and the post is listed under my /xfa-blogs/robart.1/

However, viewing as a guest: under both:
/xfa-blog-home/
and
/xfa-blog-list/

The list is empty.
 
XF 1.3.5 with BB 1.0.40 - Possible bug: viewing the profile comments on someone's profile page, the "B" icons next to the avatars of each profile comment don't link to the user who made the comment (you'd assume they would, as that's how it works in threads), but instead they link to the blog of the user whose profile page you're on.
 
Btw, I'm also currently getting these errors logged continually in the XF admin area:

Code: 
Mysqli prepare error: Table 'sffchrom_xf2.xf_import_log_blogs' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77

Could you please advise what I need to edit to stop these messages?
 
I'm importing blogs (using your import tool) from my vB 3.8+ installation. I think im running into a problem with the archive_log. I would like to redirect any old links to their new entries, but the blog's archive log has the wrong old_id and new_id. The id's are massively long, when they should be like old_id = 1 , 2, 3, 4...600.

Have I done something wrong?
 

Attachments

  • Screen Shot 2014-08-22 at 3.24.33 PM.webp
    Screen Shot 2014-08-22 at 3.24.33 PM.webp
    13.3 KB · Views: 4
Last edited:
robart said:
I'm importing blogs (using your import tool) from my vB 3.8+ installation. I think im running into a problem with the archive_log. I would like to redirect any old links to their new entries, but the blog's archive log has the wrong old_id and new_id. The id's are massively long, when they should be like old_id = 1 , 2, 3, 4...600.

Have I done something wrong?
Click to expand...
That doesn't look like the blog importer, content_type is for example 'blog_entry' for the entries
 
ibrian said:
Btw, I'm also currently getting these errors logged continually in the XF admin area:

Code: 
Mysqli prepare error: Table 'sffchrom_xf2.xf_import_log_blogs' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77

Could you please advise what I need to edit to stop these messages?
Click to expand...
Do you have the stack trace or complete error detail from the admin cp.

That kind of looks like the redirect script that I used to have for vBulletin -> Blogs, did you end up adding that?
 
Rigel Kentaurus said:
Do you have the stack trace or complete error detail from the admin cp.

That kind of looks like the redirect script that I used to have for vBulletin -> Blogs, did you end up adding that?
Click to expand...

No problem - when I imported the blogs, I selected a new table, as I was worried about writing over anything in archived_import_log so I created the table archived_imported_blog_log at the start of the import.

However, at the end of the import process it asked for a table again - not wanting to write over either of the former, I therefore created the table archived_imported_blog_log2.

I probably shouldn't have done that, but am not sure what to edit to correct any issue.

Here's the full error code:

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'sffchrom_xf2.xf_import_log_blogs' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 15 minutes ago
Stack Trace
#0 /home/sffchrom/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT new_id F...')
#1 /home/sffchrom/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT new_id F...')
#2 /home/sffchrom/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT new_id F...')
#3 /home/sffchrom/public_html/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('SELECT new_id F...', Array)
#4 /home/sffchron/public_html/forum/blog.php(58): Zend_Db_Adapter_Abstract->fetchOne('SELECT new_id F...', Array)
#5 /home/sffchron/public_html/forum/vbseo.php(1397): require('/home/sffchron/...')
#6 {main}
Request State
array(3) {
["url"] => string(52) "http://www.sffchronicles.co.uk/forum/blog.php?b=1642"
["_GET"] => array(2) {
["vbseourl"] => string(55) "blogs/stormfeather/1642-oh-how-time-changes-things.html"
["b"] => string(4) "1642"
}
["_POST"] => array(0) {
}
}
 
ibrian said:
No problem - when I imported the blogs, I selected a new table, as I was worried about writing over anything in archived_import_log so I created the table archived_imported_blog_log at the start of the import.

However, at the end of the import process it asked for a table again - not wanting to write over either of the former, I therefore created the table archived_imported_blog_log2.

I probably shouldn't have done that, but am not sure what to edit to correct any issue.

Here's the full error code:

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'sffchrom_xf2.xf_import_log_blogs' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 15 minutes ago
Stack Trace
#0 /home/sffchrom/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT new_id F...')
#1 /home/sffchrom/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT new_id F...')
#2 /home/sffchrom/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT new_id F...')
#3 /home/sffchrom/public_html/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('SELECT new_id F...', Array)
#4 /home/sffchron/public_html/forum/blog.php(58): Zend_Db_Adapter_Abstract->fetchOne('SELECT new_id F...', Array)
#5 /home/sffchron/public_html/forum/vbseo.php(1397): require('/home/sffchron/...')
#6 {main}
Request State
array(3) {
["url"] => string(52) "http://www.sffchronicles.co.uk/forum/blog.php?b=1642"
["_GET"] => array(2) {
["vbseourl"] => string(55) "blogs/stormfeather/1642-oh-how-time-changes-things.html"
["b"] => string(4) "1642"
}
["_POST"] => array(0) {
}
}
Click to expand...
It's ok, you can use any table that you like

But you need to reflect that in the "blog.php" script that you have (seems like you substituted the one on your vBulletin installation for redirects. Just change the name of the table in the queries there.
 
It looks like the Blog Description (stored in a MediumText column) is hardcoded to be a maximum of 800 characters. Can this be changed?
 
You must log in or register to reply here.

Similar threads

Recep Baltaş
Better Blogs Importer
2
Replies
37
Views
3K
matyprot
M
PrettyPixels
Other Import to threads from Better Blogs
Replies
7
Views
2K
ge66
ge66
upnet
  • Question Question
XF 1.3 Better Blogs
Replies
1
Views
847
Paul B
P
Recep Baltaş
  • Question Question
XF 1.3 Better Blogs 403 Error on Google
Replies
2
Views
809
Recep Baltaş
Recep Baltaş
DRE
Add-on Better Blogs to XI Blogs (and Vice Versa) PAID REQUEST
Replies
6
Views
3K
DRE
DRE
Back
Top Bottom