Attachment doesn’t work

If you still need help, please contact me at [email protected].

@mcjarod What version of Money Manager are you using? The table structure in the screenshot is outdated, it was changed in version 1.15.0.

If the table structure has not changed, then for some reason the update was not successful. If you can provide access to your database, then I will try to fix it. Otherwise, I have no other solution than to reinstall the plugin, losing the data already entered, unfortunately.

I would release an update if I could reproduce the issue and identify the specific bug. Based on your data, unfortunately, it is not yet clear why your database has not been updated. I can give you a SQL query to create the desired wp_money_manager_files, but it is quite possible that something else in your database is also broken.

You need to drop the existing wp_money_manager_files table and create a new one with this query:

create table wp_money_manager_files
(
id bigint unsigned auto_increment
primary key,
account_id bigint unsigned null,
transaction_id bigint unsigned null,
attachment_id bigint unsigned not null,
filename varchar(255) not null,
description text null,
url varchar(255) not null,
created_at timestamp null,
updated_at timestamp null,
constraint wp_money_manager_file_acc_id_foreign
foreign key (account_id) references wp_money_manager_accounts (id)
on delete cascade,
constraint wp_money_manager_file_txn_id_foreign
foreign key (transaction_id) references wp_money_manager_transactions (id)
on delete cascade
);

create index wp_money_manager_file_att_id_index
on wp_money_manager_files (attachment_id);

Unexpectedly good news! 🙂
If I were you, I would check the other tables as well. The correct structure for version 1.23.1 can be found at this link (this is a file with the plugin installation script). If you find any other inconsistencies in your database, please let me know.

If you need more help, feel free to contact me again.

Vladimir