gab1982 Posted November 28, 2013 Share Posted November 28, 2013 Hi I made a prestashop theme on my existing site, and then moved the entire website including the database over to another domain, and it seems that I cannot update the CMS pages, they say updated but the new content doesn't show, I have also tried adding a new page and this doesn't add to the system, it says 'Your CMS page will be saved as a draft' but the page doesn't appear in the CMS pages area in the back office. How can I fix this? Graham Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 28, 2013 Share Posted November 28, 2013 it appears that the update is actually updating the database of the original domain. Can you check the original domain to see if cms changes appear there? Link to comment Share on other sites More sharing options...
gab1982 Posted November 28, 2013 Author Share Posted November 28, 2013 Hi El Patron, When I moved the site over to the new domain, I updated the Config file, with the new db info so it can't be updating the incorrect db. I also deleted all the prestashop and database from the old server. Graham Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 28, 2013 Share Posted November 28, 2013 Hi El Patron, When I moved the site over to the new domain, I updated the Config file, with the new db info so it can't be updating the incorrect db. I also deleted all the prestashop and database from the old server. Graham ok, just checking...I've not seen the behavior described...sorry Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 28, 2013 Share Posted November 28, 2013 see if this post helps...and if not done so, please post your ps version. http://www.prestashop.com/forums/topic/254297-solved-prestashop-154-cms-pages-not-showing-content-after-updating/ Link to comment Share on other sites More sharing options...
gab1982 Posted November 28, 2013 Author Share Posted November 28, 2013 Hi El Patron, I checked that URL but no luck. I have PrestaShop™ 1.5.6.1 I do recall some issues during the upgrade, im unsure if that could be the issue :s Graham Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 28, 2013 Share Posted November 28, 2013 probably a good debug, i.e. see if missing or running outdated files (upgrade) is to check the files that differ from your install and that on the prestashop repository. try this back office-->advanced parms-->config information at the bottom, it will eventually display a list of changed files. here you might be able to identify a changed file dealing with cms...then you can back up the shop file and load the file from an unzipped installation matching your version.... it's at least something to look into. Link to comment Share on other sites More sharing options...
gab1982 Posted November 28, 2013 Author Share Posted November 28, 2013 This is what it shows: Missing files (1)psadmin/autoupgrade/index.php Updated files (4)modules/blocknewsletter/mails/en/newsletter_conf.html modules/blocknewsletter/mails/en/newsletter_verif.html modules/mailalerts/mails/en/new_order.html modules/mailalerts/mails/en/new_order.txt Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 28, 2013 Share Posted November 28, 2013 This is what it shows: Missing files (1)psadmin/autoupgrade/index.phpUpdated files (4)modules/blocknewsletter/mails/en/newsletter_conf.html modules/blocknewsletter/mails/en/newsletter_verif.html modules/mailalerts/mails/en/new_order.html modules/mailalerts/mails/en/new_order.txt that looks 'very' clean... you are able to update all other aspects of your shop yes? Link to comment Share on other sites More sharing options...
GeertN Posted December 4, 2013 Share Posted December 4, 2013 http://www.prestasho...-add-cms-pages/ The problem with eliyvo was that the database was missing a column in the ps_cms table named indexation. If you two can see if your database has that column that would be great. If not you can create it, it is a tinyint(1) column with 1 as the default value. His shop was 1.5.6.1, so it might not apply to other versions. 2 Link to comment Share on other sites More sharing options...
gab1982 Posted December 5, 2013 Author Share Posted December 5, 2013 http://www.prestasho...-add-cms-pages/ The problem with eliyvo was that the database was missing a column in the ps_cms table named indexation. If you two can see if your database has that column that would be great. If not you can create it, it is a tinyint(1) column with 1 as the default value. His shop was 1.5.6.1, so it might not apply to other versions. That worked great thanks, and thanks El Patron for trying to help me out too. Link to comment Share on other sites More sharing options...
Recommended Posts