40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Database and other errors

This topic contains 7 replies, has 3 voices, and was last updated by  Roberto Cosentino 5 years, 4 months ago.

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

Open Support Ticket
  • Author
    Posts
  • November 27, 2018 at 9:15 pm #456122

    Roberto Cosentino
    Free User
    Post count: 4

    Hello everyone, i have some trouble on Geodirectory.
    I checked my error log after some issues on my website, like page crushes, and image not loaded correctly and I found 69 MB of error log and these errors are reapiting every day:

    [27-Nov-2018 20:11:58 UTC] WordPress errore sul database 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 ‘rows FROM wp_geodir_custom_advance_search_fields where post_type= ‘gd_place” at line 1 per la query SELECT count(id) as rows FROM wp_geodir_custom_advance_search_fields where post_type= ‘gd_place’ fatta da require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/kleo/buddypress.php’), get_header, locate_template, load_template, require_once(‘/themes/kleo/header.php’), body_class, get_body_class, apply_filters(‘body_class’), WP_Hook->apply_filters, geodir_advance_search_body_class

    and

    [27-Nov-2018 20:10:47 UTC] PHP Warning: Illegal string offset ‘Zimbabwe’ in /home/bnnirpjs/public_html/wp-content/plugins/geodir_location_manager/geodir_location_functions.php on line 599

    This one is repeated for every country.

    How Can I resolve please?
    Thank you.

    November 27, 2018 at 9:58 pm #456128

    Roberto Cosentino
    Free User
    Post count: 4
    This reply has been marked as private.
    November 27, 2018 at 10:11 pm #456129

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    November 27, 2018 at 10:15 pm #456131

    Roberto Cosentino
    Free User
    Post count: 4
    This reply has been marked as private.
    November 28, 2018 at 12:26 pm #456182

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Roberto,

    I don’t see anything similar in my test sites, i suspect the issue is with the theme, is there a specific page that triggers these?

    Stiofan

    November 28, 2018 at 12:30 pm #456184

    Roberto Cosentino
    Free User
    Post count: 4

    Hi Stiofan, thanks for your help.

    Actually, in the page “Servizi” I can’t change icons and since this morning i cannot view any image in blog post (but I think that this was resolved from kleo developer).
    When I submitted the error log to the developer of Kleo, they sent me here.
    As I said, now I can view the images, but I still can’t change the Icons in “Servizi” (or any other page).

    Thank you so much,

    Roberto

    November 28, 2018 at 5:35 pm #456223

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Roberto,

    The logo thing is related to fontawesome please see this: https://wpgeodirectory.com/the-font-awesome-v5-wordpress-problem/
    Any plugin or theme using the JS version will cause this issue with wpbakery, it was causing the issue for us with themes using it and the only real solution is to also use the JS version but it can cause problems for plugins who have not updated yet.

    Please ask wpbakery if they plan to update font awseome to the JS version and give them this link https://wpgeodirectory.com/the-font-awesome-v5-wordpress-problem/

    Thanks,

    Stiofan

    November 28, 2018 at 6:11 pm #456231

    Roberto Cosentino
    Free User
    Post count: 4

    Hi Stiofan,
    Thank you so much!

    Bye,

    Roberto

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

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

Open Support Ticket