Esperanto Posted May 23, 2022 Share Posted May 23, 2022 Hi there, I've just tried to create a new category in Downloads, the first new one I've added in a couple of years. I've toggled a couple of the settings from their defaults in doing so. However, I'm receving an error: UPDATE `downloads_categories` `downloads_categories` SET `cname_furl`='trustees',`callow_anonymous`=false,`cparent`=0,`csortorder`='updated',`cdisclaimer_location`='download',`clog`=NULL,`ctypes`=NULL,`cmaxfile`=NULL,`cmultiple_files`=true,`cversion_numbers`='0',`cversioning`=0,`crequire_changelog`=NULL,`cmaxss`=0,`cmaxdims`='0x0',`ctags_disabled`=true,`ctags_noprefixes`=false,`ctags_predefined`=NULL,`cbitoptions`=133 WHERE cid=26 IPS\Db\Exception: Column 'crequire_changelog' cannot be null (1048) #0 /home/xxx/public_html/system/Db/Db.php(1156): IPS\_Db->preparedQuery('/*esperant_main...', Array) #1 /home/xxx/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`downloads_cate...', '`cname_furl`=?,...', 'WHERE cid=?') #2 /home/xxx/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save() #3 /home/xxx/public_html/system/Node/Model.php(3316): IPS\Node\_Model->save() #4 /home/xxx/public_html/system/Node/Controller.php(419): IPS\Node\_Model->saveForm(Array) #5 /home/xxx/public_html/applications/downloads/modules/admin/downloads/categories.php(79): IPS\Node\_Controller->form() #6 /home/xxx/public_html/system/Dispatcher/Controller.php(90): IPS\downloads\modules\admin\downloads\_categories->form() #7 /home/xxx/public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute() #8 /home/xxx/public_html/applications/downloads/modules/admin/downloads/categories.php(44): IPS\Node\_Controller->execute() #9 /home/xxx/public_html/system/Dispatcher/Dispatcher.php(153): IPS\downloads\modules\admin\downloads\_categories->execute() #10 /home/xxx/public_html/admin/index.php(13): IPS\_Dispatcher->run() #11 {main} It appears that whereas it's accepting NULL as a value for certain settings, it's not a fan of this for crequire_changelog. I'm on 4.6.12.1. Link to comment Share on other sites More sharing options...
Marc Posted May 23, 2022 Share Posted May 23, 2022 Please could you disable all 3rd party items and test this again? If this does not work, please let us know what items you are switching from the default, so I can test this. Esperanto 1 Link to comment Share on other sites More sharing options...
Esperanto Posted May 23, 2022 Author Share Posted May 23, 2022 Hi, Marc! I had one third-party application and three plugins active: having just disabled them all, I tried again, receiving the same error: UPDATE `downloads_categories` `downloads_categories` SET `cname_furl`='trustees-2',`callow_anonymous`=false,`cparent`=0,`csortorder`='updated',`cdisclaimer_location`='download',`clog`=NULL,`ctypes`=NULL,`cmaxfile`=NULL,`cmultiple_files`=true,`cversion_numbers`='0',`cversioning`=0,`crequire_changelog`=NULL,`cmaxss`=0,`cmaxdims`='0x0',`ctags_disabled`=true,`ctags_noprefixes`=false,`ctags_predefined`=NULL,`cbitoptions`=133 WHERE cid=27 IPS\Db\Exception: Column 'crequire_changelog' cannot be null (1048) #0 /home/xxx/public_html/system/Db/Db.php(1156): IPS\_Db->preparedQuery('/*esperant_main...', Array) #1 /home/xxx/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`downloads_cate...', '`cname_furl`=?,...', 'WHERE cid=?') #2 /home/xxx/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save() #3 /home/xxx/public_html/system/Node/Model.php(3316): IPS\Node\_Model->save() #4 /home/xxx/public_html/system/Node/Controller.php(419): IPS\Node\_Model->saveForm(Array) #5 /home/xxx/public_html/applications/downloads/modules/admin/downloads/categories.php(79): IPS\Node\_Controller->form() #6 /home/xxx/public_html/system/Dispatcher/Controller.php(90): IPS\downloads\modules\admin\downloads\_categories->form() #7 /home/xxx/public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute() #8 /home/xxx/public_html/applications/downloads/modules/admin/downloads/categories.php(44): IPS\Node\_Controller->execute() #9 /home/xxx/public_html/system/Dispatcher/Dispatcher.php(153): IPS\downloads\modules\admin\downloads\_categories->execute() #10 /home/xxx/public_html/admin/index.php(13): IPS\_Dispatcher->run() #11 {main} Notwithstanding the error, the categories were actually created: Link to comment Share on other sites More sharing options...
Marc Posted May 23, 2022 Share Posted May 23, 2022 As mentioned, I would need to know exactly what settings you are changing, as Im unable to replicate on my end unfortunately Link to comment Share on other sites More sharing options...
Esperanto Posted May 23, 2022 Author Share Posted May 23, 2022 Setting tab: Allow Comments: off Allow Reviews: off Allow file submitter to view log?: on Submissions tab: Version numbers: Disabled Allow tags: off Allow prefixes: off Link to comment Share on other sites More sharing options...
teraßyte Posted May 23, 2022 Share Posted May 23, 2022 17 minutes ago, Esperanto said: Submissions tab: Version numbers: Disabled This one's the culprit most likely. Link to comment Share on other sites More sharing options...
Esperanto Posted May 23, 2022 Author Share Posted May 23, 2022 A further complication, Marc, is that although the process created the categories anyway (just with the default settings rather than those specified), (the unchanged) permissions seem not to be respected. They look like this, as you would expect: Here's where it's positioned relative to the other categories: And yet if I try to create a new record, the new category isn't an option and doesn't feature in the sidebar: Link to comment Share on other sites More sharing options...
Marc Posted May 23, 2022 Share Posted May 23, 2022 4 minutes ago, teraßyte said: This one's the culprit most likely. Would have thought the same, but unable to replicate on my instance here @Esperanto are you ok for me to create a category for testing there? Link to comment Share on other sites More sharing options...
Esperanto Posted May 23, 2022 Author Share Posted May 23, 2022 Just now, Marc Stridgen said: @Esperanto are you ok for me to create a category for testing there? Please do, Marc. I updated the saved password on file earlier. Marc 1 Link to comment Share on other sites More sharing options...
Marc Posted May 23, 2022 Share Posted May 23, 2022 It appears I am doing something differently to you there. I have sent you a PM with a video of exactly what I do on your site. Please could you let me know what I am doing differently to yourself there? Link to comment Share on other sites More sharing options...
Marc Posted May 23, 2022 Share Posted May 23, 2022 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. Esperanto 1 Link to comment Share on other sites More sharing options...
Esperanto Posted May 23, 2022 Author Share Posted May 23, 2022 2 hours ago, teraßyte said: This one's the culprit most likely. Nearly: it was "Keep previous versions?", which I missed when listing my settings above, which is why Marc couldn't replicate the problem. Marc 1 Link to comment Share on other sites More sharing options...
Recommended Posts