#90 Error Warning Parent option savedField 'optionvalue_id' doesn't have a default value

Posted in ‘Technical Support / Bugs’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by Olivier on Saturday, 11 January 2025 23:54 UTC

Michael Martin

Hello.

When tryting to add a parent option so that an option appears based on the selection of a parent option field, there error

Warning Parent option savedField 'optionvalue_id' doesn't have a default value   appears when trying to select which selection from the parent option to trigger on. See attached)   Hope this isn't confusing.   Thank you. MIchael Martin Military Tribute Banners

Olivier

Thank you for reporting this issue, Michael. Which version of J2Commerce are you using?

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Michael Martin

Hello.

Sorry for the late reply. It is 4.0.10 Pro. We just dowloaded it last week as we were going back and forth between J2 Commerce and HikaShop and settled on J2 Commerce. Everything seems to be working smoothly except for this one aspect. It would be nice to have fields toggle based on previous field selections. Not sure if it's something we are doing incorrectly.

Thanks.

Michael Martin

Military Tribute Banners

Olivier

Thank you, Michael, I will look into it.

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Adam Melcher

Michael,

Is it possible for you to add temp login creds so I can see what your settings are on the site? You should be able to add them to the necessary fields in this ticket without anybody else seeing them.  You can also email them referencing ticket #90 as well. We will get you sorted out.

 

Adam

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Michael Martin

Hello. Yes. We have created a temp administrator account for you. What's the best email to send you the login info?

Adam Melcher

Michael,

 

You can email support@j2commerce.com and reference ticket #90.

 

Adam

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Olivier

Hello Michael,

we have been able to reproduce the issue on another site.

It turns out it is an issue of table structure in the database.

We have a fix for it which will be included in the next release.

In the meantime, if you have database access and would like to test if the fix resolves your issue, you can run the query:

ALTER TABLE `xxxxx_j2store_product_optionvalues` CHANGE `optionvalue_id` `optionvalue_id` INT(11) NULL DEFAULT NULL;

where you need to replace xxxxx with the prefix of your own database tables for your site.

Let us know!

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Michael Martin

Thanks for the update. When will the next release be?

 

Olivier

We are targetting for the end of next week, beginning of the next.

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Stay Updated

Subscribe for free and be the first to know about the latest features, updates, and new additions.