Body: <p>Shared LAMP hosting • WordPress 6.0.1 • Using CiviCRM for over a decade on Dreamhost • Current CiviCRM version: 5.38.0</p>
  <p><strong>First Question:</strong></p>
  <p>I'd like the ESR 5.45, as recommended, but when I go to this page,</p>
  <p><a href="https://lab.civicrm.org/esr/core/-/releases" rel="nofollow noreferrer">https://lab.civicrm.org/esr/core/-/releases</a></p>
  <p>as suggested here:</p>
  <p><a href="https://civicrm.stackexchange.com/questions/33892/where-to-download-5-13-7-esr/33904#33904">Where to Download 5.13.7 ESR</a></p>
  <p>or even if I log with a CiviCRM account in and click the link to the same destination, I get a 404.</p>
  <p>I know thinking of CiviCRM as a WordPress plugin is a bit like the tail wagging the dog, but is it possible there might just be a list of releases like they do with WordPress, easily accessible and zipped for download for WordPress and other CMS users without having to use Git? Including the ESR versions? Because documentation suggests such a page existed once... Why was it removed? (Okay that's a third, ancillary question.)</p>
  <p><strong>Second Question:</strong></p>
  <p>When I try to install CiviCRM 5.52.0, I get this response:</p>
  <blockquote>
  <p>CiviCRM 5.52.0 requires MySQL trigger privileges</p>
  </blockquote>
  <p>Dreamhost shared hosting doesn't allow triggers. So I reinstalled the old CiviCRM 5.38.</p>
  <p>If the ESR 5.45 requires triggers, we'll need to try a different hosting situation. Shoestring budget here... I've been keeping this updated since 2006. Does the latest ESR (5.45.7) require triggers? Version 5.38.0 apparently doesn't. If so, I'll need to look at more advanced MySQL hosting options.</p>
  <p>Thanks in advance.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T01:43:23.270Z
Comments.Text: A couple clarifications: That trigger message has been there for years - did something change at dreamhost? For ESR, maybe you already know but you have to log in to civicrm.org using an account that has paid for ESR, otherwise you will get a 404. For git, I'm not sure what you mean - the civicrm wordpress download is a zip file, e.g. https://download.civicrm.org/civicrm-5.52.1-wordpress.zip
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T01:49:45.830Z
Comments.Text: Thanks for your reply. | Yes, apparently dreamhost used to allow triggers. Any existing triggers may stay. However new triggers are apparently now disallowed on shared hosting. Yes, I've logged in on CiviCRM.org to get the file. Except it still says it's 404 when I get to the crucial link. | There is no obvious page at civicrm.org that includes all previous versions of WordPress zips for CiviCRM. At least I couldn't find it. 5.52.1 will not install because of the trigger thing.
Comments.UserDisplayName: Chris
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T02:06:43.020Z
Comments.Text: There's an archive of downloads at https://sourceforge.net/projects/civicrm/files/civicrm-stable. For ESR, if you're sure the account you're logging in with has paid the ESR fee for access, then you could try either emailing info@civicrm.org or contact Josh in https://chat.civicrm.org.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T02:10:02.737Z
Comments.Text: Thanks for the link. I wasn't aware of a fee for access to ESR. I just created an account.
Comments.UserDisplayName: Chris
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T02:10:51.200Z
Comments.Text: Sign up for ESR here: https://civicrm.org/civicrm/contribute/transact?reset=1&id=64, but NOTE: 5.45 is 6 months old - the next ESR will be 5.51, and then you will have the same trigger problem.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-13T03:03:49.290Z
Comments.Text: Unfortunately, still the same trigger problem with the 5.45 update. Just tried. Obviously dreamhost yanked a privilege. I understand why ESR might be a subscriber paid service, but unfortunately our 501c3 isn't in the position to pay. So... Looking into other options. I truly appreciate your help in this!
Comments.UserDisplayName: Chris
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-14T21:13:28.390Z
Comments.Text: 2006 is impressive. any reason to go for ESR rather than standard release?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-16T18:45:58.413Z
Comments.Text: Yeah, 2006! I was hoping the latest ESR was close enough to my current version that it wouldn't add new triggers. It did. Apparently upgrading to MySQL 8 has changed how privileges are managed on shared hosting for Dreamhost. MySQL VPS is out of our budget. So I'm looking at transferring to an alternative free CRM for this non-profit.
Comments.UserDisplayName: Chris
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-22T12:29:02.610Z
Comments.Text: Standard Civi is free, it's just the extended support aspect that isn't. Why not switch to other hosting that supports Civi?  eg civihosting.com
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-29T03:10:03.243Z
Comments.Text: @Aidan, Civihosting costs about the same as adding MySQL VPS at even the lowest price level, and we're pretty dug in at the free hosting available for non-profits on Dreamhost. I'm talking with a specialist at TechSoup to learn more no-cost options. If there is an option I've missed, please let me know. Thanks!
Comments.UserDisplayName: Chris
Tags: <wordpress><trigger><esr><shared-hosting>
Title: 2 Questions: Where to download CiviCRM for wordpress v5.45 ESR? Triggers Required?
ThreadText: # 2 Questions: Where to download CiviCRM for wordpress v5.45 ESR? Triggers Required?
  
  (Asked by: username_0 on 2022-08-12)
  
  Shared LAMP hosting • WordPress 6.0.1 • Using CiviCRM for over a decade on Dreamhost • Current CiviCRM version: 5.38.0
  
  **First Question:**
  
  I'd like the ESR 5.45, as recommended, but when I go to this page,
  
  <https://lab.civicrm.org/esr/core/-/releases>
  
  as suggested here:
  
  [Where to Download 5.13.7 ESR](https://civicrm.stackexchange.com/questions/33892/where-to-download-5-13-7-esr/33904#33904)
  
  or even if I log with a CiviCRM account in and click the link to the same destination, I get a 404.
  
  I know thinking of CiviCRM as a WordPress plugin is a bit like the tail wagging the dog, but is it possible there might just be a list of releases like they do with WordPress, easily accessible and zipped for download for WordPress and other CMS users without having to use Git? Including the ESR versions? Because documentation suggests such a page existed once... Why was it removed? (Okay that's a third, ancillary question.)
  
  **Second Question:**
  
  When I try to install CiviCRM 5.52.0, I get this response:
  
  > CiviCRM 5.52.0 requires MySQL trigger privileges
  
  Dreamhost shared hosting doesn't allow triggers. So I reinstalled the old CiviCRM 5.38.
  
  If the ESR 5.45 requires triggers, we'll need to try a different hosting situation. Shoestring budget here... I've been keeping this updated since 2006. Does the latest ESR (5.45.7) require triggers? Version 5.38.0 apparently doesn't. If so, I'll need to look at more advanced MySQL hosting options.
  
  Thanks in advance.
  
  **Tags:** wordpress, trigger, esr, shared-hosting
  
  > **Comments:**
  > **username_1**: A couple clarifications: That trigger message has been there for years - did something change at dreamhost? For ESR, maybe you already know but you have to log in to civicrm.org using an account that has paid for ESR, otherwise you will get a 404. For git, I'm not sure what you mean - the civicrm wordpress download is a zip file, e.g. https://download.civicrm.org/civicrm-5.52.1-wordpress.zip  
  > **username_0**: Thanks for your reply. | Yes, apparently dreamhost used to allow triggers. Any existing triggers may stay. However new triggers are apparently now disallowed on shared hosting. Yes, I've logged in on CiviCRM.org to get the file. Except it still says it's 404 when I get to the crucial link. | There is no obvious page at civicrm.org that includes all previous versions of WordPress zips for CiviCRM. At least I couldn't find it. 5.52.1 will not install because of the trigger thing.  
  > **username_1**: There's an archive of downloads at https://sourceforge.net/projects/civicrm/files/civicrm-stable. For ESR, if you're sure the account you're logging in with has paid the ESR fee for access, then you could try either emailing info@civicrm.org or contact Josh in https://chat.civicrm.org.  
  > **username_0**: Thanks for the link. I wasn't aware of a fee for access to ESR. I just created an account.  
  > **username_1**: Sign up for ESR here: https://civicrm.org/civicrm/contribute/transact?reset=1&id=64, but NOTE: 5.45 is 6 months old - the next ESR will be 5.51, and then you will have the same trigger problem.  
  > **username_0**: Unfortunately, still the same trigger problem with the 5.45 update. Just tried. Obviously dreamhost yanked a privilege. I understand why ESR might be a subscriber paid service, but unfortunately our 501c3 isn't in the position to pay. So... Looking into other options. I truly appreciate your help in this!  
  > **username_2**: 2006 is impressive. any reason to go for ESR rather than standard release?  
  > **username_0**: Yeah, 2006! I was hoping the latest ESR was close enough to my current version that it wouldn't add new triggers. It did. Apparently upgrading to MySQL 8 has changed how privileges are managed on shared hosting for Dreamhost. MySQL VPS is out of our budget. So I'm looking at transferring to an alternative free CRM for this non-profit.  
  > **username_3**: Standard Civi is free, it's just the extended support aspect that isn't. Why not switch to other hosting that supports Civi?  eg civihosting.com  
  > **username_0**: @username_3, Civihosting costs about the same as adding MySQL VPS at even the lowest price level, and we're pretty dug in at the free hosting available for non-profits on Dreamhost. I'm talking with a specialist at TechSoup to learn more no-cost options. If there is an option I've missed, please let me know. Thanks!  
  
  ---
  
  ## 0 answers
  
  