rex_sql_exception: Error while executing statement "SELECT art.*, art.name_1 AS art_name, art.description_1 AS art_description, art.longtext_1 AS art_longtext, var.name_1 AS var_name, var.image AS var_image, var.freeprice AS var_freeprice, var.add_parent_price AS var_add_parent_price, var.id AS var_id, var.whvarid AS var_whvarid, var.price AS var_price, var.gallery AS var_gallery, cat.name_1 AS cat_name, cat.id AS cat_id FROM rex_wh_articles AS art LEFT JOIN rex_wh_article_variants AS var ON art.id = var.parent_id LEFT JOIN rex_wh_categories AS cat ON art.category_id = cat.id WHERE (stock_item = 0 OR (stock_item = 1 AND stock > 0)) AND art.status = :p1 AND FIND_IN_SET(:cat_id,art.category_id) ORDER BY art.prio ASC, var.prio ASC" using params {"p1":1,"cat_id":3}! SQLSTATE[42S22]: Column not found: 1054 Unknown column 'var.add_parent_price' in 'field list'
File: redaxo/src/core/lib/sql/sql.php
Line: 393
rex_sql_exception: Error while executing statement "SELECT
art
.*,art
.name_1
AS art_name,art
.description_1
AS art_description,art
.longtext_1
AS art_longtext,var
.name_1
AS var_name,var
.image
AS var_image,var
.freeprice
AS var_freeprice,var
.add_parent_price
AS var_add_parent_price,var
.id
AS var_id,var
.whvarid
AS var_whvarid,var
.price
AS var_price,var
.gallery
AS var_gallery,cat
.name_1
AS cat_name,cat
.id
AS cat_id FROMrex_wh_articles
AS art LEFT JOINrex_wh_article_variants
AS var ONart
.id
=var
.parent_id
LEFT JOINrex_wh_categories
AS cat ONart
.category_id
=cat
.id
WHERE (stock_item = 0 OR (stock_item = 1 AND stock > 0)) ANDart
.status
= :p1 AND FIND_IN_SET(:cat_id,art.category_id) ORDER BYart
.prio
ASC,var
.prio
ASC" using params {"p1":1,"cat_id":3}! SQLSTATE[42S22]: Column not found: 1054 Unknown column 'var.add_parent_price' in 'field list' File: redaxo/src/core/lib/sql/sql.php Line: 393Stacktrace
| Function | File | Line | | -------------------------------------------- | ------------------------------------------------------------------------ | -------- | | rex_sql->execute | redaxo/src/core/lib/sql/sql.php | 437 | | rex_sql->setQuery | redaxo/src/core/lib/sql/sql.php | 1245 | | rex_sql->getArray | redaxo/src/addons/yform/plugins/manager/lib/yform/manager/dataset.php | 209 | | rex_yform_manager_dataset::queryCollection | redaxo/src/addons/yform/plugins/manager/lib/yform/manager/dataset.php | 203 | | rex_yform_manager_dataset::queryCollection | redaxo/src/addons/yform/plugins/manager/lib/yform/manager/query.php | 563 | | rex_yform_manager_query->find | redaxo/src/addons/warehouse/lib/wh_articles.php | 156 | | wh_articles::get_articles | rex:///module/5/output | 39 | | require | redaxo/cache/addons/structure/1.1.content | 94 | | require | redaxo/src/addons/structure/plugins/content/lib/article_content.php | 122 | | rex_article_content->getArticle | rex:///template/1 | 81 | | require | redaxo/src/addons/structure/plugins/content/lib/article_content_base.php | 482 | | rex_article_content_base->{closure} | redaxo/src/core/lib/util/timer.php | 57 | | rex_timer::measure | redaxo/src/addons/structure/plugins/content/lib/article_content_base.php | 483 | | rex_article_content_base->getArticleTemplate | redaxo/src/addons/structure/plugins/content/boot.php | 60 | | rex_package::{closure} | redaxo/src/core/lib/extension.php | 52 | | rex_extension::{closure} | redaxo/src/core/lib/util/timer.php | 57 | | rex_timer::measure | redaxo/src/core/lib/extension.php | 63 | | rex_extension::registerPoint | redaxo/src/core/frontend.php | 26 | | require | redaxo/src/core/boot.php | 143 | | require | index.php | 9 |System report (REDAXO 5.13.2, PHP 7.4.21, MySQL 5.7.34)
| REDAXO | | | ------------: | :--------- | | Version | 5.13.2 | | PHP | | | ------------: | :--------- | | Version | 7.4.21 | | OPcache | no | | Xdebug | no | | Database | | | ------------: | :----------- | | Version | MySQL 5.7.34 | | Character set | utf8mb4 | | Server | | | ------------: | :------------ | | OS | Darwin | | SAPI | cgi-fcgi | | Webserver | Apache/2.4.46 | | Request | | | ------------: | :---------- | | Browser | Safari/15.3 | | Protocol | HTTP/1.1 | | HTTPS | yes | | Packages | | | ------------------: | :--------- | | backup | 2.8.0 | | be_style | 3.0.1 | | be_style/customizer | 3.0.1 | | be_style/redaxo | 3.0.1 | | install | 2.9.3 | | media_manager | 2.12.1 | | mediapool | 2.11.2 | | metainfo | 2.8.4 | | phpmailer | 2.11.1 | | project | dev | | structure | 2.13.2 | | structure/content | 2.13.2 | | url | 2.0.1 | | users | 2.8.2 | | warehouse | 0.3.1 | | ycom | 4.0.6 | | ycom/auth | 4.0.6 | | ycom/group | 4.0.6 | | yform | 4.0.2 | | yform/email | 4.0.2 | | yform/manager | 4.0.2 | | yrewrite | 2.8.3 |