Welcome! Log In Create A New Profile

Advanced

Incorrect integer value: '' for column 'results' at row 1

Posted by edithmayerhofer 
Incorrect integer value: '' for column 'results' at row 1
March 21, 2007 02:21PM
Hi!

I've installed the latest version of sphider. Problem: if the search doesn't give any results i will get this:

Incorrect integer value: '' for column 'results' at row 1

any idea what's wrong?

thanks in advance.

BR, Edith
Re: Incorrect integer value: '' for column 'results' at row 1
March 22, 2007 12:30PM
MSG: "Out of range value adjusted for column 'results' at row 1"



Hi,

I have the same problem, without any solution, maybe some one has an idea !?!?

This message makes the 'looking and feeling' of this nice product not better!

So please let us know, if you allready found a solution.
I tried to locate the place where the msg is produced, but without any
success.

Thank for your help!
Re: Incorrect integer value: '' for column 'results' at row 1
March 24, 2007 12:41PM
It can be solved if you go to searchfuncs.php, and search for (line 345):

$res['did_you_mean'] = $near_words;
return $res;

Then you add one line:

$res['did_you_mean'] = $near_words;
$res['results'] = 0;
return $res;

And the problem is solved! It only creates the column "results" that is not created if there are no matching results.

Regards,
Fernando
Re: Incorrect integer value: '' for column 'results' at row 1
April 07, 2007 08:20PM
I was mistaken, do not make the previous modification, do the following one. In searchfuncs.php, around line 470, find:

$rows = $result['results'];

And replace it by:

$rows = isset($result['results']) ? $result['results'] : 0;

It definitely solves all "Incorrect integer value" errors!

www.mundodivx.com
Re: Incorrect integer value: '' for column 'results' at row 1
June 11, 2007 10:19PM
Thanks, this worked for me. smiling smiley Not enough thanks on these boards.
Congratulations
Sorry, only registered users may post in this forum.

Click here to login