In the magento backend im trying to input my credentials for a shipping plugin called DPD and when i save only the password is shorter then what i inputted leading me to believe that its only saving up to the first 5 characters thus leaving the password incorrect. this has happened before but ive always worked around it by editing the config file but this time i cant find the part of the config file related to the dpd plugin and dont know what to do. im asking here maybe someone could help me fix this issue of saving passwords in the backend as it is very frustrating. Thanks in advance.
You can check the database table structure and change password field data_type to "varchar(100)" and then check again.
@Manish Mittalthanks very much for your reply could you please give me slightly more detailed instructions on how to do this as im not very familiar with magento or its database table strecture. thanks in advance
As you mentioned in the database saving a password only the first 5 characters so in which table you are checking that go to that table and check password field data type and change it varchar(100).
@Manish Mittalthanks for your reply i didnt check any table i only observed this from the backend once it is refreshed would you happen to know what table i would need to edit please ?
Edit: i searched the database for any tables with a column name containing 'password' and found a few but all the ones that are varchar are at least 100. would you possibly have any other ideas?