GeekyFuroshiki Posted March 9, 2020 Share Posted March 9, 2020 I have been preparing my site for a while now, and am now ready to go live with it. While I've been working, there has been a placeholder page with the message "We are currently updating our shop and will be back really soon. Thanks for your patience." I remember setting that in OVH control panel> Hosting plans> General Information (it was a while ago), but now I can't figure out how to deactivate that page and enable the site so that people can use it. I originally thought this was an OVH problem, but asking on the OVH forums people say that it is a Prestashop issue, quoting the following: curl --head -XGET --user-agent Firefox http://www.geekyfuroshiki.com/en/ HTTP/1.1 503 Service Unavailable X-Powered-By: PHP/7.2 Set-Cookie: PrestaShop-...domain=www.geekyfuroshiki.com; HttpOnly I had a look in Prestashop General Shop Parameters, the Enable Shop option is set to yes. I tried turning it off and on again, no difference. Can anyone advise me on what I need to do? www.geekyfuroshiki.com 4 php 7.2 prestashop 1.7.5.1 Link to comment Share on other sites More sharing options...
dtwfung Posted March 9, 2020 Share Posted March 9, 2020 9 minutes ago, GeekyFuroshiki said: I have been preparing my site for a while now, and am now ready to go live with it. While I've been working, there has been a placeholder page with the message "We are currently updating our shop and will be back really soon. Thanks for your patience." I remember setting that in OVH control panel> Hosting plans> General Information (it was a while ago), but now I can't figure out how to deactivate that page and enable the site so that people can use it. I originally thought this was an OVH problem, but asking on the OVH forums people say that it is a Prestashop issue, quoting the following: curl --head -XGET --user-agent Firefox http://www.geekyfuroshiki.com/en/ HTTP/1.1 503 Service Unavailable X-Powered-By: PHP/7.2 Set-Cookie: PrestaShop-...domain=www.geekyfuroshiki.com; HttpOnly I had a look in Prestashop General Shop Parameters, the Enable Shop option is set to yes. I tried turning it off and on again, no difference. Can anyone advise me on what I need to do? www.geekyfuroshiki.com 4 php 7.2 prestashop 1.7.5.1 You should see "maintenance mode" on the top right corner in BO. Click on it and change it to non-maintenance. Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 9, 2020 Author Share Posted March 9, 2020 Whereabouts in BO, I don't see that in the top right, am I in the right area? Here's a grab of what I get: Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 9, 2020 Author Share Posted March 9, 2020 and I found this in the database, do I need to adjust this manually? If so, how do I do that? I'm wary of making my own changes to the db...! Link to comment Share on other sites More sharing options...
dtwfung Posted March 10, 2020 Share Posted March 10, 2020 (edited) 11 hours ago, GeekyFuroshiki said: Whereabouts in BO, I don't see that in the top right, am I in the right area? Here's a grab of what I get: BO means Prestashop Back Office. The screen about is Back office. But, "View my shop" on the top-right corner means your shop is already on production. Also You are NOT in maintenance mode. Try clicking the ""View my shop" see what happen , you should able to see your shop. Or directly type www.xxx.com...(I tried "http://www.geekyfuroshiki.com" but in maintenance mode) Let know your BO address (NO password) and I may able to check for you here ! Otherwise, check in your BO, Shop parameters -> Traffic & SEO -> Set Shop URL (See screen below), Hope this helps !! Cheers Edited March 10, 2020 by dtwfung (see edit history) Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 10, 2020 Author Share Posted March 10, 2020 I've been using the View my shop all the time while developing it, I thought it was just a preview rather than the live thing! The shop reached with View my shop is http://geekyfuroshiki.com/shop/index.php. The BO is http://geekyfuroshiki.com/shop/admin7032/index.php/configure/shop, is that what you need? Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 10, 2020 Author Share Posted March 10, 2020 Also, I just noticed that http://geekyfuroshiki.com/shop/index.php looks how I designed it on my home PC, but on my phone or other computers it looks different, with "lorem ipsum..." text blocks and incorrect menus etc, how has that happened? Link to comment Share on other sites More sharing options...
dtwfung Posted March 10, 2020 Share Posted March 10, 2020 (edited) 7 hours ago, GeekyFuroshiki said: Also, I just noticed that http://geekyfuroshiki.com/shop/index.php looks how I designed it on my home PC, but on my phone or other computers it looks different, with "lorem ipsum..." text blocks and incorrect menus etc, how has that happened? It seems you have TWO installations, one in root (i.e. what you see at http://geekyfuroshiki.com) and one in subfolder shop (i.e. http://geekyfuroshiki.com/shop), second one's BO is http://geekyfuroshiki.com/shop/admin7032/index.php/configure/shop, when you click "View my shop", you will see http://geekyfuroshiki.com/shop For accessing http://geekyfuroshiki.com, now is in maintenance mode. BO will be somehow http://geekyfuroshiki.com/adminXXX. You should see similar structure in subfolder "shop" is same as root ! that's why you have two appearances when accessing http://geekyfuroshiki.com (in maintenance mode) and http://geekyfuroshiki.com/shop (selling Japenese wrapping paper) First, you have to consider which one is the entry point you want your customers go ? Second, remove one root if you prefer customers go to "shop" one. and use "www redirect" to force customers from "http://geekyfuroshiki.com" to "http://geekyfuroshiki.com/shop" p.s. With the BO link, I cannot login unless I have login and password. Don't share here. I don't need this for this moment ! Edited March 10, 2020 by dtwfung (see edit history) 1 Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 10, 2020 Author Share Posted March 10, 2020 I'd rather they land at geekyfuroshiki.com, rather than xxx/shop. How do I remove a root, and where do I find www redirect? We had a faulty initial install of prestashop, and a friend advised I set up the prestashop module with the /shop extension to make it more stable, that's how this all came about. How do I get into the BO to disable the maintenance mode of http://www.geekyfuroshiki.com/? I've tried going to http://www.geekyfuroshiki.com/admin7032/ but only get the placeholder, no option to login. Link to comment Share on other sites More sharing options...
dtwfung Posted March 11, 2020 Share Posted March 11, 2020 4 hours ago, GeekyFuroshiki said: I'd rather they land at geekyfuroshiki.com, rather than xxx/shop. How do I remove a root, and where do I find www redirect? We had a faulty initial install of prestashop, and a friend advised I set up the prestashop module with the /shop extension to make it more stable, that's how this all came about. How do I get into the BO to disable the maintenance mode of http://www.geekyfuroshiki.com/? I've tried going to http://www.geekyfuroshiki.com/admin7032/ but only get the placeholder, no option to login. For removing PS installation, I use official way provided by my webservice provider. it is more safe way. Otherwise, normal root should contain .htaccess, php.ini,...... Of you can remove those folders with same directory names inside the sub-folder "shop". Leave the folder untouch should be ok or just disk usage issue, as long as you redirect your traffic to www.xxx.com/shop. For redirect, my host provides tool for me too. My online store installed in subfolder too. All customers will type www.xxx.com as an entry point and I redirect them to www.xxx.com/shop. I have www.xxx.com/test for cloning production data for testing purpose... You will need it and avoiding upgrade/patch directly to production environment !!! You may open the .htaccess file in the root and see what inside.... Make sure you know how it works....Otherwise, your customers/yourself are not able to access your installation anymore. Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 13, 2020 Author Share Posted March 13, 2020 (edited) I had a go at redirecting. Both www.xxx.com and xxx.com are already redirected to IP addresses, so it complained and I'm not sure whether it's safe to tinker with them. Is it simplest to move everything from xxx.com/shop down to the xxx.com level? How would I do that without losing my progress so far, do I need to back it all up somehow? Edited March 13, 2020 by GeekyFuroshiki (see edit history) Link to comment Share on other sites More sharing options...
dtwfung Posted March 13, 2020 Share Posted March 13, 2020 (edited) 41 minutes ago, GeekyFuroshiki said: I had a go at redirecting. Both www.xxx.com and xxx.com are already redirected to IP addresses, so it complained and I'm not sure whether it's safe to tinker with them. Is it simplest to move everything from xxx.com/shop down to the xxx.com level? How would I do that without losing my progress so far, do I need to back it all up somehow? Redirecting root traffic to subfolder is easier. You may ask your host provider or local technical support. (there is a sample .htaccess in the link below forwarding from root to a subfolder "prestashop".) Copy shop to root level can be done but need to modifying host file anyway You may refer here ( . (I never done this type of migration.I just migrate/copy PS installation to different subfolders. ), I recommended you keep the "shop" until you sure root copy is working properly. Either ways above, make sure you know how to make a FULL.BACKUP and knows HOW to restore it JUST IN CASE of migration failure. Edited March 13, 2020 by dtwfung (see edit history) Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 15, 2020 Author Share Posted March 15, 2020 I've backed up the DB and ftp files, then changed the Base URL in PS back office to "/" instead of "/shop/", then moved the shop folder up to the www. directory in ftp. I then tried to login to PS using the url without /shop, but now it says There is one error. The employee does not exist, or the password provided is incorrect. and I can't get in. Is there a way to correct this? Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 15, 2020 Author Share Posted March 15, 2020 Never mind that bit, I reset the password I'm into the BO and the "view my shop" is taking me to the root folder now, but it hasn't brought any of the work I've done with it, how can I put the files back into the right place? Link to comment Share on other sites More sharing options...
dtwfung Posted March 15, 2020 Share Posted March 15, 2020 (edited) 4 hours ago, GeekyFuroshiki said: Never mind that bit, I reset the password I'm into the BO and the "view my shop" is taking me to the root folder now, but it hasn't brought any of the work I've done with it, how can I put the files back into the right place? Woo... What a risky steps you have done ... You may have connected to the database previously linked to root's installation. Check /app/config/parameters.php ... whether 'database_name' => 'xxxx'', 'database_user' => 'xxxx', 'database_password' => 'xxxx',... Good luck ! Edited March 15, 2020 by dtwfung (see edit history) Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 15, 2020 Author Share Posted March 15, 2020 all that info is the database listed in the OVH BO, ( 'database_host' => 'geekyfurmg909.mysql.db', 'database_port' => '', 'database_name' => 'geekyfurmg909', 'database_user' => 'geekyfurmg909', 'database_password' => 'XXXXXXXX',), is there a more recent database that all the /shop stuff was under that I need to find and redirect it to? And if this doesn't work, is there a way to reinstall prestahop using the / url this time, and upload the original db/ftp files, or is it best to just start from scratch? Link to comment Share on other sites More sharing options...
dtwfung Posted March 15, 2020 Share Posted March 15, 2020 7 hours ago, GeekyFuroshiki said: all that info is the database listed in the OVH BO, ( 'database_host' => 'geekyfurmg909.mysql.db', 'database_port' => '', 'database_name' => 'geekyfurmg909', 'database_user' => 'geekyfurmg909', 'database_password' => 'XXXXXXXX',), is there a more recent database that all the /shop stuff was under that I need to find and redirect it to? And if this doesn't work, is there a way to reinstall prestahop using the / url this time, and upload the original db/ftp files, or is it best to just start from scratch? Check the old /app/config/parameters.php (previous at the root) and the one in shop/app/config/parameters.php... They should have TWO set of values for 'database_name'... The one in shop/app/config/parameters.php should be corrected one you have been working on ! If you don't know there are TWO sets of database, I don't know whether you have backup proper set ... Not to mention restoration... You may go directly to check them first !!! Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 17, 2020 Author Share Posted March 17, 2020 I can't figure it out, I think I'll start over. I delete and reinstall the prestashop module, then do I need to do anything to the Database? I'm worried I'm going to end up with a third load of data in there that is unneeded... Link to comment Share on other sites More sharing options...
dtwfung Posted March 18, 2020 Share Posted March 18, 2020 You don't need to remove database content. Because you don't know what you had backup, restoration will getting even worst. You just need to locate all databases and check the table `xxx_shop_url` (where xxx is your table prefix) (1) column `physical_uri` = '/' is for the installation in the root and (I guess it should be 'database_name' => 'geekyfurmg909', 'database_user' => 'geekyfurmg909' ) (2) column `physical_uri` = '/shop' is for the installation in the subfolder shop (TBD) Change the database_name/ database_user/database_password in /app/config/parameters.php based on (2) will do ! Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 18, 2020 Author Share Posted March 18, 2020 I only have one database in my OVH BO, geekyfurmg909. I went into that and looked for %_shop_url and found four possible tables, shown in the shot below ps_ lists the physical_url as '/', and the domain and domain_ssl as www.geekyfuroshiki.com. pre3201_ lists the physical_url as '/', and the domain and domain_ssl as geekyfuroshiki.com. mod651_ lists the physical_url as '/[[my username email address]]/', and the domain and domain_ssl as geekyfuroshiki.com. pre8351_ lists the physical_url as '/geekyfuroshiki.com/shop/', and the domain and domain_ssl as geekyfuroshiki.com. Based on that, is pre8351 the one I need the password for to put into database_name/ database_user/database_password in /app/config/parameters.php? Where can I find that password, is it in the database somewhere? And is there a significance to ps_ having www. in the domain, while the rest don't have it? Link to comment Share on other sites More sharing options...
dtwfung Posted March 19, 2020 Share Posted March 19, 2020 5 hours ago, GeekyFuroshiki said: I only have one database in my OVH BO, geekyfurmg909. I went into that and looked for %_shop_url and found four possible tables, shown in the shot below ps_ lists the physical_url as '/', and the domain and domain_ssl as www.geekyfuroshiki.com. pre3201_ lists the physical_url as '/', and the domain and domain_ssl as geekyfuroshiki.com. mod651_ lists the physical_url as '/[[my username email address]]/', and the domain and domain_ssl as geekyfuroshiki.com. pre8351_ lists the physical_url as '/geekyfuroshiki.com/shop/', and the domain and domain_ssl as geekyfuroshiki.com. Based on that, is pre8351 the one I need the password for to put into database_name/ database_user/database_password in /app/config/parameters.php? Where can I find that password, is it in the database somewhere? And is there a significance to ps_ having www. in the domain, while the rest don't have it? Glad...you found it. pre8351_... is the database set for shop. change it to Parameters.php. password should be same as geekyfurmg909, otherwise, you can reset it. with or without www is your preference only. You shop entry point Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 19, 2020 Author Share Posted March 19, 2020 I went into /app/config/parameters.php and changed the prefix to pre8351_, then went to the PS BO. Previously it was http://www.geekyfuroshiki.com/admin7032/, with the pre8351_ it becomes http://geekyfuroshiki.com/geekyfuroshiki.com/shop/admin7032/, presumably because it's listed as '/geekyfuroshiki.com/shop/' in the database and is adding an extra 'geekyfuroshiki.com'. Do I need to edit the database entry for pre8351_ to just '/shop'? Link to comment Share on other sites More sharing options...
dtwfung Posted March 19, 2020 Share Posted March 19, 2020 31 minutes ago, GeekyFuroshiki said: I went into /app/config/parameters.php and changed the prefix to pre8351_, then went to the PS BO. Previously it was http://www.geekyfuroshiki.com/admin7032/, with the pre8351_ it becomes http://geekyfuroshiki.com/geekyfuroshiki.com/shop/admin7032/, presumably because it's listed as '/geekyfuroshiki.com/shop/' in the database and is adding an extra 'geekyfuroshiki.com'. Do I need to edit the database entry for pre8351_ to just '/shop'? Your BO is http://www.geekyfuroshiki.com/admin7032/, your online shop should be http://www.geekyfuroshiki.com Database entry (physical_url) should be '/' only. domain and domain_ssl are www.geekyfuroshiki.com. p.s. "shop" was your old destination. Your previous reply said you moved to the root. Link to comment Share on other sites More sharing options...
GeekyFuroshiki Posted March 19, 2020 Author Share Posted March 19, 2020 I've altered the pre8351_shop_url to be '/', and now the BO is http://www.geekyfuroshiki.com/admin7032/, the view my shop gives http://www.geekyfuroshiki.com/gb, so I think that is straight now. I changed all the %shop_urls to be '/'. I've still only got the template basics at http://www.geekyfuroshiki.com/gb, though, none of the work I did, is that recoverable, or do I need to build it up again from here? Link to comment Share on other sites More sharing options...
dtwfung Posted March 19, 2020 Share Posted March 19, 2020 (edited) 35 minutes ago, GeekyFuroshiki said: I've altered the pre8351_shop_url to be '/', and now the BO is http://www.geekyfuroshiki.com/admin7032/, the view my shop gives http://www.geekyfuroshiki.com/gb, so I think that is straight now. I changed all the %shop_urls to be '/'. I've still only got the template basics at http://www.geekyfuroshiki.com/gb, though, none of the work I did, is that recoverable, or do I need to build it up again from here? You should know what you did, For example, products, categories, ... Check database on product, categories table whether there is any works you did ? Theme/template may be due to configuration problem. Edited March 19, 2020 by dtwfung (see edit history) 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