nginx mariadb error

This topic contains 11 replies, has 3 voices, and was last updated by  Stiofan O’Connor 7 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #200706

    siparker
    Buyer
    Post count: 114

    I am getting a 500 error for GD

    the following errors seem to be what is causing it

    PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 for query SELECT * FROM wp_term_taxonomy WHERE taxonomy IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/geodirectory/geodirectory-templates/geodir-location.php'), do_action('geodir_location_content'), call_user_func_array, geodir_action_home_content, do_action('geodir_home_content_inside'), call_user_func_array, geodir_action_home_content_inside, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, geodir_popular_postview->widget, geodir_popular_postview_output, include('/plugins/geodirectory/geodirectory-templates/widget-listing-listview.php'), setup_postdata, WP_Query->setup_postdata, do_action_ref_array, call_user_func_array, create_marker_jason_of_posts, geodir_get_term_icon

    Could you advise anything to try pls. is this a gd code error or a setting somewhere? or does it look like a server error you have seen before?

    #200870

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    What page do u see this error? DO you have any categories created for GD posts?

    Stiofan

    #200900

    siparker
    Buyer
    Post count: 114

    hi

    its just on the main gd page which is not the homepage. rest of the site runs fine its just gd gives the 500 error.

    There are three categories same as my test site on apache. i just moved it to the live server to test before go live

    #200919

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    If you provide wp-admin i’ll take a look. FTP would help if you want me to fix now also.

    Thanks,

    Stiofan

    #200939

    siparker
    Buyer
    Post count: 114
    This reply has been marked as private.
    #200944

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    How did u do the move, u seem to have los of settings missing, did u have places already there? I see none.

    Stiofan

    #200945

    siparker
    Buyer
    Post count: 114

    hi

    yeah there were several thousand.

    I will ahve to check the db as looking now i can see there are options missing for the cuastom post types etc also

    i will redo the transfer and test it again

    sorry for wasting your time i should have checked that first

    #200947

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    No probs, just let us know if u keep having problems.

    Thanks,

    Stiofan

    #200953

    siparker
    Buyer
    Post count: 114

    hi
    its was us messing up the sql by doing a find and replace for the url. it messed up a load of seralised data wiothout us realising

    #200985

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    to avoid that, you can use a script like this: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

    There is also a wp plugin based on that script, I personally prefer the script as it’s faster.

    Thanks

    #200998

    siparker
    Buyer
    Post count: 114

    that script is gonna be incredibly useful!!

    thanks for the pro tip.

    #201000

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    This one has not let me down yet: https://wordpress.org/plugins/better-search-replace/

    Stiofan

Viewing 12 posts - 1 through 12 (of 12 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket