Jump to content

error creating new category in downloads


Go to solution Solved by Daniel F,

Recommended Posts

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}

Link to comment
Share on other sites

  • 1 month later...
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}

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...