Database error

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

Open Support Ticket

Tagged: advanced search filters, database error

Author

Posts
March 22, 2018 at 7:33 am #422686

Håvard Rosenlund
Buyer

Post count: 38

Hello,

I found a similar problem here from last year, but didn’t see a solution to it, so I’ll post my own issue and hopefully someone can help.

I am not sure what has happened, as I just saw this happening suddenly (been a while since I’ve done any major updates)

I keep getting this Database error popping up here and there throughout my website:

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 ‘rows FROM wp_geodir_custom_advance_search_fields where post_type= ‘gd_sightings” at line 1]
SELECT count(id) as rows FROM wp_geodir_custom_advance_search_fields where post_type= ‘gd_sightings’ AND main_search!=’1′

Any idea how to fix it?

Thanks

March 22, 2018 at 7:35 am #422687

Håvard Rosenlund
Buyer

Post count: 38

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!

March 22, 2018 at 7:47 am #422693

Kor
Moderator

Post count: 16516

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!

March 22, 2018 at 8:01 am #422700

Håvard Rosenlund
Buyer

Post count: 38

This reply has been marked as private.

March 22, 2018 at 8:02 am #422701

Håvard Rosenlund
Buyer

Post count: 38

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!

March 22, 2018 at 8:08 am #422702

Håvard Rosenlund
Buyer

Post count: 38

This reply has been marked as private.

March 22, 2018 at 1:22 pm #422752

Kor
Moderator

Post count: 16516

This reply has been marked as private.

March 22, 2018 at 1:34 pm #422755

Håvard Rosenlund
Buyer

Post count: 38

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!

March 23, 2018 at 5:37 am #422864

Alex Rollin
Moderator

Post count: 27815

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!

March 23, 2018 at 9:05 am #422917

Håvard Rosenlund
Buyer

Post count: 38

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!

March 23, 2018 at 2:23 pm #422966

Alex Rollin
Moderator

Post count: 27815

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!

March 23, 2018 at 2:24 pm #422967

Alex Rollin
Moderator

Post count: 27815

This reply has been marked as private.

March 23, 2018 at 2:45 pm #422974

Alex Rollin
Moderator

Post count: 27815

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!

March 23, 2018 at 3:56 pm #422990

Håvard Rosenlund
Buyer

Post count: 38

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!

March 23, 2018 at 7:32 pm #423041

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!
Author

Posts