j.k.r Posted January 17, 2016 Share Posted January 17, 2016 After using the 1-Click Upgrade module to upgrade from 1.4.6.2 to 1.6.1.4, I had some problems updating the logo icons and found out it was due to duplicate values in the name and value fields in ps_configuration for the logos database records (i.e. name = PS_LOGO_MAIL). Once I deleted the extra records, I was able to upload new logos. I ran a query on the table to see if any other records were duplicated and I found quite a few. Is this normal, or does it indicate a problem? I attached a screenshot of an example. Link to comment Share on other sites More sharing options...
bellini13 Posted January 17, 2016 Share Posted January 17, 2016 as you can see in the screen shot, the id_shop value for the first row is null. this is because the concept of shops (multi shop) did not exist in PS v1.4.6.2. so when your store was upgraded, and the id_shop column was added, it was defaulted to null (expected) something then added a new row with id_shop value of 1, which is NOT the expected value. if you look at a clean install of Prestashop v1.6.1.4, NULL is the value PS_SHOP_NAME. Link to comment Share on other sites More sharing options...
j.k.r Posted January 17, 2016 Author Share Posted January 17, 2016 Thank you for explaining that. Should I delete the duplicate records with shop_id value of 1 or should I just leave them as they are? Link to comment Share on other sites More sharing options...
bellini13 Posted January 17, 2016 Share Posted January 17, 2016 are you using multi store? Link to comment Share on other sites More sharing options...
j.k.r Posted January 18, 2016 Author Share Posted January 18, 2016 No, we just have one store. We are using an add-on module from Agile for multiple sellers/vendors within one store, though. Link to comment Share on other sites More sharing options...
tuk66 Posted January 18, 2016 Share Posted January 18, 2016 Ask the Agile module developer. Nobody else can help you. Their modules are encrypted. Link to comment Share on other sites More sharing options...
bellini13 Posted January 18, 2016 Share Posted January 18, 2016 No, we just have one store. We are using an add-on module from Agile for multiple sellers/vendors within one store, though. I am not familiar with their code base, so as Tuk66 suggested you may want to discuss this issue with Agile first. Agile modules aside, there is no reason to have the configuration records where id_shop = 1 if they are duplicates to the NULL value records. I would compare the value of the duplicate records to each other, and if they are the same value, then delete the record with id_shop=1. If they have different values, then you need to decide which one to keep Link to comment Share on other sites More sharing options...
j.k.r Posted January 18, 2016 Author Share Posted January 18, 2016 I deleted the records where id_shop = 1 and haven't seen any ill side effects so far. I did notice that some of the records were recreated, however. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now