Field 'asset_id' doesn't have a default value

kimball
kimball
  • kimball
  • 12 months ago

Do you have a release planned any time soon for Community Survey update package, with this `asset_id` fix in it?

I just installed Community Surveys 6.0.3 and set up CjLib Version 3.2.10, on a new Joomla 4 site

When I try to same a new Survey I get the error "Save failed with the following error: Field 'asset_id' doesn't have a default value".  

I am able to create and save new Survey categories. 
I am able to create and save new Articles. 

The SQL fix I see is in a support forum post:

ALTER TABLE `REPLACEYOURTABLEPREFIX_survey_surveys` CHANGE COLUMN `asset_id` `asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `id`;

 


Access to viewing replies is restricted.
Showing 6 of 6 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai