Welcome to Geeklog, Anonymous Wednesday, June 19 2024 @ 09:10 am EDT

Geeklog Forums

Help Please


Status: offline

jackknyc

Forum User
Regular Poster
Registered: 12/08/03
Posts: 88
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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):
Text Formatted Code
    // run SQL but this time ignore any errors
    if (!empty ($sql)) {
        $sql .= ' LIMIT 50'; // <-- add this line
        $result = DB_query($sql, 1);
    }

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
 Quote

Jackknyc

Anonymous
Thanks Ditk,
That's agreat help
 Quote

All times are EDT. The time is now 09:10 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content