Not unique table/alias: 'wp_postmeta'

  • Resolved gcrivelli

    (@gcrivelli)


    10 years, 6 months ago

    I have founded some line in error_log with this istruction:

    WordPress database error Not unique table/alias: ‘wp_postmeta’ for query

    [11-Sep-2014 14:57:50 UTC] WordPress database error Not unique table/alias: ‘wp_postmeta’ for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE 1=1 AND wp_posts.post_type = ‘wprss_blacklist’ AND (wp_posts.post_status = ‘publish’) AND ( (wp_postmeta.meta_key = ‘wprss_permalink’ AND CAST(wp_postmeta.meta_value AS CHAR) = ‘https://www.ilgiornaledelturismo.com/dal-mondo/la-croazia-vede-incrementare-gli-arrivi-del-5-nei-primi-otto-mesi-dellanno/&#8217;) ) AND (wp_postmeta.meta_key = ‘snap_isAutoPosted’ AND wp_postmeta.meta_value = ‘1’) AND post_date > ‘2014-09-01 00:00:00’ AND post_date < ‘2014-09-10 23:59:59’ AND (wp_postmeta.meta_key = ‘snapTW’ AND wp_postmeta.meta_value LIKE ‘%nxsi0tw%’) AND ( (post_date = ‘1975-01-01’ && ID > 0 ) || post_date > ‘1975-01-01’ ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8 made by do_action_ref_array, call_user_func_array, wprss_fetch_insert_single_feed_items, wprss_is_blacklisted, WP_Query->__construct, WP_Query->query, WP_Query->get_posts.

    Thank’s for support.
    Giancarlo

    https://www.ads-software.com/plugins/wp-rss-aggregator/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Miguel Muscat

    (@mekku)

    This looks more like a Database problem than an error in our plugin.

    Can you confirm that your database tables do infact use the “wp_” prefix and that the “wp_postmeta” table exists?

    Thread Starter gcrivelli

    (@gcrivelli)

    The database is ok and the prefix is wp_.

    I have executed this quesy via phpadmin and there is the errore: #1066 – Not unique table/alias: ‘wp_postmeta’.

    I suppose that in inner or left join you must use the alias on wp_postmeta.

    The site is: https://www.opforyou.com

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts
    INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    LEFT JOIN wp_postmeta as leftjoin ON wp_posts.ID = leftjoin.post_id …..

    Thank’s for all

    Plugin Contributor Miguel Muscat

    (@mekku)

    I see. Can you provide us with your System Information? You can find this from your WordPress Admin menu > RSS Aggregator > Debugging page.

    Thread Starter gcrivelli

    (@gcrivelli)

    Ok. The version of Mysql is MariaDB but i have founded the same error with local system with Windows/EasyPhp.

    ### Begin System Info ###

    ## Please include this information when posting support requests ##

    Multi-site: No

    SITE_URL: https://www.opforyou.com
    HOME_URL: https://www.opforyou.com

    Plugin Version: 4.5.3
    WordPress Version: 4.0

    Platform: Windows
    Browser Name: Firefox
    Browser Version: 32.0
    User Agent String: Mozilla/5.0 (Windows NT 5.1; rv:
    32.0) Gecko/20100101 Firefox/32.
    0

    PHP Version: 5.5.16
    MySQL Version: 5.6.17
    Web Server Info: LiteSpeed

    PHP Safe Mode: No
    PHP Memory Limit: 256M
    PHP Post Max Size: 8M
    PHP Time Limit: 120

    WP_DEBUG: Disabled

    WP Table Prefix: Length: 3 Status: Acceptable

    Show On Front: posts
    Page On Front: #0
    Page For Posts: #0

    Session: Enabled
    Session Name: PHPSESSID
    Cookie Path: /
    Save Path: /tmp
    Use Cookies: On
    Use Only Cookies: On

    UPLOAD_MAX_FILESIZE: 2MB
    POST_MAX_SIZE: 8MB
    WordPress Memory Limit: 512MB
    DISPLAY ERRORS: N/A
    FSOCKOPEN: Your server supports fsockopen.

    ACTIVE PLUGINS:

    Admin Bar Disabler: 1.2
    Adminimize: 1.8.4
    Automatic Post Tagger: 1.6
    Booking.com Official Search Box: 1.2
    Captcha Code: 2.5.1
    Category Posts Widget: 4.0
    Contact Form 7: 3.9.3
    Contact Form 7 Datepicker: 2.4.5
    Contact Form DB: 2.8.13
    Cookie Law Info: 1.2.1
    Cyclone Slider 2: 2.8.4
    Erident Custom Login and Dashboard: 3.2
    Google Analytics by Yoast: 5.0.6
    Google XML Sitemaps: 4.0.7.1
    Link Manager: 0.1-beta
    List category posts: 0.51
    NextScripts: Social Networks Auto-Poster: 3.4.3
    Peter’s Login Redirect: 2.8.2
    PHP Code Widget: 2.2
    Popup with fancybox: 1.7
    PYU Generic Plugin: 1.0
    RSS Multi Importer: 9.10.00
    Share Buttons by AddToAny: 1.3.7
    Stop Spammer Registrations Plugin: 5.9.3
    TinyMCE Advanced: 4.1.1
    Types – Complete Solution for Custom Fields and Types: 1.6.3
    User Meta: 1.1.6
    WP-Optimize: 1.8.9.7
    WP Crontrol: 1.2.3
    WP exec PHP: 2.0.1
    WP RSS Aggregator: 4.5.3
    WP RSS Aggregator – Excerpts and Thumbnails: 1.7.1
    WP Super Cache: 1.4.2

    Plugin Contributor Miguel Muscat

    (@mekku)

    Have you tried using a different theme, or disabling the other plugins one by one? This could be caused either by the theme or another plugin, conflicting with WP RSS Aggregator.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Not unique table/alias: 'wp_postmeta'’ is closed to new replies.