cambob

great I will take a look at that approach

thanks

Looks like you added to the functions file. tried adding to functions file didnt work. Also tried adding to customizer file but errors both cases.
Thought I would try to tackle this but looks like its over my head.

thanks anyway!

This is the code I am using that I changed from the example here
https://www.nosegraze.com/customizer-settings-wordpress-theme/

/**
	 * Section: Colours
	 *
	 * @param WP_Customize_Manager $wp_customize
	 *
	 * @access private
	 * @since  1.0
	 * @return void
	 */
	private function colours_section( $wp_customize ) {

		/* Paragraph text */
		$wp_customize->add_setting( 'header_background', array(
			'default'           => '#444444',
			'sanitize_callback' => 'sanitize_hex_color'
		) );
		$wp_customize->add_control( new WP_Customize_Color_Control( $wp_customize, 'header_background', array(
			'label'    => esc_html__( 'Header Background Colour', 'twentytwelve-child' ),
			'section'  => 'colors',
			'settings' => 'header_background',
			'priority' => 10
		) ) );

	}

as mentioned above I tried the plugin “better search replace”. tried it twice now but same result as above.

that is why i want to change it directly in the database via sql but I cant find the content?

you cant see it in the text because the URLs are html links to images. But for example if you click on the name across from “download comp” it will take you to an old URL (different domain) and the image to download wont be there because the path has not been updated.

https://www.zenmaps.art/wm006-117/

thanks

I tried that, searched all the tables and the log said no instances were repplaced. And checking the posts they stillhave the old url in the text/html section of the post.

Thats why I would like to find this text/html in the database so that I can change it with sql.

Thanks all the same

I left it open because I was hoping to get some other responses. My question is as above. Restated in a simpler way.

Is there somewhere in the database where I can insert, by SQL, paths to the featured images of existing posts.
So that I dont have to add them to each existing post individually?

Thanks

yes better leave it alone. I managed to add featured images by inserting post_id and meta_value(s) into the wp_postmeta table before but the sql that I was using before returns an error message now. I’ll dig deeper into the shortcode. thanks

ps. site is new and hardly gets any visitors so thats not the problem
https://www.oldskullhockey.com

Thanks Again

hmmm interesting, the link is to the old url. so where can i change this link to the new url?

I have already updated to the new the url in the nextgen lightbox advanced settings.

so I have managed to import a few featured images into the wp_post_meta table. They show up in edit mode of the post and I have added a tag and the same tag into the body text of the post.

However they do not show up in the search results.
I added a few search images on other posts (exact same image and tag) by adding one at a time in add featured image within the post edit and they do show up.

I,ve looked at the database table and see no difference at all between the images I added through SQL and the images added manually through the post edit.

There must be another table affected by adding the FI manually through the post edit???? any suggestions would really be appreciated

sorry lost the formatting on the examples
meta_id post_id meta_key meta_value
874 3767 _thumbnail _id 3841

well I have finally tracked down where they are.

They are in the wp_postmeta table
example:

meta_id post_id meta_key meta_value
874 3767 _thumbnail_id 3841

with the meta value being the ID of the image
unfortunately there are rows and rows of other data such as:
meta_id post_id meta_key meta_value
860 3766 _encloseme 1
861 3766 _pingme 1

just wondering if its ok to add rows as above to the table without messing things up??

I really hope someone can help me through this. I would imagine it would be valuable in helping others add feature images in bulk.

hmmmmm, I set the featured image on 4 of the posts just so that I do have featured images attached to posts and in the DB wherever that may be??

OK, I thought I read on one of the docs that the .htaccess that was in the root directory would affect all directories below (such as wp in its own directory). But its definitely good to know for future installs, updates ect. that it has to be in the WP directory.

My host does allow ftp. I use CODA and discovered I can turn on hidden files on that as well.

Thanks again!