Melbourne Meetups issueshttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues2022-11-18T10:21:01Zhttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/31CiviCrm Upgrade error2022-11-18T10:21:01ZmarkdevarajCiviCrm Upgrade errorhi,
I was looking to upgrade my current version of CiviCrm 5.28.3 to 5.36.0 and was getting the following error - see attached files too which has a screen shot and a copy of the log file.
The upgrade fails at upgrade to 5.31.alpha1
|...hi,
I was looking to upgrade my current version of CiviCrm 5.28.3 to 5.36.0 and was getting the following error - see attached files too which has a screen shot and a copy of the log file.
The upgrade fails at upgrade to 5.31.alpha1
| Error Field | Error Value |
|-------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Type | DB_Error |
| Code | -1 |
| Message | DB Error: unknown error |
| Mode | 16 |
| UserInfo | ALTER TABLE civicrm_group CHANGE `title` `title` varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes] |
| DebugInfo | ALTER TABLE civicrm_group CHANGE `title` `title` varchar(255) DEFAULT NULL COMMENT 'Name of Group.' [nativecode=1071 ** Specified key was too long; max key length is 767 bytes] |
Does anyone know how to fix this?
cheers
mark
![Screen_Shot_2021-06-04_at_2.10.42_pm](/uploads/c1dea707294f13740cdc40afdb1fc3be/Screen_Shot_2021-06-04_at_2.10.42_pm.png)
![Screen_Shot_2021-06-04_at_2.14.21_pm](/uploads/735e517da4871c7028ac386ae514f7a5/Screen_Shot_2021-06-04_at_2.14.21_pm.png)https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/28Errors in ConfigAndLog 21 Nov 20202020-11-26T22:21:32ZmarkdevarajErrors in ConfigAndLog 21 Nov 2020Hello all,
I'm wondering if anyone has seen these errors and how to resolve them.
[Errors_ConfigAndLog_Nov_21_2020.docx](/uploads/a3c3853539544dad2d8c4b9ea3297ce9/Errors_ConfigAndLog_Nov_21_2020.docx)
My environment
Wordpress 5.5.3...Hello all,
I'm wondering if anyone has seen these errors and how to resolve them.
[Errors_ConfigAndLog_Nov_21_2020.docx](/uploads/a3c3853539544dad2d8c4b9ea3297ce9/Errors_ConfigAndLog_Nov_21_2020.docx)
My environment
Wordpress 5.5.3
Civicrm 5.28.3
Mosaico 2.5.1597918155
We do have intermittent problems with saving working mosaico newsletters/templates
Thanks in Advancehttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/26Server migration2020-09-21T08:17:35Zdavid.hohmServer migrationHello,
sorry for what is probably a ridiculous question.
Our wordpress site was migrated to a new server by our host, the domain is unchanged. Now several of the CIVICRM features are not working anymore. Such as payment processing for e...Hello,
sorry for what is probably a ridiculous question.
Our wordpress site was migrated to a new server by our host, the domain is unchanged. Now several of the CIVICRM features are not working anymore. Such as payment processing for example or signing up to our newsletter. One of the issues for example is our stripe webhook failing as it now can't reach https://example.org.au/?page=CiviCRM&q=civicrm/payment/ipn/3. When I try to go to the live links for contribution pages, it just shows: "Do not delete this page. Page content is generated by CiviCRM."
I've cleared the cache and reset the paths and looked at the civicrm.settings.php files but couldn't find a place where I had to link to a new IP address. I've also looked for a guide on the CiviCRM page but was unable to find clear instructions on what to do.
If someone can point me in the right direction it would be super appreciated, thank you for the help
cheers, Davidhttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/23Conditional statements with CiviMail templates2020-05-04T01:28:38Zrenz56c.oConditional statements with CiviMail templatesThis is something basic that I should know how to do by now but don't!
has anyone else got a conditional statement in their civimail templates that replaces Dear contact.first_name with another value if there is no first name for that c...This is something basic that I should know how to do by now but don't!
has anyone else got a conditional statement in their civimail templates that replaces Dear contact.first_name with another value if there is no first name for that contact?
Something along the lines of:
{if $contact.first_name}
Hi {$contact.first_name},
{else}
Hi there,
Next question can you insert such code into Mosaico templates?
Thanks if anyone in the group might know,
Renaee.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/22CiviMail setting to use Google's smtp servers - this is not an issue but info...2020-03-30T02:42:20ZmarkdevarajCiviMail setting to use Google's smtp servers - this is not an issue but info if you are having issues with google smtpHello All
This is not an issue but info for others if you are having problems setting up CiviMail to send mail thru Google SMTP service.
We use a Gsuite account for our mail. We setup 3x email accounts on Gsuite to catch the bounce, a...Hello All
This is not an issue but info for others if you are having problems setting up CiviMail to send mail thru Google SMTP service.
We use a Gsuite account for our mail. We setup 3x email accounts on Gsuite to catch the bounce, an email account to send from and email to activity account.
After much trial and error and reading all the posts on CivMail to Google issues, the setting that worked for us is as follows:-
SMTP Server: ssl://smtp.gmail.com
SMTP Port: 465
Authentication : Yes
SMTP Username : xxxxx@melbournecameraclub.org.au
SMTP Password :xxxxxxx
we send under 500 emails weekly from a Civi mailing list.
Settings - for CiviMail
Mailer Batch limit = 100
Mailer throttle Time =1000000 (micro secs)
Mailer Job size =0
Mailer Cron Job limit =0
very separator = .
Enable custom reply to =no
Cron was setup to execute job.execute every 5 mins (*/5 * * * * etc)
Cron was setup to execute fetch bounces on the hour (0 * * * * etc)
We sent 460 emails in just under 25mins as mail was sent in 100 email batches every 5 mins. Speed of email delivery is not important for us as it is just a weekly newsletter.
Bounces was recorded in Civi reports correctly.
I hope that this helps someone.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/21Nextgen Gallery plugin on WP stops Civicrm Scheduled jobs from running2020-03-27T03:46:38ZmarkdevarajNextgen Gallery plugin on WP stops Civicrm Scheduled jobs from runningWe are running Civicrm 5.14.1 on Wordpress(WP) and have encountered that the latest Update of NextGen Gallery (v3.3.0) stops Civicrm Scheduled jobs from running. We were running NextGen Gallery without any issues until the latest upgrade...We are running Civicrm 5.14.1 on Wordpress(WP) and have encountered that the latest Update of NextGen Gallery (v3.3.0) stops Civicrm Scheduled jobs from running. We were running NextGen Gallery without any issues until the latest upgrade to v3.3.0.
Once we deactivated this plugin Civicrm Scheduled jobs started working again.
Has anyone else encountered this issue? Any suggested solutions?https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/20Pausing autorenewal memberships2020-03-27T03:31:42Zdavid.hohmPausing autorenewal memberships
with the current covid-19 situations and mandatory closures, we are investigating ways to 'pause' autorenewals. The idea being that members who have paid for part of this month's memberships will get the remaining days of the month for...
with the current covid-19 situations and mandatory closures, we are investigating ways to 'pause' autorenewals. The idea being that members who have paid for part of this month's memberships will get the remaining days of the month for free when we reopen our facility.
What is the best way to achieve this? We use Stripe as the payment processor and monthly autorenewals.
thanks for the all the help we have gotten from this great community here.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/19Job Title in Civicrm2020-03-27T03:31:42Zphillipm2001Job Title in CivicrmI spent a fair bit of time putting contacts into Civi yesterday. All the contacts have been included but their job titles have not. We have been advised by our Civi consultant that there is a flaw with the way that job titles are entered...I spent a fair bit of time putting contacts into Civi yesterday. All the contacts have been included but their job titles have not. We have been advised by our Civi consultant that there is a flaw with the way that job titles are entered and to enter a job title we have to edited the Employed By relationship. This is annoying. Here is a link to some posts on [Stack Exchange](https://civicrm.stackexchange.com/questions/34569/design-flaw-in-current-employer-and-job-title).https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/18Civicrm and campaigning2020-03-27T03:31:42Zphillipm2001Civicrm and campaigningI would like to gather information as a result of an online campaign. There are a lot of platforms out there such Action Networks. I want to use Civi to collect signatures from an online petition. I would also like to use it to assist pe...I would like to gather information as a result of an online campaign. There are a lot of platforms out there such Action Networks. I want to use Civi to collect signatures from an online petition. I would also like to use it to assist people to write to their local MPs.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/17Membership price points2020-03-27T03:31:42Zphillipm2001Membership price pointsMy organisation would like to set up organisational memberships. It would be good to have bronze, silver and gold memberships see this website for an example https://www.and.org.au/pages/membership-packages.html. I would like to know how...My organisation would like to set up organisational memberships. It would be good to have bronze, silver and gold memberships see this website for an example https://www.and.org.au/pages/membership-packages.html. I would like to know how to do this in Civi. I would also like to know how to use payment processors such as Stripe and Paypal.
https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/16Civicrm Training2020-03-27T03:31:42Zphillipm2001Civicrm TrainingThere is a lack of training in Civicrm. I have done some training with Cividesk in Denver, Colorado. But I need to get up at 3am in the morning and that is very hard.There is a lack of training in Civicrm. I have done some training with Cividesk in Denver, Colorado. But I need to get up at 3am in the morning and that is very hard.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/15Conversion Tracking with Google Ads2021-01-18T09:29:57Zdavid.hohmConversion Tracking with Google AdsMy organisation got accepted for the Google Ads Grant. There are several benefits that we can unlock if we are able to set up conversions.
I am trying to get my head around how this would work with civicrm and have not had much luck with...My organisation got accepted for the Google Ads Grant. There are several benefits that we can unlock if we are able to set up conversions.
I am trying to get my head around how this would work with civicrm and have not had much luck with an online search.
I'm trying to understand how one would set up the tracking code on the thank you pages since civicrm's thank you pages are automatically and dynamically generated. I'm therefore not sure where one would place the conversion tracking code.
Has anyone here worked out how to achieve conversion tracking with Civicrm?
sorry for the many questions. Just slowly chipping away at features on our wishlist and coming across questions as we tackle them,
Thanks for help here, it has been really appreciated.
cheers,
Davidhttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/14notification of failed payment2020-03-27T03:31:41Zdavid.hohmnotification of failed paymentHi everyone,
is there a way to get a notification of some kind for when a recurring payment hasn't gone through? Maybe with membership rules?
We've had it a couple of times now that payments haven't gone through for insufficient funds f...Hi everyone,
is there a way to get a notification of some kind for when a recurring payment hasn't gone through? Maybe with membership rules?
We've had it a couple of times now that payments haven't gone through for insufficient funds for example and we only find out about it by chance a few days later.
thanks again for your help,
Davidhttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/13Settings - Localization - Language and Currency2020-03-27T03:31:41Zrenz56c.oSettings - Localization - Language and CurrencyA small issue that cropped up but may be of interest to the group, for those with international contacts. Under the Language and Currency Setting, I have selected Australia as the Default, and I have also selected Australia from the two ...A small issue that cropped up but may be of interest to the group, for those with international contacts. Under the Language and Currency Setting, I have selected Australia as the Default, and I have also selected Australia from the two option lists, which should ensure that these countries are the only ones available for state listings.
However I have recently discovered that some of our contacts had in the State field Washington DC. when it should have shown Western Australia. This happened for three different contacts in Western Australia. It was discovered when I was doing a membership search in the Advanced Search to show all memberships in Western Australia. I could not figure out why this was not showing the full listing of members i knew we had in that state, as I had a list of members Reps to compare it to in WA who did have the correct address. Then when I went to the Org record where the membership address was listed, I saw that Washington was in the state field. However I do not seem to be able to replicate this! So I don't actually know how Washington could have occurred there. Especially given Australia is the only Country that appears in the drop down field for Country.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/12Standard CiviCRM menu is missing2020-03-27T03:31:41Zdavid.hohmStandard CiviCRM menu is missingOur menu bar is currently missing. I managed to get CiviCRM Admin Utilities installed and that makes the site workable, but i would like to get the menu working. This is what I currently see. ![Menu](/uploads/7eef3c131a38fed6fe23af2db91d...Our menu bar is currently missing. I managed to get CiviCRM Admin Utilities installed and that makes the site workable, but i would like to get the menu working. This is what I currently see. ![Menu](/uploads/7eef3c131a38fed6fe23af2db91db1f5/Menu.PNG)
I am not sure if I am on the correct track, but I saw on some forums that this could be related to the resource url.
My resource url currently is ![resourceurl](/uploads/78721980ae1dc7dea725d4afea852137/resourceurl.PNG).
Is that correct?
Hope the question isn't too details specific.
thanks for any help,
Davidhttps://lab.civicrm.org/community/region/melbourne-meetups/-/issues/11How to show relationships on the summary page?2020-03-27T03:31:41ZMickCHow to show relationships on the summary page?Is there an extension that can help do this?Is there an extension that can help do this?https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/10Improvements to Soft Credits2020-03-27T03:31:41ZmfuggleImprovements to Soft CreditsIf one contact makes a payment for more than one other contact (e.g. a parent paying a membership fee for two or more children) the total value of the contribution shows against the parent. However the total amount also shows against eac...If one contact makes a payment for more than one other contact (e.g. a parent paying a membership fee for two or more children) the total value of the contribution shows against the parent. However the total amount also shows against each of the children as a soft credit. What needs to happen is that the total value should show against the parent but the individual membership fees, for example, should show as soft credits against the children.
For example assume a parent has two children and the membership fee for each child is $100. The parent would pay $200 and that is shown as a contribution against the parent's contact record. The soft credit against each child should be $100, however the soft credit against each child is $200.
This issue is a webform issue when integrated with CivCRM.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/9Contribution Partial Refunds2020-03-27T03:31:41ZmfuggleContribution Partial RefundsIt is not possible to make a partial refund without the use of a third party extension. It would be helpful to be able to make partial refunds in CiviCRM and have the refund take effect in the Payment Gateway.It is not possible to make a partial refund without the use of a third party extension. It would be helpful to be able to make partial refunds in CiviCRM and have the refund take effect in the Payment Gateway.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/8Contribution Refunds2020-03-27T03:31:41ZmfuggleContribution RefundsIt would be helpful if refunds could be initiated in CivCRM and effect the Payment Gateway so that it is not necessary to deal with refunds in the Payment Gateway (eWay in our case) as well as CiviCRM.It would be helpful if refunds could be initiated in CivCRM and effect the Payment Gateway so that it is not necessary to deal with refunds in the Payment Gateway (eWay in our case) as well as CiviCRM.https://lab.civicrm.org/community/region/melbourne-meetups/-/issues/4Measuring Engagement Via Searches2020-03-27T03:31:41Zrenz56c.oMeasuring Engagement Via SearchesHow would you use Search builder to show all participants who have status Registered or Attended for 10 or more events?How would you use Search builder to show all participants who have status Registered or Attended for 10 or more events?