Hello,

I have seen `Query error: Unknown column 'base_unit_cost'`

The `base_unit_cost` column was added in the v3.4.38 Update step 8 is very important to update the database. You can run the following query after selecting your database to add the column

```sql
ALTER TABLE `sma_purchase_items` ADD `base_unit_cost` decimal(25,4) NULL;
```

Thank you

Oh I see. I think I was not imported any files from there. but I have just imported the files but I did not see this command like you menionted in the V3.4.38.

and after I add your sql command it works just fine, does it means that the db updates in the files folder was not included this line of command? "ALTER TABLE `sma_purchase_items` ADD `base_unit_cost` decimal(25,4) NULL;"?

Hello, You can check the first line of `files/db_updates/ALL.3.4.38.sql`

I tried and now I cannot sell in POS, it seems like the problem is going around.
what if I do like this? I want to udate to V3.4.38 so can I install a fresh new and then I will import my old database in to my new install with files and asset folder?

does that solve my problem? or do i need to take any extra action or command to complete it?

thanks

Hello,

_As step 8 says, you will need to import all the sql file starting from next to your version to latest._

You can export contents only and import on fresh database. You can't export tables schema as it won't have latest changes and will cause same problem.

Thank you

Oh I see that the new version V3.4.41 did not have backup and restore feature.

Yes, the backup option were removed as system can't backup large database. So you should backup from your database server if you need. Thank you