[php-src] Issue #9705: PHP Error In Drupal When MS App Name (Excel, Outlook, PowerPoint, etc.) In Article Title
| From: | sbrownvno | Date: | Mon, 10 Oct 2022 15:03:12 +0000 |
| Subject: | [php-src] Issue #9705: PHP Error In Drupal When MS App Name (Excel, Outlook, PowerPoint, etc.) In Article Title | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-242565@lists.php.net to get a copy of this message | ||
Issue: https://github.com/php/php-src/issues/9705
Author: sbrownvno
### Description
When i attempt to view an article that has the name of a Microsoft Office application such as
Outlook, Excel, Word or PowerPoint, the article does not appear. A pageful of HTML text appears. If
I replace the app name or enter a dash (-) anywhere within the name (E-xcel, for example), then the
article appears correctly. In Drupal's "Recent log messages" report, a "Type
PHP" error is recorded when the error occurs:
<html>
<body>
<!--StartFragment-->
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Advyzer List[advyzer_list]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.changed' in 'field
list': SELECT node_field_data.title AS node_field_data_title, node_field_data.nid AS nid,
GREATEST(node.changed, comment_entity_statistics.last_comment_timestamp) AS
comment_entity_statistics_last_updated FROM {node_field_data} node_field_data INNER JOIN
{taxonomy_index} taxonomy_index ON node_field_data.nid = taxonomy_index.nid INNER JOIN
{comment_entity_statistics} comment_entity_statistics ON node_field_data.nid =
comment_entity_statistics.entity_id AND comment_entity_statistics.entity_type =
:views_join_condition_0 INNER JOIN {node} node ON node_field_data.nid = node.nid WHERE
((taxonomy_index.tid = :taxonomy_index_tid)) AND ((node_field_data.status =
:db_condition_placeholder_1) AND (node_field_data.type IN (:db_condition_placeholder_2))) ORDER BY
comment_entity_statistics_last_updated DESC, node_field_data_title ASC LIMIT 25 OFFSET 0; Array (
[:taxonomy_index_tid] => 276 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2]
=> how_to_article [:views_join_condition_0] => node )
in Drupal\views\Plugin\views\query\Sql->execute() (line 1528 of /opt/rh/httpd24/root/var/www/html/vistaprd/core/modules/views/src/Plugin/views/query/Sql.php).
--
<br class="Apple-interchange-newline"><!--EndFragment-->
</body>
</html>
The article URL is:
http://c210edru01/vistaprd/how/how-to-restore-column-to-your-list-emails-**outlook**
This only seems to occur with articles that were created with one particular Drupal "Content
Type". I compared this content type to a very similar content type that did no have the issue
and tested with a few changes where settings were different, but the issue persisted.
Here is the HTML as it appears in the browser when I attempt to view the article:
The website encountered an unexpected error. Please try again later.</br></br><em
class="placeholder">Drupal\Core\Database\DatabaseExceptionWrapper</em>: Exception
in Advyzer List[advyzer_list]: SQLSTATE[42S22]: Column not found: 1054 Unknown column
'node.changed' in 'field list': SELECT node_field_data.title AS
node_field_data_title, node_field_data.nid AS nid, GREATEST(node.changed,
comment_entity_statistics.last_comment_timestamp) AS comment_entity_statistics_last_updated
FROM
{node_field_data} node_field_data
INNER JOIN {taxonomy_index} taxonomy_index ON node_field_data.nid = taxonomy_index.nid
INNER JOIN {comment_entity_statistics} comment_entity_statistics ON node_field_data.nid =
comment_entity_statistics.entity_id AND comment_entity_statistics.entity_type =
:views_join_condition_0
INNER JOIN {node} node ON node_field_data.nid = node.nid
WHERE ((taxonomy_index.tid = :taxonomy_index_tid)) AND ((node_field_data.status =
:db_condition_placeholder_1) AND (node_field_data.type IN (:db_condition_placeholder_2)))
ORDER BY comment_entity_statistics_last_updated DESC, node_field_data_title ASC
LIMIT 25 OFFSET 0; Array
(
[:taxonomy_index_tid] => 276
[:db_condition_placeholder_1] => 1
[:db_condition_placeholder_2] => how_to_article
[:views_join_condition_0] => node
)
in <em
class="placeholder">Drupal\views\Plugin\views\query\Sql->execute()</em>
(line <em class="placeholder">1528</em> of <em
class="placeholder">core/modules/views/src/Plugin/views/query/Sql.php</em>).
<pre class="backtrace">Drupal\views\ViewExecutable->execute(NULL) (Line:
1454)
Drupal\views\ViewExecutable->render() (Line: 117)
Drupal\views\Plugin\views\display\Block->execute() (Line: 1630)
Drupal\views\ViewExecutable->executeDisplay('block_1', Array) (Line: 77)
Drupal\views\Element\View::preRenderViewElement(Array) (Line: 59)
Drupal\views\Plugin\Block\ViewsBlock->build() (Line: 203)
Drupal\block\BlockViewBuilder::preRender(Array)
call_user_func('Drupal\block\BlockViewBuilder::preRender', Array) (Line: 378)
Drupal\Core\Render\Renderer->doRender(Array) (Line: 450)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 490)
Drupal\Core\Template\TwigExtension->escapeFilter(Object, Array, 'html',
NULL, 1) (Line: 339)
__TwigTemplate_b5dd121e73a72609264c58badeaf0e6cb146e7abb72c0811817a2b5fb616f41d->doDisplay(Array,
Array) (Line: 432)
Twig_Template->displayWithErrorHandling(Array, Array) (Line: 403)
Twig_Template->display(Array) (Line: 411)
Twig_Template->render(Array) (Line: 64)
twig_render_template('themes/mayo/templates/page.html.twig', Array) (Line: 384)
Drupal\Core\Theme\ThemeManager->render('page', Array) (Line: 437)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 490)
Drupal\Core\Template\TwigExtension->escapeFilter(Object, Array, 'html',
NULL, 1) (Line: 93)
__TwigTemplate_3a30473b5ae124b769364c472b3fed6dd5aed5ecc097ad6da2babacd53d26452->doDisplay(Array,
Array) (Line: 432)
Twig_Template->displayWithErrorHandling(Array, Array) (Line: 403)
Twig_Template->display(Array) (Line: 411)
Twig_Template->render(Array) (Line: 64)
twig_render_template('themes/mayo/templates/html.html.twig', Array) (Line: 384)
Drupal\Core\Theme\ThemeManager->render('html', Array) (Line: 437)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 147)
Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}()
(Line: 582)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 148)
Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object, Object) (Line: 90)
Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object,
'kernel.view', Object)
call_user_func(Array, Object, 'kernel.view', Object) (Line: 111)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.view',
Object) (Line: 156)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 57)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 99)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 78)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 666)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
</pre>
### PHP Version
PHP 7.1.30
### Operating System
Red Hat Enterprise Linux Server release 7.9 (Maipo)