Modern admin dashboard

[balihr]

I've created a pull request for this and it will hopefully be part of Zen Cart 2.2.0, but this commit will not work with any version prior to 2.2.0 because of the currencies class which needs to be included manually on versions 2.1.0 and older.

For anyone using Zen Cart 2.1.0 (and probably any other version down to 1.5.8), you can use this "plugin" to achieve the same look:
https://zenexpert.com/zen-cart-modern-admin-dashboard

Will submit to plugins if no bugs are reported.

[OldNGrey]

Error displayed on screen bottom RH corner. Image is attached.

1055 'zc220_exp.pd.products_name' isn't in GROUP BY
in:
[SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold FROM orders_products op JOIN orders o ON op.orders_id = o.orders_id JOIN products p ON op.products_id = p.products_id JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = 1) WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY) GROUP BY p.products_id ORDER BY total_sold DESC LIMIT 5]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

error-log

[12-Jan-2026 07:55:34 Australia/Brisbane] Request URI: /zc220_exp/public/admin/, IP address: 192.168.1.63, Language id 1#0 [internal function]: zen_debug_error_handler()
#1 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(757): trigger_error()
#2 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(701): queryFactory->show_error()
#3 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(314): queryFactory->set_error()
#4 E:\Web\zc220_exp\public\admin\includes\modules\dashboard_widgets\MostPopularProductsDashboardWidget.php(21): queryFactory->Execute()
#5 E:\Web\zc220_exp\public\admin\index_dashboard.php(141): include('E:\\Web\\zc220_ex...')
#6 E:\Web\zc220_exp\public\admin\home.php(27): require('E:\\Web\\zc220_ex...')
#7 E:\Web\zc220_exp\public\admin\index.php(16): require('E:\\Web\\zc220_ex...')
--> PHP Fatal error: FATAL MySQL error 1055: 'zc220_exp.pd.products_name' isn't in GROUP BY :: SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold
        FROM orders_products op
        JOIN orders o ON op.orders_id = o.orders_id
        JOIN products p ON op.products_id = p.products_id
        JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = 1)
        WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY)
        GROUP BY p.products_id
        ORDER BY total_sold DESC
        LIMIT 5 ==> (as called by) E:\Web\zc220_exp\public\admin\includes\modules\dashboard_widgets\MostPopularProductsDashboardWidget.php on line 21 <== in E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php on line 757.

Environment: Zen Cart 2.2.0; Apache 2.4.63; PHP 8.4.16; MySQL 11.8.5-MariaDB-log; Windows 11

[dbltoe]

Sorry, saw the 2.2.0 finally

Are you using github or the zip?

[balihr]

Error displayed on screen bottom RH corner. Image is attached.

1055 'zc220_exp.pd.products_name' isn't in GROUP BY
in:
[SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold FROM orders_products op JOIN orders o ON op.orders_id = o.orders_id JOIN products p ON op.products_id = p.products_id JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = 1) WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY) GROUP BY p.products_id ORDER BY total_sold DESC LIMIT 5]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

error-log

[12-Jan-2026 07:55:34 Australia/Brisbane] Request URI: /zc220_exp/public/admin/, IP address: 192.168.1.63, Language id 1#0 [internal function]: zen_debug_error_handler()
#1 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(757): trigger_error()
#2 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(701): queryFactory->show_error()
#3 E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php(314): queryFactory->set_error()
#4 E:\Web\zc220_exp\public\admin\includes\modules\dashboard_widgets\MostPopularProductsDashboardWidget.php(21): queryFactory->Execute()
#5 E:\Web\zc220_exp\public\admin\index_dashboard.php(141): include('E:\\Web\\zc220_ex...')
#6 E:\Web\zc220_exp\public\admin\home.php(27): require('E:\\Web\\zc220_ex...')
#7 E:\Web\zc220_exp\public\admin\index.php(16): require('E:\\Web\\zc220_ex...')
--> PHP Fatal error: FATAL MySQL error 1055: 'zc220_exp.pd.products_name' isn't in GROUP BY :: SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold
        FROM orders_products op
        JOIN orders o ON op.orders_id = o.orders_id
        JOIN products p ON op.products_id = p.products_id
        JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = 1)
        WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY)
        GROUP BY p.products_id
        ORDER BY total_sold DESC
        LIMIT 5 ==> (as called by) E:\Web\zc220_exp\public\admin\includes\modules\dashboard_widgets\MostPopularProductsDashboardWidget.php on line 21 <== in E:\Web\zc220_exp\public\includes\classes\db\mysql\query_factory.php on line 757.

Environment: Zen Cart 2.2.0; Apache 2.4.63; PHP 8.4.16; MySQL 11.8.5-MariaDB-log; Windows 11

MySQL is in strict mode...
Can you please try updating admin\includes\modules\dashboard_widgets\MostPopularProductsDashboardWidget.php
Replace

$sql = "SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold
        FROM " . TABLE_ORDERS_PRODUCTS . " op
        JOIN " . TABLE_ORDERS . " o ON op.orders_id = o.orders_id
        JOIN " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id
        JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] . ")
        WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY)
        GROUP BY p.products_id
        ORDER BY total_sold DESC
        LIMIT 5";

with

$sql = "SELECT p.products_id, pd.products_name, p.products_image, p.products_model, SUM(op.products_quantity) as total_sold
        FROM " . TABLE_ORDERS_PRODUCTS . " op
        JOIN " . TABLE_ORDERS . " o ON op.orders_id = o.orders_id
        JOIN " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id
        JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] . ")
        WHERE o.date_purchased >= DATE_SUB(NOW(), INTERVAL 30 DAY)
        GROUP BY p.products_id, pd.products_name, p.products_image, p.products_model
        ORDER BY total_sold DESC
        LIMIT 5";

Notice the text in red - that's the only addition.
Please report back - this will probably need to be updated in the PR as well.

[OldNGrey]

The error is due to the DB_MYSQL_MODE setting ONLY_FULL_GROUP_BY which is on by default in MYSQL.
Without this setting the page displays fully.

[OldNGrey]

Yes updating the GROUP BY statement works.

[balihr]

Thanks for the update.

If there are any other bugs, or even better - suggestions, I'm happy to hear it! I've also redesigned the header, but I have a feeling it won't be welcomed because we're all used to the styling that's been with us for decades... Although new users might like it? If anyone is interested in taking it for a spin, please PM me.

[OldNGrey]

Post a link to the header and I'll give it a try.

[balihr]

Post a link to the header and I'll give it a try.

Yeah, probably easier.

Same link as above - the zip file now contains two separate folders, one for dashboard and one for header.

[balihr]

Just updated the zip file - I uploaded with wrong structure and missing language file... Same download link as in post #1