Error: non-existing attribute ID.

  • Resolved php-supadev

    (@lbdeveloper)


    3 years, 7 months ago

    My wp-admin/edit.php?post_type=product&page=product_attributes page shows product attributes , but they should not exist (indeed i cannot edit them, i get the error message when i try) , since i have deleted them with an SQL that i have copy pasted from a site, to remove all products, attributes, variations.

    Why do i still see those attributes there?
    Which query should i execute to remove them?

    This is my status report

    
### WordPress Environment ###

WordPress address (URL): https://brandly.co.za
Site address (URL): https://brandly.co.za
WC Version: 5.5.2
REST API Version: ? 5.5.2
WC Blocks Version: ? 5.3.3
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.4.4
Log Directory Writable: ?
WP Version: 5.8
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.3.29
PHP Post Max Size: 256 MB
PHP Time Limit: 900
PHP Max Input Vars: 10000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.30-MariaDB-log-cll-lve
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.5.2
WC Database Prefix: wp_
Total Database Size: 57.26MB
Database Data Size: 44.95MB
Database Index Size: 12.31MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
amrod_category: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
earning_margins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.52MB + Index: 0.66MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.39MB + Index: 0.23MB + Engine InnoDB
wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_litespeed_url_file: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_loginizer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_masterslider_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_masterslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 16.48MB + Index: 0.39MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 19.56MB + Index: 7.06MB + Engine InnoDB
wp_posts: Data: 4.52MB + Index: 1.70MB + Engine InnoDB
wp_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smackuci_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 1.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpie_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 5424
custom_css: 2
elementor_library: 1
nav_menu_item: 6
page: 9
post: 2
revision: 70
sa_slider: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (11) ###

Checkout Files Upload for WooCommerce: by WP Wham – 2.1.0
Creative Mail by Constant Contact: by Constant Contact – 1.4.3
Elementor: by Elementor.com – 3.4.0
Kirki Customizer Framework: by David Vongries – 3.1.9
Google Ads & Marketing by Kliken: by Kliken – 1.0.7
Loginizer: by Softaculous – 1.6.7
Mailchimp for WooCommerce: by Mailchimp – 2.5.2
Premium Addons for Elementor: by Leap13 – 4.4.7
WooCommerce Tiered Price Table: by bycrik – 2.5.0
WooCommerce PayFast Gateway: by WooCommerce – 1.4.19
WooCommerce: by Automattic – 5.5.2

### Inactive Plugins (7) ###

LiteSpeed Cache: by LiteSpeed Technologies – 4.3
Massive Addons for WPBakery Page Builder: by MassivePixelCreation – 2.4.8
Master Slider: by averta – 3.7.8
Slide Anything - Responsive Content / HTML Slider and Carousel: by Simon Edge – 2.3.38
Smush: by WPMU DEV – 3.8.8
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.17
WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0

### Settings ###

API Enabled: ?
Force SSL: –
Currency: ZAR (R)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: 
Taxonomies: Product Visibility: 
Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Customify
Version: 0.3.6
Author URL: https://pressmaximum.com
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: customify/woocommerce/cart/cart.php
customify/woocommerce/cart/mini-cart.php version 3.7.0 is out of date. The core version is 5.2.0
customify/woocommerce/checkout/form-coupon.php
customify/woocommerce/content-product.php
customify/woocommerce/content-single-product.php
customify/woocommerce/content-widget-product.php
customify/woocommerce/content-widget-reviews.php
customify/woocommerce/loop/add-to-cart.php
customify/woocommerce/loop/loop-end.php
customify/woocommerce/loop/loop-start.php
customify/woocommerce/loop/pagination.php
customify/woocommerce/loop/result-count.php
customify/woocommerce/loop/sale-flash.php
customify/woocommerce/product-searchform.php
customify/woocommerce/single-product/add-to-cart/external.php
customify/woocommerce/single-product/add-to-cart/grouped.php version 4.0.0 is out of date. The core version is 4.8.0
customify/woocommerce/single-product/add-to-cart/simple.php
customify/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
customify/woocommerce/single-product/product-image.php
customify/woocommerce/single-product/sale-flash.php
customify/woocommerce/single-product/tabs/tabs.php
customify/woocommerce/single-product/title.php

Outdated Templates: ?
					
					
						Learn how to update

### Checkout Files Upload Settings ###

WooCommerce Checkout Files Upload: yes
Total file uploaders: 1
Form extras: yes
Enable alert on successful file upload: yes
Enable alert on successful file remove: yes
Max file size: 15
alg_checkout_files_upload_max_file_size_exceeded_message: Allowed file size exceeded (maximum %max_file_size% MB).
Attach files to admin's new order emails: yes
Attach files to customer's processing order emails: yes
Send additional email to admin on user actions: Array
(
)
Attach file on upload action: yes
Recipient(s): (set)
Subject: [{site_title}] Checkout files upload action in customer order ({order_number}) - {order_date}
Email heading: {action}: File #{file_num}
Email content: File name: {file_name}
Action: File removed: File removed
Action: File uploaded: File uploaded
Before: Label:
					?
					%field_label%%required_html%
				
												
					Field Container:
					?
					%button_html% %field_html%
				
												
					Uploaded File:
					?
					%image% %file_name% %remove_button%
				
												
					After:
Label: 
%field_label%%required_html%: 
Field Container: 
%button_html% %field_html%: 
Uploaded File: %image% %file_name% %remove_button%
After: 
"Delete" button style: color:red;
Image style: width:64px;
Enable/disable: yes
Required: no
Accepted file types: .jpg,.jpeg,.png
Validate image dimensions: 
Width: 1
Height: 1
Checkout page: woocommerce_before_checkout_form
Position order (i.e. priority): 20
"Thank You" page: no
"My Account" page: no
Label: Please select file to upload
Upload button (single): Choose File
Wrong file type: Wrong file type: "%s"!
Wrong image dimensions: Wrong image dimensions: "%s"! Current: %current_width% x %current_height%. Required: %required_width% x %required_height%.
Couldn't get image dimensions: Couldn't get image dimensions: "%s"!
File is required: File is required!
File was successfully uploaded: File "%s" was successfully uploaded.
File was successfully removed: File "%s" was successfully removed.
Require products: 
Require product categories: 
Require product tags: 
Label: 
%field_label%%required_html%: 
Field Container: 
%button_html% %field_html%: 
Uploaded File: %image% %file_name% %remove_button%
After: 

### Action Scheduler ###

Canceled: 2
Oldest: 2021-08-17 17:47:09 +0000
Newest: 2021-08-17 18:32:22 +0000

Complete: 1,836
Oldest: 2021-08-11 14:41:17 +0000
Newest: 2021-08-17 18:32:22 +0000

### Status report information ###

Generated at: 2021-08-17 18:41:23 +00:00
    • This topic was modified 3 years, 7 months ago by php-supadev.
    • This topic was modified 3 years, 7 months ago by php-supadev.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error: non-existing attribute ID.’ is closed to new replies.