Trying to solve log file errors

[peter.schaefer]

My log file shows a bunch of errors and i don't know where to start solving them, so i appreciate any hint, answer and help.

I attached the log summary. The Errors are:

1. TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0) -> 167 counted
2. TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0) -> 86 counted
3. SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 85 counted
4. SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 57 counted
5. SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 39 counted
6. SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 16 counted
7. SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('+{query}' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 11 counted

 

TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0)
#0 .../ipb/system/Email/Incoming/Email.php(186): mb_strtolower(Array)
#1 .../ipb/system/Email/Incoming/Email.php(166): IPS\Email\Incoming\_Email->_decodePart('\r\nContent-Type:...')
#2 .../ipb/system/Email/Incoming/Email.php(86): IPS\Email\Incoming\_Email->_decodePart('Return-Path: <b...')
#3 .../ipb/applications/core/tasks/pop.php(59): IPS\Email\Incoming\_Email->__construct('Return-Path: <b...')
#4 .../ipb/system/Task/Task.php(274): IPS\core\tasks\_pop->execute()
#5 .../ipb/system/Task/Task.php(237): IPS\_Task->run()
#6 .../ipb/applications/core/interface/task/task.php(72): IPS\_Task->runAndLog()
#7 {main} -> counted 167

TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0)
#0 .../ipb/system/Email/Incoming/Email.php(186): mb_strtolower(Array)
#1 .../ipb/system/Email/Incoming/Email.php(166): IPS\Email\Incoming\_Email->_decodePart('\r\nContent-Type:...')
#2 .../ipb/system/Email/Incoming/Email.php(86): IPS\Email\Incoming\_Email->_decodePart('Return-Path: <b...')
#3 .../ipb/applications/core/tasks/pop.php(59): IPS\Email\Incoming\_Email->__construct('Return-Path: <b...')
#4 .../ipb/system/Task/Task.php(274): IPS\core\tasks\_pop->execute()
#5 .../ipb/system/Task/Task.php(237): IPS\_Task->run()
#6 .../ipb/applications/core/interface/task/task.php(58): IPS\_Task->runAndLog()
#7 {main}} -> counted 86

SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `core_search_index` AS `main` LEFT JOIN `cms_pages` ON cms_pages.page_id=main.index_item_id WHERE ( index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND ( ( index_class='IPS\cms\Pages\PageItem' AND cms_pages.page_>=0 ) ) AND ( ( MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE) ) OR ( index_item_index_id=index_id AND ( index_item_index_id IN(3127361) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'cms_pages.page_' in 'field list' (1054)
#0 .../ipb/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*ipb::ipbu::IP...', Array, true)
#1 .../ipb/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 .../ipb/system/Content/Search/Mysql/Query.php(1329): iterator_to_array(Object(IPS\Db\Select))
#4 .../ipb/applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('1', Array, 17, 'and')
#5 .../ipb/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#6 .../ipb/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#7 .../ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 .../ipb/index.php(13): IPS\_Dispatcher->run()
#9 {main}} -> counted 85

SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `core_search_index` AS `main` LEFT JOIN `cms_pages` ON cms_pages.page_id=main.index_item_id WHERE ( index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND ( ( index_class='IPS\cms\Pages\PageItem' AND cms_pages.page_>=1 ) ) AND ( ( MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE) ) OR ( index_item_index_id=index_id AND ( index_item_index_id IN(3127361) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'cms_pages.page_' in 'field list' (1054) #0 .../ipb/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*ipb::ipbu::IP...', Array, true)
#1 .../ipb/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 .../ipb/system/Content/Search/Mysql/Query.php(1329): iterator_to_array(Object(IPS\Db\Select))
#4 .../ipb/applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('1', Array, 17, 'and')
#5 .../ipb/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#6 .../ipb/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#7 .../ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 .../ipb/index.php(13): IPS\_Dispatcher->run()
#9 {main}} -> counted 57

SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `core_search_index` AS `main` LEFT JOIN `cms_pages` ON cms_pages.page_id=main.index_item_id WHERE ( index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND ( ( index_class='IPS\cms\Pages\PageItem' AND cms_pages.page_>=-1 ) ) AND ( ( MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE) ) OR ( index_item_index_id=index_id AND ( index_item_index_id IN(3127361) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'cms_pages.page_' in 'field list' (1054)
#0 .../ipb/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*ipb::ipbu::IP...', Array, true)
#1 .../ipb/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 .../ipb/system/Content/Search/Mysql/Query.php(1329): iterator_to_array(Object(IPS\Db\Select))
#4 .../ipb/applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('1', Array, 17, 'and')
#5 .../ipb/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#6 .../ipb/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#7 .../ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 .../ipb/index.php(13): IPS\_Dispatcher->run()
#9 {main}} -> counted 39

SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `core_search_index` AS `main` LEFT JOIN `cms_pages` ON cms_pages.page_id=main.index_item_id WHERE ( index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND ( ( index_class='IPS\cms\Pages\PageItem' AND cms_pages.page_>=-5 ) ) AND ( ( MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE) ) OR ( index_item_index_id=index_id AND ( index_item_index_id IN(3127361) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'cms_pages.page_' in 'field list' (1054)#0 .../ipb/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*ipb::ipbu::IP...', Array, true)
#1 .../ipb/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 .../ipb/system/Content/Search/Mysql/Query.php(1329): iterator_to_array(Object(IPS\Db\Select))
#4 .../ipb/applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('1', Array, 17, 'and')
#5 .../ipb/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#6 .../ipb/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#7 .../ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 .../ipb/index.php(13): IPS\_Dispatcher->run()
#9 {main}} -> counted 16

SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('+{query}' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('+{query}' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `core_search_index` AS `main` LEFT JOIN `cms_pages` ON cms_pages.page_id=main.index_item_id WHERE ( index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND ( ( index_class='IPS\cms\Pages\PageItem' AND cms_pages.page_>=0 ) ) AND ( ( MATCH(index_title) AGAINST ('+{query}' IN BOOLEAN MODE) ) OR ( index_item_index_id=index_id AND 1=0 ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'cms_pages.page_' in 'field list' (1054)
#0 .../ipb/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*ipb::ipbu::IP...', Array, true)
#1 .../ipb/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 .../ipb/system/Content/Search/Mysql/Query.php(1329): iterator_to_array(Object(IPS\Db\Select))
#4 .../ipb/applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('{query}', Array, 25, 'and')
#5 .../ipb/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#6 .../ipb/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#7 .../ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 .../ipb/index.php(13): IPS\_Dispatcher->run()
#9 {main}} -> counted 11

 

[Marc Stridgen]

I have created a ticket on this for you, so we can take a closer look 

[peter.schaefer]

Thanks for finding the broken mail which caused 1 & 2. 🙏

Any idea what´s causing the other entries?

[Marc Stridgen]

If you still have some issues, I would add this to your ticket

[peter.schaefer]

I am curious what's causing the other log entries and if there is any chance to solve them. Thanks.