forlogos

closing this out

Oh, ok.

Tested it on PHP 8.0.22 and 8.1.9 with WP 6.1.1 and WooCommerce 7.4.0 and it works fine. Also tested with the free Kadence Blocks plugin with no issues.

The plugin codebase is so small, there’s not much to look thru. I wonder what part of the Kadence theme or plugins used is causing it not to work properly. It’s likely that something in there is causing a filter conflict on ‘render_block’.

Thanks for sharing the link. It looks like there could be a theme/plugin conflict or an issue with the PHP version. It’s outputting the data the same as it was pasted in – it’s not being processed. I copied the data from your site to a test site with WP 6.1.1 and WooCommerce 7.4.0 like you have and it worked properly: https://imgur.com/a/Kp1b5J1

Could you try this test version of the plugin and see if it fixes the problem? https://github.com/forlogos/WP-Spreadsheet-Paste/archive/7f792c18d4c58d4f433a005e033c895f403f79be.zip

If it doesn’t, it would be good to know what PHP version your server is using. I could test it using the same PHP version, but that’s the limit of things I’ll be able to do on my side alone. Further troubleshooting will need you to switch themes and deactivate plugins.

Sorry you’re having issues. I designed the block to be as simple as possible, so am sure it’s not something you’re doing.

To help pinpoint the cause – could you please try the following:

1. See what happens if you use it on one of the default WP themes?
2. See what happens if you deactivate all your other plugins
3. Could you share a link to a page that has it?

I realize you might not be able to do #1 & 2 on your site and that this is a public forum for #3. LMK

looks like this will be handled in WP 3.1

Awesome!!!!

WordPress 3.1 Beta 1

figured out that if you want to show the complete comment change everything to this:

<?
if(get_query_var('author_name')) :
$curauth = get_userdatabylogin(get_query_var('author_name'));
else :
$curauth = get_userdata(get_query_var('author'));
endif;
$querystr = "
    SELECT comment_ID, comment_post_ID, post_title, comment_content
    FROM $wpdb->comments, $wpdb->posts
    WHERE user_id = $curauth->ID
    AND comment_post_id = ID
    AND comment_approved = 1
    ORDER BY comment_ID DESC
 ";

 $comments_array = $wpdb->get_results($querystr, OBJECT);

if ($comments_array): ?>
<h2>Recent Comments </h2>
<ul>
<? foreach ($comments_array as $comment):
	setup_postdata($comment);
	echo "<li><a href='". get_bloginfo('url') ."/?p=".$comment->comment_post_ID."'>Comment on ". $comment->post_title. "</a><br />". $comment->comment_content . "</li>";
endforeach; ?>
</ul>
<? endif; ?>

@matsim – thanks for sharing the code! Great find!!

the reason why it doesn’t work is because you are simply dropping the code onto a page, your $thisauthor->ID variable hasn’t been defined so nothing shows. One way to change it is to change the first part like this:

<?
if(get_query_var('author_name')) :
$curauth = get_userdatabylogin(get_query_var('author_name'));
else :
$curauth = get_userdata(get_query_var('author'));
endif;
$querystr = "
    SELECT comment_ID, comment_post_ID, post_title
    FROM $wpdb->comments, $wpdb->posts
    WHERE user_id = $curauth->ID

and add it all to your author.php file