Better Blogs [Deleted]

Im getting an internal server error on clean install:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table 'testforum_test4.xfa_blog' doesn't exist - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Alfa1, 36 minutes ago
Stack Trace

#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/XfAddOns/Blogs/Install/Install.php(338): Zend_Db_Adapter_Abstract->query('ALTER TABLE xfa...')
#3 /library/XfAddOns/Blogs/Install/Install.php(38): XfAddOns_Blogs_Install_Install->step6()
#4 [internal function]: XfAddOns_Blogs_Install_Install::install(false, Array, Object(SimpleXMLElement))
#5 /library/XenForo/Model/AddOn.php(215): call_user_func(Array, false, Array, Object(SimpleXMLElement))
#6 /library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#7 /library/XenForo/ControllerAdmin/AddOn.php(187): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phprMyNA9')
#8 /library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_AddOn->actionInstall()
#9 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(59) "http://mysite.com/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 
Im getting an internal server error on clean install:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table 'testforum_test4.xfa_blog' doesn't exist - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Alfa1, 36 minutes ago
Stack Trace

#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/XfAddOns/Blogs/Install/Install.php(338): Zend_Db_Adapter_Abstract->query('ALTER TABLE xfa...')
#3 /library/XfAddOns/Blogs/Install/Install.php(38): XfAddOns_Blogs_Install_Install->step6()
#4 [internal function]: XfAddOns_Blogs_Install_Install::install(false, Array, Object(SimpleXMLElement))
#5 /library/XenForo/Model/AddOn.php(215): call_user_func(Array, false, Array, Object(SimpleXMLElement))
#6 /library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#7 /library/XenForo/ControllerAdmin/AddOn.php(187): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phprMyNA9')
#8 /library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_AddOn->actionInstall()
#9 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
  ["url"] => string(59) "http://mysite.com/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
You might need to try to install again, was this being done in a single browser window?

That error is complaining on step 6, that the table xfa_blog does not exist. That table is created in step 1. There is no good way on an empty installation for that to happen.

I am going to test myself in an empty installation just in case
 
You might need to try to install again, was this being done in a single browser window?

That error is complaining on step 6, that the table xfa_blog does not exist. That table is created in step 1. There is no good way on an empty installation for that to happen.

I am going to test myself in an empty installation just in case
This was done in a single browser window.
I have removed all tables from the database as instructed, by running these queries: http://xfaddons.com/threads/manually-deleting-better-blogs.146/#post-737
After that I have uploaded the latest version of BB(1.0.25) and tried to install BB.

Just tried it again. This time I am getting:
Mysqli statement execute error : Duplicate entry 'xfa_option_use_style-xfa_blogs_option_group' for key 'PRIMARY'
 
Last edited:
Feature request
Is there away to have blog post count as post count?


I ask because I decided to delete all our zero posters using XenForo's new user batch update.

Sounds simple enough.... Guess what.... A few of our bloggers went "poof". Why you ask? Because technically they were zero posters (on the forum).

* face palms self * :X3:
 
That happened to me :LOL:
I'm so glad I'm not alone on that.

We do purge once a year. Basically wipe out anyone with zero post or who has not visited in X amount of time.

Even if the users were deleted, their blogs should have remained.
 
It might show up if you go in the database and change the user id/name out for an existing user.
Interesting idea...

Some how I worry it would not be as easy as that. Oh it may very well show up, but I'm worried about integration of database integrity
 
