News Box Manager v3.0.0 [Support Thread]

[lat9]

I just installed v3.2.2-beta1 (storefront change only) on a local zc210 site. Added a new article with no error logs.

The change I suggested above ensures that one of the Enabled/Disabled radio-buttons is selected when the insert-entry form is displayed.

[keneso]

Yes, I noticed that, but like said I had checked it anyway, and for some reason is returning the warning.
I noticed that the error log has been generated for the attempts done by a limited admin, whereas not generated for the power admin, getting that by the reported time of the erro logs.

[lat9]

Yes, I noticed that, but like said I had checked it anyway, and for some reason is returning the warning.
I noticed that the error log has been generated for the attempts done by a limited admin, whereas not generated for the power admin, getting that by the reported time of the erro logs.

Hmm, interesting. For the limited admin's profile, are any of the "News Box Manager" scripts enabled in the "Tools" menu?

[keneso]

Let me make it more interesting. ;)

Only the type1 is enabled for the limited.
Anyhow I got the same warning from power admin.

Now some more details:

I enabled "all types", and disabled the "type1, type2, type3, type4".
And the "all types" cannot be access with the security clearance message, prompting to contact site admin.

I enabled them all "all types, type1, type2, type3, type4"
"type1, type2, type3, type4" can be accessed, but "all types" would again display the security clearance message.

I apologize as I thought the diffrent log files would contain same error (actually warning), I had opened two only, I now opened them all and can see different line reference in 7 of them as opposed to the two I reported in previous post.

So instead of posting the error log file I posted the content of the warning one, and the lack of the power admin is the warning type, while it does generate the error type.
To be clear in previous post I posted the content of:
myDEBUG-adm-20250625-115415-048278-warning.log

The content of the:
myDEBUG-adm-20250625-123458-778999-error.log

Is the following, and save the IP the content is the same for both limited, and power admin:

[25-Jun-2025 22:29:01 Europe/London] Request URI: /path_to_zen_cart_admin/index.php?cmd=news_box_manager1&action=insert&nType=1, IP address: 2.234.145.206, Language id 2
#0 [internal function]: zen_debug_error_handler()
#1 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /path_to_zen_cart/zen-210/includes/functions/database.php(134): queryFactory->Execute()
#5 /path_to_zen_cart_admin/news_box_manager.php(112): zen_db_perform()
#6 /path_to_zen_cart_admin/news_box_manager1.php(12): require('/home3/tesoreri...')
#7 /path_to_zen_cart_admin/index.php(16): require('/home3/tesoreri...')
--> PHP Fatal error: MySQL error 1364: Field 'box_news_id' doesn't have a default value :: INSERT INTO box_news (news_start_date, news_end_date, news_content_type, news_status, news_added_date) VALUES ('2025-06-25 00:00:00', null, '1', '1', now()) ==> (as called by) /path_to_zen_cart/zen-210/includes/functions/database.php on line 134 <== in /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php on line 733.

On another error file there is one less line

[25-Jun-2025 16:24:43 Europe/London] Request URI: /path_to_zen_cart_admin/index.php?cmd=news_box_manager&action=insert, IP address: 2.234.145.206, Language id 2
#0 [internal function]: zen_debug_error_handler()
#1 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /path_to_zen_cart/zen-210/includes/functions/database.php(134): queryFactory->Execute()
#5 /path_to_zen_cart_admin/news_box_manager.php(112): zen_db_perform()
#6 /path_to_zen_cart_admin/index.php(16): require('/home3/tesoreri...')
--> PHP Fatal error: MySQL error 1364: Field 'box_news_id' doesn't have a default value :: INSERT INTO box_news (news_start_date, news_end_date, news_content_type, news_status, news_added_date) VALUES ('2025-06-25 00:00:00', null, '1', '1', now()) ==> (as called by) /path_to_zen_cart/zen-210/includes/functions/database.php on line 134 <== in /path_to_zen_cart/zen-210/includes/classes/db/mysql/query_factory.php on line 733.

Again apologies for the confusion.

[lat9]

The box_news_id field of the box_news table is defined as an auto_increment field (see /admin/includes/init_includes/news_box_manager_install.php):

// ----
// Create each of the database tables for the news-box records.
//
$sql = "CREATE TABLE IF NOT EXISTS " . TABLE_BOX_NEWS . " (
    `box_news_id` int(11) NOT NULL auto_increment,
    `news_added_date` datetime NOT NULL default '0001-01-01 00:00:00',
    `news_modified_date` datetime default NULL,
    `news_start_date` datetime default NULL,
    `news_end_date` datetime default NULL,
    `news_status` tinyint(1) default 0,
    `news_content_type` tinyint(1) NOT NULL default 1,
    PRIMARY KEY  (`box_news_id`)
)";

... as such, that field has an implicit MySQL-calculated default value.

I'll suggest that you review the structure of the box_news and box_news_content tables via phpMyAdmin to ensure that the structures match that installed by the module referenced above.

[keneso]

Thank you, and sorry for belated reply.
I am away, as soon as I get back I'll check, and update.

[keneso]

I'll suggest that you review the structure of the box_news and box_news_content tables via phpMyAdmin to ensure that the structures match that installed by the module referenced above.

I don't know why, but indeed the "primary key", and "auto increment" were missing.
Fixed, and works as it used to.

Thank you.

[lat9]

News Box Manager v3, version 3.2.2 is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2264

This release contains changes for these GitHub issues:

#38: Enable integration with the ZCA Bootstrap template
#40: Correct PHP warning when no content is shown in news listings.
#41: Remove unwanted MoveNext in sidebox foreach loops (causes articles to be missed).