Julie Lawrence

I rolled back to 8.9.3 using the RollBack plugin, and had to temporarily deactivate a bunch of woocommerce add-ons to do so. I reactivated them all, turned off auto-updates, and all was fine. And then 10 hours later, my site is down again, and woocommerce has somehow re-updated itself to version 9.0.0. Simply History log doesn’t show any updates to it. WTF? Could the WC-related plugins have forced it to update? And now Rollback won’t load for Woocommerce, so I can’t get my site up at all! Any ideas?!!

UPDATE: I was able to use Rollback by deactivating WooCommerce first.

• This reply was modified 8 months, 2 weeks ago by Julie Lawrence. Reason: to click on
• This reply was modified 8 months, 2 weeks ago by Julie Lawrence. Reason: update

I’ve made a local copy, with ONLY Woocommerce and WC Paypal Payments installed, and changed the theme, and I’m STILL getting the same issue. I don’t get the issue if I install them both in a clean wordpress installation. I’m totally out of ideas in how to debug this!

Another similar post (https://www.ads-software.com/support/topic/authentication-with-paypal-failed-could-not-create-token/) had a similar issue, and it was resolved by turning off caches – I’ve tried that too, at both the server level, and removed any caching plugins. Still no luck.

• This reply was modified 1 year ago by Julie Lawrence.

>> an email is sent to the administrator

Oddly, no email is sent!! And there’s nothing in the error logs. I’m still able to access the WP back end, the error is only on the front end. I get the site back up by disabling the PD Email plugin.

>> I would suggest you rebuild the database, and I know you did this before, but I’m going to give you a specific process so that is happens the way it should.

That would be awesome, please!!

>> RPNE2 is the private ID of the former “default record” the plugin used originally, and its use was phased out years ago, so seeing that surface is puzzling.

It happened when I exported and then re-imported my list, if that helps.

I finally tracked down the source of the iframe – it was coming from _oembed_filter_feed_content, which is used by the_content() – thanks for that hint!

In the PD settings, Advanced tab, I’ve set Use WordPress Auto Formatting to “none”, and it’s working now!!

My site is still crashing when I enable the Email plugin, with errors like this in the log:

Cannot modify header information - headers already sent
in /home/mtneboor/public_html/wp-content/plugins/participants-database/classes/PDb_Session.php on line 377

• This reply was modified 2 years, 3 months ago by Julie Lawrence.

Thank you SO much … I’m amazed by your willingness to support!!!

The private_id column is a series of 5 character strings, consisting of uppercase letters and numbers, as generated by SET private_id = UPPER(SUBSTR(MD5(RAND()), 1, 5))

Thanks for the iframes hint – I’ll track that down!!

Looking forward to the next steps – thank you!!!!

Oh, I’ve just found that what’s actually in the email is this (which doesn’t help me, it still takes me to “record not found” … I’m just sending it in case it helps you understand what might be going on.)

<iframe class="wp-embedded-content" sandbox="allow-scripts" security="restricted" 
style="position: absolute; clip: rect(1px, 1px, 1px, 1px);" 
title="“Update your details 
[pdb_record]” — Mt Nebo Resident's Association" 
src="https://www.mtnebo.org.au/participants-database-public-list/participants-database-edit-record/embed/#?secret=Qm4XghdtjF#?secret=jDDT87L7i4" 
data-secret="jDDT87L7i4" 
width="500" height="282" frameborder="0" marginwidth="0" marginheight="0" scrolling="no"></iframe>

>> It sounds like you’re talking about using the admin List Participants “With selected” function, right?

Yes, correct.

Here’s what i’ve tried, and now it IS sending links, but none of them work.

1. I noticed that my imported records didn’t have a Private ID, whereas ones created with the signup form DO, so I exported them all, and re-imported. Now they all DO have a private ID – but it’s all the SAME ONE, RPNE2! I’ve managed to update in phpMyAdmin like this:
UPDATE xx_participants_database
SET private_id = UPPER(SUBSTR(MD5(RAND()), 1, 5))

2. [This one happened BEFORE I updated the private IDs, as above]
I do NOT have the “Use the Private ID for the Single Record Link” option checked, but when I tried to send the link as you describe above, using a template I set up using the Email plugin, the link I get is: https://www.mtnebo.org.au/participants-database-public-list/participants-database-edit-record/?pid=RPNE2
– ie. it’s using the PID, NOT the record id.
Furthermore, the underlying URL is:
https//https://www.mtnebo.org.au/participants-database-public-list/participants-database-edit-record/?pid=RPNE2
– i.e. no colon in https:// … so it doesn’t work (and wouldn’t anyway, cos it’s a much-duplicated private ID)

3. WHen I send the email using the built in “send edit link/password recovery email”, the link is get is: https://www.mtnebo.org.au/participants-database-public-list/participants-database-edit-record/ – i.e. NO record OR private ID.

4. When I send email using a template I created, with [record_link], I now get the same as in [3].

5. My site kept randomly crashing during all this, and I could only get it back by disabling your Email plugin. I think this is the message generated in the debug log when that happens:
Cannot modify header information – headers already sent
in /home/mtneboor/public_html/wp-content/plugins/participants-database/classes/PDb_Session.php on line 377

I am at a loss and have no idea how to sort this out. Do you have any ideas???

Thank you!

I’m getting similar. Several of my sites are showing these in the error log, and my sites aren’t loading

——————————-

WordPress database error Unknown column 'date' in 'order clause' for query 
					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id
					WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (99)
) AND ( 
  wp_tec_occurrences.post_id IS NOT NULL 
  AND 
  CAST(wp_tec_occurrences.end_date AS DATETIME) >= '2022-10-23 16:08:58'
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish'))
					GROUP BY wp_tec_occurrences.occurrence_id
					ORDER BY date desc, CAST(wp_tec_occurrences.start_date AS CHAR) ASC, post_date ASC
					LIMIT 0, 6
				 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/astra/page.php'), astra_content_page_loop, do_action('astra_content_page_loop'), WP_Hook->do_action, WP_Hook->apply_filters, Astra_Loop->loop_markup_page, Astra_Loop->loop_markup, do_action('astra_page_template_parts_content'), WP_Hook->do_action, WP_Hook->apply_filters, Astra_Loop->template_parts_page, get_template_part, locate_template, load_template, require('/themes/astra/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_blocks, render_block, WP_Block->render, WP_Block->render, UAGB_Post->post_grid_callback, UAGB_Helper::get_query, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, TEC\Events\Custom_Tables\V1\WP_Query\Modifiers\Events_Only_Modifier->filter_posts_pre_query, TEC\Events\Custom_Tables\V1\WP_Query\Custom_Tables_Query->get_posts, WP_Query->get_posts

—————————

[23-Oct-2022 06:08:17 UTC] PHP Fatal error:  Uncaught Error: <strong>Call to a member function get() on null</strong> in /home/mtneboor/public_html/wp-includes/query.php:28
Stack trace:
#0 /home/mtneboor/public_html/wp-content/plugins/the-events-calendar/src/Tribe/Query.php(46): get_query_var('tribe_events_fr...')
#1 /home/mtneboor/public_html/wp-includes/class-wp-hook.php(307): Tribe__Events__Query::parse_query(Object(WP_Query))
#2 /home/mtneboor/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#3 /home/mtneboor/public_html/wp-includes/plugin.php(524): WP_Hook->do_action(Array)
#4 /home/mtneboor/public_html/wp-includes/class-wp-query.php(1112): do_action_ref_array('parse_query', Array)
#5 /home/mtneboor/public_html/wp-includes/class-wp-query.php(1805): WP_Query->parse_query()
#6 /home/mtneboor/public_html/wp-includes/class-wp-query.php(3613): WP_Query->get_posts()
#7 /home/mtneboor/public_html/wp-includes/post.php(2410): WP_Query->query(Array)
#8 /home/mtneboor/public_html/wp-content/plugins/pdb-email-expansion/cpt_email_templates/con in /home/mtneboor/public_html/wp-includes/query.php on line 28

——————————

Thanks for your response!!! Much appreciated!! And you’re right, I just tested it with the signup process, and it works.

My failure is when I’m testing sending out the “send edit link/password recovery code” email. All i get in the email is this:

Here is the private link you requested from Mount Nebo website, so that you can update your details.

[record_link]

i.e. the [record_link] shortcode isn’t being replaced by the appropriate URL.

Any ideas how to debug this?

Thanks!!
Julie

Oh, and yes, I’ve added the page with the [pdb_record] shortcode, to the Record Form Settings tab of the Settings page.

Oh, and all the other tags work fine, including [admin_record_link], just not this one.

Thank you @alphamobility!!! I’ve tried 50 other things, but it was the SALT keys. Thank you!

I’m getting the same thing, and like you, rolling Gutenberg back doesn’t help. Nor does rolling back Astra. Anyone?

UPDATE: sorry, they’re not mp4s, they’re both zip files to begin with.