Going from Test environment to Live environment - a few questions

tomowensphoto · 2016-06-12 22:47:31

Good afternoon/evening/morning Chaps,
OK, I made the big decision to migrate my new site to the live environment having developed it in my test domain (see link at footer)

I erroneously (as I have found out) assumed that if I copied my development files to the root of my domain and then edited the settings in Backlight/Admin that and Publisher (authenticated OK) to point at the parent directory that all would be OK. The answer is No.

I had decided not to migrate CE4 galleries as one of the opportunities of the new site was a housekeeping exercise.

When I try and save the Backlight admin settings, I get a rather obvious (with hindsight) big red SQL error.

I can get the Live site to display OK but if I click a menu item I get taken down a level to my test domain which at the moment is identical to the top level in content.

I have floundered around trying to find out what the path is from development environment to live environment and I am struggling to find what I ought to have done, and what I need to do to rectify the situation, without losing the templates and content.

As always, grateful for any advice. The Live domain is as below but missing the /test/

Regards
TomO

rod barbee · 2016-06-12 22:54:49

When moving sites between domains this is what I've done:
Download everything from test domain to my PC.
Upload same to new domain.
(You could just move all the files and folders. I prefer copying so that I still have a test site to experiment with)
Log in to Backlight in new domain and go to Settings.
Change Site and Company URL and save settings.

If you've uploaded any images for the rest site using the Backlight uploaded, you may need to upload them again. So check to make sure they're appearing where you expect them to.
They're supposed to come along for the ride but in my experience, they sometimes don't.

tomowensphoto · 2016-06-12 23:06:58

Hi Rod,
My process is the same as you have outlined. I wanted to keep the useful /test domain for further testing etc. When I try and save Company and Site URLs I get this message.

Something went wrong

Update query failed with error: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database sql: 'UPDATE `settings` SET `key`=\'COMPANY_URL\', `value`=\'http://tomowens.openpoint.co.uk\', `modified`=\'2016-06-12 14:00:16\' WHERE `key`=\'COMPANY_URL\'' params: array ( ) in PdoExtended.php on line 552

Regards,
TomO

tomowensphoto · 2016-06-13 00:41:26

I cannot republish from Lightroom to this new location as I get the same error. How does the database or how do the databases go into read only mode by downloading from the webserver to Mac and uploading back to the root of the domain?
Regards,
TomO

rod barbee · 2016-06-13 00:53:40

Ben will have to answer. Have you looked at permissions on those files?

tomowensphoto · 2016-06-13 01:14:09

Hi Rod,
I've checked the test directory permissions against the live. They look the same unless my eyes are getting tired.
Question - When one copies down the test site to the local machine in order to FTP it back up to the root does one have to clear out the album sets and album structure in Publisher first as all the database records will be pointing at the test location?
Then one has to re-publish the sets and albums again. That somehow does not feel right as a fair bit of time is spent in getting the pages to look right with the the right text /content in test.
Regards,
TomO

@Ben, the remote login credentials are still the same

rod barbee · 2016-06-13 01:43:51

When one copies down the test site to the local machine in order to FTP it back up to the root does one have to clear out the album sets and album structure in Publisher first as all the database records will be pointing at the test location?

No, you shouldn't have to do that. The albums and sets I had in one test domain were there when I moved everything to another. domain.
The Publisher API url will need to be changed in Lightroom.

tomowensphoto · 2016-06-13 01:51:08

I'd done the Publisher URL Rod - I've just pointed it back to the /test domain to remove an album and that worked as I expected. I'll leave that as it is for the moment. At least I seem to have done things the way you would have for this basic migration. I'll have to wait for Ben to take a look. He has had to wade through the back end on my ISP account before so I'm sure he will have an answer.
Regards,
TomO

tonesshots · 2016-06-13 04:30:07

I have a similar but not exactly the same as you Tom. If I try a non existent URL on your site such as http://tomowens.openpoint.co.uk/test/galleries/rubbish I would expect to get an error message as there is no such gallery. I get a top level galleries display on your site instead just as I do on mine. See my post today about this topic.
Tony P

Ben · 2016-06-13 08:12:33

That error is not related to this topic. Please see my reply in the other thread.

Ben · 2016-06-13 08:21:11

Hi Tom, the problem here is due to file ownership. The database files under test were copied from Backlight into the data directory by the web server. They've been given the user and group httpd / httpd. I have tried to set the user and group via FTP but it wasn't allowed.

