Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
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.
Actually Bob, I was able to reproduce the error, no need for additional information at this time. Thanks!
Olivier.
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.
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.
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.
