- Posts: 112
- Thank you received: 1
Vendor - Not saving user
10 years 1 month ago #247581
by darrelluk
Vendor - Not saving user was created by darrelluk
-- HikaShop version -- : 2.6.3 Business
-- HikaMarket version -- : 1.7.1
-- Joomla version -- : 3.6.2
Hi,
When we add a user to a vendor account it is being removed when we save the Vendor record.
Which table does the record get written to? What checks does it make?
How can I figure why the user isn't being saved on the Vendor account?
before.PNG = user before pressing SAVE.
after.PNG = user after pressing SAVE.
Thx, Darrell
-- HikaMarket version -- : 1.7.1
-- Joomla version -- : 3.6.2
Hi,
When we add a user to a vendor account it is being removed when we save the Vendor record.
Which table does the record get written to? What checks does it make?
How can I figure why the user isn't being saved on the Vendor account?
before.PNG = user before pressing SAVE.
after.PNG = user after pressing SAVE.
Thx, Darrell
Please Log in or Create an account to join the conversation.
10 years 1 month ago #247591
by darrelluk
Replied by darrelluk on topic Vendor - Not saving user
Hi all,
After a bit of an investigation, I have found that the Vendor ID is stored in field user_vendor_id in the hikashop_user table.
The problem is that for some old test vendors that were deleted the vendor_id was still stored against the hikashop_user. Trying to assign that user back to a new vendor always fails (it doesn't save). Setting the user_vendor_id to 0 for that user then allows that user to be saved against a vendor and saving now works.
Why was the user_vendor_id left again the hikashop_user?
Thx, Darrell
After a bit of an investigation, I have found that the Vendor ID is stored in field user_vendor_id in the hikashop_user table.
The problem is that for some old test vendors that were deleted the vendor_id was still stored against the hikashop_user. Trying to assign that user back to a new vendor always fails (it doesn't save). Setting the user_vendor_id to 0 for that user then allows that user to be saved against a vendor and saving now works.
Why was the user_vendor_id left again the hikashop_user?
Thx, Darrell
Please Log in or Create an account to join the conversation.
10 years 1 month ago #247603
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic Vendor - Not saving user
Hi,
I checked the HikaMarket code and when you do delete a vendor through the HikaMarket backend interface, the vendor assignation on the user table is clean-up
You can check it yourself, you will see the query in the function "delete" of the HikaMarket vendor class.
So if you do not have the vendors anymore but you still have some values in the user table ; I have to suppose that you deleted the vendor directly in the database.
When you add a user to a vendor, you need to use the green button "add users" that we can see in your first screenshot.
The "save". It will add the line in the interface and the "save" will confirm the addition.
Before you do not provide the screenshot with the user in the "table" we could thought that you miss to click on that button before the save.
Regards,
I checked the HikaMarket code and when you do delete a vendor through the HikaMarket backend interface, the vendor assignation on the user table is clean-up
You can check it yourself, you will see the query in the function "delete" of the HikaMarket vendor class.
So if you do not have the vendors anymore but you still have some values in the user table ; I have to suppose that you deleted the vendor directly in the database.
When you add a user to a vendor, you need to use the green button "add users" that we can see in your first screenshot.
The "save". It will add the line in the interface and the "save" will confirm the addition.
Before you do not provide the screenshot with the user in the "table" we could thought that you miss to click on that button before the save.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
Moderators: Obsidev
Time to create page: 0.168 seconds