EasyStore Database 1.8.1 Issues
DB
Douglas B
Hello, I just updated EasyStore to 1.8.1 and have the following database issues:
Table 'jrx7o_easystore_orders' does not have column 'custom_invoice_id'. (From file 1.7.0.sql.) Table 'jrx7o_easystore_orders' does not have index 'idx_custom_invoice_id'. (From file 1.7.0.sql.) 19 database changes were checked. 58 database changes did not alter table structure and were skipped.
Maintenance:Database > Select EasyStore > Update Structure > does not fix this issue.
Any advice would be appreciated, thank you.
5 Answers
Order by
Oldest
Ziaul Kabir
Accepted AnswerTo fix this issues, Please, go to your phpmyadmin data base -> SQL -> then paste this command and click go.
ALTER TABLE `jrx7o_easystore_orders`
ADD COLUMN `custom_invoice_id` VARCHAR(255) NULL AFTER `order_token`;
ALTER TABLE `jrx7o_easystore_orders`
ADD INDEX `idx_custom_invoice_id` (`custom_invoice_id`);Thanks
Ziaul Kabir
Accepted AnswerHello,
Thanks for reaching out to us. Could you please share temporary administrator access to your Joomla backend? You can provide the credentials securely in the hidden content section. Also, please take a full backup of your site before we make any changes.
Once I have access, I’ll investigate further and see what’s causing the issue. Let me know once you’ve shared the details!
Best regards,
DB
Douglas B
Accepted Answerthank you. i was able to work that out.
Had an error with the above sql command as the column order_token did not exist, so the AFTER order_token part generated an error.
Anyway, got it sorted. thank you for the help.