Geeklog Forums

HI.
When I try to open my admin page I get this message: Fatal error: Maximum execution time of 30 seconds exceeded in /usr/www/users/jackknyc/geeklog/system/classes/template.class.php on line 499
My .

When Iasked for help they sent me this email:
Thank you in advance,
Jack K

My spontaneous guess would be that you have a lot of submissions (probably spam) and it takes so long to display them all that you run into the timeout that your hosting service imposes for PHP scripts.

Check your database in phpMyAdmin (or whatever's handy) and see if you have a large number of entries in the gl_eventsubmission, gl_linksubmission, and/or gl_storysubmission tables.

If so, you will have to remove them there (i.e. directly from the database). You may also pick a few obvious keywords or URLs from those submissions and feed Spam-X's Personal Blacklist with them.

bye, Dirk

As I was just looking into this - here's a quick and dirty workaround. In admin/moderation.php find this piece of code (search for the "run SQL" comment):
That will ensure that only 50 submissions will be requested at once, preventing the timeout. You can then use the first column in the submission queues to select and delete all the entries. It will then display the next 50 entries, and so on.

Just an alternative for those who don't want to mess around in the database ...

bye, Dirk

Thanks Ditk,
That's agreat help