Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted October 24, 20159 yr 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} ------------------------------------------------------------------------
October 24, 20159 yr Author Have you tried to configure this block to fetch records from particular fatabase category(-ies) only? Does it save chosen cetageries selection?
October 24, 20159 yr 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
October 24, 20159 yr Author 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:
October 24, 20159 yr 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.
October 24, 20159 yr Author 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.
October 24, 20159 yr 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.
October 24, 20159 yr Author 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
October 24, 20159 yr 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.
October 24, 20159 yr Author 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.
Archived
This topic is now archived and is closed to further replies.