[ad_1]
INSERT INTO wp_postmeta (post_id, meta_key, meta_value) (
SELECT p.id, ‘_wp_attachment_image_alt’, p.post_title
FROM wp_posts
WHERE NOT EXISTS (
SELECT 1
FROM wp_postmeta b
WHERE p.id = b.post_id AND b.meta_key = ‘_wp_attachment_image_alt’
)
AND p.post_parent IN (15732730)
AND p.post_author = 7777777777
The SQL below found in insert_attachment_meta_alt() should says FROM wp_posts p
[16-May-2024 13:13:46 UTC] WordPress database error Unknown column ‘p.id’ in ‘field list’ for queryINSERT INTO wp_postmeta (post_id, meta_key, meta_value) (
SELECT p.id, ‘_wp_attachment_image_alt’, p.post_title
FROM wp_posts
WHERE NOT EXISTS (
SELECT 1
FROM wp_postmeta b
WHERE p.id = b.post_id AND b.meta_key = ‘_wp_attachment_image_alt’
)
AND p.post_parent IN (15732730)
AND p.post_author = 7777777777
) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/astra-child/woocommerce/single-product.php'), wc_get_template_part, load_template, require('/themes/astra-child/woocommerce/content-single-product.php'), do_action('woocommerce_after_single_product'), WP_Hook->do_action, WP_Hook->apply_filters, ajax_catalogue_container, ajax_load_more_products, attach_external_product_images, fifu_dev_set_image_list, fifu_update_fake_attach_id, fifu_db_update_fake_attach_id_gallery, FifuDb->update_fake_attach_id_gallery, FifuDb->insert_attachment_meta_alt