Do you have a way of setting the user and group for these directories? If you have SSH access then doing so as sudo would work.

The directories to change (including all contents within):

backlight/data/admin/
backlight/data/designer/
backlight/data/publisher/
backlight/data/sessions/

I have another strategy to fix this if you're not able to change the user and group.

tomowensphoto · 2016-06-13 14:42:58

Hi Ben,
I do not have SSH access.
I downloaded the test environment to my local machine via FTP and then uploaded the files and directories to tomowens.openpoint.co.uk via FTP. I'm hoping your Plan B will work.
Regards,
TomO

Ben · 2016-06-13 16:16:40

Hi Tom, it would be easier for me to run plan B on your behalf. Are you happy for me to try and fix this via your FTP?

The method will be to replace the default master.sq3 places within the backlight application directories with those from your test site, move the files aside from backlight/data/ on your new site, and have Backlight automatically copy the new default databases into backlight/data/

tomowensphoto · 2016-06-13 16:58:20

Fine Ben, please proceed. I have to get on video confs for a while to sort out other work stuff so I will not be on the webserver.
Let me know via email what you had to do and if there is anything I ought to have done in my migration.
Many thanks,
TomO

Ben · 2016-06-13 19:49:53

Hi Tom, I had success with what I was attempting, but it doesn't solve the whole problem. Please see my email.

tomowensphoto · 2016-06-13 20:31:15

Thanks Ben. Have replied and also written to ISP instructing them to add owner permissions. I really appreciate your help as always. I'll let you know when something happens. The ISP is not nearly so quick as you chaps.
Regards
TomO

Last edited by tomowensphoto (2016-06-14 04:31:48)

tomowensphoto · 2016-06-13 21:45:22

Progress Ben.
Permissions/ownership changed by ISP. Galleries pages now working.
Having problems with Error 404 clicking on
Home
About/Privacy Policy
Exhibitions
Contact

Search and Blog menu items are OK. Have tried clearing cache.
Getting there. Any ideas for the 404's?
Regards,
TomO

Daniel Leu · 2016-06-13 21:51:35

Having problems with Error 404 clicking on
Home
About/Privacy Policy
Exhibitions
Contact

They work for me.

tomowensphoto · 2016-06-13 22:03:36

That is good news Daniel. I'll keep at it here.
Regards,
TomO

tomowensphoto · 2016-06-13 22:23:59

I thought this was working on the iPhone and iPad but the cached pages were still pointing at the /test/ sub-domain
Error 404 in Firefox and Safari for every page listed above.
Regards,
TomO

Last edited by tomowensphoto (2016-06-13 22:24:13)

Daniel Leu · 2016-06-13 22:26:32

Sorry, Tom, I had clicked on the link in your signature that goes to the test site and not the main site and didn't notice this.... Get the same error on your main page ... :-(

Daniel Leu · 2016-06-13 22:28:14

Just one thought: you did copy the .htaccess over from your test site, didn't you?

tomowensphoto · 2016-06-13 22:33:27

Ben had to go in to the back end and copy stuff for me. I 'll check that out but in the meantime I have got the other pages to open by changing from URL to page in the menu set. Galleries, Search and Blog are all URL setting that I have left as such. The rest have been changed from URL to Page.
Does this suggest anything?
Regards,
TomO

tomowensphoto · 2016-06-13 22:42:24

Now this shows my ignorance of these things.
One of my initial problems when BL first came out was accessing the SQLite from the link. I had to place a line in .htaccess to sort that out. There are many .htaccess files cascading down the tree so I made that edit in the root of tomowens.openpoint.co.uk and I was able to access the database to delete orphans in v101. I can see that the .htaccess sitting at the top level of my test directory structure is very much larger

This is what is in the .htaccess at the top level of tomwens.openpoint.co.uk

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /blog/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
php_flag register_globals off

This is what is in the top level of /test
<IfModule mod_rewrite.c>
RewriteEngine On

############################################################################
# Edit this section for servers using FastCGI

# For FastCGI (or seeing the error message 'No input file specified.':
# add # to the start of the next line
RewriteBase /

RewriteCond $0#%{REQUEST_URI} ([^#]*)#(.*)\1$

# For FastCGI (or seeing the error message 'No input file specified.':
# add # to the start of the next line and remove # from the line after)
RewriteRule ^.*$ - [E=BASE:%2]
#RewriteRule ^(.*)$ - [E=BASE:]

############################################################################

