Skip to Content

New J2Commerce 6.6.5 is out. Here is everything in the release.

See What’s New
Account
Enter the email address on your account.
Forgot your username?
Enter your password.
Forgot your password?

Or continue with

Closed Public Category: Technical Support / Bugs Ticket #90

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

This is a public ticket

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

Conversation

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

Attachments

Screenshot 2024-12-26 at 11.14.52 AM.png
Olivier Buisard Staff

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

Olivier.

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 Buisard Staff

Thank you, Michael, I will look into it.

Olivier.

Adam Melcher Staff

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

Michael Martin

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

Olivier Buisard Staff

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.

Michael Martin

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

 

Olivier Buisard Staff

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

Olivier.