View Issue Details

IDProjectCategoryView StatusLast Update
0007221OXID eShop B2B EditionB2B edition - subpublic2023-06-29 12:54
Reporterbissie Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionwon't fix 
Product Version4.0.0 
Summary0007221: Loading employee details page by superior leads to error
DescriptionLoading employee details page by superior will lead to maintenance page and an sql error occurred
Steps To ReproducePrecondition:Fresh B2B Edition, nothin was activated before, no b2b table created.
Activate B2B Modiules M01 up to M04. Do not activate M05 (Budgets)
Create a superior user
Create a employee assigned to this superior
Log in as superior and try to see employee details page - ERROR
----
SQLSTATE[42S02]:
Base table or view not found: 1146 Table 'oxid.b2bbudget' doesn't exist at ...
---
Reason:
BuyingAgentDetailsController::render() try to load users budget info even if module is not active and table still not created
TagsNo tags attached.

Activities

QA

2021-03-23 13:44

administrator   ~0013400

Last edited: 2021-03-23 13:45

https://github.com/OXID-eSales/b2b-buying-agent-module/tree/master

Activate the Module - OXID B2B Buying Agent Module - OXID B2B M04 - Einkäufer

Activate the B2B module in the OXID eShop administration area. Ensure that all dependencies to other modules from the OXID B2B bundle are satisfied by ensuring that the following modules from the OXID B2B Bundle are activated as well:

    OXID B2B M01 - B2B Services
    OXID B2B M03 - Approval Procedure
    OXID B2B M05 - Budget

So here is written, if you activate M4 ensure all dependecies to other modules are satisfied and the following Bundles are activated:
OXID B2B M01
OXID B2B M03
OXID B2B M05
So if OXID B2B M05 is activated loading employee details page by superior will not lead to the error mentioned above

So its not a bug
-- es --

bissie

2021-03-23 13:49

reporter   ~0013401

Well, I got the error until I activated M05 manually in Shop Backend. The onActivate Event create this table.
I installed b2b Edition Modules and activated M01,M02, M03 and M04 in this order. M05 was not activated and table not created.
Maybe one call it feature, for me it's strange and not expected behaviour.

QA

2021-03-23 14:43

administrator   ~0013402

Last edited: 2021-03-23 14:44

Improvement
When opening the detail page of a employee assigned to an superior user, it should be enough if OXID B2B M04 - Buying Agent Module is active.
Currently, OXID B2B M05 Budget must be activated too to edit the employee details page, even if budget planning is not needed.

So severity is set to feature.

SvenBrunk

2023-06-29 12:54

manager   ~0015347

Since this is not the only dependency between those 2 modules, it does not make sense to think about getting rid of this dependency. Works as intended and documented.