#97 Search error

[Favern]

Dear,

I have installed the last version of WebCollab and i have a problem with the Forum Search. When i run a search, i have this error message:

Hello,
This is the WebCollab Project Management site and I have an error :

Error message: Not a valid integer
Database message: SELECT DISTINCT forum.taskid AS taskid,
forum.edited AS last_edit,
tasks.name AS taskname
FROM forum
LEFT JOIN tasks ON (tasks.id=forum.taskid)
WHERE forum.edited > ( now()-INTERVAL 14 DAY)

GROUP BY forum.taskid, last_edit, taskname
ORDER BY last_edit DESC LIMIT 50
User: Philippe Chapet (philippe.chapet@chauvin-arnoux.com)
Component: Forum search
Page that was called: /~deltacen/webcollab/forum.php
Requested URL: /~deltacen/webcollab/forum.php
URL string:
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36
Time: January 7, 2014, 09:07
IP: 193.248.210.240
WebCollab version:3.31
POST variables: Array
(
[x] => 0
[action] => search
[start] => R3918503769
[string] => 1
[webcollab_sticky] => active_only=0:condensed=0
[webcollab_session] => 3faef5be8f41f628a1547636225de710
[startBAK] => R3415744843
)

Best regards

[Andrew Simpson]

Sorry, I did reply to this, but I'm on holiday and the internet connection (via cell phone) has been poor in the mountains (sometimes dropping out while posting).

The code for the forum search has not been changed for a while - certainly not in version 3.31 - so the problem must be older. What version of WebCollab were you using previously? Does this happen with all browsers?

Actually having said that, I see the problem: The POST variable [start] should be a low integer (like '5', or '10'). Your debug is showing [start] => R3918503769, which is being sent by the browser to WebCollab.

There is also '[startBAK] => R3415744843' which is nothing to do with WebCollab, but being sent by the browser also. It would appear that your organisation is injecting this into the browser responses for some purpose?

Can you please confirm?

[Favern]

Dear,

Thank you for your help. This product is very good.

Webcollab 3.31 is the first version that i have installed.
I have this problem in my company and at home too (at home, i have only a computer and a basic modem/router ADSL).
I have tested with chrome 31 and IE 11.
The PHP version is 5.5.

Best regards

[Andrew Simpson]

O.K. It appears that your web host is adding a 'cookie' of the same name ('start') which is overwriting the POST value set by WebCollab. I think the default configuration of PHP should prevent this, but in this case it's obviously not.

I have attached a replacement file for the existing file at '[webcollab path]/webcollab/forum/forum_search.php' that should fix the problem.

Can you let me know if this fixes the problem? If so, I will make commits to the next release.

[Favern]

Dear,
The fix works very well.
Thank you very much.

[Andrew Simpson]

Fix committed to Git Repository.

Closing bug report.