I'm looking for an agile but full open source free ERP/CRM software for our company that has to manage:
-full accountability: expense/income registration, elaboration of statements about income, balance sheet, cash flow
-project expense tracking and budget
-project management: task chats, Gantt charts, task assignment, kanban view, relational tasks, etc...
-inventory management: merchandise in/out, assets with amortization, etc...
-CRM tools: contact management, quotation management, sales process, management of sales managers, contract agreements
I thought that the open source version of Odoo can do this job.
I installed v18 in a docker container running in a local server machine but I'm encountering a lot of issues:
no exhaustive guide: even if there are some guides or videos on how to use odoo they are very poor and not well classified because there are a lot of versions
there is no a clear guide for the setup of odoo after installation
it seems odoo 18 does not have the specific modules that I need for the tests, but other versions yes
the system is not stable: it is easy to lose access to the database without a double check of the system, like losing admin capabilities
After this introduction about my first impression, let me explain my issues:
I set the emailing server providing the outbound and inbound email. The test connection works but if I try to invite another user, it cannot send the email because of an error with the server. It seems wants to send an email with another address, different from what I provided
I activated some modules from the app list, and now it returns this " Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."
I got the logs of the app and I got this:
"$ sudo docker logs --since=2h 09d9772bdd59
2024-12-10 07:47:58,249 1 INFO MyCompany odoo.modules.loading: loading 1 modules...
2024-12-10 07:47:58,321 1 INFO MyCompany odoo.modules.loading: 1 modules loaded in 0.07s, 0 queries (+0 extra)
2024-12-10 07:47:58,454 1 INFO MyCompany odoo.modules.loading: loading 48 modules...
2024-12-10 07:47:59,252 1 INFO MyCompany odoo.modules.loading: 48 modules loaded in 0.80s, 0 queries (+0 extra)
2024-12-10 07:47:59,389 1 INFO MyCompany odoo.modules.loading: Modules loaded.
2024-12-10 07:47:59,400 1 INFO MyCompany odoo.modules.registry: Registry loaded in 1.241s
2024-12-10 07:47:59,401 1 INFO MyCompany odoo.addons.base.models.ir_http: Generating routing map for key None
2024-12-10 07:47:59,531 1 INFO MyCompany odoo.addons.base.models.res_device: User 2 inserts device log (tabr8iDb4LqQsGfgvuv5vNWhZsSZSgD_sbVXI1LvcF)
2024-12-10 07:47:59,567 1 INFO MyCompany werkzeug: 172.18.0.1 - - [10/Dec/2024 07:47:59] "GET / HTTP/1.1" 303 - 28 0.192 1.218
2024-12-10 07:47:59,682 1 ERROR MyCompany odoo.addons.base.models.ir_model: Missing model website
2024-12-10 07:47:59,683 1 ERROR MyCompany odoo.addons.base.models.ir_model: Missing model website.page
2024-12-10 07:47:59,683 1 ERROR MyCompany odoo.addons.base.models.ir_model: Missing model website.visitor
2024-12-10 07:47:59,683 1 ERROR MyCompany odoo.addons.base.models.ir_model: Missing model website.track
2024-12-10 07:47:59,943 1 ERROR MyCompany odoo.http: Exception during request handling.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/ir_qweb.py", line 600, in _render
result = ''.join(rendering)
^^^^^^^^^^^^^^^^^^
File "<441>", line 67, in template_441
File "<441>", line 56, in template_441_content
File "<181>", line 1683, in template_181
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
KeyError: 'website'
Template: web.frontend_layout
Path: /t/t[2]
Node: <t t-if="not request.env.user._is_public()" t-set="nothing" t-value="html_data.update({ \'data-is-published\': \'website_published\' in main_object.fields_get() and main_object.website_published, \'data-can-optimize-seo\': \'website_meta_description\' in main_object.fields_get(), \'data-can-publish\': \'can_publish\' in main_object.fields_get() and main_object.can_publish, \'data-editable-in-backend\': edit_in_backend or (\'website_published\' in main_object.fields_get() and main_object._name != \'website.page\'), })"/>
2024-12-10 07:51:40,326 1 INFO MyCompany werkzeug: 172.18.0.1 - - [10/Dec/2024 07:51:40] "GET /favicon.ico HTTP/1.1" 500 - 10 0.007 0.027
2024-12-10 07:53:45,709 1 INFO MyCompany odoo.addons.base.models.ir_cron: Job 'Mail: Fetchmail Service' (6) starting
2024-12-10 07:53:45,714 1 INFO MyCompany odoo.addons.mail.models.fetchmail: start checking for new emails on pop server MyCompany Automatic Management
2024-12-10 07:53:45,851 1 INFO MyCompany odoo.addons.mail.models.fetchmail: Fetched 0 email(s) on pop server MyCompany Automatic Management; 0 succeeded, 0 failed.
2024-12-10 07:53:45,868 1 INFO MyCompany odoo.addons.base.models.ir_cron: Job 'Mail: Fetchmail Service' (6) done in 0.159s
2024-12-10 07:53:45,871 1 INFO MyCompany odoo.addons.base.models.ir_cron: Job 'Mail: Fetchmail Service' (6) processed 0 records, 0 records remaining
2024-12-10 07:53:45,875 1 INFO MyCompany odoo.addons.base.models.ir_cron: Job 'Mail: Fetchmail Service' (6) completed"
Even if I reinstall the application, I need to understand what happened and why I got these instabilities to avoid other errors like these ones.
I'd like to receive also your suggestions for the best version to install and how to use/configure to make the system robust and eventually deploy in the real case.
Thanks