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.

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.

Parserus, UserAgentAnalyzer.
I speak only Russian  :P

Re: Insane query. Aborting.

Visman wrote:

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.

I made the change in the config.php

Bottom right hand of the screen shows - Generated in 0.093 seconds (77% PHP - 23% DB) with 10 queries

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.

Parserus, UserAgentAnalyzer.
I speak only Russian  :P

Re: Insane query. Aborting.

Visman wrote:

Errors are not displayed?
Then do

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

It's not showing any errors directly related.

I'm discussing it with my server now to see if there is something on their end that is messed up.

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.');

Re: Insane query. Aborting.

PanBB.Ru wrote:

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

    function query($sql, $unbuffered = false)
    {
        if (strlen($sql) > FORUM_DATABASE_QUERY_MAXIMUM_LENGTH)
            exit('Insane query. Aborting.');

I found this code in both mysql.php and mysqli.php.

What exactly am I looking to do here?

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.

Re: Insane query. Aborting.

PanBB.Ru wrote:

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.

Interesting.

I have made no changes to my forum so what would cause it to suddenly take this action?

Is it a server side issue or do I need to make an adjustment in my settings?

Re: Insane query. Aborting.

Would this possibly clear up the issue?



If you have added, edited or removed posts manually in the database or if you are having problems searching, you should rebuild the search index. For best performance you should put the forum in maintenance mode during rebuilding. Once the process has completed you will be redirected back to this page. It is highly recommended that you have JavaScript enabled in your browser during rebuilding (for automatic redirect when a cycle has completed).

IMPORTANT! Rebuilding the search index can take a long time and will increase server load during the rebuild process. If you are forced to abort the rebuild process, make a note of the last processed post ID and enter that ID+1 in "Starting post ID" when you want to continue.

WARNING! If you want to resume an aborted rebuild, do not select "empty index".

Re: Insane query. Aborting.

Your forum closed?

http://live4sportnetwork.com/forumlist/

Re: Insane query. Aborting.

PanBB.Ru wrote:

Your forum closed?

http://live4sportnetwork.com/forumlist/

I'm currently rebuilding the index hoping to clear up this issue.

Re: Insane query. Aborting.

paulcambull wrote:
PanBB.Ru wrote:

Your forum closed?

http://live4sportnetwork.com/forumlist/

I'm currently rebuilding the index hoping to clear up this issue.

This did not fix the problem.

I cannot understand how I went from having no issues to having this problem without making any changes to my forums.

Re: Insane query. Aborting.

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

Re: Insane query. Aborting.

PanBB.Ru wrote:

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

Open access how?

Re: Insane query. Aborting.

Right now a guest can use the search and see the results.

Re: Insane query. Aborting.

Your registration is approved.

18 (edited by paulcambull 2017-02-20 06:41)

Re: Insane query. Aborting.

PanBB.Ru wrote:

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.

Someone in another forum suggested this but I wanted your opinion first -

var_dump($sql) in that function instead of exit('Blah blah') Or change the FORUM_DATABASE_QUERY_MAXIMUM_LENGTH constant

Re: Insane query. Aborting.

What about in include/constants.php

19: define('FORUM_DATABASE_QUERY_MAXIMUM_LENGTH', 140000);

Re: Insane query. Aborting.

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

Re: Insane query. Aborting.

PanBB.Ru wrote:

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

mysql - 5.1.73

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

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.

Re: Insane query. Aborting.

PanBB.Ru wrote:

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.

There were no changes made over the last several weeks.

When I have the time I can go back and create an archive for you but it probably won't be for a few days.

Re: Insane query. Aborting.

PanBB.Ru wrote:

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.


Ok, so I was able to get it working this morning.

I changed the online timeout to zero and saved. Then went back and set it to the normal time and the search began working without issue.

I'm not sure how this corrected it but it did.

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