Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by Bob Nelson on Saturday, 13 December 2025 19:51 UTC
Hi all-
In working witht he Gift Card App, creating manual vouchers- there is not a field(s) in the process that allows you to add the "From" information for the voucher, resulting in: "Field 'from_order_id' doesn't have a default value" when you attenpt to save the voucher.
Bob
Hello Bob,
can you send us the structure of the _j2store_vouchers table? Just a paste of the table structure in the ticket will be fine. Don't add the data. I am looking on my end to see why the error could happen.
Olivier.
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Actually Bob, I was able to reproduce the error, no need for additional information at this time. Thanks!
Olivier.
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Bob, if you have access to the database, try:
ALTER TABLE `XXXXXXXX_j2store_vouchers` CHANGE `from_order_id` `from_order_id` VARCHAR(255) NOT NULL DEFAULT '0';
where XXXXXXXX is the table prefix for your site.
Let us know if that fixes your issue. Thank you!
Olivier.
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Hey Oliver- Just wanted to say thank you for checking in to this- I will apply the database alter this weekend and let you know.
- Bob
Ok, soundfs good Bob, let us know!
Olivier.
Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.
Hey Oliver-
I was able to update the table, then logged out of admin and back in, but still got the same error. Attached the screenshots.
Subscribe for free and be the first to know about the latest features, updates, and new additions.