Hello all. Apologies in advance for a long explanatory post. As per previous post because I am desperate. Our web site in Drupal 7.34 ceased to work publicly yesterday afternoon. I loaded the new Skeleton theme via /themes/ [Install New theme] all worked well. I changed the css so that the page had a background colour, all worked for 3-4 hours then stopped with browser errors. Safari in the url field flicks between /domain/index.html and domain/folder/?=index.php about 20 times then fails. Chromium fails with Web page not available Firefox fails with This page isn't redirecting properly. - There are no redirects other than in Drupal index.php. Google is no help so far. I reset the theme to the original mayo, cleared cache, worked once then failed so reverted to core Bartik and cleared caches every alteration but problem exists. Now I find in cPanel/phpmyadmin that Drupal 7 has not cleared the database caches and apparently never does so, the caches contain reference to other themes and redundant data, so what's the point of Drupal Clear Cache if it doesn't clear the data. When I last used drush cc all via ssh terminal it destroyed the database making it unusable so we reverted to an earlier version. Therefore Drush is not an option, too dangerous. I fresh installed drupal-7.34 on the server, copied the /sites folder to the new install, /settings.php refers to the original database, started it and it too fails. So either something in the sites folder or in the database is damaged, so I am really stuck and would appreciate help. Deleting the Skeleton theme and clearing caches does not remove traces from the database caches. I have 3 other drupal 7 installs and all work perfectly, only the main one fails. So a question would be, If I created a new database in cPanel then dumped each table one at a time from the original but not the caches into it what would that do, would it work? What I also do not understand is, when I url to www.domain/directory/user everything works, the theme works login works and loging in as Admin the theme and site is perfect but as anonymous user browsers fail. Waving the white flag here and need help desperately Thank you in advance Roger
Hi, I've created a donation system using CRM and Drupal Commerce. I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table. Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country. That is stored in Drupal commerce as the billing address and not CRM. What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this. Yani
This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <akayani@aapt.net.au> wrote:
Hi,
I've created a donation system using CRM and Drupal Commerce.
I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table.
Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country.
That is stored in Drupal commerce as the billing address and not CRM.
What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this.
Yani
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and with that bit of encouragement sorted it. Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <akayani@aapt.net.au> wrote: Hi, I've created a donation system using CRM and Drupal Commerce. I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table. Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country. That is stored in Drupal commerce as the billing address and not CRM. What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this. Yani -- [ Drupal support list | http://lists.drupal.org/ ] -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
Too easy but it has created a problem I didn’t notice. The information is now not available to all users. Requires an admin log on to see. It doesn’t seem to be resolved via any changes in permissions. Is there something special that happens here? Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: support@drupal.org Subject: Re: [support] Adding an additional table to views Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and with that bit of encouragement sorted it. Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <akayani@aapt.net.au> wrote: Hi, I've created a donation system using CRM and Drupal Commerce. I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table. Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country. That is stored in Drupal commerce as the billing address and not CRM. What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this. Yani -- [ Drupal support list | http://lists.drupal.org/ ] -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
I find that happens when I've added an incorrect relationship. Make sure you remove any relationships the view does not need. Tracey -------------------- Tracey Hummel IT Director Sagent Labs tracey@sagentlabs.com ________________________________ From: support-bounces@drupal.org [support-bounces@drupal.org] on behalf of Yasni [akayani@aapt.net.au] Sent: Saturday, January 24, 2015 5:27 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views Too easy but it has created a problem I didn’t notice. The information is now not available to all users. Requires an admin log on to see. It doesn’t seem to be resolved via any changes in permissions. Is there something special that happens here? Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: support@drupal.org Subject: Re: [support] Adding an additional table to views Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and with that bit of encouragement sorted it. Yani From: support-bounces@drupal.org<mailto:support-bounces@drupal.org> [mailto:support-bounces@drupal.org] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: support@drupal.org<mailto:support@drupal.org> Subject: Re: [support] Adding an additional table to views This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <akayani@aapt.net.au<mailto:akayani@aapt.net.au>> wrote: Hi, I've created a donation system using CRM and Drupal Commerce. I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table. Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country. That is stored in Drupal commerce as the billing address and not CRM. What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this. Yani -- [ Drupal support list | http://lists.drupal.org/ ] -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
There is only one relationship. I think it has something to do with pulling an address from Billing in Drupal Commerce but it didn't matter what permissions I gave things either within the roles or within view it rendered the display without data (some message I can't remember). No issues when I was logged in. Anyway I've thrown the idea away. Now the site is live I'm seeing a few issues but I'm going to leave it until I use this config again rather than muck up the data or the site now it is live. Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Hummel, Tracey S - (thummel) Sent: Sunday, 25 January 2015 2:37 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views I find that happens when I've added an incorrect relationship. Make sure you remove any relationships the view does not need. Tracey -------------------- Tracey Hummel IT Director Sagent Labs tracey@sagentlabs.com _____ From: support-bounces@drupal.org [support-bounces@drupal.org] on behalf of Yasni [akayani@aapt.net.au] Sent: Saturday, January 24, 2015 5:27 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views Too easy but it has created a problem I didn't notice. The information is now not available to all users. Requires an admin log on to see. It doesn't seem to be resolved via any changes in permissions. Is there something special that happens here? Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Yasni Sent: Saturday, 24 January 2015 7:09 PM To: support@drupal.org Subject: Re: [support] Adding an additional table to views Thanks... I watched this http://nodeone.se/en/relation-and-views-pt-1 and with that bit of encouragement sorted it. Yani From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Steve Kessler Sent: Saturday, 24 January 2015 6:26 AM To: support@drupal.org Subject: Re: [support] Adding an additional table to views This should not be too bad. You need to make a relationship in views with (probably) the Commerce Order. Once you add the relationship you can then use the fields from table in the relationship. -Steve On Friday, January 23, 2015, Yasni <akayani@aapt.net.au> wrote: Hi, I've created a donation system using CRM and Drupal Commerce. I have a view for the most recent 10 donations. All the details I need are being returned from the CRM table. Now after the site has gone live the client recognises that in this list of 10 recent donation is missing the Country. That is stored in Drupal commerce as the billing address and not CRM. What I need is a few really good references for how to add additional tables to views. And likely a bit of advice on the complexity of doing this. Yani -- [ Drupal support list | http://lists.drupal.org/ ] -- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
participants (4)
-
Hummel, Tracey S - (thummel) -
Roger -
Steve Kessler -
Yasni