Events: Extra margin bottom on the form tag on the upcoming events page

[renintw]

This seems to happen only on the local env upcoming events page.
Not see it on the same page on production or other pages locally.

cc @StevenDufresne

[iandunn]

🤔 I don't see it in my local env. Does dev tools show you what rule is causing it?

[renintw]

It's from the user agent stylesheet. Probably related to these broken messages on top of the page:

There's an extra style added to the form on this page (only on this page) - margin-block-end: 1em;.
Steve also saw it. There is a high chance it's a local env problem as I use his env config.

But somehow now I can't even click that filter button, I'm on latest production branch, do you also have the issue?
Error message when clicking on the button: directives.js:72 Uncaught TypeError: Cannot read properties of undefined (reading 'wporg')

[iandunn]

Hmm, no, they're still working for me. It looks like that error may be related to this query:

wordcamp.org/public_html/wp-content/themes/wporg-events-2023/inc/city-landing-pages.php

Lines 49 to 58 in 252e104

	$sites = $wpdb->get_results( $wpdb->prepare( "
	SELECT blog_id
	FROM {$wpdb->blogs}
	WHERE
	site_id = %d AND
	path REGEXP %s
	LIMIT 1",
	EVENTS_NETWORK_ID,
	"^/$city/\d{4}/[a-z-]+/$"
	) );

can you try putting this code after it and refresh?

var_dump( $wp->request, $city, EVENTS_NETWORK_ID, $wpdb->last_query, $wpdb->last_error );
wp_die();

Then copy/paste the values here. Also, let me know the full URL of the page you're on.

[renintw]

Hmm, ah, actually the errors on the top actually don't affect the development, and I suspect they are not the main reason why the button isn't working. Everything was functioning normally about an hour ago, and those errors have always been there.
About an hour ago, for some unknown reason, the button suddenly became unresponsive.
Here are the value and URL.

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE site_id = 1 AND path REGEXP '^/upcoming-events/\\d{4}/[a-z-]+/$' ...' at line 3]
SELECT blog_id FROM WHERE site_id = 1 AND path REGEXP '^/upcoming-events/\\d{4}/[a-z-]+/$' LIMIT 1

string(15) "upcoming-events" string(15) "upcoming-events" int(1) string(114) " SELECT blog_id FROM WHERE site_id = 1 AND path REGEXP '^/upcoming-events/\\d{4}/[a-z-]+/$' LIMIT 1" string(228) "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE site_id = 1 AND path REGEXP '^/upcoming-events/\\d{4}/[a-z-]+/$' ...' at line 3"

Full URL: http://localhost:8888/upcoming-events/

And this is the error when clicking the button:

[StevenDufresne]

I've seen this before but now looking for it, I can't reproduce it.

[iandunn]

The problem w/ that query is that the table name is missing. {$wpdb->blogs} should have been interpreted as wc_blogs. I'm not sure why, though, I've never seen that happen before 🤔