• Registered: 2013-02-13
  • Posts: 188

Topic: Insane query. Aborting.

The search feature on my website is one of the most regularly used aspects.

I am getting the same all white page with "Insane query. Aborting." in the upper left hand corner every time I use the search for a name that I know is listed.

If I know the name is not, it simply tells me that there is nothing found and to try again.

The search was working as late as 11pm last night so this is something that happened within the last 12 hours.



Any help solving this problem is greatly appreciated.

Thank you.

  • From: Siberia
  • Registered: 2013-08-05
  • Posts: 408

Re: Insane query. Aborting.

Open config.php
Replace

// Enable DEBUG mode by removing // from the following line
//define('FORUM_DEBUG', 1);

to

// Enable DEBUG mode by removing // from the following line
define('FORUM_DEBUG', 1);

Save config.php
---
Or enter on your server and open a log of errors (error.log) of your server.

ForkBB
I speak only Russian  :P

Visman's Website

  • From: Siberia
  • Registered: 2013-08-05
  • Posts: 408

Re: Insane query. Aborting.

Errors are not displayed?
Then do

Or enter on your server and open a log of errors (error.log) of your server.

ForkBB
I speak only Russian  :P

Visman's Website

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

see here /include/dblayer/mysql-mysqli.php

    function query($sql, $unbuffered = false)
    {
        if (strlen($sql) > FORUM_DATABASE_QUERY_MAXIMUM_LENGTH)
            exit('Insane query. Aborting.');
  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

this strings 

        if (strlen($sql) > FORUM_DATABASE_QUERY_MAXIMUM_LENGTH)
            exit('Insane query. Aborting.');

I just showed you where this message.  Insane query. Aborting

This shows that an error occurs when you exceed the maximum number of characters in the message.
But what happens to you on the forum, we do not know.

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

Your forum closed?

http://live4sportnetwork.com/forumlist/

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

Why do not you open the forum? open access, in order to reproduce the problem.

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

I see that the problem with the main search. Search Members operating normally. which database type do you use?

9 Reply by PanBB.Ru (edited by PanBB.Ru 2017-02-20 08:03)

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

you made any changes to the files? You edited files of forum? Could you create an archive file and send it to me for research?
full all files and extension, except of course the config.php file.

  • Registered: 2015-05-02
  • Posts: 541

Re: Insane query. Aborting.

Yes, now the search for work. That is, the problem was in the online timeout?

After registering on your forum I saw the error:
undefined variable : tpl_main

This occurs if you install the settings redirect greater than zero.
Redirect wait  |    0       |
If set to 0 seconds, no redirect page will be displayed

Solution this problem here http://punbb.informer.com/forums/post/156857/#p156857