Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Ibragim Pupkevich Posted October 24, 2015 Posted October 24, 2015 Hi guys, May you check on your board whether this bug appears in your Pages app as well? I'm trying to create simple feed block, which is about to show records from particular database and particular category, I choose database, I choose category, I press "Save", but after all it doesn't save categories selection I have made. And I get following error logs: Sat, 24 Oct 2015 20:15:32 +0000 (Severity: 0) 127.0.0.1 - http://localhost/index.php?app=cms&module=pages&controller=builder&do=getBlock&blockID=app_cms_Blocks_wozsdnlj6&pageID=4&orientation=horizontal&csrfKey=c390bfd301bd9c5e4736061089e7bd96 Unknown column 'Array' in 'where clause' SELECT cms_custom_database_1.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ibf_cms_custom_database_1` AS `cms_custom_database_1` LEFT JOIN `ibf_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT(?,cms_custom_database_1.primary_id_field)) LEFT JOIN `ibf_core_members` AS `author` ON author.member_id = cms_custom_database_1.member_id LEFT JOIN `ibf_core_members` AS `last_commenter` ON last_commenter.member_id = cms_custom_database_1.record_last_comment_by WHERE category_id IN (Array) AND record_locked=0 AND ( cms_custom_database_1.record_approved=1 OR ( cms_custom_database_1.record_approved=0 AND ( cms_custom_database_1.member_id=1 ) ) ) AND cms_custom_database_1.category_id IN(1,2,3,4,5,6) ORDER BY record_publish_date desc LIMIT 5 Array ( [0] => cms;records1; ) | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 386 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\_Db].preparedQuery | 334 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\Db\_Select].runQuery | 529 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Patterns/ActiveRecordIterator.php | [IPS\Db\_Select].count | 62 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\Patterns\_ActiveRecordIterator].count | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/cms/widgets/RecordFeed.php | [].count | 302 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/cms/sources/Blocks/Block.php | [IPS\cms\widgets\_RecordFeed].render | 220 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/cms/widgets/Blocks.php | [IPS\cms\Blocks\_Block].display | 127 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Widget/Widget.php | [IPS\cms\widgets\_Blocks].render | 739 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/cms/modules/front/pages/builder.php | [IPS\_Widget].__toString | 143 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\cms\modules\front\pages\_builder].getBlock | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Controller.php | [].call_user_func | 85 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/front/system/widgets.php | [IPS\Dispatcher\_Controller].execute | 39 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\core\modules\front\system\_widgets].execute | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ------------------------------------------------------------------------ ------------------------------------------------------------------------ Sat, 24 Oct 2015 20:15:32 +0000 (Severity: 2) 127.0.0.1 - http://localhost/index.php?app=cms&module=pages&controller=builder&do=getBlock&blockID=app_cms_Blocks_wozsdnlj6&pageID=4&orientation=horizontal&csrfKey=c390bfd301bd9c5e4736061089e7bd96 IPS\Db\Exception 1054: Unknown column 'Array' in 'where clause' #0 /var/www/localhost/system/Db/Select.php(334): IPS\_Db->preparedQuery('SELECT cms_cust...', Array) #1 /var/www/localhost/system/Db/Select.php(529): IPS\Db\_Select->runQuery() #2 /var/www/localhost/system/Patterns/ActiveRecordIterator.php(62): IPS\Db\_Select->count(false) #3 [internal function]: IPS\Patterns\_ActiveRecordIterator->count() #4 /var/www/localhost/applications/cms/widgets/RecordFeed.php(302): count(Object(IPS\Patterns\ActiveRecordIterator)) #5 /var/www/localhost/applications/cms/sources/Blocks/Block.php(220): IPS\cms\widgets\_RecordFeed->render() #6 /var/www/localhost/applications/cms/widgets/Blocks.php(127): IPS\cms\Blocks\_Block::display('newsblock-gener...', 'horizontal') #7 /var/www/localhost/system/Widget/Widget.php(739): IPS\cms\widgets\_Blocks->render() #8 /var/www/localhost/applications/cms/modules/front/pages/builder.php(143): IPS\_Widget->__toString() #9 [internal function]: IPS\cms\modules\front\pages\_builder->getBlock() #10 /var/www/localhost/system/Dispatcher/Controller.php(85): call_user_func(Array) #11 /var/www/localhost/applications/core/modules/front/system/widgets.php(39): IPS\Dispatcher\_Controller->execute() #12 /var/www/localhost/system/Dispatcher/Dispatcher.php(129): IPS\core\modules\front\system\_widgets->execute() #13 /var/www/localhost/index.php(13): IPS\_Dispatcher->run() #14 {main} ------------------------------------------------------------------------
Adlago Posted October 24, 2015 Posted October 24, 2015 I have not this bug. This feed block I just created.
Ibragim Pupkevich Posted October 24, 2015 Author Posted October 24, 2015 Have you tried to configure this block to fetch records from particular fatabase category(-ies) only? Does it save chosen cetageries selection?
Adlago Posted October 24, 2015 Posted October 24, 2015 Upper example - all categories - sorry. Actually has a bug when selecting a category. When selecting a category - have the same log entry Report you in bug tracker
Adlago Posted October 24, 2015 Posted October 24, 2015 PP. In version 4.1.0 Beta 10 everything is fine. No problem.
Ibragim Pupkevich Posted October 24, 2015 Author Posted October 24, 2015 Are you feeding entries from forums (i.e. topics from selected forums) or Pages database? Topics feed from selected forums works fine to me as well. But if I try to setup block, which is to fetch entries from Pages database - it doesn't save particular database categories selection I mean this one:
Adlago Posted October 24, 2015 Posted October 24, 2015 And to me is a bug in 4.0.13.1. I wrote above. In 4.1.0 it is fixed - there is only a bug in the name when the block is widget This report already in the bug tracker.
Ibragim Pupkevich Posted October 24, 2015 Author Posted October 24, 2015 Damn... I want IPS to fix it in 4.0, because 4.1 is too buggy still IMO Thanks for confirmation. Hope to see this fixed in 4.0 still.
Adriano Faria Posted October 24, 2015 Posted October 24, 2015 1 minute ago, Ibragim Pupkevich said: Damn... I want IPS to fix it in 4.0, because 4.1 is too buggy still IMO Thanks for confirmation. Hope to see this fixed in 4.0 still. All fixes are being applied on 4.1.0. There will not have 4.0.14.
Ibragim Pupkevich Posted October 24, 2015 Author Posted October 24, 2015 1 minute ago, Adriano Faria said: All fixes are being applied on 4.1.0. There will not have 4.0.14. Sad to hear. Because you may see my activity in the past few days - I tried to run 4.1 with 3rd party apps like your Tutorials and also Collections by Mike, but I faved too many weird falls. I do really think that it's too early for 4.1 to go live... maybe only for those, who is fine with basic set of apps only. By the way, @Adriano Faria, it seems Mike says you "hello" in his latest Collections 2.0.2
Adriano Faria Posted October 24, 2015 Posted October 24, 2015 Just now, Ibragim Pupkevich said: Sad to hear. Because you may see my activity in the past few days - I tried to run 4.1 with 3rd party apps like your Tutorials and also Collections by Mike, but I faved too many weird falls. I do really think that it's too early for 4.1 to go live... maybe only for those, who is fine with basic set of apps only. And I will say one more time since you don't seem to understand: those apps are developed and supported ONLY on IPS 4.0.X, as pretty clear stated on its descriptions. When 4.1 is released, I will review mine.
Ibragim Pupkevich Posted October 24, 2015 Author Posted October 24, 2015 7 minutes ago, Adriano Faria said: And I will say one more time since you don't seem to understand: those apps are developed and supported ONLY on IPS 4.0.X, as pretty clear stated on its descriptions. When 4.1 is released, I will review mine. This I understood, that's why I have already decided to stay with 4.0.13.1. But yesterday I have really played whole day with 4.1.0 b10 without any custom apps, just tried to setup required Pages & Databases configuration... and I faced tooo many weird stuff. Finally I've got whole front-end falling with "Error 500" without any clear error explanation in logs... finally I said "F***k you!!" in warm blood to it and just removed this great 4.1 from test server. Menu manager, which they have brought to 4.1... I suppose it will bring few more sleepless nights to many people.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.