Jump to content

[4.0.13.1] Pages feed block categories selection error


Ibragim Pupkevich

Recommended Posts

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}
------------------------------------------------------------------------

 

Link to comment
Share on other sites

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 :D

562c1232a0c63_collections2.0.2categorype

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...