Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
peter.schaefer Posted October 3, 2023 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
Marc Posted October 3, 2023 Posted October 3, 2023 I have created a ticket on this for you, so we can take a closer look
peter.schaefer Posted October 4, 2023 Author Posted October 4, 2023 Thanks for finding the broken mail which caused 1 & 2. 🙏 Any idea what´s causing the other entries?
Marc Posted October 4, 2023 Posted October 4, 2023 If you still have some issues, I would add this to your ticket
peter.schaefer Posted October 4, 2023 Author Posted October 4, 2023 I am curious what's causing the other log entries and if there is any chance to solve them. Thanks.
Recommended Posts