40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Error connecting to dB on specific search strings

This topic contains 26 replies, has 4 voices, and was last updated by  Iain Brewster 5 years, 6 months ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • April 24, 2019 at 6:43 am #482471

    Iain Brewster
    Expired Member
    Post count: 74
    This reply has been marked as private.
    April 24, 2019 at 12:21 pm #482517

    Iain Brewster
    Expired Member
    Post count: 74
    This reply has been marked as private.
    April 24, 2019 at 6:14 pm #482617

    Iain Brewster
    Expired Member
    Post count: 74
    This reply has been marked as private.
    April 24, 2019 at 7:21 pm #482645

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    April 24, 2019 at 7:32 pm #482652

    Iain Brewster
    Expired Member
    Post count: 74

    Thanks Alex

    April 26, 2019 at 6:50 am #483000

    Iain Brewster
    Expired Member
    Post count: 74

    Hi all,

    Its been noticed that when searching for a listing of the listing prompt (shows all categories and listing names) drop down is still catching up then there is almost certainly the error message however if you wait for the listing prompt to finish then there doesn’t seem to be an error message.

    Is there a way I can disable the listing prompt to test if this is causing the issue?

    April 26, 2019 at 9:10 am #483012

    Alex Rollin
    Moderator
    Post count: 27815

    Sure, you can disable autocomplete in the settings.

    April 26, 2019 at 9:25 am #483018

    Iain Brewster
    Expired Member
    Post count: 74

    Thanks Alex,

    Is it also possible to disable the catagory prompt on the listing search box?

    April 26, 2019 at 11:41 am #483034

    Alex Rollin
    Moderator
    Post count: 27815

    It disables both, the search autocomplete setting.

    April 26, 2019 at 3:43 pm #483079

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    The warning message in ur logs happens when a user tried to geolocate themselfs but it fails and goes to a manual location, it tries to ping that site to get generallocation for the IP but your hosting has the function used disabled, i have added a check for it so it won’t produce a warning in future if disabled by the host.

    The logins no longer seem to work so i can’t check anything else, but i was reading up on things a but and think it might be related to the DB version, if you can provide working logins i can do some tests or you can ask your host to update to latest SQL version.

    Thanks,

    Stiofan

    April 26, 2019 at 3:50 pm #483080

    Iain Brewster
    Expired Member
    Post count: 74
    This reply has been marked as private.
    May 3, 2019 at 1:12 pm #484311

    Iain Brewster
    Expired Member
    Post count: 74

    HI Stiofan,

    Just to let you know the “error connecting to database” issue has now stopped.
    I disabled the autocomplete setting for both search boxes and doesn’t happen any more.

    I also spoke to my host and they advised that i am on the latest version of SQL so not sure if you made any progress with any checks on performance?

    Thanks

  • Author
    Posts
Viewing 12 posts - 16 through 27 (of 27 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount