benzachar Posted January 21, 2017 Share Posted January 21, 2017 (edited) Hi, I updated my website this morning (from 1.6.1.6 to 1.6.1.11). I thought it went smoothly, but I realized the text fields for customization don't appear on the frontend product pages anymore. I tried to: Remove/add and modify the fields - didn't work Add file fields - I could see them on the frontend Inspect the html page - didn't see anything wrong Inspect the product.tpl file - didn't see anything wrong Search the forum for a solution - didn't find one Can you please help? I'm selling customizable products, but users can't customize them anymore... A product page: https://sartoriasapone.com/home/42-thin-lychee-band.html Thanks in advance. Edited January 21, 2017 by benzachar (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted January 21, 2017 Share Posted January 21, 2017 Very bad issue it seems, you can only see the new ones? Some data might have got corrupted in the ps_customized_data table, can you check if you have anything wrong there? Link to comment Share on other sites More sharing options...
benzachar Posted January 22, 2017 Author Share Posted January 22, 2017 (edited) Thank you for your help NemoPS. To check the ps_customized_data table, should I use Modules and Services >> Prestashop Cleaner? Or is there a manual check to do? Edit: I checked if I could see the fields on a new product, but same problem. Text fields are not displayed... Edited January 22, 2017 by benzachar (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted January 23, 2017 Share Posted January 23, 2017 So you could see them in the database?I would avoid the cleaner as it's likely to mess things up even moreAre you using any override? Link to comment Share on other sites More sharing options...
benzachar Posted January 23, 2017 Author Share Posted January 23, 2017 I'm a noob and I don't know how to check the ps_customized_data table. I went to SQL Manager (I guess it's where it should be). And made this query (another guess from PS documentation): SELECT id_customization, type, index, value FROM ps_customized_data But no results. Can you let me know how to check the database? Thanks Link to comment Share on other sites More sharing options...
NemoPS Posted January 27, 2017 Share Posted January 27, 2017 Is ps_ your tables' prefix? Login to your cpanel, then phpmyadmin, you canfind the table there Link to comment Share on other sites More sharing options...
benzachar Posted February 5, 2017 Author Share Posted February 5, 2017 Ok, thank you. I found it and I can see this: http://prnt.sc/e4ofgt And I guess it's not what's supposed to be there. What do you think/recommend? Link to comment Share on other sites More sharing options...
benzachar Posted February 16, 2017 Author Share Posted February 16, 2017 Should I restore via Softalicious? It's been almost a month I'm stuck now. It's a project I started so not much traffic yet, but I need to fix this. Link to comment Share on other sites More sharing options...
NemoPS Posted February 23, 2017 Share Posted February 23, 2017 It would be better to have a clean db dump, never tried restoring with that Link to comment Share on other sites More sharing options...
benzachar Posted February 24, 2017 Author Share Posted February 24, 2017 Ok, what's the risk to restore? Because I'm in the dark now. Are we talking about a fresh install of PS? Or re-import all products? Link to comment Share on other sites More sharing options...
NemoPS Posted February 24, 2017 Share Posted February 24, 2017 Well the risk is breaking the shop for good, I would keep a manual backup just in case you need to restore it. As for other options, you don't really have any, if you don't have a database dumb of when it was working Link to comment Share on other sites More sharing options...
benzachar Posted April 6, 2017 Author Share Posted April 6, 2017 So finally I asked a developer and he used code to fix it. Thanks for your help. 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