yes, the debug is turned on. but the script halts after freezing the system with an error as follow: Fatal error: Maximum execution time of 60 seconds exceeded in path\to \cake\libs\model\datasources\dbo\dbo_mysql.php on line 133
i also tried "custom pagination" following http://devzone.zend.com/article/3240-Chris-Hartjes-Custom-CakePHP-1.2-Pagination-Queries, and it worked fine, except the usual pagination variables are not registered like $paginator and only one model can be used, which means only half the problem solved yet a big leap. and Simon, neither am I using any conditions nor have i used indexes. but if the same thing works with findAll(), i can't figure out why paginate() has issues though it is based on findAll() itself. On Apr 7, 1:23 am, zonium <[EMAIL PROTECTED]> wrote: > Did you turn on debug? > Look at the SQL statements to see what cake is trying to do and you'll > figure out where the issue is. > > zonium > > On Apr 6, 1:10 pm, crazyDavid <[EMAIL PROTECTED]> wrote: > > > sry about the version. it is 1.2 > > > i am using only one model and i finally am able to run the script > > without halt with findAll() but i needpaginationas well.. the > > problem persists with paginate(). > > > i still can't understand. i followed the exact procedure for > >paginationin 1.2 but the problem ain't fixed. > > > thank you for ur suggestions guyz! > > > On Mar 18, 2:29 am, "Jon Bennett" <[EMAIL PROTECTED]> wrote: > > > > > are your models correct? the query that is built makes sense and all? > > > > also check you're not trying to retrieve records from too many tables > > > (via associations) at once, this could time-out at php level if you've > > > not got a great amount of ram. > > > > jb > > > > -- > > > > jon bennett > > > w:http://www.jben.net/ > > > iChat (AIM): jbendotnet Skype: jon-bennett- Hide quoted text - > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
