Better Blogs [Deleted]

Alpha1 · Oct 6, 2013

I do use litespeed cache on my server.

Rigel Kentaurus said:
If you want to merge three routes into one, that is not really possible

Are 3 routes needed?

Live Free · Oct 7, 2013

Run these set of queries

Code:

ALTER TABLE xfa_blog_css CHANGE className className varchar(200) NOT NULL;
ALTER TABLE xfa_blog_entry CHANGE allow_members allow_members_ids varchar(500) NULL;
ALTER TABLE xfa_blog_entry_scheduled CHANGE allow_members allow_members_ids varchar(500) NULL;
ALTER TABLE xfa_blog_entry ADD last_edit_date INT unsigned DEFAULT 0 NOT NULL;
ALTER TABLE xfa_blog_entry ADD last_edit_user_id INT unsigned DEFAULT 0 NOT NULL;
ALTER TABLE xfa_blog_entry ADD edit_count INT unsigned DEFAULT 0 NOT NULL;
ALTER TABLE xfa_blog_comment ADD last_edit_date INT unsigned DEFAULT 0 NOT NULL;
ALTER TABLE xfa_blog_comment ADD last_edit_user_id INT unsigned DEFAULT 0 NOT NULL;
ALTER TABLE xfa_blog_comment ADD edit_count INT unsigned DEFAULT 0 NOT NULL;

Don't worry if any of those fail

This could also happen if you upload the PHP files, but for any reason Install.php does not get uploaded

Getting an error when trying to run those queries:

Code:

Error
SQL query:

ALTER TABLE xfa_blog_entry CHANGE allow_members allow_members_ids VARCHAR( 500 ) NULL ;

MySQL said: [IMG]https://50.28.94.210:2087/cpsess2061533267/3rdparty/phpMyAdmin/themes/dot.gif[/IMG]

#1054 - Unknown column 'allow_members' in 'xfa_blog_entry'

No allow_members table (there is an allow_members_ids). Would I add this to the query list? -

Code:

ALTER TABLE xfa_blog_entry ADD allow_members INT unsigned DEFAULT 0 NOT NULL;

Rigel Kentaurus · Oct 7, 2013

Live Free said:
Getting an error when trying to run those queries:

Code:

Error SQL query: ALTER TABLE xfa_blog_entry CHANGE allow_members allow_members_ids VARCHAR( 500 ) NULL ; MySQL said: [IMG]https://50.28.94.210:2087/cpsess2061533267/3rdparty/phpMyAdmin/themes/dot.gif[/IMG] #1054 - Unknown column 'allow_members' in 'xfa_blog_entry'

No allow_members table (there is an allow_members_ids). Would I add this to the query list? -

Code:

ALTER TABLE xfa_blog_entry ADD allow_members INT unsigned DEFAULT 0 NOT NULL;

You can ignore any query that did not run, mostly means you already have that change

Live Free · Oct 7, 2013

Rigel Kentaurus said:
You can ignore any query that did not run, mostly means you already have that change

I removed the queries that were throwing errors. Tables were altered/updated successfully. Still getting an error when trying to post an entry though:

