EasyStore Database 1.8.1 Issues - Question | JoomShaper
Back to the questions

EasyStore Database 1.8.1 Issues

DB

Douglas B

EasyStore 6 days ago

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.

0
3 Answers
Order by
Oldest Newest Votes
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 3 days ago #223376

Hello,

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,

0
DB
Douglas B
Accepted Answer
2 days ago #223453

Please check hidden content.

0
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 2 days ago #223462

To 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

0