error creating new category in downloads

[Unlucky]

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}

[Daniel F]

This was resolved for the upcoming 4.7 release 

[Unlucky]

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.

[Marc Stridgen]

4.7 is in beta testing at present, so it will depend on the outcome of that testing phase

[Unlucky]

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]

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]

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