3.0.1 Problems

[mfvetter]

I'm running Typo3 6.2.3.

After upgrading News from 2.3.1 or in a fresh install, I faced an error of missing tx_news_domain_model_category table on the database. I copied the SQL from version 2.3.1 and added to 3.0.1 and executed Database analyzer.

Missing SQL on ext_tables.sql:

#
# Table structure for table 'tx_news_domain_model_category'
#
CREATE TABLE tx_news_domain_model_category (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    sys_language_uid int(11) DEFAULT '0' NOT NULL,
    l10n_parent int(11) DEFAULT '0' NOT NULL,
    l10n_diffsource mediumtext,
    sorting int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    starttime int(11) DEFAULT '0' NOT NULL,
    endtime int(11) DEFAULT '0' NOT NULL,
    fe_group varchar(100) DEFAULT '0' NOT NULL,
    title tinytext,
    description text,
    image text,
    parentcategory int(11) DEFAULT '0' NOT NULL,
    single_pid int(11) unsigned DEFAULT '0' NOT NULL,
    shortcut int(11) DEFAULT '0' NOT NULL,
    import_id varchar(100) DEFAULT '' NOT NULL,
    import_source varchar(100) DEFAULT '' NOT NULL,
    is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY parentcategory (parentcategory),
    KEY import (import_id,import_source)
);

The message went away.
After doing that and adding a news item, when I try to list the items on the backend I get this error:

#1: PHP Warning: Division by zero in /var/www/typo3_src-6.2.3/typo3/sysext/fluid/Classes/ViewHelpers/Be/Widget/Controller/PaginateController.php line 65 (More information)

TYPO3\CMS\Core\Error\Exception thrown in file
/var/www/typo3_src-6.2.3/typo3/sysext/core/Classes/Error/ErrorHandler.php in line 111.

54 TYPO3\CMS\Core\Error\ErrorHandler::handleError(2, "Division by zero", "/var/www/typo3_src-6.2.3/typo3/sysext/fluid/Classe…elpers/Be/Widget/Controller/PaginateController.php", 65, array)

/var/www/typo3_src-6.2.3/typo3/sysext/fluid/Classes/ViewHelpers/Be/Widget/Controller/PaginateController.php:

00063:   \TYPO3\CMS\Core\Utility\ArrayUtility::mergeRecursiveWithOverrule($this->configuration, $this->widgetConfiguration['configuration'], FALSE);
00064:   $this->numberOfObjects = count($this->objects);

00065:   $this->numberOfPages = ceil($this->numberOfObjects / (int)$this->configuration['itemsPerPage']);

00066:  }
00067: 
...

[mfvetter]

Found the problem.

I forgot to verify if the Include static (from extensions) : News (news) was added. After adding it, everything is working fine. Even the sorting asc or desc that wasn't working started working.