Skip to Content
Menu
This question has been flagged
4 Replies
6963 Views

Hello everyone, I had a website on odoo.sh and migrated to my own server which is Odoo 12 both the same version but eventhough I have all the permissions on filestore, database and addons right, I am keep getting below error when I try to access that imported database;

Forbidden
You don't have the permission to access the requested resource. It is either read-protected or not readable by the server.

I exported whole database dump with the filestore from odoo.sh and imported it using database manager on my own server so this process was completed without any errors but I cannot figure out how to fix this permission issue since a few days. I appreciate any help. Thanks!

Avatar
Discard

This could be due to ownership of the database or tables. Please check the ownership of your database and the tables.

Author

Hello Sudhir, thanks for your answer. I checked again but the owner is odoo for the database and tables like my test database. Test database is working fine but this one is not. And I see this error on the logs: "ERROR production odoo.sql_db: bad query:" followed by bunch of table names.

Author

At least is there any other way to export my product including the product pictures and import it to my new server? I tried the exporting from Products page but it's not taking the pictures.

Best Answer

you may try the following:

  1. copy the custom addons folder to the new server

  2. copy the file store to the new server

  3. backup only dump sql and restore it to the new server

  4. in the new server odoo config file, edit the filestore location to the new folder you copied

Avatar
Discard
Related Posts Replies Views Activity
0
Nov 19
3622
4
Jul 19
7686
0
Nov 24
2611
0
May 24
183
0
Sep 23
407