Unlucky Posted May 31, 2022 Posted May 31, 2022 We just tried to create a second category in downloads and got this error - Any ideas? UPDATE `downloads_categories` `downloads_categories` SET `cname_furl`='walking-football-tournaments-festivals',`callow_anonymous`=false,`cpwyw_onoff`=true,`cpwyw_groups`='4',`cparent`=0,`csortorder`='updated',`cdisclaimer_location`='download',`clog`=NULL,`ctypes`=NULL,`cmaxfile`=NULL,`cmultiple_files`=true,`cversion_numbers`='1',`cversioning`=NULL,`crequire_changelog`=false,`cmaxss`=0,`cmaxdims`='0x0',`ctags_disabled`=false,`ctags_noprefixes`=false,`ctags_predefined`='',`cforum_id`=0,`ctopic_prefix`=NULL,`ctopic_suffix`=NULL,`cbitoptions`=261 WHERE cid=8 IPS\Db\Exception: Unknown column 'cpwyw_onoff' in 'field list' (1054) #0 /________________________.com/public_html/system/Db/Db.php(1156): IPS\_Db->preparedQuery('/*badhabi5_foot...', Array) #1 /________________________.com/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`downloads_cate...', '`cname_furl`=?,...', 'WHERE cid=?') #2 /________________________.com/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save() #3 /________________________.com/public_html/system/Node/Model.php(3316): IPS\Node\_Model->save() #4 /________________________..com/public_html/system/Node/Controller.php(419): IPS\Node\_Model->saveForm(Array) #5 /________________________.com/public_html/applications/downloads/modules/admin/downloads/categories.php(79): IPS\Node\_Controller->form() #6 /________________________.com/public_html/system/Dispatcher/Controller.php(90): IPS\downloads\modules\admin\downloads\_categories->form() #7 /________________________..com/public_html/init.php(913) : eval()'d code(29): IPS\Dispatcher\_Controller->execute() #8 /________________________..com/public_html/system/Node/Controller.php(69): IPS\Dispatcher\hook3189->execute() #9 /________________________..com/public_html/applications/downloads/modules/admin/downloads/categories.php(44): IPS\Node\_Controller->execute() #10 /________________________..com/public_html/system/Dispatcher/Dispatcher.php(153): IPS\downloads\modules\admin\downloads\_categories->execute() #11 /________________________..com/public_html/admin/index.php(13): IPS\_Dispatcher->run() #12 {main} Felipo Antonoff - Opencart 1
Solution Daniel F Posted May 31, 2022 Solution Posted May 31, 2022 This was resolved for the upcoming 4.7 release David N. and Felipo Antonoff - Opencart 2
Unlucky Posted June 2, 2022 Author Posted June 2, 2022 On 5/31/2022 at 7:23 PM, Daniel F said: This was resolved for the upcoming 4.7 release Do you know how long this will be? It's just we need to upload files to our new category but have no way of selecting the category at present. Felipo Antonoff - Opencart 1
Marc Posted June 2, 2022 Posted June 2, 2022 4.7 is in beta testing at present, so it will depend on the outcome of that testing phase
Unlucky Posted July 18, 2022 Author Posted July 18, 2022 On 6/2/2022 at 1:17 PM, Marc Stridgen said: 4.7 is in beta testing at present, so it will depend on the outcome of that testing phase Hi, We have been waiting patiently for this fix. Downloaded the latest version today and went to create a new category and it's still not working. UPDATE `downloads_categories` `downloads_categories` SET `cname_furl`='xxxxxxxxx',`callow_anonymous`=false,`cpwyw_onoff`=true,`cpwyw_groups`='4',`cparent`=7,`csortorder`='updated',`cdisclaimer_location`='purchase',`clog`=NULL,`ctypes`=NULL,`cmaxfile`=NULL,`cmultiple_files`=true,`cversion_numbers`='0',`cversioning`=NULL,`crequire_changelog`=false,`cmaxss`=0,`cmaxdims`='0x0',`ctags_disabled`=false,`ctags_noprefixes`=false,`ctags_predefined`='',`cforum_id`=0,`ctopic_prefix`=NULL,`ctopic_suffix`=NULL,`cbitoptions`=1 WHERE cid=9 IPS\Db\Exception: Unknown column 'cpwyw_onoff' in 'field list' (1054) #0 /home/customer/www/,/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*badhabi5_foot...', Array) #1 /home/customer/www/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`downloads_cate...', '`cname_furl`=?,...', 'WHERE cid=?') #2 /home/customer/www/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save() #3 /home/customer/www//public_html/system/Node/Model.php(3316): IPS\Node\_Model->save() #4 /home/customer/www//public_html/system/Node/Controller.php(419): IPS\Node\_Model->saveForm(Array) #5 /home/customer/www//public_html/applications/downloads/modules/admin/downloads/categories.php(79): IPS\Node\_Controller->form() #6 /home/customer/www//public_html/system/Dispatcher/Controller.php(107): IPS\downloads\modules\admin\downloads\_categories->form() #7 /home/customer/www//public_html/init.php(927) : eval()'d code(29): IPS\Dispatcher\_Controller->execute() #8 /home/customer/www//public_html/system/Node/Controller.php(69): IPS\Dispatcher\hook3189->execute() #9 /home/customer/www//public_html/applications/downloads/modules/admin/downloads/categories.php(44): IPS\Node\_Controller->execute() #10 /home/customer/www//public_html/system/Dispatcher/Dispatcher.php(153): IPS\downloads\modules\admin\downloads\_categories->execute() #11 /home/customer/www//public_html/admin/index.php(13): IPS\_Dispatcher->run() #12 {main}
Daniel F Posted July 18, 2022 Posted July 18, 2022 I'm really sorry, this was a mistake on my end. The one which was fixed is IPS\Db\Exception: Column 'crequire_changelog' cannot be null (1048) is quite similar, but not exactly the same as yours. IPS\Db\Exception: Unknown column 'cpwyw_onoff' in 'field list' (1054) I did take a look at the code and we have no field called cpwyw_onoff ( also cpwyw_groups is not a default field) Are you using any 3rd party applications which are changing the downloads app behaviour?
Unlucky Posted July 18, 2022 Author Posted July 18, 2022 Hi Yes. Thanks for your quick reply. We have the pay want you want and kitchin sink applications. I just disabled one of them at a time and the one causing this issue is: https://invisioncommunity.com/files/file/9708-pay-what-you-want/ Hi @Adriano Faria could you take a look at this issue please. Many thanks
Recommended Posts