Your code looks correct to me, so I suspect there is some kind of issue connecting to the second database.
Try the following which will log the last error:
$wpdb->show_errors();
if($wpdb->last_error !== '') :
$wpdb->print_error()
endif;
If you are using multisite, then you will also need to add:
define( 'DIEONDBERROR', true );
Have a look here for more info: https://codex.wordpress.org/Class_Reference/wpdb#Show_and_Hide_SQL_Errors
Related Posts:
- do_shortcode based on _thumbnail_id
- WordPress Shortcode show database row
- Enumeration Contact form using database table’s numbe of rows [closed]
- Code is providing a row of data but not formatting it as table
- How to reload the shortcode content when the database is changing
- my form does not insert any data in the database
- WordPress Database Error using $wpdb->get_results()
- current_shortcode() – detect currently used shortcode
- Get shortcode name from within it’s callback function? [duplicate]
- Tinymce – How to hook before or after live shortcodes rendering?
- How to customize a shortcode using the customizer
- Stray closing paragraph tag when using shortcodes
- Get post id shortcode
- The result of a shortcode appear BEFORE page content
- Getting attribute value from shortcode
- Get shortcode attributes outside shortcode function
- How to make this shortcode work for post content
- Problem with email_exists in shortcode
- Alternate text if shortcode returns no data
- sql query in shortcode not working
- Global, network-wide shortcodes or text replace functions
- Video size and border radius using a shortcode
- How to use div class between the shortcode variable?
- wp_editor returns the shortcode and not render the output
- Prevent wordpress from rendering shortcode in post
- Error do_shortcode In WooCommerce Template
- Embedding Instagram via shortcode doesn’t work as advertised in official docs
- Execute shortcode only once in the page
- Can a shortcode return its own name?
- Order Woocommerce Products by Latest Reviewed
- $content not null in shortcode, even though it is self closing
- Nesting shortcodes results in the inner shortcode being placed AFTER outer shortcode
- i have create shortcode that work but not perfect coding
- menu item to display the most recent post
- how to format / execute post content and shortcode?
- Gravity forms – get shortcode attribute from post content
- How to get the $atts of a shortcode
- Getting the count of a shortcode that is nested
- Single post content custom order
- Adding a class to shortcode API
- Parse Error: unexpected ‘}’ while creating Shortcode with Loop [closed]
- Pass data back to TinyMCE from Thickbox
- Forcing WP to embedd a video when using a shortcode
- Shortcode for output of wp_get_archives displays at top of post
- How can I execute shortcode outside the loop?
- Shortcode is not returned correctly
- How do I make a shortcode?
- passing markup thought a shortcode attribute
- How to have shortcode autofilling the content if the attribution is specified?
- Shortcode argument multiple values
- How can I collect and output all attributes of all executed ShortCodes?
- Do I need to escape number in this shortcode function?
- How can I list only custom shortcodes?
- Substite Category Slug in a Shortcode
- add new attributes into existing shortcodes
- Anchor text in Short code →
- Need 2 separate elements of add_shortcode for presentation
- Why ‘do_shortcode’ doesn’t work in a REST request?
- Basic custom Shortcode not working
- Shortcode to return an image based on post taxonomy
- How to show an image via shortcode
- How to put custom admin setting field into a shortcode
- shortcode – I need to throw a message or load a different page
- How to add site tags in alphabetical order to shortcode?
- WordPress post shortcode pagination not working
- Shortcode do not return a value
- How to use multiple (or array) values in $content of shortcode?
- How to display content if user meta data isn’t empty with shortcode
- How to display total user count by specific role in WordPress as statistics?
- User name in referral URLs
- How to style inline code in block editor?
- Is it possible to capture the content outside/between shortcodes?
- Create Button for Shortcode in Text Editor
- Send Mail with link to current_user
- Geoip shortcodes in comments
- Shortcode not interpreted if parameter set
- Can we add a single caption to the gallery shortcode?
- do_shortcode for is_page(slug)
- Create shortcode to display specific post in relationship current date
- Add custom shortcodes to the Welcome Mail
- How to handle multiple nested shortcodes with different tags?
- Using shortcode to stop post content from displaying
- How to echo an array returned by a function
- Nested WordPress Shortcodes of Different Types
- Creating custom shortcode
- What is short code for following?
- Initialize add_action() for every copy of a specific shortcode
- WP_Editor Shortcode Issue
- Shortcode not working in custom post types
- Shortcode or placeholder for theme options page?
- Remove some tags from shortcodes output? Trying to fix autop
- do_shortcode & render custom field won’t work
- shortcodes inside shortcode to sum values
- is_mobile as shortcode
- Is it possible to change a shortcode parameter based on a media query?
- IFrame Shortcode plugin – issue
- How to call shortcode on button click
- How can you alter the name of attributes in a shortcode?
- How to reuse php templates as shortcodes?
- Shortcode attributes from meta query variables