News Box Manager v3.0.0 [Support Thread]

[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).