I have a big problem.

I have one form (for survey purpose) saved to database, and I have until now more than 2000 participation, every thing was OK, but after the number of participations growth to more than 1400 I get problem with display results (even poll result and table), the page continuing loading to long time and thin display (page not found error).

How I can divide the results to multi-pages to display them?

Please help, it is an urgent case.

no body can help in this?

Which version do you have installed?

3.7

Thanks for reply

What is the problem with show poll results !!

Why it didn't work if the number of forms submitted over 1000?

I'm getting the following error on install. Couldn't find anything about it in the thread. Anyone know anything about it?

Database error in vBulletin 3.8.7:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `forms` (
`fid` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`displayorder` int(10) NOT NULL,
`action` int(3) NOT NULL,
`where` varchar(200) NOT NULL default '',
PRIMARY KEY (`fid`)
) TYPE=MyISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Error Number : 1064
Request Date : Thursday, June 28th 2012 @ 07:15:59 AM
Error Date : Thursday, June 28th 2012 @ 07:16:00 AM
Script : http://mysite.com/admincp/plugin.php?do=productimport
Referrer : http://mysite.com/admincp/plugin.php?do=productadd
IP Address : MyIP
Username : MyUsername
Classname : vB_Database
MySQL Version : 5.5.23-55

I've tried all versions of the mod, even the 3.7 one and I get the same error. No problems with any other mods.

I'm wondering if I just create the table 'forms' manually, will that work?

find in product file TYPE=MyISAM;
and replace with ENGINE=MyISAM;
all instances

Thanks. Worked like a charm.

Does anyone know of a tutorial on how to use this product? Never mind. I figured it out.

thank you