• Resolved Mart456

    (@mjmcgowan)


    Hi, i am getting a lot of database errors that appear to be coming from Geo mashup,

    when i turn off the plugin the errors stop, is any one able to help me troubleshoot the issue?

    31-May-2013 06:08:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND p.post_status=’publish” at line 6 for query SELECT count(*) FROM wp_posts p
    INNER JOIN wp_term_relationships tr ON tr.object_id = p.ID
    INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
    INNER JOIN wp_geo_mashup_location_relationships gmlr ON gmlr.object_id = p.ID AND gmlr.object_name = ‘post’
    WHERE tt.term_id =
    AND p.post_status=’publish’ made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/canvas5.2.4/404.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/canvas5.2.4/sidebar.php’), woo_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Categories->widget, wp_dropdown_categories, walk_category_dropdown_tree, call_user_func_array, Walker->walk, Walker->display_element, Walker->display_element, call_user_func_array, Walker_CategoryDropdown->start_el, apply_filters(‘list_cats’), call_user_func_array, GeoMashup::list_cats, GeoMashupDB::category_located_post_count
    [31-May-2013 06

    Martin

    http://wordpress.org/extend/plugins/geo-mashup/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Dylan Kuhn

    (@cyberhobo)

    Hi Martin,

    Look in Settings / Geo Mashup / Obscure Settings / Add Category Links – uncheck that. It doesn’t look to me like you’re using it, and it isn’t working with something in your 404.php template.

    Thread Starter Mart456

    (@mjmcgowan)

    Thanks Dylan, that seemed to work.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Geo-mashup Database Error’ is closed to new replies.