Database error on MariaDB 10.2.6

This topic contains 6 replies, has 4 voices, and was last updated by  Paolo 6 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #386176

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22

    Hi.
    For technical reasons recently I upgraded my database to Mariadb 10.2.6. After that operation a sql error appear in the site. This error is caused for the reserved word ‘ROWS’ because is not correctly escaped.

    
    
    Error en la base de datos de WordPress: [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]
    SELECT count(id) as rows FROM wp_geodir_custom_advance_search_fields where post_type= 'gd_place'
    
    class="home page-template-default page page-id-4 logged-in geodir-page gd-map-auto">
    #386183

    Guust
    Moderator
    Post count: 29970

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #386260

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #386391

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22
    This reply has been marked as private.
    #386406

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #386438

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #386439

    Paolo
    Site Admin
    Post count: 31206

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

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

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

Open Support Ticket