ErrorException: Undefined offset: 7 - library/XfAddOns/Blogs/Model/BlogKey.php:44
Сгенерирована пользователем: Неизвестная учётная запись, Сегодня, в 09:54
Трассировка стэка
#0 /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Model/BlogKey.php(44): XenForo_Application::handlePhpError(8, 'Undefined offse...', '/home/s/sm42/fo...', 44, Array)
#1 /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Cron/CreateBlogKeys.php(43): XfAddOns_Blogs_Model_BlogKey->getBlogKey(Array)
#2 /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Cron/CreateBlogKeys.php(17): XfAddOns_Blogs_Cron_CreateBlogKeys->processKeys()
#3 [internal function]: XfAddOns_Blogs_Cron_CreateBlogKeys::runBlogKeys(Array)
#4 /home/s/sm42/forum.***.su/public_html/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#5 /home/s/sm42/forum.***.su/public_html/library/XenForo/Deferred/Cron.php(22): XenForo_Model_Cron->runEntry(Array)
#6 /home/s/sm42/forum.***.su/public_html/library/XenForo/Model/Deferred.php(198): XenForo_Deferred_Cron->execute(Array, Array, 9.99999785423, '')
#7 /home/s/sm42/forum.***.su/public_html/library/XenForo/Model/Deferred.php(321): XenForo_Model_Deferred->runDeferred(Array, 9.99999785423, '', false)
#8 /home/s/sm42/forum.***.su/public_html/library/XenForo/Model/Deferred.php(274): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#9 /home/s/sm42/forum.***.su/public_html/deferred.php(18): XenForo_Model_Deferred->run(false)
#10 {main}
Содержимое запроса
array(3) {
["url"] => string(37) "http://forum.***.su/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(1) "/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

I do not know who is guilty of this error.
 
An exception occurred: Argument 1 passed to XfAddOns_Blogs_Model_Blog::prepareBlog() must be an array, null given, called in /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Panel/Entries.php on line 45 and defined in /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Model/Blog.php on line 49

  1. XenForo_Application::handlePhpError() in XfAddOns/Blogs/Model/Blog.php at line 49
  2. XfAddOns_Blogs_Model_Blog->prepareBlog() in XfAddOns/Blogs/Panel/Entries.php at line 45
  3. XfAddOns_Blogs_Panel_Entries->getEntriesFiltered() in XfAddOns/Blogs/Widget/Entries.php at line 37
  4. XfAddOns_Blogs_Widget_Entries->_render() in WidgetFramework/WidgetRenderer.php at line 637
  5. WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 338
  6. WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 250
  7. WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 51
  8. WidgetFramework_Listener::template_post_render()
  9. call_user_func_array() in XenForo/CodeEvent.php at line 58
  10. XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
  11. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
  12. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
  13. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 604
  14. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  15. XenForo_FrontController->run() in /home/s/sm42/forum.***.su/public_html/index.php at line 13
 
I can't install it either. Using AddOnInstaller 1.1.0 with Better Blogs 1.0.25, I don't get an error, it just returns me to the add-on list without having installed.
 
An exception occurred: Argument 1 passed to XfAddOns_Blogs_Model_Blog::prepareBlog() must be an array, null given, called in /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Panel/Entries.php on line 45 and defined in /home/s/sm42/forum.***.su/public_html/library/XfAddOns/Blogs/Model/Blog.php on line 49

  1. XenForo_Application::handlePhpError() in XfAddOns/Blogs/Model/Blog.php at line 49
  2. XfAddOns_Blogs_Model_Blog->prepareBlog() in XfAddOns/Blogs/Panel/Entries.php at line 45
  3. XfAddOns_Blogs_Panel_Entries->getEntriesFiltered() in XfAddOns/Blogs/Widget/Entries.php at line 37
  4. XfAddOns_Blogs_Widget_Entries->_render() in WidgetFramework/WidgetRenderer.php at line 637
  5. WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 338
  6. WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 250
  7. WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 51
  8. WidgetFramework_Listener::template_post_render()
  9. call_user_func_array() in XenForo/CodeEvent.php at line 58
  10. XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
  11. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
  12. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
  13. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 604
  14. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  15. XenForo_FrontController->run() in /home/s/sm42/forum.***.su/public_html/index.php at line 13

Are you using BD Widget to configure the sidebar? Could you share with me which panels you have added?
 
I don't support AddOnInstaller, but you can do a classic add-on installation :)

I've uploaded the zip file in my forum root in file manager, unzipped it, then added the xml file in the ACP. That led to "The files associated with this add-on could not be found. Please upload them and try again."

Does everything need to go somewhere else, or does it specifically need to be done by FTP etc? I'm confused.
 
As long as the files end up in the correct place, there should be no problem

For example, do you have a <FORUM_ROOT>/library/XfAddOns/Blogs directory?
 
Top Bottom