peter.schaefer Posted October 3, 2023 Share Posted October 3, 2023 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: TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0) -> 167 counted TypeError: mb_strtolower(): Argument 1 ($string) must be of type string, array given (0) -> 86 counted SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 85 counted SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 57 counted SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 39 counted SELECT main.*, cms_pages.page_, ((MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ... -> 16 counted 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 Link to comment Share on other sites More sharing options...
Marc Posted October 3, 2023 Share Posted October 3, 2023 I have created a ticket on this for you, so we can take a closer look Link to comment Share on other sites More sharing options...
peter.schaefer Posted October 4, 2023 Author Share Posted October 4, 2023 Thanks for finding the broken mail which caused 1 & 2. 🙏 Any idea what´s causing the other entries? Link to comment Share on other sites More sharing options...
Marc Posted October 4, 2023 Share Posted October 4, 2023 If you still have some issues, I would add this to your ticket Link to comment Share on other sites More sharing options...
peter.schaefer Posted October 4, 2023 Author Share Posted October 4, 2023 I am curious what's causing the other log entries and if there is any chance to solve them. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts