I upgraded from Xubuntu 13.04 to Xubuntu 13.10. Unfortunately, the Broadcom Wireless Adapter 4313 was not working. Meanwhile, in hope of a solution or a fix to the wireless adapter resolution, I continued to use Evolution. Patience finally ran out. Unfortunately, with not much choice left, I downgraded to Xubuntu 13.04. Before the downgrade, I took a backup of my Evolution data (email, addressbooks, etc).
After the downgrade was complete, I tried to restore evolution’s data back, but got the following error:
This address book cannot be opened. Check that the path /home/user/.local/addressbook/… exists and that permissions are set to access it.
‘table folders has 8 columns but 6 values were supplied’
To overcome this error, I performed the steps below:
- Backup the defective evolution database and exit Evolution.
- Start Evolution and export all email folders to an .mbox file.
- Next rename the folder in the path /home/user/.local/share/evolution to any other another name, in my case xevolution. Note it down because after everything is done, the folder needs to be deleted. Here, ‘user’ is the user ID.
- Also, rename the folder /home/user/.config/evolution to another name, in my case, xevolution. Note it down because after everything is done, the folder needs to be deleted. Here, ‘user’ is the user ID.
- Now, start evolution once more. It is a clean slate.
- If you have an evolution backup taken before you upgraded, restore it using evolution’s File -> Restore Evolution Data…
- You will see your older emails and addressbook now. No errors when accessing the addressbook. Now, delete all the emails in all the folders. The objective is to restore the latest emails you backed up from the .mbox files.
- One by one, import all the email within folders that you saved in the .mbox files.
- That done, you are now back to where you were after you had performed an upgrade.
- Lastly, go back and delete the folders (xevolution) you renamed as in 3 and 4 above.