Advertisement:

Author Topic: Database Error on Advanced Search attempt.  (Read 1108 times)

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 820
Re: Database Error on Advanced Search attempt.
« Reply #20 on: July 11, 2018, 03:24:39 AM »
Version on my forum, no search problems (or any other errors).

Database Server: MariaDB
MySQL version: 10.1.30-MariaDB-1~xenial
PHP: 7.0.29
Server version: Apache

Maybe differences between 10.1.30 & 10.2.15, and host upgraded lately ?
2.0.15, ssl, php 7.1.19, MySQL 10.1.30-MariaDB-1~xenial
Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 974
    • sbulen on GitHub
Re: Database Error on Advanced Search attempt.
« Reply #21 on: July 11, 2018, 08:38:43 AM »
OK well my host has responded and it is indeed Maria.

Quote
The server is running MariaDB 10.2.15

the full version information provided under Admin | Support and Credits is -

Quote
Forum version: SMF 2.0.15 (more detailed)
 Current SMF version: SMF 2.0.15
 GD version: bundled (2.1.0 compatible)
 Database server: MariaDB
 MySQL version: 10.2.15-MariaDB-cll-lve
 PHP: 5.6.36
 Server version: LiteSpeed


Does this help as far as the troubleshooting is concerned?

It may explain a change in behavior.  That version was released on 5/18/18.  So it was patched very recently.

https://downloads.mariadb.org/mariadb/+releases/

It would be very helpful to see the sql.  Could you try albertlast's suggestion above?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline landyvlad

  • Full Member
  • ***
  • Posts: 627
  • Gender: Male
    • Michael Reed on Facebook
    • GSX1400 Owners ORG
Re: Database Error on Advanced Search attempt.
« Reply #22 on: July 11, 2018, 08:00:01 PM »
OK will do, when I get the opportunity (tonight hopefully). Ta.



Having said that I've just checked and the search appears to be working OK again. Odd.
I'll check again later and see if its working later.
Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 974
    • sbulen on GitHub
Re: Database Error on Advanced Search attempt.
« Reply #23 on: July 11, 2018, 10:13:43 PM »
What version of MariaDB?

(It was patched again recently...  If you are now ar 10.2.16, then I think all is explained....)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline landyvlad

  • Full Member
  • ***
  • Posts: 627
  • Gender: Male
    • Michael Reed on Facebook
    • GSX1400 Owners ORG
Re: Database Error on Advanced Search attempt.
« Reply #24 on: July 11, 2018, 10:53:34 PM »
Admin - Support and Credits still states "MySQL version: 10.2.15-MariaDB-cll-lve"
Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."

Offline landyvlad

  • Full Member
  • ***
  • Posts: 627
  • Gender: Male
    • Michael Reed on Facebook
    • GSX1400 Owners ORG
Re: Database Error on Advanced Search attempt.
« Reply #25 on: July 12, 2018, 05:39:32 AM »
and the host confirms that version is correct they have not yet updated.

Search is still working fine.  VERY odd. 

I'll mark this as resolved but come back to it with more details on the error, as per albertlasts's suggestion, if it comes up again.

Thanks all.
Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."