RewriteRule ^(.*)$ - [E=QS:mod_rewrite=on]

RewriteRule ^([^\/.]*)-single.php$ %{ENV:BASE}single.php?%{ENV:QS}&id=$1 [QSA,L]

RewriteRule ^([^\/.]*).css$ %{ENV:BASE}index.php?%{ENV:QS}&extension=css&name=$1 [QSA,L]
RewriteRule ^([^\/.]*).js$ %{ENV:BASE}index.php?%{ENV:QS}&extension=js&name=$1 [QSA,L]
RewriteRule ^([^\/.]*).gif$ %{ENV:BASE}index.php?%{ENV:QS}&extension=gif&name=$1 [QSA,L]
RewriteRule ^([^\/.]*).png$ %{ENV:BASE}index.php?%{ENV:QS}&extension=png&name=$1 [QSA,L]
RewriteRule ^([^\/.]*).jpg$ %{ENV:BASE}index.php?%{ENV:QS}&extension=jpg&name=$1 [QSA,L]

#RewriteCond %{QUERY_STRING} !mod_rewrite=on
#RewriteRule ^index.php$ %{ENV:BASE}index.php?%{ENV:QS} [QSA,L]

RewriteCond %{QUERY_STRING} !mod_rewrite=on
RewriteRule ^mobile.php$ %{ENV:BASE}mobile.php?%{ENV:QS} [QSA,L]

RewriteCond %{QUERY_STRING} !mod_rewrite=on
RewriteRule ^(.*)download.php %{ENV:BASE}download.php?%{ENV:QS} [QSA,L]

RewriteRule ^$ %{ENV:BASE}index.php?%{ENV:QS} [QSA,L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^(.*)$ %{ENV:BASE}index.php?%{ENV:QS}&page=$1 [QSA,L]

</IfModule>

Which one should have the php_flag register_globals off line in it and what about the content in the small one anyway? This is a danger zone for me.
Regards,
TomO

tomowensphoto · 2016-06-13 23:01:50

Spoke too soon. Intermittent 404 errors now even with Page links.
Regards,
TomO

Community @ The Turning Gate

#1 2016-06-12 22:47:31

Going from Test environment to Live environment - a few questions

#2 2016-06-12 22:54:49

Re: Going from Test environment to Live environment - a few questions

#3 2016-06-12 23:06:58

Re: Going from Test environment to Live environment - a few questions

#4 2016-06-13 00:41:26

Re: Going from Test environment to Live environment - a few questions

#5 2016-06-13 00:53:40

Re: Going from Test environment to Live environment - a few questions

#6 2016-06-13 01:14:09

Re: Going from Test environment to Live environment - a few questions

#7 2016-06-13 01:43:51

Re: Going from Test environment to Live environment - a few questions

#8 2016-06-13 01:51:08

Re: Going from Test environment to Live environment - a few questions

#9 2016-06-13 04:30:07

Re: Going from Test environment to Live environment - a few questions

#10 2016-06-13 08:12:33

Re: Going from Test environment to Live environment - a few questions

#11 2016-06-13 08:21:11

Re: Going from Test environment to Live environment - a few questions

#12 2016-06-13 14:42:58

Re: Going from Test environment to Live environment - a few questions

#13 2016-06-13 16:16:40

Re: Going from Test environment to Live environment - a few questions

#14 2016-06-13 16:58:20

Re: Going from Test environment to Live environment - a few questions

#15 2016-06-13 19:49:53

Re: Going from Test environment to Live environment - a few questions

#16 2016-06-13 20:31:15

Re: Going from Test environment to Live environment - a few questions

#17 2016-06-13 21:45:22

Re: Going from Test environment to Live environment - a few questions

#18 2016-06-13 21:51:35

Re: Going from Test environment to Live environment - a few questions

#19 2016-06-13 22:03:36

Re: Going from Test environment to Live environment - a few questions

#20 2016-06-13 22:23:59

Re: Going from Test environment to Live environment - a few questions

#21 2016-06-13 22:26:32

Re: Going from Test environment to Live environment - a few questions

#22 2016-06-13 22:28:14

Re: Going from Test environment to Live environment - a few questions

#23 2016-06-13 22:33:27

Re: Going from Test environment to Live environment - a few questions

#24 2016-06-13 22:42:24

Re: Going from Test environment to Live environment - a few questions

#25 2016-06-13 23:01:50

Re: Going from Test environment to Live environment - a few questions

Board footer