Guys,

I have 2 concerns I need help with:

1. Whenever I'd generate a report, I'd encounter this error. So what i did was to limit the contents of the weborm_submissions and webform_submitted_data to a month's worth. Previous data were backed up to corresponding master tables.

Per my research, I already tried the ff:

1. increase max_packat_data on my.ini from 2M to (even 300M);
2. set max_execution time to 250;
3. set default_socket_timeout and max_connect_timeout to 300;
4. a lot more from the threads.

but nothing worked. I also tried executing the query on MySQL directly and got the same result. I already optimized the script to no avail.

Hoping someone could provide me with a solution. User count is expected to increase. As it is right now, i've only seen around 27 users and yet this is happening already.

Any inputs, thoughts, suggestions would be appreciated. need is very urgent. We are about to launch to another site.

I can provide more info as needed.

2. I need to filter my webform report via the fields Site and Supervisor. However, I am unable to see it on the 'Add filter' list. So what I did was to create the corresponding hidden fields on my webform. Now, how do I format the token values for these data? I mean, do you know the syntax? That is, if comparing the filter fields (Site and Supervisor) to token values is possible.

I am using webform report 6.x-2.0, Windows, IE 8, MySQL server, and Apache.

Thanks