[v9.0.1] Column name error when querying the database

axEllkr · November 15, 2021, 2:19pm

In the new version, such errors began to appear in the event log:

Messenger Worker Message Failed: /new_site/public_html/concrete/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:80 Handling “Concrete\Core\Page\Command\ReindexPageCommand” failed: An exception occurred while executing ‘SELECT * FROM btAccordionEntries WHERE bID = ? order by sortOrde’ with params [419]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘sortOrde’ in ‘order clause’

In the database table, this column is called ‘sortOrder’.

This error is related to the filling of the inserted Accordion block.

In version 9.0.1, which was installed on an external server, the database is constantly broken. For example, if the text contains the symbol “И” (Russian capital letter I).
here I wrote about errors during installation

JohntheFish · November 15, 2021, 3:05pm

At a guess, there is a typo in that SQL and sortOrde should be sortOrder

mesuva · November 15, 2021, 3:49pm

Yep, that’s it:

github.com

concrete5/concrete5/blob/develop/concrete/blocks/accordion/controller.php#L138

    
      
              return [
                  Features::ACCORDIONS,
              ];
          }
          
          
public function getSearchableContent()
          {
              $content = '';
              $db = $this->app->make('database')->connection();
              $v = [$this->bID];
              $q = 'SELECT * FROM btAccordionEntries WHERE bID = ? order by sortOrde';
              $r = $db->executeQuery($q, $v);
              foreach ($r as $row) {
                  $content .= $row['title'] . ' ' . $row['description'];
              }
          
          
    return $content;
          }
          
          
public function edit()
          {

andrew · November 16, 2021, 3:01pm

Thanks. This will be in 9.0.2. In the future you might consider posting this to GitHub because bug reports in the forums aren’t guaranteed to get looked at, whereas everything that goes into GitHub will be.