CMS MADE SIMPLE FORGE

Company Directory

 
Back Back to List

[#12202] Can't create category nor hierarchy

avatar
Created By: Franck (knarf)
Date Submitted: Mon Dec 09 11:51:07 -0500 2019

Assigned To: Robert Campbell (calguy1000)
Version: 1.903
CMSMS Version: 2.3-beta7
Severity: Minor
Resolution: None
State: Open
Summary:
Can't create category nor hierarchy
Detailed Description:
CMS V2.3beta8

When trying to create a category, or a hierarchy, I have this error message (for
both): "Field 'hierarchy' doesn't have a default value -- Field 'hierarchy'
doesn't have a default value"

So I can't create a category or hierarchy.

No error in PHP logs.


History

Comments
avatar 
Date: 2020-02-21 15:10
Posted By: Victor Avgust (Vavgust)

To fix: add default value for 'hierarchy' field in 2 tables
'cms_module_compdir_categories' and 'cms_module_compdir_hier'
Here are SQL lines to execute:
ALTER TABLE `cms_module_compdir_categories` ALTER `hierarchy` SET  DEFAULT '1';
ALTER TABLE `cms_module_compdir_hier` ALTER `hierarchy` SET  DEFAULT '1';