Code:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'allow_members' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Daniel, A moment ago
Stack Trace
#0 /home/admin/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/admin/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/admin/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xfa_blog_entry', Array)
#5 /home/admin/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/admin/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/admin/public_html/library/XfAddOns/Blogs/ControllerPublic/Blog.php(365): XenForo_DataWriter->save()
#8 /home/admin/public_html/library/XenForo/FrontController.php(337): XfAddOns_Blogs_ControllerPublic_Blog->actionSaveEntry()
#9 /home/admin/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/admin/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(53) "http://www.site.org/blog/daniel.1/save-entry"
["_GET"] => array(0) {
}
["_POST"] => array(17) {
["title"] => string(30) "Haven't blogged for a while..."
["message_html"] => string(1866) "<p>content-content.</p>
"
["_xfRelativeResolver"] => string(52) "http://www.site.org/blog/daniel.1/new-entry"
["attachment_hash"] => string(32) "cdd0d0a8847fd43be747a60ac633b18f"
["post_date"] => string(10) "2013-10-02"
["hour"] => string(1) "5"
["minute"] => string(1) "5"
["second"] => string(2) "15"
["category"] => array(1) {
[0] => string(4) "1488"
}
["allow_comments"] => string(1) "1"
["allow_view_entry_enable"] => string(1) "1"
["allow_view_entry"] => string(8) "everyone"
["allow_members"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(24) "/blog/daniel.1/new-entry"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Rigel Kentaurus · Oct 7, 2013

Live Free said:

I removed the queries that were throwing errors. Tables were altered/updated successfully. Still getting an error when trying to post an entry though:

Code:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'allow_members' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Daniel, A moment ago
Stack Trace
#0 /home/admin/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/admin/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/admin/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xfa_blog_entry', Array)
#5 /home/admin/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/admin/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/admin/public_html/library/XfAddOns/Blogs/ControllerPublic/Blog.php(365): XenForo_DataWriter->save()
#8 /home/admin/public_html/library/XenForo/FrontController.php(337): XfAddOns_Blogs_ControllerPublic_Blog->actionSaveEntry()
#9 /home/admin/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/admin/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(53) "http://www.site.org/blog/daniel.1/save-entry"
["_GET"] => array(0) {
}
["_POST"] => array(17) {
["title"] => string(30) "Haven't blogged for a while..."
["message_html"] => string(1866) "<p>content-content.</p>
"
["_xfRelativeResolver"] => string(52) "http://www.site.org/blog/daniel.1/new-entry"
["attachment_hash"] => string(32) "cdd0d0a8847fd43be747a60ac633b18f"
["post_date"] => string(10) "2013-10-02"
["hour"] => string(1) "5"
["minute"] => string(1) "5"
["second"] => string(2) "15"
["category"] => array(1) {
[0] => string(4) "1488"
}
["allow_comments"] => string(1) "1"
["allow_view_entry_enable"] => string(1) "1"
["allow_view_entry"] => string(8) "everyone"
["allow_members"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(24) "/blog/daniel.1/new-entry"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Version 33 will not give you that error. Make sure to upload all PHP files

Live Free · Oct 7, 2013

Rigel Kentaurus said:
Version 33 will not give you that error. Make sure to upload all PHP files

Ah, K. I haven't tried upgrading from 31 because I figured it could make the problem worse. I'll try updating and running those queries again if necessary.

Live Free · Oct 7, 2013

Rigel Kentaurus said:
Version 33 will not give you that error. Make sure to upload all PHP files

Worked, can post now. Thanks so much for the support.

TPerry · Oct 8, 2013

Anybody else getting this (well, not EXACTLY this - just the css.css part)

Code:

2013/10/06 14:22:41 [error] 3017#0: *36613 open() "/var/www/apple4me/xfa-blog-customize/css.css" failed (2: No such file or directory), client: 64.188.196.60, server: sayapple.com, request: "GET /xfa-blog-customize/css.css HTTP/1.1", host: "sayapple.com", referrer: "http://sayapple.com/xfa-blog-list/"

in their web server log file (my error log file) on the latest update?

RobParker · Oct 10, 2013

This seems to push the quick reply box over to the right and squashes it on mobiles.

I thought it just did it to the blog pages but it does it to every thread.

Any ideas?

Digital Doctor · Oct 10, 2013

Alfa1 said:
Any fix for this?

heh. same error type

Alpha1 · Oct 10, 2013

It seems to me that this error may be related to Better Blogs:

Server Error
Mysqli statement execute error : Duplicate entry '5' for key 'PRIMARY'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
XenForo_Model_Import->_importData() in Waindigo/ImportTools/Extend/XenForo/Model/Import.php at line 58
Waindigo_ImportTools_Extend_XenForo_Model_Import->_importData() in XfAddOns/Blogs/Override/Model/Import.php at line 26
XfAddOns_Blogs_Override_Model_Import->_importData() in XenForo/Model/Import.php at line 637
XenForo_Model_Import->importUserGroup() in XenForo/Importer/vBulletin.php at line 354
XenForo_Importer_vBulletin->stepUserGroups() in XenForo/Importer/Abstract.php at line 77
XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 195
XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 247
XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 190
XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /admin.php at line 13

Rigel Kentaurus · Oct 11, 2013

Alfa1 said:
It seems to me that this error may be related to Better Blogs:

Server Error
Mysqli statement execute error : Duplicate entry '5' for key 'PRIMARY'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297

Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479

Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574

Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612

XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601

XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393

XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599

XenForo_Model_Import->_importData() in Waindigo/ImportTools/Extend/XenForo/Model/Import.php at line 58

Waindigo_ImportTools_Extend_XenForo_Model_Import->_importData() in XfAddOns/Blogs/Override/Model/Import.php at line 26

XfAddOns_Blogs_Override_Model_Import->_importData() in XenForo/Model/Import.php at line 637

XenForo_Model_Import->importUserGroup() in XenForo/Importer/vBulletin.php at line 354

XenForo_Importer_vBulletin->stepUserGroups() in XenForo/Importer/Abstract.php at line 77

XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 195

XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 247

XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 190

XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337

XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134

XenForo_FrontController->run() in /admin.php at line 13

What were you trying to do ?

Alpha1 · Oct 11, 2013

I was trying to import a newer copy of my vb3 database. I'm not sure why better blogs is listed in there.

santamo · Oct 11, 2013

Search by category dont work else.

Adam Howard · Oct 12, 2013

The following error occurred:
You do not have permission to view this page or perform this action.

Got this when trying to upload something to someone else's blog. The idea is the photo is remote linked & I'd rather have it on my site so it doesn't get changed later.

Live Free · Oct 12, 2013

I'd like to report a possible bug/issue:

It's a problem within the comments section. Two issues: tagging and paragraphs.

Tagging seems to work sometimes in comments (haven't pinpointed exactly when it's not yet). Additionally, when I go to edit a comment, once I save it it removes the paragraph formatting leaving one giant paragraph.

Rigel Kentaurus · Oct 12, 2013

Live Free said:
I'd like to report a possible bug/issue:

It's a problem within the comments section. Two issues: tagging and paragraphs.

Tagging seems to work sometimes in comments (haven't pinpointed exactly when it's not yet). Additionally, when I go to edit a comment, once I save it it removes the paragraph formatting leaving one giant paragraph.

If you edit and tag someone, that would not work. It is the same with posts, only on first submit you can tag the person.

Live Free · Oct 12, 2013

Rigel Kentaurus said:
If you edit and tag someone, that would not work. It is the same with posts, only on first submit you can tag the person.

Even on the first submission a tagging didn't work. More importantly though is the paragraph formatting is lost.

Fleur · Oct 12, 2013

This download link (xxxxx) has expired. Please contact the merchant at xenforo@cemzoo.com.

Any update?

Fleur · Oct 13, 2013

Hi, I brought your Better Blogs some time ago. I'm not asking for much...

It states: Please open a conversation with Kentaurus, and make sure to include from which PayPal email you made the purchase.

On your forum you've probably seen my conversation. Can you kindly let me know on a response?

Better Blogs [Deleted]

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Active member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Active member

Well-known member

Active member

Well-known member

Active member

Member

Member

Similar threads

We value your privacy